Details
Description
I'm seeing this on head of trunk:
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
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:
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
Attachments
Attachments
Issue Links
- is broken by
-
DERBY-6566 Simplify handling of untyped nulls in CASE and NULLIF expressions
- Closed
- relates to
-
DERBY-6408 EXISTS returns NULL instead of FALSE
- Closed
-
DERBY-6409 Wrong result from quantified comparison
- Closed
-
DERBY-6759 Derby 10.10 backport issue (fall 2014)
- Closed