!!!TEST there is a enum
enum a {
a;
b;
};
!!!UPDATE enum is dropped, scalar is created with the same name
scalar a = sql"TEXT";
!!!RESULT
-- updated: there is a enum --
CREATE TYPE a AS ENUM (
'a'
, 'b'
);
-- updated: enum is dropped, scalar is created with the same name --
ALTER TYPE a
RENAME TO moveaway_1
;
CREATE DOMAIN a AS TEXT;
DROP TYPE moveaway_1;
-- updated: cleanup schema changes --
DROP DOMAIN a;