Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
5.0-alpha
-
None
Description
tdvt test compared to version kylin-5.0-alpha a new failed sql has been added, the query reports an error
SELECT (CASE WHEN "t2"."__measure__2" = 0 THEN NULL ELSE CAST("t0"."__measure__0" AS DOUBLE PRECISION) / "t2"."__measure__2" END) AS "TEMP(Test)(3502400386)(0)" FROM ( SELECT SUM("CALCS"."NUM1") AS "__measure__0" FROM "TDVT"."CALCS" "CALCS" HAVING (COUNT(1) > 0) ) "t0" CROSS JOIN ( SELECT AVG("t1"."__measure__0") AS "__measure__2" FROM ( SELECT SUM("CALCS"."NUM1") AS "__measure__0" FROM "TDVT"."CALCS" "CALCS" GROUP BY "CALCS"."STR1" ) "t1" HAVING (COUNT(1) > 0) ) "t2" LIMIT 500