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

Queries containing a UNION with an ORDER BY are producing unexpected results in CTC Query Testing

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • None
    • 7.0
    • Integration Tests
    • None

    Description

      I am getting unexpected results (all sources) on 17 queries containing a UNION and ORDER BY. The ORDER BY isn't working when there is a UNION involved. These queries were producing expected results prior to the holidays. Below is a sample query:

      RDBMS_Test_Queries_6500_TestQuery32" value="SELECT StringKey FROM BQT1.SmallA WHERE IntKey >= 0 AND IntKey < 15 UNION SELECT StringKey FROM BQT1.SmallB WHERE IntKey >= 10 AND IntKey < 30 ORDER BY StringKey DESC

      The interesting thing is the queries do work with a UNION ALL.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            wgibson_jira Warren Gibson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: