feat: support for case insensitive for contains and like queries #6045

nityanandagohain · 2024-09-20T12:13:43Z

This PR adds case insensitive support to like/ilike/contains/ncontains

Attributes

We are taking the tradeoff that contains/ncontains/like/ilike won't use the index.

As of now we have two index for resources one is lowecase and the other one is uppercase.
Since we want case insensitivity for like/ilike/contains/ncontains , we are using the lowercase index.

For body and resource we are making sure case insensitive search works by using like with lower(column).

nityanandagohain · 2024-09-23T04:28:20Z

Have made a small change with respect to index filter to build it with lowercase which was missed, please have a look at the last commit.

feat: support for case insensitive for contains and like queries

236b1a5

nityanandagohain requested a review from srikanthccv September 20, 2024 12:13

github-actions bot added the enhancement New feature or request label Sep 20, 2024

srikanthccv previously approved these changes Sep 20, 2024

View reviewed changes

fix: make index filter lowercase for like and not like

426d1ff

nityanandagohain dismissed srikanthccv’s stale review via 426d1ff September 23, 2024 04:27

nityanandagohain requested a review from srikanthccv September 23, 2024 04:27

Merge branch 'develop' into feat/case-insensitive

06f600c

srikanthccv approved these changes Sep 23, 2024

View reviewed changes

nityanandagohain merged commit 3866f89 into develop Sep 23, 2024
13 checks passed

nityanandagohain deleted the feat/case-insensitive branch September 23, 2024 06:57