postgrest-py icon indicating copy to clipboard operation
postgrest-py copied to clipboard

Foreign tables filtering issue

Open tbrains opened this issue 3 years ago • 1 comments
trafficstars

When filtering on a foreign table column, the function sanitize_param adds extra quotes if the param has restricted characters, this breaks and throws an error.

'foreign_table.col1' -> sanitize_param -> '"foreign_table.col1"'

I checked, by removing the extra quotes, the filter works as expected. sanitize_param is used twice => filter() and in_().

What do you suggest?

tbrains avatar May 03 '22 16:05 tbrains

Duplicate of supabase-community/postgrest-py#189; we'll get to fixing this soon. Thanks for the report!

anand2312 avatar May 05 '22 06:05 anand2312

Closing in favour of tracking on #189

J0 avatar Feb 07 '23 13:02 J0