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

Teiid not qualifying returned result data element when AS used in query

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 7.5
    • Query Engine
    • None

      Not qualifying result data element when AS used in query. Example query below.

      SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE (BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND (BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY SmallA_IntKey, MediumB_IntKey

      Actual Results:
      <dataElement type="integer">IntKey</dataElement>
      <dataElement type="integer">IntKey</dataElement>

      Expected Results:
      <dataElement type="integer">SmallA_IntKey</dataElement>
      <dataElement type="integer">MediumB_IntKey</dataElement>

      VDB attached.

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

              Created:
              Updated:
              Resolved: