プロジェクト

全般

プロフィール

Vote #72814

完了

Watchers auto-complete search on non-latin chars

Admin Redmine さんが3年以上前に追加. 3年以上前に更新.

ステータス:
Closed
優先度:
通常
担当者:
-
カテゴリ:
Database_21
対象バージョン:
開始日:
2022/05/09
期日:
進捗率:

0%

予定工数:
category_id:
21
version_id:
59
issue_org_id:
12349
author_id:
3231
assigned_to_id:
1
comments:
7
status_id:
5
tracker_id:
1
plus1:
0
affected_version:
closed_on:
affected_version_id:
ステータス-->[Closed]

説明

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.


journals

--------------------------------------------------------------------------------
Was working fine with Mysql but not Postgresql. Fixed in r10801 with a test.
--------------------------------------------------------------------------------
Hmmm...
Repo https://github.com/redmine/redmine syncronization broken again. Fix it please!
--------------------------------------------------------------------------------
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

--------------------------------------------------------------------------------
I close this one too as it seems to work.
--------------------------------------------------------------------------------
Not yet merged 2.1-stable branch.
--------------------------------------------------------------------------------
Merged.
--------------------------------------------------------------------------------

Admin Redmine さんが3年以上前に更新

  • カテゴリDatabase_21 にセット
  • 対象バージョン2.1.3_59 にセット

他の形式にエクスポート: Atom PDF

いいね!0
いいね!0