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

BQT Query not returning expected row count

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 7.4.1, 7.5
    • 7.4
    • Query Engine
    • None

      Teiid 7.4 - the following query is returning no rows but the expected row count is 47 rows. This was tested with MySql50 and Teradata12. I verified the query produced 47 rows with SOA-P 5.1 GA. See expected query results file attached. VDB can be made available if needed.

      SELECT INTKEY, DATEVALUE, BYTENUM FROM BQT1.SmallA WHERE DATEVALUE <> ANY (SELECT DATEVALUE FROM BQT1.SmallA WHERE BYTENUM >= '-108')

      The source query from the log file is:
      SELECT cast(g_0.INTKEY AS signed) AS c_0, g_0.DATEVALUE AS c_1, g_0.BYTENUM AS c_2 FROM smalla AS g_0 WHERE g_0.DATEVALUE NOT IN (SELECT g_1.DATEVALUE FROM smalla AS g_1 WHERE g_1.BYTENUM >= -108) LIMIT 100

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

              Created:
              Updated:
              Resolved: