[JAMES-176] MySQL query not using index for string comparison

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.2.0
• Component/s: UsersStore & UsersRepository
• Assignee: Unassigned
• Reporter: Serge Knystautas
• Created: 21/Mar/04 22:49
• Updated: 21/Mar/04 22:50
• Resolved: 21/Mar/04 22:50

Description

MySQL SELECT string comparisions are already case-insensitive. Using lower() in a WHERE clause effectively negates the index.