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

[Warren Gibson (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12610388#comment-12610388 ] 

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