You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Manish Khettry (JIRA)" <de...@db.apache.org> on 2006/04/28 20:00:39 UTC

[jira] Updated: (DERBY-578) Grouped select from temporary table raises null pointer exception in byte code generator

     [ 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


Re: JUnit documentation (was: [jira] Updated: (DERBY-578) Grouped select from temporary table raises null pointer exception in byte code generator)

Posted by Kristian Waagan <Kr...@Sun.COM>.
Manish Khettry (JIRA) wrote:
>      [ 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!

Hello Manish,

There is a little information about JUnit at 
http://wiki.apache.org/db-derby/DerbyJUnitTesting, but it really isn't much.

If you go ahead and convert a test, please let the list (or me) know 
what information you miss, and we/I will try to help you and add content 
to the page.



--
Kristian


[snip - DERBY-578 details]

Re: [jira] Updated: (DERBY-578) Grouped select from temporary table raises null pointer exception in byte code generator

Posted by Myrna van Lunteren <m....@gmail.com>.
On 6/6/06, Kathey Marsden <km...@sbcglobal.net> wrote:
> Manish Khettry wrote:
> Hi Manish,
>
> Checking the patch available box  can help get reviewers/committers
> attention.
> http://issues.apache.org/jira/secure/ConfigureReport.jspa?filterid=12310751&mapper=assignees&selectedProjectId=10594&reportKey=com.atlassian.jira.plugin.system.reports%3Asinglelevelgroupby&Next=Next
>
> We seem to have quite a few and quite a few UNASSIGNED and I think maybe
> out of date.
[...snip...]
> and the ever hard working
> Unassigned.

I had a look at the unassigneds, and my attention was caught by
DERBY-654. Unassigned is correct, patch was to disable the running of
a test under a specific jvm and has been committed, so I took off the
patch available check for that one.

Myrna

Re: [jira] Updated: (DERBY-578) Grouped select from temporary table raises null pointer exception in byte code generator

Posted by Kathey Marsden <km...@sbcglobal.net>.
Manish Khettry wrote:

> Just wondering if any of the commiters had seen this and were planning 
> to commit this patch?

Hi Manish,

Checking the patch available box  can help get reviewers/committers 
attention.

Speaking  of patch available ...
http://issues.apache.org/jira/secure/ConfigureReport.jspa?filterid=12310751&mapper=assignees&selectedProjectId=10594&reportKey=com.atlassian.jira.plugin.system.reports%3Asinglelevelgroupby&Next=Next

We seem to have quite a few and quite a few UNASSIGNED and I think maybe 
out of date. 
The patch report shows patches for the following contributors.

A B
Andreas Korneliussen
Deepa Remesh
Dyre Tjeldvoll
Fernanda Pizzorno
John Embretsen
Kristian Waagan
Myrna van Lunteren
Satheesh Bandaram
and the ever hard working
Unassigned.

Take a look if you think you should be on this list or if you are on 
this list but don't think you have a patch oustanding.

Kathey



Re: [jira] Updated: (DERBY-578) Grouped select from temporary table raises null pointer exception in byte code generator

Posted by Manish Khettry <ma...@gmail.com>.
Just wondering if any of the commiters had seen this and were planning to
commit this patch?

Thanks,
Manish

On 4/28/06, Manish Khettry (JIRA) <de...@db.apache.org> wrote:
>
>      [ 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
>
>