[DERBY-4644] Sql query "select * from tablename where column1 in (?,?)" never ends when no parameter value have been set to PreparedStatement.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.5.3.0
• Component/s: JDBC
• Environment: window xp; jdk1.5
• Urgency: Normal
• Assignee: Unassigned
• Reporter: xiaofeng.zhang
• Created: 06/May/10 04:02
• Updated: 24/Jan/11 10:05
• Resolved: 06/May/10 08:53

Description

Reproduce steps:
1. Create a PreparedStatement with sql text "select * from tablename where column1 in (?,?)".
2. Call JDBC PreparedStatement .executeQuery( ) to execute this statement and it never stop. I found my CPU Usage is 100% after this happened.

More info:
1. The SQL like "select * from tablename where column1 in " can return an empty result set
2. If call PreparedStatement .setInt( 1,1 ) to set a parameter value the query can work

Issue Links

• duplicates: DERBY-4376 Simple select runs forever