[
https://issues.apache.org/jira/browse/DERBY-6577?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen updated DERBY-6577:
--------------------------------------
Attachment: d6577-1a.diff
[^d6577-1a.diff] fixes ValueNodeList.preprocess() and adds test cases to verify
that the correct results are returned from the queries mentioned in this bug
report.
I've started the full regression test suite on the patch.
> Quantified comparison returns wrong result in CASE, COALESCE, IN and BETWEEN
> ----------------------------------------------------------------------------
>
> 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
> Attachments: d6577-1a.diff
>
>
> 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)
