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)
