db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "xiaofeng.zhang (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4644) Sql query "select * from tablename where column1 in (?,?)" never ends when no parameter value have been set to PreparedStatement.
Date Thu, 06 May 2010 04:05:48 GMT
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.


Mime
View raw message