Hey there -
I have a simple GET for a messages data type based on the thread_id, which is a UUID.
It has worked without any problem up until Sunday. It just stopped working, which is very bizarre. I also didn't touch the function stack, which is just 1 action (query all records where thread_id=message.thread_id)
Depending on the order of the condition I get following errors:
- Exception: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type uuid: "" (SQL: select "message".* from "mvpw1_test_2XX9" as "message" where ("message"."xdo"->>'thread_id')::uuid = '35cbd2ca-f836-465d-b7bb-5f3c13784215')
- {"message":"Invalid cast: \"(\"message\".\"xdo\"->>'thread_id')::uuid\" is of type:\"tablerefuuid\", but trying to be of type:\"text\""}
Anyone an idea or has seen this before?