[DERBY-4376] Simple select runs forever

• 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.3.3.1, 10.4.2.1, 10.5.3.1, 10.6.1.0
• Component/s: SQL
• Issue & fix info: Repro attached
• Bug behavior facts: Regression
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 15/Sep/09 08:52
• Updated: 06/May/10 09:00
• Resolved: 25/Sep/09 17:38

Description

On Derby 10.3.1.4 and later, I see that evaluating the statements below in ij apparently makes Derby go into an infinite loop. The select statement ran for two hours until I aborted it. I do not see this problem on Derby 10.2.2.0 or earlier.

ij> create table t(x int primary key);
0 rows inserted/updated/deleted
ij> prepare ps as 'select * from t where x=? or x=?';
ij> execute ps using 'values (cast(null as int), 0)';
IJ WARNING: Autocommit may close using result set
X
-----------

Issue Links

• is duplicated by: DERBY-4644 Sql query "select * from tablename where column1 in (?,?)" never ends when no parameter value have been set to PreparedStatement.
• is related to: ODE-671 clean up queries in HLargeData are too broad
• relates to: DERBY-47 Some possible improvements to IN optimization
• relates to: DERBY-4378 Create test cases for MultiProbeTableScanResultSet with duplicates in the probe list