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

optimize determined case when filters

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • v2.0.0
    • None
    • None

    Description

      currently calcite will not handle with determined filter like:

      1. where 1 = 1 => where true
      2. where ( 1= 1 or x = 2) => where true
      3. where case when 'a' = 'a' then x > 1 else x < 1 => where x > 1

      the first two cases have been handled in KYLIN-2539, however the third case is not handled yet. This JIRA is to track the third case.

      In theory, this JIRA together with KYLIN-2539, KYLIN-2597 should be solved in calcite rather than KYLIN. However it's urgent demand so we'll fix in KYLIN first.

      Attachments

        Activity

          People

            mahongbin Hongbin Ma
            mahongbin Hongbin Ma
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: