Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 18272 invoked from network); 5 Oct 2009 15:40:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 5 Oct 2009 15:40:58 -0000 Received: (qmail 34520 invoked by uid 500); 5 Oct 2009 15:40:58 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 34455 invoked by uid 500); 5 Oct 2009 15:40:58 -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 34446 invoked by uid 99); 5 Oct 2009 15:40:58 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Oct 2009 15:40:58 +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; Mon, 05 Oct 2009 15:40:55 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 471C5234C04B for ; Mon, 5 Oct 2009 08:40:31 -0700 (PDT) Message-ID: <627632081.1254757231289.JavaMail.jira@brutus> Date: Mon, 5 Oct 2009 08:40:31 -0700 (PDT) From: "Knut Anders Hatlen (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-4380) SOME 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:comment-tabpanel&focusedCommentId=12762218#action_12762218 ] Knut Anders Hatlen commented on DERBY-4380: ------------------------------------------- Here's a stripped down repro for the NPEs seen in the lojreorder test with the patch: ij> create table t(x int); 0 rows inserted/updated/deleted ij> insert into t values 1; 1 row inserted/updated/deleted ij> select * from t t1 right join t t2 on 1=1 and t1.x in (select a.x from t a left join t b on 1=0 where a.x=b.x); X |X ----------------------- ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression. ERROR XJ001: Java exception: ': java.lang.NullPointerException'. ij> select * from t t1 right join t t2 on 1=1 and t1.x >= ALL (select a.x from t a left join t b on 1=0 where a.x=b.x); X |X ----------------------- ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression. ERROR XJ001: Java exception: ': java.lang.NullPointerException'. > SOME not allowed in ON clause > ----------------------------- > > Key: DERBY-4380 > URL: https://issues.apache.org/jira/browse/DERBY-4380 > Project: Derby > Issue Type: Bug > Components: Store > Reporter: Bernt M. Johnsen > Attachments: on_subquery.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.