enum-mapped columns improperly handled in in expressions
--------------------------------------------------------
Key: CAY-832
URL: https://issues.apache.org/cayenne/browse/CAY-832
Project: Cayenne
Issue Type: Bug
Components: Cayenne Core Library
Affects Versions: 2.0 [STABLE]
Environment: os x 10.4
java1.5.0_07
mysql 5.0.27
connectorj 5.0.4
hsqldb 5.1
Reporter: Robert Zeigler
Assignee: Andrus Adamchik
Attachments: enumdemo.tgz
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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
