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

Ingres as source - 3 VQT Queries using COUNT(*) returning unexpected results

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 7.4.1
    • Misc. Connectors
    • None

      EDS Query Testing is getting unexpected results on the following queries:

      3 queries involving COUNT

      QUERY: SELECT COUNT FROM VQT.Agg1
      COMMENT: Expected count of 47 rows but got count of 1.
      Agg1 transformation: SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA GROUP BY BQT1.SmallA.StringNum

      QUERY: SELECT COUNT FROM VQT.Agg3
      COMMENT: Expected count of 1 but got count of 50.
      Agg3 transformation: SELECT COUNT FROM BQT1.SmallA

      QUERY: SELECT COUNT FROM VQT.Agg4
      COMMENT: Expected count of 47 but got count of 1.
      Agg4 transformation: SELECT MIN(BQT1.SmallA.StringNum), SUM(BQT1.SmallA.IntKey), AVG(BQT1.SmallA.IntKey) FROM BQT1.SmallA GROUP BY BQT1.SmallA.StringNum

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

              Created:
              Updated:
              Resolved: