db-postgres: is like
filter condition does case-insensitive text search and the result is equivalent to contains
filter
#6898
Labels
Link to reproduction
No response
Describe the Bug
Both of
is like
andcontains
filter does case-insensitive search by postgresILIKE
operator, and the issued SQL and search results are idential.I guess that
is like
should do case-sensitive search by postgresLIKE
operator.To Reproduce
You can reproduce the problem by
_community
app:Filter by
is like
conditionSQL
Filter by
contains
conditionSQL
Payload Version
2.22.0 (db-postgres: 0.8.5)
Adapters and Plugins
No response
The text was updated successfully, but these errors were encountered: