----------------------------------------------------------------
2008-01-16 10:44:39.752 GMT:
 Booting Derby version The Apache Software Foundation - Apache Derby - 10.4.0.0 alpha - (612399): instance c013800d-0117-8233-5b94-000003e8a4d8
on database directory /home/jl208045/ntnu_javadb/usethese/tmp/10.4/testdb  

Database Class Loader started - derby.database.classpath=''
2008-01-16 10:44:46.396 GMT Thread[main,5,main] (XID = 161), (SESSIONID = 0), (DATABASE = testdb), (DRDAID = null), Cleanup action starting
2008-01-16 10:44:46.396 GMT Thread[main,5,main] (XID = 161), (SESSIONID = 0), (DATABASE = testdb), (DRDAID = null), Failed Statement is: select * from a 
   where not exists 
   (select bb from (select bb from b) p where a.bb=p.bb)
java.lang.NullPointerException
	at org.apache.derby.impl.sql.compile.FromSubquery.getMatchingColumn(FromSubquery.java:289)
	at org.apache.derby.impl.sql.compile.FromList.bindColumnReference(FromList.java:602)
	at org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(ColumnReference.java:349)
	at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(ResultColumn.java:552)
	at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(ResultColumnList.java:680)
	at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java:433)
	at org.apache.derby.impl.sql.compile.SelectNode.bindTargetExpressions(SelectNode.java:585)
	at org.apache.derby.impl.sql.compile.SubqueryNode.bindExpression(SubqueryNode.java:473)
	at org.apache.derby.impl.sql.compile.UnaryOperatorNode.bindOperand(UnaryOperatorNode.java:332)
	at org.apache.derby.impl.sql.compile.UnaryLogicalOperatorNode.bindExpression(UnaryLogicalOperatorNode.java:74)
	at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java:456)
	at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(DMLStatementNode.java:227)
	at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:140)
	at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(CursorNode.java:236)
	at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:314)
	at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
	at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:756)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:607)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:556)
	at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:330)
	at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:508)
	at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:353)
	at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:248)
	at org.apache.derby.impl.tools.ij.Main.go(Main.java:215)
	at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:181)
	at org.apache.derby.impl.tools.ij.Main.main(Main.java:73)
	at org.apache.derby.tools.ij.main(ij.java:59)
	at org.apache.derby.iapi.tools.run.main(run.java:51)
Cleanup action completed

2008-01-16 10:44:49.785 GMT:
Shutting down instance c013800d-0117-8233-5b94-000003e8a4d8
----------------------------------------------------------------
