[
https://issues.apache.org/jira/browse/DERBY-4001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12698231#action_12698231
]
Bryan Pendleton commented on DERBY-4001:
----------------------------------------
+1 to the suggestion to cease flattening NOT EXISTS, although if you think you
can tell
the difference between queries that are safe to flatten, and those that aren't,
that would be fine too.
What are the example queries in subqueryFlattening that involve flattening of
NOT EXISTS?
> 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
> Priority: Minor
> Fix For: 10.4.2.0
>
>
> 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.
