complete down migration

SasSwart · SasSwart · commit ebb716db58cc · 2024-11-12T09:22:11.000Z
diff --git a/coderd/database/migrations/000274_check_tags.down.sql b/coderd/database/migrations/000274_check_tags.down.sql
@@ -1,3 +1,3 @@
-DROP FUNCTION IF EXISTS tags_compatible(jsonb, jsonb);
+DROP FUNCTION IF EXISTS tags_compatible(tags, tags);
 
 DROP DOMAIN IF EXISTS tags;
diff --git a/coderd/database/migrations/000274_check_tags.up.sql b/coderd/database/migrations/000274_check_tags.up.sql
@@ -1,3 +1,6 @@
+-- We need this as a type alias to ensure that we can override it in sqlc.
+-- We need to override it in sqlc so that it can be recognised as a StringMap.
+-- Without this zero values for other inferred types cause json syntax errors.
 CREATE DOMAIN tags AS jsonb;
 
 CREATE OR REPLACE FUNCTION tags_compatible(subset_tags tags, superset_tags tags)

Original file line number	Diff line number	Diff line change
`@@ -1,3 +1,3 @@`
`1`		`-DROP FUNCTION IF EXISTS tags_compatible(jsonb, jsonb);`
	`1`	`+DROP FUNCTION IF EXISTS tags_compatible(tags, tags);`
`2`	`2`
`3`	`3`	`DROP DOMAIN IF EXISTS tags;`