You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2016/10/05 12:50:20 UTC

[jira] [Created] (CALCITE-1413) New CASE statement simplification

Jesus Camacho Rodriguez created CALCITE-1413:
------------------------------------------------

             Summary: New CASE statement simplification
                 Key: CALCITE-1413
                 URL: https://issues.apache.org/jira/browse/CALCITE-1413
             Project: Calcite
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.9.0
            Reporter: Jesus Camacho Rodriguez
            Assignee: Jesus Camacho Rodriguez


Another possible simplification for CASE statements.

{code:sql}
CASE
 WHEN p1 THEN x
 WHEN p2 THEN y
 ELSE TRUE
END
{code}

can be rewritten into:
{code:sql}
(p1 and x) or (p2 and y and not(p1)) or (not(p1) and not(p2))
{code}
if p1...pn cannot be nullable.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)