[
https://issues.apache.org/jira/browse/DERBY-6577?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen updated DERBY-6577:
--------------------------------------
Affects Version/s: 10.10.2.0
Summary: Quantified comparison returns wrong result in CASE and
COALESCE expressions (was: Quantified comparison returns wrong result in CASE
expression)
Updated affects version to include 10.10.2.0, since the problem can also be
seen there in some queries. Keeping the regression flag, since the problem is
seen in more queries on trunk.
> Quantified comparison returns wrong result in CASE and COALESCE expressions
> ---------------------------------------------------------------------------
>
> 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, 10.10.2.0
> Reporter: Knut Anders Hatlen
> Assignee: 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)
