-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
7.4.1
-
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