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 "Bernt M. Johnsen (JIRA)" <ji...@apache.org> on 2009/09/22 17:06:16 UTC
[jira] Updated: (DERBY-4385) Comparision with ALL (subquery) may
give wrong result if constant is selected
[ https://issues.apache.org/jira/browse/DERBY-4385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bernt M. Johnsen updated DERBY-4385:
------------------------------------
Component/s: SQL
> Comparision with ALL (subquery) may give wrong result if constant is selected
> -----------------------------------------------------------------------------
>
> Key: DERBY-4385
> URL: https://issues.apache.org/jira/browse/DERBY-4385
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Reporter: Bernt M. Johnsen
> Priority: Critical
>
> Consider the following:
> CREATE TABLE t1 (i INT PRIMARY KEY, j INT);
> CREATE TABLE t2 (i INT);
> INSERT INTO t1 VALUES (1,1),(2,2);
> INSERT INTO t2 VALUES (81);
> The two following queries should give the same result:
> SELECT * FROM t1 WHERE i < ALL (SELECT i FROM t2);
> SELECT * FROM t1 WHERE i < ALL (SELECT 81 FROM t2);
> But, they don't:
> ij> SELECT * FROM t1 WHERE i < ALL (SELECT i FROM t2);
> I |J
> -----------------------
> 1 |1
> 2 |2
> 2 rows selected
> ij> SELECT * FROM t1 WHERE i < ALL (SELECT 81 FROM t2);
> I |J
> -----------------------
> 0 rows selected
> ij>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.