[
https://issues.apache.org/jira/browse/KYLIN-5876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liyang closed KYLIN-5876.
-------------------------
> 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)
