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

Mon Jun 20 15:01:24 EDT 2011

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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira