Knut Wannheden created DERBY-7048:
-------------------------------------
Summary: Unexpected quantified ALL predicate result
Key: DERBY-7048
URL: https://issues.apache.org/jira/browse/DERBY-7048
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.15.1.3
Reporter: Knut Wannheden
According to the SQL standard the following query should return {{NULL}} rather
than {{FALSE}}:
{code:java}
select 1 = all (select cast(null as numeric) from sysibm.sysdummy1)
from sysibm.sysdummy1
{code}
The same goes for the {{ANY}} predicate, which should also evaluate to {{NULL}}
but currently returns {{false}}:
{code:java}
select 1 = any (select cast(null as numeric) from sysibm.sysdummy1)
from sysibm.sysdummy1{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
