SupabaseS
Supabase•15mo ago
༺ ╲⎝ζ͜͡Lukyrouge⎠╱༻

FTS makes relationship null

I have a super weird bug but I migh just be very stupid.
If I call /rest/v1/item?limit=10&item_name.fr=fts.'Gemme:*'&select=id,item_name:translation!name_translation_id(fr)
I get : 
[
    {
        "id": 38019,
        "item_name": null
    }
]

And If I call it without the fts like rest/v1/item?limit=1&select=id,item_name:translation!name_translation_id(fr)
I get the relationship : 
[
    {
        "id": 38019,
        "item_name": {
            "fr": "Marquis de l'ombre"
        }
    }
]

I don't understand why the fts breaks the relationship ?

My RLS is on and set to let everyone read everything (in case it changes anything but I highly doubt it)
image.png
Was this page helpful?