Sql query "select * from tablename where column1 in (?,?)" never ends when no
parameter value have been set to PreparedStatement.
---------------------------------------------------------------------------------------------------------------------------------
Key: DERBY-4644
URL: https://issues.apache.org/jira/browse/DERBY-4644
Project: Derby
Issue Type: Bug
Components: JDBC
Affects Versions: 10.5.3.0
Environment: window xp; jdk1.5
Reporter: xiaofeng.zhang
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
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
