You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "xiaofeng.zhang (JIRA)" <ji...@apache.org> on 2010/05/06 06:05:48 UTC
[jira] Created: (DERBY-4644) Sql query "select * from tablename
where column1 in (?,?)" never ends when no parameter value have been set to
PreparedStatement.
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.
[jira] Resolved: (DERBY-4644) Sql query "select * from tablename
where column1 in (?,?)" never ends when no parameter value have been set to
PreparedStatement.
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen resolved DERBY-4644.
---------------------------------------
Resolution: Duplicate
I believe this bug has been fixed by DERBY-4376. Resolving as a duplicate. Please reopen if that didn't fix this issue.
The problematic query in DERBY-4376 was a different one: "select * from t where x=? or x=?". However, it is rewritten internally to "select * from t where x in (?,?)" which is the same as the query in this report.
> 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.