Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 54150 invoked from network); 24 Jan 2008 11:51:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 24 Jan 2008 11:51:59 -0000 Received: (qmail 17464 invoked by uid 500); 24 Jan 2008 11:51:49 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 17425 invoked by uid 500); 24 Jan 2008 11:51:49 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 17416 invoked by uid 99); 24 Jan 2008 11:51:49 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Jan 2008 03:51:49 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Jan 2008 11:51:43 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id EE0C371425D for ; Thu, 24 Jan 2008 03:51:35 -0800 (PST) Message-ID: <32839622.1201175495972.JavaMail.jira@brutus> Date: Thu, 24 Jan 2008 03:51:35 -0800 (PST) From: "Thomas Nielsen (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Created: (DERBY-3349) Nested WHERE EXITS queries need improved testing MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Nested WHERE EXITS queries need improved testing ------------------------------------------------ Key: DERBY-3349 URL: https://issues.apache.org/jira/browse/DERBY-3349 Project: Derby Issue Type: Improvement Components: Test Reporter: Thomas Nielsen DERBY-3301 reported an error in subquery flattening of nested WHERE EXISTS clauses, or WHERE EXISTS subqueries. The query returned the wrong number of rows. There is currently some tests for WHERE EXISTS, but none for nested WHERE EXISTS clauses. See DERBY-3301 for a full sql repro. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.