cli icon indicating copy to clipboard operation
cli copied to clipboard

Supabase diff omit semicolon from migration statement?

Open higheruceo opened this issue 1 year ago • 1 comments

Describe the bug supabase diff when specifying --db-url does not include semicolon

To Reproduce supabase db diff --db-url postgres://url -f migration_name

Expected behavior semicolon should be included at the end of each statement so that a supabase start or db reset would complete without error.

System information Rerun the failing command with --create-ticket flag.

  • Ticket ID: 469084417d594511b4593c1a8156f238
  • Version of OS: MacOs
  • Version of CLI: 1.163.6

higheruceo avatar Apr 28 '24 18:04 higheruceo

Sorry I can't seem to reproduce

$ supabase db diff --db-url 'postgres://postgres:postgres@localhost:54322/postgres' -f what
onnecting to remote database...
Creating shadow database...

$ cat supabase/migrations/20240429062258_what.sql
create extension if not exists "hypopg" with schema "extensions";

create extension if not exists "index_advisor" with schema "extensions";

Could you report versions from the supabase services as well as the problematic schema and actual output?

sweatybridge avatar Apr 29 '24 06:04 sweatybridge

closing as not reproducible

sweatybridge avatar Jun 10 '24 14:06 sweatybridge