Mailing-List: contact commits-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cayenne.apache.org
Date: Thu, 15 Sep 2011 08:36:08 +0000 (UTC)
From: "Dzmitry Kazimirchyk (JIRA)" <jira@apache.org>
To: commits@cayenne.apache.org
Message-ID: 
 <1589975600.30083.1316075768931.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (CAY-1210) mysql does not use index for case
 insensitive searches
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/CAY-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13105210#comment-13105210 ] 

Dzmitry Kazimirchyk commented on CAY-1210:
------------------------------------------

Committed the changes which will enable us to do this. Anyway, we still need to configure Jenkins to work with our new version naming pattern: http://markmail.org/message/m4x3lxtcoxlsi6r2

> 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 is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira