Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-5876

Avoid infinite match in OlapProjectMergeRule caused by simplify projects

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 5.0-alpha
    • 5.0.0
    • Query Engine
    • 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
      

      Attachments

        Activity

          People

            pfzhan Pengfei Zhan
            pfzhan Pengfei Zhan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: