[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[jira] [Created] (CALCITE-2620) Simplify "coalesce(null,x)" to "x"

pengzhiwei created CALCITE-2620:

             Summary: Simplify "coalesce(null,x)" to "x"
                 Key: CALCITE-2620
                 URL: https://issues.apache.org/jira/browse/CALCITE-2620
             Project: Calcite
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.18.0
            Reporter: pengzhiwei
            Assignee: Julian Hyde

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

This message was sent by Atlassian JIRA