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
Reporter: Ari Maniatis
Assignee: Ari Maniatis
Fix For: 3.0
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.
