Actions
Defect #8822
closed
User search is case sensitive
Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Search engine
Target version:
-
Start date:
2011-07-15
Due date:
% Done:
0%
Estimated time:
Resolution:
Fixed
Affected version:
Description
Filter in create user page (/users) generate SQL like:
SELECT * FROM "users" WHERE (1=1 AND (status = 1) AND (LOWER(login) LIKE '%Виктор%' OR LOWER(firstname) LIKE '%Виктор%' OR LOWER(lastname) LIKE '%Виктор%' OR LOWER(mail) LIKE '%Виктор%')) AND ( ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) ) ORDER BY login LIMIT 25 OFFSET 0
Аs result i got nothing, because
LOWER(firstname) LIKE '%Виктор%'does't return anything.
Imho it must used Ilike or what sense in lower()? Or add comment to search field.
Updated by 
Updated by
Updated by Jean-Philippe Lang about 12 years ago
- Status changed from New to Closed
- Resolution set to Fixed
This was fixed some time ago. User.like scope would now use LOWER(firstname) LIKE LOWER('%Виктор%')
Actions