Case insensitive search with postgres #1719

New Issue

Lombra · 2020-04-19T16:35:04Z

Lombra commented

2020-04-19 16:35:04 +00:00

Searching for tasks in the main search bar and the task relation search bar seems to be case sensitive, which is rather confusing.

konrad commented

2020-04-19 17:30:51 +00:00

The search parameter is passed as is into an sql like query which at least in sqlite seems to be case-insensitive (that explains why I didn't notice it yet).
I agree, this should be consistent everywhere.

What database are you using?

The search parameter is passed as is into an sql `like` query which at least in sqlite seems to be case-insensitive (that explains why I didn't notice it yet). I agree, this should be consistent everywhere. What database are you using?

konrad added the

kind/feature

label 2020-04-19 17:31:32 +00:00

Lombra commented

2020-04-19 17:33:47 +00:00

Postgres.

konrad commented

2020-04-19 17:37:16 +00:00

Seems like this is something specific to postgres (which makes sense imho) since the search on try.vikunja.io is case-insensitive and that is running with mysql.

konrad changed title from ~~Case insensitive search~~ to Case insensitive search with postgres

2020-04-27 10:55:35 +00:00

konrad referenced this issue

2020-05-15 13:32:17 +00:00

Fix case-insensitive task search for postgresql #524

konrad commented

2020-05-19 10:52:14 +00:00

Fixed in vikunja/api#524

Fixed in https://kolaente.dev/vikunja/api/pulls/524

konrad closed this issue

2020-05-19 10:52:14 +00:00

konrad referenced this issue from a commit