[teiid-issues] [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Warren Gibson commented on TEIID-1643:
--------------------------------------
Customers (vendors or clients) using metadata in their application will be impacted by
this. Backward compatibility is broken by the simple fact that we now require them to
change to use us.
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira