Commit3aa0d73

authored

chore: fix down migration 196 (#13006)

It didn't account for null values.

1 parent319fd5b commit3aa0d73Copy full SHA for 3aa0d73

File tree

-5

lines changed

-5

lines changed

Lines changed: 9 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -11,11 +11,15 @@ CREATE OR REPLACE FUNCTION revert_migrate_external_auth_providers_to_jsonb(jsonb`
`11`	`11`	`DECLARE`
`12`	`12`	`resulttext[];`
`13`	`13`	`BEGIN`
`14`		`-SELECT`
`15`		`- array_agg(id::text) INTO result`
`16`		`-FROM (`
`17`		`-SELECT`
`18`		`- jsonb_array_elements($1)->>'id'AS id)AS external_auth_provider_ids;`
	`14`	`+ IF jsonb_typeof($1)='null' THEN`
	`15`	`+ result :='{}';`
	`16`	`+ ELSE`
	`17`	`+SELECT`
	`18`	`+ array_agg(id::text) INTO result`
	`19`	`+FROM (`
	`20`	`+SELECT`
	`21`	`+ jsonb_array_elements($1)->>'id'AS id)AS external_auth_provider_ids;`
	`22`	`+ END IF;`
`19`	`23`	`RETURN result;`
`20`	`24`	`END;`
`21`	`25`	`$$;`

Comments

(0)