[
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)
