[teiid-issues] [JBoss JIRA] (TEIID-1777) Ingres as source - 3 VQT Queries using COUNT(*) returning unexpected results

Ingres as source - 3 VQT Queries using COUNT(*) returning unexpected results ---------------------------------------------------------------------------- Key: TEIID-1777 URL: https://issues.jboss.org/browse/TEIID-1777 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 7.4.1 Reporter: Warren Gibson Assignee: Van Halbert 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