Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 13282 invoked from network); 28 Apr 2006 18:01:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 28 Apr 2006 18:01:06 -0000 Received: (qmail 69740 invoked by uid 500); 28 Apr 2006 18:01:05 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 69701 invoked by uid 500); 28 Apr 2006 18:01:05 -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 69692 invoked by uid 99); 28 Apr 2006 18:01:05 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Apr 2006 11:01:05 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [209.237.227.198] (HELO brutus.apache.org) (209.237.227.198) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Apr 2006 11:01:04 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id D9BF67142E7 for ; Fri, 28 Apr 2006 18:00:39 +0000 (GMT) Message-ID: <15406756.1146247239889.JavaMail.jira@brutus> Date: Fri, 28 Apr 2006 18:00:39 +0000 (GMT+00:00) From: "Manish Khettry (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-578) Grouped select from temporary table raises null pointer exception in byte code generator In-Reply-To: <1837017731.1127174488364.JavaMail.jira@ajax.apache.org> 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-578?page=all ] Manish Khettry updated DERBY-578: --------------------------------- Attachment: 578.diff.txt The problem is simple enough-- we didn't have a conglomerate name for temporary tables. I fixed the code to behave more like what fillInScanArgs does. Several master files had to be changed and I think I got to all of them. If there is a wiki entry on how to convert existing tests to JUnit or if there is some work underway, let me know! > Grouped select from temporary table raises null pointer exception in byte code generator > ---------------------------------------------------------------------------------------- > > Key: DERBY-578 > URL: http://issues.apache.org/jira/browse/DERBY-578 > Project: Derby > Type: Bug > Components: Services, SQL > Reporter: Rick Hillegas > Assignee: Manish Khettry > Attachments: 578.diff.txt > > The last statement in the following script: > autocommit off; > declare global temporary table session.ztemp > ( orderID varchar( 50 ) ) > not logged; > select orderID from session.ztemp group by orderID; > raises the following stack trace in the trunk: > java.lang.NullPointerException > at java.util.Hashtable.get(Hashtable.java:333) > at org.apache.derby.iapi.services.classfile.ClassHolder.findMatchingEntry(ClassHolder.java:656) > at org.apache.derby.iapi.services.classfile.ClassHolder.addUtf8Entry(ClassHolder.java:482) > at org.apache.derby.iapi.services.classfile.ClassHolder.addString(ClassHolder.java:506) > at org.apache.derby.iapi.services.classfile.ClassHolder.addConstant(ClassHolder.java:302) > at org.apache.derby.impl.services.bytecode.BCMethod.push(BCMethod.java:452) > at org.apache.derby.impl.sql.compile.FromBaseTable.generateDistinctScan(FromBaseTable.java:3216) > at org.apache.derby.impl.sql.compile.FromBaseTable.generateResultSet(FromBaseTable.java:3032) > at org.apache.derby.impl.sql.compile.FromBaseTable.generate(FromBaseTable.java:2978) > at org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1196) > at org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1145) > at org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1196) > at org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1145) > at org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1196) > at org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1145) > at org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1196) > at org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1145) > at org.apache.derby.impl.sql.compile.ScrollInsensitiveResultSetNode.generate(ScrollInsensitiveResultSetNode.java:109) > at org.apache.derby.impl.sql.compile.ReadCursorNode.generate(ReadCursorNode.java:118) > at org.apache.derby.impl.sql.compile.CursorNode.generate(CursorNode.java:546) > at org.apache.derby.impl.sql.compile.StatementNode.generate(StatementNode.java:232) > at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:433) > at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:107) > at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:704) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:533) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480) > at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:299) > at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:433) > 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) -- 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