Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-989

Pushdown query ORDER BY is not always ordering results properly on Sql2000

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.0
    • Fix Version/s: 7.0
    • Component/s: Query Engine
    • Labels:
      None

      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                wgibson Warren Gibson
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: