db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: [jira] Commented: (DERBY-578) Grouped select from temporary table raises null pointer exception in byte code generator
Date Tue, 20 Jun 2006 19:33:47 GMT
Thanks, Manish. I can add the new canon myself. I just want to make sure 
that you've seen and understood this diff and don't regard it as a 
regression.

Regards,
-Rick

Manish Khettry wrote:

> Yes for some reason there is a missing newline in the patch I 
> submitted :(
>
> Do you want to edit the subquery.out file yourself or should I attach 
> another patch? Do you want the entire patch or just subquery.diff?
>
>
>
> On 6/20/06, *Rick Hillegas (JIRA)* <derby-dev@db.apache.org 
> <mailto:derby-dev@db.apache.org>> wrote:
>
>         [
>     http://issues.apache.org/jira/browse/DERBY-578?page=comments#action_12416915
>     ]
>
>     Rick Hillegas commented on DERBY-578:
>     -------------------------------------
>
>     Thanks for the explanation, Manish. I ran derbyall and came up
>     with one unexpected diff in lang/subquery.sql. It's some extra
>     cruft on the printout for some scan qualifiers. On its surface
>     this suggests that a little work is needed to fix that printout.
>     Would appreciate your opinion here.
>
>     > 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: SQL, Services
>     >     Reporter: Rick Hillegas
>     >     Assignee: Manish Khettry
>     >  Attachments: 578.diff.new.txt, 578.diff.txt,
>     predicatePushdown.out.patch
>     >
>     > 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
>
>


Mime
View raw message