db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6409) Wrong result from quantified comparison
Date Wed, 19 Feb 2014 18:44:22 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13905837#comment-13905837
] 

Mike Matrigali commented on DERBY-6409:
---------------------------------------

10.6 gets a syntax error on both statements, maybe some feature went into 10.7 that enabled
these
queries, anyway does not look like a regression:
ij version 10.6
CONNECTION0* -  jdbc:derby:wombat
* = current connection
ij> values 1 > all (select 2 from sysibm.sysdummy1);
ERROR 42X01: Syntax error: Encountered ">" at line 1, column 10.
Issue the 'help' command for general information on IJ command syntax.
Any unrecognized commands are treated as potential SQL commands and executed directly.
Consult your DBMS server reference documentation for details of the SQL syntax supported by
your server.
ij> values 1 < all (select 2 from sysibm.sysdummy1);
ERROR 42X01: Syntax error: Encountered "<" at line 1, column 10.
Issue the 'help' command for general information on IJ command syntax.
Any unrecognized commands are treated as potential SQL commands and executed directly.
Consult your DBMS server reference documentation for details of the SQL syntax supported by
your server.


> 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.7.1.4, 10.8.3.3, 10.9.2.2, 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.5#6160)

Mime
View raw message