Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
2.0 branch
-
None
-
os x 10.4
java1.5.0_07
mysql 5.0.27
connectorj 5.0.4
hsqldb 5.1
Description
When mapping string or int columns to enum types, queries using "in" expressions against the enum-mapped column will fail.
The objects in the list provided to the expression are not properly converted to their database representation.
For mysql, this happens for both character and numeric database representations of the column type.
In testing, I found that using hsqldb results in the enum types being converted to strings; so in expressions work with enums, hsqldb , and character-based db representations of the enum type, but fail for hsqldb and numeric db representations of the enum.