[DERBY-4105] NPE when the attached reproducible script is run using ij.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 10.1.3.2
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Mamta A. Satoor
• Created: 20/Mar/09 21:08
• Updated: 23/Mar/09 19:45
• Resolved: 23/Mar/09 16:51

Description

I am running the attached script in ij as shown below
$ java -Dij.exceptionTrace=true org.apache.derby.tools.ij
ij version 10.1
ij> connect 'jdbc:derby:testDB;create=true';
ij> run 'script1.sql';

After running quite a bit of sql in the script, it gives following NPE
ij> UPDATE table2 SET value='true' WHERE id=2147483649 AND name='has_address';
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
java.lang.NullPointerException
at org.apache.derby.impl.sql.compile.TypeCompilerFactoryImpl.getAnInstance(TypeCompilerFactoryImpl.java:318)
at org.apache.derby.impl.sql.compile.TypeCompilerFactoryImpl.staticGetTypeCompiler(TypeCompilerFactoryImpl.java:248)
at org.apache.derby.impl.sql.compile.TypeCompilerFactoryImpl.getTypeCompiler(TypeCompilerFactoryImpl.java:81)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getTypeCompiler(QueryTreeNode.java:739)
at org.apache.derby.impl.sql.compile.ValueNode.getTypeCompiler(ValueNode.java:223)
at org.apache.derby.impl.sql.compile.ResultColumn.checkStorableExpression(ResultColumn.java:876)
at org.apache.derby.impl.sql.compile.ResultColumnList.checkStorableExpressions(ResultColumnList.java:922)
at org.apache.derby.impl.sql.compile.UpdateNode.bind(UpdateNode.java:531)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:332)
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:513)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:487)
at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:313)
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)

Issue Links

• relates to: DERBY-3926 Incorrect ORDER BY caused by index