db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6409) Wrong result from quantified comparison
Date Fri, 08 Nov 2013 10:03:17 GMT
Knut Anders Hatlen created DERBY-6409:
-----------------------------------------

             Summary: Wrong result from quantified comparison
                 Key: DERBY-6409
                 URL: https://issues.apache.org/jira/browse/DERBY-6409
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.10.1.1
            Reporter: Knut Anders Hatlen


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



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message