Knut Anders Hatlen created DERBY-6577:
-----------------------------------------
Summary: Quantified comparison returns wrong result in CASE
expression
Key: DERBY-6577
URL: https://issues.apache.org/jira/browse/DERBY-6577
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.11.0.0
Reporter: Knut Anders Hatlen
I'm seeing this on head of trunk:
{noformat}
ij> select c, c = all (values 'Y'), case when c = all (values 'Y') then true
else false end from (values 'Y', 'N') v(c);
C|2 |3
-------------
Y|true |false
N|false|true
2 rows selected
{noformat}
Column 2 and column 3 should have the same value, but something seems to go
wrong when the quantified comparison is used in a CASE expression.
I'm seeing the expected result on 10.10.2.0, though:
{noformat}
ij> select c, c = all (values 'Y'), case when c = all (values 'Y') then true
else false end from (values 'Y', 'N') v(c);
C|2 |3
-------------
Y|true |true
N|false|false
2 rows selected
{noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
