diff options
| author | Hazelnoot <acomputerdog@gmail.com> | 2025-02-12 11:01:26 -0500 |
|---|---|---|
| committer | Hazelnoot <acomputerdog@gmail.com> | 2025-02-12 11:01:26 -0500 |
| commit | fb058410f6e907428a2fd7b25237d11a6ef39420 (patch) | |
| tree | 080fc6e8027f5cd703c5fabcbf357ed0db0611aa /packages/backend/src/core/SearchService.ts | |
| parent | Merge branch 'develop' into merge/2024-02-03 (diff) | |
| download | sharkey-fb058410f6e907428a2fd7b25237d11a6ef39420.tar.gz sharkey-fb058410f6e907428a2fd7b25237d11a6ef39420.tar.bz2 sharkey-fb058410f6e907428a2fd7b25237d11a6ef39420.zip | |
fix pgroona note.text query
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 35c67400ba..3ad2042d53 100644 --- a/packages/backend/src/core/SearchService.ts +++ b/packages/backend/src/core/SearchService.ts @@ -225,7 +225,7 @@ export class SearchService { .leftJoinAndSelect('renote.user', 'renoteUser'); if (this.config.fulltextSearch?.provider === 'sqlPgroonga') { - query.andWhere('note.text &@ :q', { q }); + query.andWhere('note.text &@~ :q', { q }); } else { query.andWhere('LOWER(note.text) LIKE :q', { q: `%${ sqlLikeEscape(q.toLowerCase()) }%` }); } |