[DERBY-4549] NPE in JBitSet

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.1.4, 10.5.3.0, 10.6.1.0
• Fix Version/s: 10.5.3.1, 10.6.1.0
• Component/s: SQL
• Urgency: Urgent
• Bug behavior facts: Seen in production
• Assignee: Knut Anders Hatlen
• Reporter: Murat Knecht
• Created: 16/Feb/10 09:24
• Updated: 17/Jun/13 09:19
• Resolved: 18/Feb/10 10:36

Description

A NPE occurs at org.apache.derby.iapi.util.JBitSet.or().

A NPE occured at the same location before: http://issues.apache.org/jira/browse/DERBY-1574
The bug was confirmed by Bryan Pendleton to show in the HEAD as well: http://mail-archives.apache.org/mod_mbox/db-derby-user/201002.mbox/[e-mail]%3E

To reproduce:
----------------------

CREATE TABLE ABC (ID int PRIMARY KEY NOT NULL);
CREATE TABLE DEF (ID int PRIMARY KEY NOT NULL);

SELECT *
FROM ABC t1
WHERE (SELECT DISTINCT t2.ID FROM DEF t2)
IN (SELECT t3.ID FROM DEF t3)

----------------------

Leads to

error message:
Error: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerExceptionXJ001.U
SQLState: XJ001
ErrorCode: -1

Stacktrace:
java.lang.NullPointerException
at org.apache.derby.iapi.util.JBitSet.or(Unknown Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.<init>(Unknown Source)
at org.apache.derby.impl.sql.compile.Level2OptimizerImpl.<init>(Unknown Source)
at org.apache.derby.impl.sql.compile.Level2OptimizerFactoryImpl.getOptimizerImpl(Unknown Source)
at org.apache.derby.impl.sql.compile.OptimizerFactoryImpl.getOptimizer(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultSetNode.getOptimizer(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source)
at org.apache.derby.impl.sql.compile.SubqueryNode.optimize(Unknown Source)
at org.apache.derby.impl.sql.compile.SubqueryList.optimize(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(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.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.drda.DRDAStatement.prepare(Unknown Source)
at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Cleanup action completed

Issue Links

• relates to: DERBY-1574 NullPointerException in UPDATE with COALESCE and subquery