[teiid-issues] [JBoss JIRA] Created: (TEIID-1009) BQT Pushdown query "ORDER BY" is not always ordering results properly

[Warren Gibson (JIRA)]

BQT Pushdown query "ORDER BY" is not always ordering results properly
---------------------------------------------------------------------

                 Key: TEIID-1009
                 URL: https://jira.jboss.org/jira/browse/TEIID-1009
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 7.0
            Reporter: Warren Gibson
            Assignee: Steven Hawkins


Pushdown queries with "ORDER BY" are not always returning results in correct order. The below query is returning query results in the wrong order for Pushdown on DB2, MySql, Ora9-10-11, and SqlServer sources.  If BQT1.SmallA.StringKey is placed in the SELECT clause the results are returned in the correct order.

SELECT BQT1.SmallA.IntNum, BQT2.SmallB.StringNum FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.IntNum = BQT2.SmallB.StringNum AND BQT1.SmallA.IntKey >= 5 AND BQT2.SmallB.IntKey >= 5 ORDER BY BQT1.SmallA.StringKey


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira