[ https://issues.apache.org/jira/browse/KYLIN-5876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17865962#comment-17865962 ]
ASF subversion and git services commented on KYLIN-5876: -------------------------------------------------------- Commit c4e45aa956f83dbf9da78537abc8475871869586 in kylin's branch refs/heads/kylin5 from Guoliang Sun [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=c4e45aa956 ] KYLIN-5876 Avoid infinite match of OlapProjectMergeRule caused by project simplification > Avoid infinite match in OlapProjectMergeRule caused by simplify projects > ------------------------------------------------------------------------ > > Key: KYLIN-5876 > URL: https://issues.apache.org/jira/browse/KYLIN-5876 > Project: Kylin > Issue Type: Improvement > Components: Query Engine > Affects Versions: 5.0-alpha > Reporter: pengfei.zhan > Assignee: pengfei.zhan > Priority: Major > Fix For: 5.0.0 > > > tdvt test compared to version kylin-5.0-alpha a new failed sql has been > added, the query reports an error > {code:sql} > 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 > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)