Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 40576 invoked from network); 2 Apr 2006 15:58:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Apr 2006 15:58:09 -0000 Received: (qmail 36504 invoked by uid 500); 2 Apr 2006 15:58:08 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 36481 invoked by uid 500); 2 Apr 2006 15:58:08 -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 36464 invoked by uid 99); 2 Apr 2006 15:58:07 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Apr 2006 08:58:07 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Apr 2006 08:58:06 -0700 Received: from ajax (localhost.localdomain [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id 4C71B6ACB3 for ; Sun, 2 Apr 2006 16:57:45 +0100 (BST) Message-ID: <2041528419.1143993465311.JavaMail.jira@ajax> Date: Sun, 2 Apr 2006 16:57:45 +0100 (BST) From: "Satheesh Bandaram (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Resolved: (DERBY-1085) java.lang.NullPointerException with char for bit data column and subquery In-Reply-To: <753100970.1141790798951.JavaMail.jira@ajax> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/DERBY-1085?page=all ] Satheesh Bandaram resolved DERBY-1085: -------------------------------------- Fix Version: 10.2.0.0 10.1.3.0 10.1.2.4 Resolution: Fixed Merged in simple fix into trunk and 10.1 branches. > java.lang.NullPointerException with char for bit data column and subquery > -------------------------------------------------------------------------- > > Key: DERBY-1085 > URL: http://issues.apache.org/jira/browse/DERBY-1085 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.1.2.2, 10.2.0.0, 10.1.3.0, 10.1.2.3 > Reporter: Kathey Marsden > Assignee: Satheesh Bandaram > Fix For: 10.2.0.0, 10.1.3.0, 10.1.2.4 > > The repro below gives a NullPointerException with 10.1 and trunk with query involving char for bit data column and subquery: > ij> connect 'wombat;create=true'; > ij> create table npetest1 (col1 char(36) for bit data not null, constraint > pknpe1 primary > key (col1)); > 0 rows inserted/updated/deleted > ij> create table npetest2 (col2 char(36) for bit data, constraint fknpe1 foreign > key > (col2) references npetest1 (col1) on delete cascade); > 0 rows inserted/updated/deleted > ij> insert into npetest1 (col1) values > (x'000000000000000000000000000000000001'); > 1 row inserted/updated/deleted > ij> insert into npetest1 (col1) values > (x'000000000000000000000000000000000002'); > 1 row inserted/updated/deleted > ij> insert into npetest1 (col1) values > (x'000000000000000000000000000000000003'); > 1 row inserted/updated/deleted > ij> insert into npetest2 (col2) values > (x'000000000000000000000000000000000001'); > 1 row inserted/updated/deleted > ij> insert into npetest2 (col2) values (NULL); > 1 row inserted/updated/deleted > ij> insert into npetest2 (col2) values > (x'000000000000000000000000000000000002'); > 1 row inserted/updated/deleted > ij> select col1 from npetest1 where col1 not in (select col2 from > npetest2); > COL1 > ------------------------------------------------------------------------ > ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression. > ERROR XJ001: Java exception: ': java.lang.NullPointerException'. > ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression. > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:315) > at org.apache.derby.iapi.error.StandardException.unexpectedUserException(StandardException.java:564) > at org.apache.derby.impl.services.reflect.DirectCall.invoke(ReflectGeneratedClass.java:163) > at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:270) > at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(BasicNoPutResultSetImpl.java:474) > at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:401) > at org.apache.derby.impl.jdbc.EmbedResultSet.next(EmbedResultSet.java:346) > at org.apache.derby.tools.JDBCDisplayUtil.indent_DisplayResults(JDBCDisplayUtil.java:334) > at org.apache.derby.tools.JDBCDisplayUtil.indent_DisplayResults(JDBCDisplayUtil.java:271) > at org.apache.derby.tools.JDBCDisplayUtil.DisplayResults(JDBCDisplayUtil.java:260) > at org.apache.derby.impl.tools.ij.utilMain.displayResult(utilMain.java:381) > at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:434) > at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:310) > at org.apache.derby.impl.tools.ij.Main.go(Main.java:203) > at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169) > at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55) > at org.apache.derby.tools.ij.main(ij.java:60) > ============= begin nested exception, level (1) =========== > java.lang.NullPointerException > at org.apache.derby.iapi.types.SQLBinary.getLength(SQLBinary.java:230) > at org.apache.derby.impl.sql.execute.BaseActivation.materializeResultSetIfPossible(BaseActivation.java:1430) > at org.apache.derby.exe.acfe120070x0109xd801x02acx000000142bf86.g0(Unknown Source) > at org.apache.derby.exe.acfe120070x0109xd801x02acx000000142bf86.e1(Unknown Source) > at org.apache.derby.impl.services.reflect.DirectCall.invoke(ReflectGeneratedClass.java:140) > at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:270) > at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(BasicNoPutResultSetImpl.java:474) > at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:401) > at org.apache.derby.impl.jdbc.EmbedResultSet.next(EmbedResultSet.java:346) > at org.apache.derby.tools.JDBCDisplayUtil.indent_DisplayResults(JDBCDisplayUtil.java:334) > at org.apache.derby.tools.JDBCDisplayUtil.indent_DisplayResults(JDBCDisplayUtil.java:271) > at org.apache.derby.tools.JDBCDisplayUtil.DisplayResults(JDBCDisplayUtil.java:260) > at org.apache.derby.impl.tools.ij.utilMain.displayResult(utilMain.java:381) > at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:434) > at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:310) > at org.apache.derby.impl.tools.ij.Main.go(Main.java:203) > at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169) > at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55) > at org.apache.derby.tools.ij.main(ij.java:60) > ============= end nested exception, level (1) =========== -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira