[teiid-issues] [JBoss JIRA] Updated: (TEIID-989) Pushdown query ORDER BY is not always ordering results properly on Sql2000

[Warren Gibson (JIRA)]

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

Warren Gibson updated TEIID-989:
--------------------------------

    Description: 
Pushdown queries with ORDER BY are not always ordering results correctly.  The below query is returning query results in the proper order for Simple Capabilities but in the wrong order for Pushdown on sql2000 source.   This may also be happening on other sources.

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 



  was:
Pushdown queries with ORDER BY are not always ordering results correctly.  The below query is returning query results in the proper order for Simple Capabilities but in the wrong order for Pushdown on sql2000 source.

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 





> Pushdown query ORDER BY  is not always ordering results properly on Sql2000 
> ----------------------------------------------------------------------------
>
>                 Key: TEIID-989
>                 URL: https://jira.jboss.org/jira/browse/TEIID-989
>             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 ordering results correctly.  The below query is returning query results in the proper order for Simple Capabilities but in the wrong order for Pushdown on sql2000 source.   This may also be happening on other sources.
> 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