db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "mark boylan" <markboy...@hotmail.com>
Subject Re: Derby fails inserting a join
Date Wed, 08 Mar 2006 16:22:10 GMT
Hi Satheesh,

Can you give me the link for JIRA?

Here's the contents of derby.log:

- mark


----------------------------------------------------------------
2006-03-07 20:01:12.152 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby - 
10.1.2.1 - (330608): instance c013800d-0109-d64c-5067-000000172958
on database directory D:\Documents and Settings\***\My Documents\test

Database Class Loader started - derby.database.classpath=''
2006-03-07 20:01:52.671 GMT Thread[main,5,main] (XID = 124), (SESSIONID = 
0), (DATABASE = test), (DRDAID = null), Cleanup action starting
2006-03-07 20:01:52.671 GMT Thread[main,5,main] (XID = 124), (SESSIONID = 
0), (DATABASE = test), (DRDAID = null), Failed Statement is: insert into 
dest (source_id_1, source_id_2)
select s1.source_id, s2.source_id
from source as s1
join source as s2
on 1 = 1
java.lang.NullPointerException
	at 
org.apache.derby.impl.sql.compile.ResultColumnList.remapColumnReferencesToExpressions(Unknown

Source)
	at org.apache.derby.impl.sql.compile.JoinNode.flatten(Unknown Source)
	at org.apache.derby.impl.sql.compile.FromList.flattenFromTables(Unknown 
Source)
	at org.apache.derby.impl.sql.compile.SelectNode.preprocess(Unknown Source)
	at 
org.apache.derby.impl.sql.compile.SingleChildResultSetNode.preprocess(Unknown 
Source)
	at org.apache.derby.impl.sql.compile.DMLStatementNode.optimize(Unknown 
Source)
	at org.apache.derby.impl.sql.compile.DMLModStatementNode.optimize(Unknown 
Source)
	at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
	at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
	at 
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown

Source)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
	at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
	at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
	at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
	at org.apache.derby.tools.ij.main(Unknown Source)
Cleanup action completed

2006-03-07 20:43:03.759 GMT:
Shutting down instance c013800d-0109-d64c-5067-000000172958
----------------------------------------------------------------

>
>
>mark boylan wrote:
>
> > Hi.
> >
> > ij> insert into dest (source_id_1, source_id_2)
> > select s1.source_id, s2.source_id
> > from source as s1
> > join source as s2
> > on 1 = 1;
> >
> > ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> > ij>
> >
>That is a strange response to a simple query.... If you can post
>derby.log, with exception stack, that would help.  Also do file a bug
>report in JIRA. Issues like this are typically easily fixable. I can
>help if anyone wants to try.
>
>Satheesh
>
>



Mime
View raw message