cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (CAY-1210) mysql does not use index for case insensitive searches
Date Tue, 28 Jan 2014 10:48:37 GMT

     [ 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)

Mime
View raw message