Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3049

When simplifying expressions, revisit "IS NULL" if its argument has been simplified

    XMLWordPrintableJSON

    Details

      Description

      When simplifying expressions, revisit "IS NULL" if its argument has been simplified. For example, we currently simplify

      (CASE WHEN FALSE THEN +(v0) ELSE -1 END) IS UNKNOWN

      to

      -1 IS UNKNOWN

      but we should further simplify that to FALSE.

      I have a preliminary dev branch, but it needs a little more debugging. I'd be grateful if someone could finish it.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                danny0405 Danny Chen
                Reporter:
                julianhyde Julian Hyde
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m