You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "liyang (Jira)" <ji...@apache.org> on 2024/09/27 15:20:01 UTC

[jira] [Closed] (KYLIN-5876) Avoid infinite match in OlapProjectMergeRule caused by simplify projects

     [ 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)