You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
An Exception will be thrown if setting search.case_sensitive = false, and having a JSON field as searchable. The field is JSON type due to it being translatable (using the package spatie/laravel-translatable).
Exception: SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(json) does not exist
I'm using Postgresql
EDIT: The problem exists on other field types as well, Orion tries to do lower() on integer columns as well
The text was updated successfully, but these errors were encountered:
pakomp
changed the title
Case-insensitive does not work with json
Case-insensitive does not work with JSON field type
Jun 13, 2023
Hi,
An Exception will be thrown if setting search.case_sensitive = false, and having a JSON field as searchable. The field is JSON type due to it being translatable (using the package spatie/laravel-translatable).
Exception:
SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(json) does not exist
I'm using Postgresql
EDIT: The problem exists on other field types as well, Orion tries to do lower() on integer columns as well
The text was updated successfully, but these errors were encountered: