[teiid-issues] [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query

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 &gt;= 0) AND (BQT1.SmallA.IntKey &lt;= 15) AND (BQT2.MediumB.IntKey &gt;= 5) AND (BQT2.MediumB.IntKey &lt;= 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.