-
-
Notifications
You must be signed in to change notification settings - Fork 126
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Database relationships query types not working #472
Labels
bug
Something isn't working
Comments
I think the issue is the column name, once the name does not match the foreign table name, the query breaks down for relations. |
ok, it works if I use |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Bug report
Describe the bug
Given a schema types definition for a table like so:
When querying data from
my_resource
, one gets errors or an empty type:This only happens when one tries to query data using relations in a query; the
account
type works fine when querying it directly. It also works on other table types where the foreign key id is calledaccount_id
instead of not matching the foreign table name +_id
.To Reproduce
foreign_table
+_id
(*)
Expected behavior
The correct types are produced based on the relationships generated by the Supabase DB schema.
Screenshots
System information
The text was updated successfully, but these errors were encountered: