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)

/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
    }
]

[
    {
        "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)

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"
        }
    }
]

[
    {
        "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)

Supabase•2y ago•

38 replies

༺ ╲⎝ζ͜͡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)

/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
    }
]

[
    {
        "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)

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"
        }
    }
]

[
    {
        "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)

FTS makes relationship null

Similar Threads

FTS makes relationship null

Similar Threads

Similar Threads

Similar Threads