[
https://issues.apache.org/jira/browse/DERBY-4001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen updated DERBY-4001:
--------------------------------------
Attachment: d4001-2a-code.diff
This patch (d4001-2a-code.diff) is the same as dontFlatten.diff, only that it
adds comments and also enables SubqueryFlatteningTest as part of the regression
test suite. Derbyall and suites.All ran cleanly with the dontFlatten.diff
patch, but I'm rerunning the tests now in case I accidentally changed something
I didn't mean to change.
> Sequence comparison with "ALL" does not yield correct results
> -------------------------------------------------------------
>
> Key: DERBY-4001
> URL: https://issues.apache.org/jira/browse/DERBY-4001
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.3.2.1
> Environment: Windows
> Reporter: Venkateswaran Iyer
> Assignee: Knut Anders Hatlen
> Priority: Minor
> Attachments: d4001-1a-test.diff, d4001-2a-code.diff, dontFlatten.diff
>
>
> A query involving "< ALL" does not yield the right results for decimal
> datatype. "< ANY" works, though.
> To reproduce the issue:
> % create table t1(col1 decimal(10,5));
> % insert into t1 values (-21483.64800);
> % insert into t1 values (74837.00000);
> % select col1 from t1 where col1 < ALL (select 0.0 from t1);
> The above yields no results whereas it should return the first row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
