From derby-dev-return-75673-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Tue Feb 02 09:20:44 2010 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 44746 invoked from network); 2 Feb 2010 09:20:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Feb 2010 09:20:43 -0000 Received: (qmail 27644 invoked by uid 500); 2 Feb 2010 09:20:43 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 27602 invoked by uid 500); 2 Feb 2010 09:20:43 -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 27594 invoked by uid 99); 2 Feb 2010 09:20:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Feb 2010 09:20:43 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Feb 2010 09:20:41 +0000 Received: from brutus.apache.org (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 0EBF3234C1EF for ; Tue, 2 Feb 2010 01:20:20 -0800 (PST) Message-ID: <195293651.22391265102420058.JavaMail.jira@brutus.apache.org> Date: Tue, 2 Feb 2010 09:20:20 +0000 (UTC) From: "Knut Anders Hatlen (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-4380) Subqueries not allowed in ON clause In-Reply-To: <1815040702.1253261217710.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-4380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen updated DERBY-4380: -------------------------------------- Attachment: releaseNote.html Attaching release note. > Subqueries not allowed in ON clause > ----------------------------------- > > Key: DERBY-4380 > URL: https://issues.apache.org/jira/browse/DERBY-4380 > Project: Derby > Issue Type: Improvement > Components: SQL > Affects Versions: 10.5.3.0 > Reporter: Bernt M. Johnsen > Assignee: Knut Anders Hatlen > Fix For: 10.6.0.0 > > Attachments: on_subquery.diff, on_subquery_v2.diff, on_subquery_v2.stat, releaseNote.html, remove_translations.diff > > > SOME is not allowed in ON-clause: > ij> create table t1 (i integer); > 0 rows inserted/updated/deleted > ij> create table t2 (i integer); > 0 rows inserted/updated/deleted > ij> create table t3 (i integer); > 0 rows inserted/updated/deleted > ij> insert into t1 values (1); > 1 row inserted/updated/deleted > ij> insert into t2 values (2); > 1 row inserted/updated/deleted > ij> insert into t3 values 2,3,4; > 3 rows inserted/updated/deleted > ij> select * from t1 where t1.i = some (select i from t3); > I > ----------- > 0 rows selected > ij> select * from t1 inner join t2 on t1.i = some (select i from t3); > ERROR 42972: An ON clause associated with a JOIN operator is not valid. > ij> -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.