supabase / cli / 30371873088
65%

DEFAULT BRANCH: develop
Ran
Jobs 1
Files 230
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 65.313%. Remained the same
30371873088

push

github

web-flow 
fix(cli): bump default pg-delta version to pick up PUBLIC-privilege revoke fix (#5970)

## What changed

`supabase db diff` (pg-delta engine) silently dropped `REVOKE ... FROM
PUBLIC` privilege changes (default privileges and function EXECUTE) from
generated migrations when diffing a declarative schema. Root cause was
in the upstream `@supabase/pg-delta` library:
`filterPublicBuiltInDefaults()` unconditionally stripped PUBLIC's
implicit default privilege from both sides of a privilege diff, silently
eating any `REVOKE ... FROM PUBLIC` the declarative schema asked for.

Fixed upstream in
[supabase/pg-toolbelt#357](https://github.com/supabase/pg-toolbelt/pull/357)
(merged), released as `@supabase/pg-delta@1.0.0-alpha.33`.

This PR:

- Bumps the two CLI-side "default pg-delta npm version" constants from
`1.0.0-alpha.32` to `1.0.0-alpha.33`
(`apps/cli-go/pkg/config/pgdelta_version.go`,
`apps/cli/src/legacy/commands/db/shared/legacy-pgdelta.deno-templates.ts`).
These are the only version-pin sources of truth — the embedded Deno
template scripts always use a fixed placeholder string that gets
substituted at runtime, so they're unaffected.
- Adds `apps/cli/src/legacy/commands/db/diff/diff.live.test.ts`, a live
regression test against a real local Docker stack: a declarative schema
revoking a function's implicit PUBLIC `EXECUTE` grant, diffed with `db
diff --local --use-pg-delta`, must produce a migration that actually
contains the `REVOKE` statement. Verified empirically in both directions
— passes with the `alpha.33` pin, and (temporarily reverting to
`alpha.32`) reproduces the silent omission pre-fix.

Fixes #5930

## Related

Linear: CLI-1947

11288 of 17283 relevant lines covered (65.31%)

10.52 hits per line

Jobs
ID Job ID Ran Files Coverage
1 30371873088.1 230
65.31
 GitHub Action Run
Source Files on build 30371873088