[JBoss JIRA] Created: (TEIID-989) Pushdown query ORDER BY is not always ordering results properly on Sql2000
12:34 a.m.
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.
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
12:36 a.m.
New subject: [JBoss JIRA] Updated: (TEIID-989) Pushdown query ORDER BY is not always ordering results properly on Sql2000
[
https://jira.jboss.org/jira/browse/TEIID-989?page=com.atlassian.jira.plug...
]
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
9:17 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-989) Pushdown query ORDER BY is not always ordering results properly on Sql2000
[
https://jira.jboss.org/jira/browse/TEIID-989?page=com.atlassian.jira.plug...
]
Steven Hawkins resolved TEIID-989.
----------------------------------
Resolution: Done
Refactored the order by handling logic to ensure that unrelated items will be displayed
based upon their full name. Also fixed the sql server limit logic for queries.
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
4:33 a.m.
New subject: [JBoss JIRA] Resolved: (TEIID-989) Pushdown query ORDER BY is not always ordering results properly on Sql2000
[
https://jira.jboss.org/jira/browse/TEIID-989?page=com.atlassian.jira.plug...
]
Steven Hawkins resolved TEIID-989.
----------------------------------
Fix Version/s: 7.0
Resolution: Done
Also added a fix for unrelated order bys created by ruleassignoutputelements.
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
Fix For: 7.0
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
4:33 a.m.
New subject: [JBoss JIRA] Reopened: (TEIID-989) Pushdown query ORDER BY is not always ordering results properly on Sql2000
[
https://jira.jboss.org/jira/browse/TEIID-989?page=com.atlassian.jira.plug...
]
Steven Hawkins reopened TEIID-989:
----------------------------------
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
Fix For: 7.0
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
8:40 p.m.
New subject: [JBoss JIRA] Closed: (TEIID-989) Pushdown query ORDER BY is not always ordering results properly on Sql2000
[
https://jira.jboss.org/browse/TEIID-989?page=com.atlassian.jira.plugin.sy...
]
Steve Hawkins closed TEIID-989.
-------------------------------
Pushdown query ORDER BY is not always ordering results properly on
Sql2000
----------------------------------------------------------------------------
Key: TEIID-989
URL: https://jira.jboss.org/browse/TEIID-989
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.0
Reporter: Warren Gibson
Assignee: Steven Hawkins
Fix For: 7.0
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/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5333
days inactive
5454
days old
5 comments
3 participants
participants (3)
-
Steve Hawkins (JIRA) -
Steven Hawkins (JIRA)
-
Warren Gibson (JIRA)