[
https://issues.apache.org/jira/browse/CAY-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12981164#action_12981164
]
Andrus Adamchik commented on CAY-1210:
--------------------------------------
I think the purpose of this property is somewhat analogous to your suggestion
of tagging individual DbAttributes as CI or CS. So use of BINARY should
probably be implied for CI. So suggesting a different property naming:
cayenne.runtime.db.collation.assume.ci = true | false
If true: BINARY is used for CS search, UPPER is dropped for CI search
If false (default): no change from current policy.
> mysql does not use index for case insensitive searches
> ------------------------------------------------------
>
> Key: CAY-1210
> URL: https://issues.apache.org/jira/browse/CAY-1210
> Project: Cayenne
> Issue Type: Improvement
> Components: Database integration
> Reporter: Ari Maniatis
> Assignee: Ari Maniatis
> Fix For: 3.1M1
>
>
> When performing a case insensitive search Cayenne spits out SQL which looks
> like this
> SELECT .... WHERE upper(name) LIKE upper("fred")
> This prevents any index being used for the search. Since mysql already
> performed case insensitive searches on text fields we need to suppress the
> 'upper' functions being used in these situations. All searches on these
> fields are already case insensitive.
> http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
