© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•16mo 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)
image.png
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Database Relationship just returns null
SupabaseSSupabase / help-and-questions
4y ago
FTS Generated Column using data from multiple tables
SupabaseSSupabase / help-and-questions
3y ago
Only insert nullable column if not null
SupabaseSSupabase / help-and-questions
4y ago
Query for non-null values in a nullable column
SupabaseSSupabase / help-and-questions
3y ago