You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Knut Wannheden (JIRA)" <ji...@apache.org> on 2019/07/03 07:51:00 UTC

[jira] [Created] (DERBY-7048) Unexpected quantified ALL predicate result

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)