[
https://issues.apache.org/jira/browse/CAY-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrus Adamchik closed CAY-1210.
--------------------------------
Resolution: Fixed
Both 3.1 and 3.2 support 'cayenne.runtime.db.collation.assume.ci'. It was
committed on Sept 14, 2011, i.e. after the patches. So I added it ti old
release notes, and now closing the issue. If there's anything else we need to
do, let's jira it separately.
> 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.1 (final)
>
> Attachments: case-insensitive-search.patch,
> case-insensitive-search.patch
>
>
> 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 was sent by Atlassian JIRA
(v6.1.5#6160)
