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.
This archive was generated by hypermail 2.0.0 : Thu Jul 26 2007 - 14:36:23 EDT