fix(postgrest): type hinted self-referencing embeds as arrays - #2520
Merged
mandarini merged 2 commits intoJul 14, 2026
Merged
mandarini merged 2 commits into
mandarini merged 2 commits into
Conversation
Copy link
Copy Markdown
Contributor
Sorry, something went wrong.
Copy link
Copy Markdown
|
@supabase/auth-js
npm i https://pkg.pr.new/@supabase/auth-js@2520
npm i https://pkg.pr.new/@supabase/functions-js@2520
npm i https://pkg.pr.new/@supabase/postgrest-js@2520
npm i https://pkg.pr.new/@supabase/realtime-js@2520
npm i https://pkg.pr.new/@supabase/storage-js@2520
npm i https://pkg.pr.new/@supabase/supabase-js@2520 commit: 8ea6979 |
Sorry, something went wrong.
mandarini
force-pushed
the
fix/postgrest-self-ref-hint-array-type
branch
from
13fa08b to
8a8642e
Compare
July 13, 2026 12:57
Self-referencing embeds resolved via an explicit hint (e.g. `collections!parent_id(*)` or `collections!collections_parent_id_fkey(*)`) were incorrectly typed as a single object when the hint matched a column name, while returning an array at runtime. PostgREST only ever resolves the one-to-many direction for a hinted self-reference, so the result is always an array regardless of what the hint matched. Check for an explicit hint before the `match: 'col'` single-object branch, which now applies only to the no-hint case (`parent_id(*)`). Add regression tests for both hint forms. Fixes #2517
mandarini
force-pushed
the
fix/postgrest-self-ref-hint-array-type
branch
from
8a8642e to
ef05ba5
Compare
July 13, 2026 13:36
Comment thread
packages/core/postgrest-js/src/select-query-parser/result.ts
Outdated
Comment thread
packages/core/postgrest-js/test/relationships.test.ts
Copy link
Copy Markdown
|
Coverage is 93.041% — fix/postgrest-self-ref-hint-array-type into master. No base build found for master. |
Sorry, something went wrong.
laurenceisla
approved these changes
Jul 14, 2026
mandarini
pushed a commit
to supabase/ssr
that referenced
this pull request
Jul 15, 2026
This PR updates `@supabase/supabase-js` to v2.110.6. **Source**: supabase-js-stable-release --- ## Release Notes ## v2.110.6 ## 2.110.6 (2026-07-15) ### 🩹 Fixes - **postgrest:** type hinted self-referencing embeds as arrays ([#2520](supabase/supabase-js#2520)) - **realtime:** forward opts to send() in track() ([#2490](supabase/supabase-js#2490)) - **supabase:** warn instead of throw for unrecognized sb_ API key subtypes ([#2526](supabase/supabase-js#2526)) ### ❤️ Thank You - Franco Kaddour @FrancoKaddour - Katerina Skroumpelou @mandarini This PR was created automatically. Co-authored-by: supabase-workflow-trigger[bot] <266661614+supabase-workflow-trigger[bot]@users.noreply.github.com>
mandarini
pushed a commit
to supabase/supabase
that referenced
this pull request
Jul 15, 2026
This PR updates @supabase/*-js libraries to version 2.110.6. **Source**: supabase-js-stable-release **Changes**: - Updated @supabase/supabase-js to 2.110.6 - Updated @supabase/auth-js to 2.110.6 - Updated @supabase/realtime-js to 2.110.6 - Updated @supabase/postgest-js to 2.110.6 - Refreshed pnpm-lock.yaml --- ## Release Notes ## v2.110.6 ## 2.110.6 (2026-07-15) ### 🩹 Fixes - **postgrest:** type hinted self-referencing embeds as arrays ([#2520](supabase/supabase-js#2520)) - **realtime:** forward opts to send() in track() ([#2490](supabase/supabase-js#2490)) - **supabase:** warn instead of throw for unrecognized sb_ API key subtypes ([#2526](supabase/supabase-js#2526)) ### ❤️ Thank You - Franco Kaddour @FrancoKaddour - Katerina Skroumpelou @mandarini ## v2.110.5 ## 2.110.5 (2026-07-14) ### 🩹 Fixes - **supabase:** avoid edge runtime warning ([#2522](supabase/supabase-js#2522)) ### ❤️ Thank You - Vaibhav @7ttp ## v2.110.4 ## 2.110.4 (2026-07-14) ### 🩹 Fixes - **functions:** stop sending API key in Authorization header for function calls ([#2511](supabase/supabase-js#2511)) - **realtime:** encode broadcast header fields as UTF-8 ([#2516](supabase/supabase-js#2516)) ### ❤️ Thank You - Katerina Skroumpelou @mandarini - Pedro Henrique ## v2.110.3 ## 2.110.3 (2026-07-13) ### 🩹 Fixes - **auth:** preserve pkce verifier ([#2513](supabase/supabase-js#2513)) - **postgrest:** pin tstyche target off floating latest ([#2509](supabase/supabase-js#2509)) ### ❤️ Thank You - Katerina Skroumpelou @mandarini - Vaibhav @7ttp ## v2.110.2 ## 2.110.2 (2026-07-09) ### 🩹 Fixes - **auth:** clear local session on signout failures ([#2504](supabase/supabase-js#2504)) ### ❤️ Thank You - Luc Peng This PR was created automatically. Co-authored-by: supabase-workflow-trigger[bot] <266661614+supabase-workflow-trigger[bot]@users.noreply.github.com>
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Self-referencing embeds resolved via an explicit hint (e.g. collections!parent_id(*) or collections!collections_parent_id_fkey(*)) were incorrectly typed as a single object when the hint matched a column name, while returning an array at runtime.
PostgREST only ever resolves the one-to-many direction for a hinted self-reference, so the result is always an array regardless of what the hint matched. Check for an explicit hint before the match: 'col' single-object branch, which now applies only to the no-hint case (parent_id(*)). Add regression tests for both hint forms.
Fixes #2517