Re: [jira] Commented: (DERBY-578) Grouped select from temporary table raises null pointer exception in byte code generator
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 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-578Project: Derby Type: Bug Components: SQL, Services Reporter: Rick Hillegas Assignee: Manish KhettryAttachments: 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
Re: [jira] Commented: (DERBY-578) Grouped select from temporary table raises null pointer exception in byte code generator
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
Re: [jira] Commented: (DERBY-578) Grouped select from temporary table raises null pointer exception in byte code generator
Since only predicatePushdown failed, I generated a context diff for this one file. I already have a bunch of other uncommitted changes in my view, so I'm not sure how I can generate one patch file without pulling in a lot of other stuff. The following sequence of steps should work. 1. Apply the complete patch (578.patch.txt). 2. revert predicatePushdown 3. patch predicatePushdown. Manish --- Rick Hillegas (JIRA) derby-dev@db.apache.org wrote: [ http://issues.apache.org/jira/browse/DERBY-578?page=comments#action_12416588 ] Rick Hillegas commented on DERBY-578: - Hi Manish, I'm confused about what I'm supposed to do with the latest attachment. It looks like it might just be the changes to predicatePushdown.out. Could you give me a single patch file which contains everything I need to apply this patch and which I can apply with a single patch command? Thanks-Rick 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.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: