#1554 Wrong result for quantified ALL predicate

[Knut Wannheden]

The following query returns NULL as expected:

SELECT 1 = ALL (SELECT x FROM (VALUES (NULL), (1)) AS t(x))
FROM (VALUES (1)) AS dual

But for the following query the expected result would be FALSE, but HSQLDB evaluates it to NULL again:

SELECT 1 = ALL (SELECT x FROM (VALUES (NULL), (0)) AS t(x))
FROM (VALUES (1)) AS dual

[Fred Toussi]

Thanks for reporting. Fixed and committed to SVN trunk.

[Knut Wannheden]

+1