diff options
| author | Chocobozzz <me@florianbigard.com> | 2022-02-03 10:24:48 +0100 |
|---|---|---|
| committer | Chocobozzz <me@florianbigard.com> | 2022-02-03 10:24:48 +0100 |
| commit | cd8f207a8ea3fecd5697ee9b24a968c2c0c140c4 (patch) | |
| tree | fb7c2b6741dcd2b06aa64feff30ff2faeb68d929 | |
| parent | e17358fa335a769d3f22b2d95e9a0d7fef152372 (diff) | |
| download | PeerTube-cd8f207a8ea3fecd5697ee9b24a968c2c0c140c4.tar.gz PeerTube-cd8f207a8ea3fecd5697ee9b24a968c2c0c140c4.tar.zst PeerTube-cd8f207a8ea3fecd5697ee9b24a968c2c0c140c4.zip | |
Case insensitive search on tags
| -rw-r--r-- | server/models/video/sql/videos-id-list-query-builder.ts | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/server/models/video/sql/videos-id-list-query-builder.ts b/server/models/video/sql/videos-id-list-query-builder.ts index 76aafb883..098e15359 100644 --- a/server/models/video/sql/videos-id-list-query-builder.ts +++ b/server/models/video/sql/videos-id-list-query-builder.ts | |||
| @@ -545,7 +545,7 @@ export class VideosIdListQueryBuilder extends AbstractRunQuery { | |||
| 545 | ' EXISTS (' + | 545 | ' EXISTS (' + |
| 546 | ' SELECT 1 FROM "videoTag" ' + | 546 | ' SELECT 1 FROM "videoTag" ' + |
| 547 | ' INNER JOIN "tag" ON "tag"."id" = "videoTag"."tagId" ' + | 547 | ' INNER JOIN "tag" ON "tag"."id" = "videoTag"."tagId" ' + |
| 548 | ` WHERE lower("tag"."name") = ${escapedSearch} ` + | 548 | ` WHERE lower("tag"."name") = lower(${escapedSearch}) ` + |
| 549 | ' AND "video"."id" = "videoTag"."videoId"' + | 549 | ' AND "video"."id" = "videoTag"."videoId"' + |
| 550 | ' )' | 550 | ' )' |
| 551 | 551 | ||