Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
cognos will generate queries with parenthesized sub-clause in JOIN. for example:
SELECT "TABLE1"."DIM1_1" "DIM1_1" ,"TABLE2"."DIM2_1" "DIM2_1" ,SUM("FACT"."M1") "M1" ,SUM("FACT"."M2") "M2" FROM ("COGNOS"."FACT" "FACT" LEFT OUTER JOIN "COGNOS"."TABLE1" "TABLE1" ON "FACT"."FK_1" = "TABLE1"."PK_1") LEFT OUTER JOIN "COGNOS"."TABLE2" "TABLE2" ON "FACT"."FK_2" = "TABLE2"."PK_2" GROUP BY "TABLE2"."DIM2_1" ,"TABLE1"."DIM1_1";
as mentioned in https://issues.apache.org/jira/browse/CALCITE-35 such issue is difficult to handle in calcite. We'll leverage IQueryTransformer to remove unnecessary parentheses