Grokbase Groups Cayenne dev July 2007
enum-mapped columns improperly handled in in expressions

Key: CAY-832
Project: Cayenne
Issue Type: Bug
Components: Cayenne Core Library
Affects Versions: 2.0 [STABLE]
Environment: os x 10.4
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.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
postedJul 26, '07 at 6:36p
activeJul 26, '07 at 6:36p

1 user in discussion

Anonymous: 1 post



site design / logo © 2021 Grokbase