Hibernate 3.0.5
RDBMS: MySQL, version: 4.1.12-nt
JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.8 ( $Date: 2005/04/14 20:36:13 $, $Revision: 1.27.4.64 $ )
Is it legal to refer to a set using the equality operator in the where statement? That is:
Code:
from classname where fieldWhichIsASet=:setValue
I tried something like this, assigning "setValue" using query.setParameterList(), and got the following MySQL exception:
Code:
Hibernate: select themehiber0_.id as id, themehiber0_.version as version3_, themehiber0_.name as name3_, themehiber0_.parent_id as parent5_3_, themehiber0_.class as class from theme themehiber0_ where themehiber0_.parent_id is null limit ?
17:16:08,062 WARN JDBCExceptionReporter:71 - SQL Error: 1210, SQLState: HY000
17:16:08,062 ERROR JDBCExceptionReporter:72 - Incorrect arguments to mysql_stmt_execute
Any ideas? Is this a MySQL driver bug, a Hibernate issue or error in my code?
Thanks,
Gili