Today we were working on a client project that we hadn't touched since last week, and a series of SQL queries that were working are no longer functioning. Specifically, the errors seem to be related to the ANY operator and the columns with UUID. I am attaching a screenshot of a simple select that is no longer working. Has the version of Postgres in the Retool DB been recently updated? How can I make the application operational again? Thank you for your prompt responses.
1 Like
Hello @t.naibo,
That is very odd I don't think the version of Postgres has been updated but I can check with the engineering team.
The query in your screenshot looks like it should be valid, it seems the error is related to the IDE thinking the string is supposed to stop after 16fe 
What is the data type for the oj_det.id in your schema?
You might need to either sanitize out the '-' symbols or make sure its reading the entire value as a string. I am guessing this was working fine before and now it isn't without any changes being made?
Does this error message persist if you delete the query and rebuild it?