Extend the CASE expression syntax for "simple case"
---------------------------------------------------
Key: DERBY-1576
URL: http://issues.apache.org/jira/browse/DERBY-1576
Project: Derby
Issue Type: Improvement
Components: SQL
Reporter: Christian d'Heureuse
Priority: Minor
The ISO/IEC 9075-2:1999 SQL standard describes two kinds of CASE expressions:
"simple case" and "searched case".
The current Derby version supports "searched case" but not "simple case".
The syntax for "simple case" is:
CASE Expression
WHEN Expression THEN Expression
[ WHEN Expression THEN Expression ]
...
ELSE ElseExpression
END
Example:
VALUES
CASE 4
WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
WHEN 3 THEN 'three'
ELSE 'many'
END
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
