Jiang Bohan 3c4ac3b455 fix(search): use LOWER()+LIKE instead of ILIKE for pg_bigm index compat ...

ILIKE bypasses pg_bigm GIN indexes. Instead, lowercase the query in Go
and use LOWER(column) LIKE in SQL. Rebuild bigram indexes on LOWER()
expressions to match.

2026-04-09 19:03:03 +08:00

..

generated

fix(search): use LOWER()+LIKE instead of ILIKE for pg_bigm index compat

2026-04-09 19:03:03 +08:00

queries

fix(search): use LOWER()+LIKE instead of ILIKE for pg_bigm index compat

2026-04-09 19:03:03 +08:00