supabase/postgres-meta

gentype producing wrong type for inner join

louisgv opened this issue 2 years ago · 1 comments

louisgv commented 2 years ago

Bug report

I confirm this is a bug with Supabase, not with my own application.
I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

When creating an inner join via a !inner(*) query, the inferred type returns an array, but the actual data is a single object.

To Reproduce

await supabase
      .from('deadwood')
      .select('*, cs!inner(*)')

Expected behavior

deadwood.cs should be typed correctly

System information

OS: macOS
Browser (if applies) [e.g. chrome, safari]
Version of supabase-js: 1.77.9
Version of Node.js: 18.x

Additional context

sweatybridge commented 2 years ago

The underlying cause seems to be non-handling of unique constraint. Closing as a duplicate of #612