ilike query not finding strings when it contains a +

[nyeu]

Bug report

Describe the bug

I have a query that searches if a string is into a column called email. It works really well unless you search for emails that contain a +.

For example:

• nyeu@mail.com would work perfectly
• nyeu+1@mail.com would not work

Both are valid emails and it should return the object.

Here's how I look for it:
queryBuilder.ilike(column: "email", value: "%name+something@mail.com%")

To Reproduce

Search in a column for a string that contains a +.

Expected behavior

It should work with and without the +.

System information

• OS: macOS Ventura 13.3
• Version of supabase-ios: 0.2.1

[tfoldi]

also does not work with eq operator.

I have a fairly simple select:

try await supabase.database
            .from("table")
            .select() // keep it empty for all, else specify returned data
            .eq(column: "id", value: "Cigányka-ér (0+400 cskm) vízrajzi állomás")
            .execute()
            .value

and it does not find anything. Other values without + works fine.

[grdsdev]

Hey guys thanks for providing these examples, I think I was able to fix it on #48, can you guys give it a spin?

[tfoldi]

Tried to add that branch to my project, but have this error:

[grdsdev]

Fixed on https://github.com/supabase-community/postgrest-swift/releases/tag/1.0.2