Defect #12349
closed
Watchers auto-complete search on non-latin chars
0%
Description
The current code generates SQL like as:
SELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND (users.status = 1) AND (LOWER(login) LIKE '%Собо%' OR LOWER(firstname) LIKE '%Собо%' OR LOWER(lastname) LIKE '%Собо%' OR LOWER(mail) LIKE '%Собо%') LIMIT 100
So, searching user "Соболев Денис" on "Собо" as result - not found. There is the case sensitive.
Patch attached.
Files
Updated by Jean-Philippe Lang over 11 years ago
- Status changed from New to Confirmed
- Target version set to 2.1.3
Updated by Jean-Philippe Lang over 11 years ago
- Status changed from Confirmed to Resolved
- Assignee set to Jean-Philippe Lang
- Resolution set to Fixed
Was working fine with Mysql but not Postgresql. Fixed in r10801 with a test.
Updated by Alexander Oryol over 11 years ago
Hmmm...
Repo https://github.com/redmine/redmine syncronization broken again. Fix it please!
Updated by Toshi MARUYAMA over 11 years ago
Alexander Oryol wrote:
Hmmm...
Repo https://github.com/redmine/redmine syncronization broken again. Fix it please!
See #11918.
Bitbucket Mercurial mirror is syncronized.
https://bitbucket.org/redmine
Updated by Daniel Felix over 11 years ago
- Status changed from Resolved to Closed
I close this one too as it seems to work.
Updated by Toshi MARUYAMA over 11 years ago
- Status changed from Closed to Reopened
Not yet merged 2.1-stable branch.