aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/models
diff options
context:
space:
mode:
authorChocobozzz <me@florianbigard.com>2022-02-03 10:24:48 +0100
committerChocobozzz <me@florianbigard.com>2022-02-03 10:24:48 +0100
commitcd8f207a8ea3fecd5697ee9b24a968c2c0c140c4 (patch)
treefb7c2b6741dcd2b06aa64feff30ff2faeb68d929 /server/models
parente17358fa335a769d3f22b2d95e9a0d7fef152372 (diff)
downloadPeerTube-cd8f207a8ea3fecd5697ee9b24a968c2c0c140c4.tar.gz
PeerTube-cd8f207a8ea3fecd5697ee9b24a968c2c0c140c4.tar.zst
PeerTube-cd8f207a8ea3fecd5697ee9b24a968c2c0c140c4.zip
Case insensitive search on tags
Diffstat (limited to 'server/models')
-rw-r--r--server/models/video/sql/videos-id-list-query-builder.ts2
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