[DERBY-6409] Wrong result from quantified comparison

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.7.1.4, 10.8.3.3, 10.9.2.2, 10.10.1.1
• Component/s: SQL
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Wrong query result
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 08/Nov/13 10:02
• Updated: 21/Jan/15 00:23
• Resolved: 04/Mar/14 08:36

Description

This query should have returned FALSE:

ij> values 1 > all (select 2 from sysibm.sysdummy1);
1

---

true

1 row selected

This query should have returned TRUE:

ij> values 1 < all (select 2 from sysibm.sysdummy1);
1

---

NULL

1 row selected

Issue Links

• duplicates: DERBY-6408 EXISTS returns NULL instead of FALSE
• is related to: DERBY-6408 EXISTS returns NULL instead of FALSE
• is related to: DERBY-6577 Quantified comparison returns wrong result in CASE, COALESCE, IN and BETWEEN