Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <698173624.1253631376006.JavaMail.jira@brutus>
Date: Tue, 22 Sep 2009 07:56:16 -0700 (PDT)
From: "Bernt M. Johnsen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-4385) Comparision with ALL (subquery) may
 give wrong result if constant is selected
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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
            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.