diff options
| author | Yuba <m.takuma@gmail.com> | 2025-01-04 15:03:00 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-01-04 06:03:00 +0000 |
| commit | 79b3d2a711cc659b9e6c1668b4d182906986bc50 (patch) | |
| tree | b2b74db6a9b38e28cc340a06f99e6a30df48d1e8 /packages/backend/src/core/SearchService.ts | |
| parent | enhance(frontend): ワードミュート・ハードワードミュートの... (diff) | |
| download | sharkey-79b3d2a711cc659b9e6c1668b4d182906986bc50.tar.gz sharkey-79b3d2a711cc659b9e6c1668b4d182906986bc50.tar.bz2 sharkey-79b3d2a711cc659b9e6c1668b4d182906986bc50.zip | |
pg_bigmが利用できるよう、ノートの検索をILIKE演算子でなくLIKE演算子でLOWER()をかけたテキストに対して行うように (#15205)
* Use LIKE-LOWER instead of ILIKE, which pg_bigm doesn't support.
* changelog: Enhance: pg_bigmが利用できるよう、ノートの検索をILIKE演算子でなくLIKE演算子でLOWER()をかけたテキストに対して行うように
Diffstat (limited to 'packages/backend/src/core/SearchService.ts')
| -rw-r--r-- | packages/backend/src/core/SearchService.ts | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/packages/backend/src/core/SearchService.ts b/packages/backend/src/core/SearchService.ts index edfc470375..f3c11277c5 100644 --- a/packages/backend/src/core/SearchService.ts +++ b/packages/backend/src/core/SearchService.ts @@ -215,7 +215,7 @@ export class SearchService { } query - .andWhere('note.text ILIKE :q', { q: `%${ sqlLikeEscape(q) }%` }) + .andWhere('LOWER(note.text) LIKE :q', { q: `%${ sqlLikeEscape(q.toLowerCase()) }%` }) .innerJoinAndSelect('note.user', 'user') .leftJoinAndSelect('note.reply', 'reply') .leftJoinAndSelect('note.renote', 'renote') |