[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...
]
Paul Nittel commented on TEIID-1643:
------------------------------------
Not meaning to flog this pretty dead horse, but what if the user's software is some
proprietary gizmo over which they have no control? I'm just sayin'...
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