Recently encountered an issue in queries to Postgres.
Say you have a table with an entry:
id = 1
name = ‘TEST_NAME’
select * from auth_group where name ilike ‘%TEST_NAME%’
The above query will yield no results in Retool, although does return you the record with ID 1 if queried to the DB.
Also, it seemed to work in earlier versions.
Is this expected?