diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sqljson_jsontable.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sqljson_jsontable.out --- C:/cirrus/src/test/regress/expected/sqljson_jsontable.out 2025-05-20 08:19:19.683029300 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sqljson_jsontable.out 2025-05-20 08:22:56.223154000 +0000 @@ -41,13 +41,19 @@ ^ --return composite data type. create type comp as (a int, b int); +ERROR: type "comp" already exists SELECT * FROM JSON_TABLE(jsonb '{"rec": "(1,2)"}', '$' COLUMNS (id FOR ORDINALITY, comp comp path '$.rec' omit quotes)) jt; - id | comp -----+------- - 1 | (1,2) + id | comp +----+------ + 1 | (1 row) drop type comp; +ERROR: cannot drop type comp because other objects depend on it +DETAIL: column f4 of table t1 depends on type comp[] +column e of table t1 depends on type comp +column f11 of table t1 depends on column e of table t1 +HINT: Use DROP ... CASCADE to drop the dependent objects too. -- NULL => empty table SELECT * FROM JSON_TABLE(NULL::jsonb, '$' COLUMNS (foo int)) bar; foo