Describe the bug
We had a query like:
SELECT * FROM tableName WHERE columnName = ANY(:param)
and :param
is a string like '{Value1,Value2}'
This was working fine when using local-data-api with postgres but on aws data-api failed with error:
ERROR: op ANY/ALL (array) requires array on right side\n Position: 464; SQLState: 42809
We fixed it by adding a cast as suggested in the inserting arrays workaround:
SELECT * FROM tableName WHERE columnName = ANY(CAST(:param AS text[]))
To Reproduce
As described above.
Expected behavior
The local-data-api should fail in the same way as aws data-api, as we now can't be sure that our queries that work locally will work on the real thing
Pay now to fund the work behind this issue.
Get updates on progress being made.
Maintainer is rewarded once the issue is completed.
You're funding impactful open source efforts
You want to contribute to this effort
You want to get funding like this too