[JBoss JIRA] (TEIID-5409) left join is reversed
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-5409?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5409:
---------------------------------------
Yes it needs some specific conditions to trigger the issue. It has to be a left outer
join that cannot be initially pushed (in this issue it's the timestampdiff function
that prevents that initially) with a nested join where one of the nested tables can be
pushed with the outer side - which it can here as it's all the same source.
left join is reversed
---------------------
Key: TEIID-5409
URL: https://issues.jboss.org/browse/TEIID-5409
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 10.3.1, 10.3.2
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
Priority: Blocker
Fix For: 11.1, 11.0.1, 10.3.3
Attachments: plan_teiid_10.3.2.txt, plan_teiid_9.1.txt
A query that is run on teiid 9.1 results in 56186 rows.
The same query that is run on teiid 10.3.2 results in 5919 rows.
It seems like the left join is reversed.
I've attached both query plans.
The queries are exactly the same. Note that on 9.1 we've prefixed table names with
cos2_5_.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
2355
days inactive
2355
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)