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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1643.
-----------------------------------

    Resolution: Rejected


7.4 fixed the notion of column name vs. column label.  CTC is using the column name which is the non-aliased form.

> 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