[DERBY-4001] Sequence comparison with "ALL" does not yield correct results

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.3.2.1
• Fix Version/s: 10.5.2.0, 10.6.1.0
• Component/s: SQL
• Environment: Windows
• Issue & fix info: High Value Fix
• Bug behavior facts: Wrong query result
• Assignee: Knut Anders Hatlen
• Reporter: Venkateswaran Iyer
• Created: 05/Jan/09 07:16
• Updated: 21/Jan/11 17:52
• Resolved: 28/Apr/09 07:48

Description

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.

Issue Links

• is duplicated by: DERBY-4385 Comparision with ALL (subquery) may give wrong result if constant is selected