]> source.dussan.org Git - gitea.git/commit
Make searching issues by keyword case insensitive on DB (#14848)
authorzeripath <art27@cantab.net>
Tue, 2 Mar 2021 13:07:01 +0000 (13:07 +0000)
committerGitHub <noreply@github.com>
Tue, 2 Mar 2021 13:07:01 +0000 (14:07 +0100)
commitdef964e57fae6dadf124f07d3b250b0a09a37546
tree08e2ef5f93a7c7e6b775991977e8c0ba347c36cd
parentf878c8231f9e8a29668e19d27c29eedb1c6dab0e
Make searching issues by keyword case insensitive on DB (#14848)

Most DBs apart from SQLite will use a default Collation that is not case insensitive.
This means that SearchIssuesByKeyword becomes case sensitive for db indexing - in
contrast to the bleve and elastic indexers.

This PR simply uses UPPER(...) to do the LIKE - and although it may be more efficient
to change collations this would be a non-trivial task.

Fix #13663

Signed-off-by: Andrew Thornton <art27@cantab.net>
models/issue.go