[JBoss JIRA] (TEIID-5988) We have strange behavior with aliases
- 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.redhat.com/browse/TEIID-5988?page=com.atlassian.jira.plugi...
]
Steven Hawkins resolved TEIID-5988.
-----------------------------------
Fix Version/s: 15.0
Resolution: Done
Changed the soql generation strategy to only qualify when a specific parent name is set.
Otherwise we are relying upon the context of the table in the immediate from clause. From
what I can see since no correlation is supported this should work - and does for the join
scenarios we have captured in our tests. This change also addresses the dubious query
generation for the testSelfJoinOuterParentToChild case - it now has no qualification on
the inner id column.
[~i3draven] if these changes work for you and there is a specific currently supported
other branch, 13.x or 14.x you would like to see them on let us know.
We have strange behavior with aliases
-------------------------------------
Key: TEIID-5988
URL: https://issues.redhat.com/browse/TEIID-5988
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Reporter: Renat Eskenin
Assignee: Steven Hawkins
Priority: Major
Fix For: 15.0
Attachments: Снимок экрана от 2020-06-26 12-37-40.png, Снимок экрана от
2020-06-26 12-38-04.png
Original Estimate: 5 hours
Remaining Estimate: 5 hours
We have two SOQL
SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE
Language = 'it' LIMIT 5
SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a
WHERE a.Language = 'it' LIMIT 5
This SOQL requests get different responses from SF because in second request we have
alias for table.
It is mystics from SF (we made bug in sf)
How we can call
SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE
Language = 'it' LIMIT 5
in Teiid without aliases?
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
1642
days inactive
1642
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (Jira)