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

Simplify "coalesce(null,x)" to "x"

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.18.0
    • Fix Version/s: 1.18.0
    • Component/s: core
    • Labels:
      None

      Description

      "coalesce(x0,x1,.....)" can be simplified if any of "xi" is null literal.

      e.g.  "coalesce(null,x)" can simplify to "x", "coalesce(x,null,y)" can simplify to "coalesce(x,y)"

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                pzw2018 pengzhiwei
                Reporter:
                pzw2018 pengzhiwei
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: