supabase / supabase-swift / 31580837832

84%

push

github

fix(postgrest): escape reserved characters in array filter values (#1126)

* fix(postgrest): escape reserved characters in array filter values

Array's PostgrestFilterValue.rawValue joined elements with commas inside
{...} without escaping, so an element containing a comma, brace, quote,
backslash, surrounding whitespace, or the literal NULL corrupted the array
literal — e.g. ["a,b"] became {a,b}, which PostgREST reads as two separate
values. Quote and backslash-escape elements that need it, mirroring the
existing in() filter escaping. Nested array literals ({...}) pass through
unchanged so arrays of arrays keep working.

* fix(postgrest): encode nested arrays and NULL array members by type, not rawValue shape

Array's rawValue guessed nested-array vs. NULL semantics from the shape of
each element's rawValue string, which meant a scalar String that happened to
look like "{a,b}" was misread as a nested array, and Optional.none/AnyJSON.null
were quoted as the string "NULL" instead of an actual SQL NULL array member.
Add a typed PostgrestArrayLiteralElementEncodable contract so Array, Optional,
and AnyJSON declare their own array-literal encoding instead.

---------

Co-authored-by: Guilherme Souza <guilherme@supabase.io>

2 of 34 new or added lines in 2 files covered. (5.88%)

8771 of 10408 relevant lines covered (84.27%)

39.72 hits per line