# org.apache.hop.databases.cockroachdb.CockroachDatabaseMeta
# Generated by CockroachFieldDefinitionGoldenTest. Do not hand-edit.
# Records current behaviour including known bugs. See the class javadoc.

[plain]
STRING       len=      -1 prec=  -1 -        -> TEXT
STRING       len=       0 prec=   0 -        -> TEXT
STRING       len=       4 prec=   0 -        -> VARCHAR(4)
STRING       len=       9 prec=   0 -        -> VARCHAR(9)
STRING       len=      10 prec=   2 -        -> VARCHAR(10)
STRING       len=      15 prec=   0 -        -> VARCHAR(15)
STRING       len=      18 prec=   0 -        -> VARCHAR(18)
STRING       len=      20 prec=   0 -        -> VARCHAR(20)
STRING       len= 9999999 prec=   0 -        -> TEXT
INTEGER      len=      -1 prec=  -1 -        -> BIGINT
INTEGER      len=       0 prec=   0 -        -> BIGINT
INTEGER      len=       4 prec=   0 -        -> SMALLINT
INTEGER      len=       9 prec=   0 -        -> INTEGER
INTEGER      len=      10 prec=   2 -        -> BIGINT
INTEGER      len=      15 prec=   0 -        -> BIGINT
INTEGER      len=      18 prec=   0 -        -> BIGINT
INTEGER      len=      20 prec=   0 -        -> NUMERIC(20, 0)
INTEGER      len= 9999999 prec=   0 -        -> NUMERIC
NUMBER       len=      -1 prec=  -1 -        -> DOUBLE PRECISION
NUMBER       len=       0 prec=   0 -        -> DOUBLE PRECISION
NUMBER       len=       4 prec=   0 -        -> SMALLINT
NUMBER       len=       9 prec=   0 -        -> INTEGER
NUMBER       len=      10 prec=   2 -        -> NUMERIC(10, 2)
NUMBER       len=      15 prec=   0 -        -> BIGINT
NUMBER       len=      18 prec=   0 -        -> BIGINT
NUMBER       len=      20 prec=   0 -        -> NUMERIC(20, 0)
NUMBER       len= 9999999 prec=   0 -        -> NUMERIC
BIGNUMBER    len=      -1 prec=  -1 -        -> DOUBLE PRECISION
BIGNUMBER    len=       0 prec=   0 -        -> DOUBLE PRECISION
BIGNUMBER    len=       4 prec=   0 -        -> SMALLINT
BIGNUMBER    len=       9 prec=   0 -        -> INTEGER
BIGNUMBER    len=      10 prec=   2 -        -> NUMERIC(10, 2)
BIGNUMBER    len=      15 prec=   0 -        -> BIGINT
BIGNUMBER    len=      18 prec=   0 -        -> BIGINT
BIGNUMBER    len=      20 prec=   0 -        -> NUMERIC(20, 0)
BIGNUMBER    len= 9999999 prec=   0 -        -> NUMERIC
DATE         len=      -1 prec=  -1 -        -> TIMESTAMP
DATE         len=       0 prec=   0 -        -> TIMESTAMP
DATE         len=       4 prec=   0 -        -> TIMESTAMP
DATE         len=       9 prec=   0 -        -> TIMESTAMP
DATE         len=      10 prec=   2 -        -> TIMESTAMP
DATE         len=      15 prec=   0 -        -> TIMESTAMP
DATE         len=      18 prec=   0 -        -> TIMESTAMP
DATE         len=      20 prec=   0 -        -> TIMESTAMP
DATE         len= 9999999 prec=   0 -        -> TIMESTAMP
TIMESTAMP    len=      -1 prec=  -1 -        -> TIMESTAMP
TIMESTAMP    len=       0 prec=   0 -        -> TIMESTAMP
TIMESTAMP    len=       4 prec=   0 -        -> TIMESTAMP
TIMESTAMP    len=       9 prec=   0 -        -> TIMESTAMP
TIMESTAMP    len=      10 prec=   2 -        -> TIMESTAMP
TIMESTAMP    len=      15 prec=   0 -        -> TIMESTAMP
TIMESTAMP    len=      18 prec=   0 -        -> TIMESTAMP
TIMESTAMP    len=      20 prec=   0 -        -> TIMESTAMP
TIMESTAMP    len= 9999999 prec=   0 -        -> TIMESTAMP
BOOLEAN      len=      -1 prec=  -1 -        -> CHAR(1)
BOOLEAN      len=       0 prec=   0 -        -> CHAR(1)
BOOLEAN      len=       4 prec=   0 -        -> CHAR(1)
BOOLEAN      len=       9 prec=   0 -        -> CHAR(1)
BOOLEAN      len=      10 prec=   2 -        -> CHAR(1)
BOOLEAN      len=      15 prec=   0 -        -> CHAR(1)
BOOLEAN      len=      18 prec=   0 -        -> CHAR(1)
BOOLEAN      len=      20 prec=   0 -        -> CHAR(1)
BOOLEAN      len= 9999999 prec=   0 -        -> CHAR(1)
BINARY       len=      -1 prec=  -1 -        -> BYTEA
BINARY       len=       0 prec=   0 -        -> BYTEA
BINARY       len=       4 prec=   0 -        -> BYTEA
BINARY       len=       9 prec=   0 -        -> BYTEA
BINARY       len=      10 prec=   2 -        -> BYTEA
BINARY       len=      15 prec=   0 -        -> BYTEA
BINARY       len=      18 prec=   0 -        -> BYTEA
BINARY       len=      20 prec=   0 -        -> BYTEA
BINARY       len= 9999999 prec=   0 -        -> BYTEA
INET         len=      -1 prec=  -1 -        -> INET
INET         len=       0 prec=   0 -        -> INET
INET         len=       4 prec=   0 -        -> INET
INET         len=       9 prec=   0 -        -> INET
INET         len=      10 prec=   2 -        -> INET
INET         len=      15 prec=   0 -        -> INET
INET         len=      18 prec=   0 -        -> INET
INET         len=      20 prec=   0 -        -> INET
INET         len= 9999999 prec=   0 -        -> INET
JSON         len=      -1 prec=  -1 -        -> JSONB
JSON         len=       0 prec=   0 -        -> JSONB
JSON         len=       4 prec=   0 -        -> JSONB
JSON         len=       9 prec=   0 -        -> JSONB
JSON         len=      10 prec=   2 -        -> JSONB
JSON         len=      15 prec=   0 -        -> JSONB
JSON         len=      18 prec=   0 -        -> JSONB
JSON         len=      20 prec=   0 -        -> JSONB
JSON         len= 9999999 prec=   0 -        -> JSONB
VECTOR       len=      -1 prec=  -1 -        -> TEXT
VECTOR       len=       0 prec=   0 -        -> TEXT
VECTOR       len=       4 prec=   0 -        -> TEXT
VECTOR       len=       9 prec=   0 -        -> TEXT
VECTOR       len=      10 prec=   2 -        -> TEXT
VECTOR       len=      15 prec=   0 -        -> TEXT
VECTOR       len=      18 prec=   0 -        -> TEXT
VECTOR       len=      20 prec=   0 -        -> TEXT
VECTOR       len= 9999999 prec=   0 -        -> TEXT

[strings]
STRING       len=     254 prec=   0 -        -> VARCHAR(254)
STRING       len=     255 prec=   0 -        -> VARCHAR(255)
STRING       len=     256 prec=   0 -        -> VARCHAR(256)
STRING       len=    1999 prec=   0 -        -> VARCHAR(1999)
STRING       len=    2000 prec=   0 -        -> VARCHAR(2000)
STRING       len=    2001 prec=   0 -        -> VARCHAR(2001)
STRING       len=    3999 prec=   0 -        -> VARCHAR(3999)
STRING       len=    4000 prec=   0 -        -> VARCHAR(4000)
STRING       len=    4001 prec=   0 -        -> VARCHAR(4001)
STRING       len=    7999 prec=   0 -        -> VARCHAR(7999)
STRING       len=    8000 prec=   0 -        -> VARCHAR(8000)
STRING       len=    8001 prec=   0 -        -> VARCHAR(8001)
STRING       len=   21843 prec=   0 -        -> VARCHAR(21843)
STRING       len=   21844 prec=   0 -        -> VARCHAR(21844)
STRING       len=   32663 prec=   0 -        -> VARCHAR(32663)
STRING       len=   32664 prec=   0 -        -> VARCHAR(32664)
STRING       len=   32671 prec=   0 -        -> VARCHAR(32671)
STRING       len=   32672 prec=   0 -        -> VARCHAR(32672)
STRING       len=   32699 prec=   0 -        -> VARCHAR(32699)
STRING       len=   32700 prec=   0 -        -> VARCHAR(32700)
STRING       len=   32719 prec=   0 -        -> VARCHAR(32719)
STRING       len=   32720 prec=   0 -        -> VARCHAR(32720)
STRING       len=   32766 prec=   0 -        -> VARCHAR(32766)
STRING       len=   32767 prec=   0 -        -> VARCHAR(32767)
STRING       len=   32768 prec=   0 -        -> VARCHAR(32768)
STRING       len=   65532 prec=   0 -        -> VARCHAR(65532)
STRING       len=   65533 prec=   0 -        -> VARCHAR(65533)
STRING       len=   65534 prec=   0 -        -> VARCHAR(65534)
STRING       len=   65535 prec=   0 -        -> VARCHAR(65535)
STRING       len=   65536 prec=   0 -        -> VARCHAR(65536)
STRING       len= 1999999 prec=   0 -        -> VARCHAR(1999999)
STRING       len= 2000000 prec=   0 -        -> VARCHAR(2000000)
STRING       len= 2000001 prec=   0 -        -> VARCHAR(2000001)
STRING       len= 9999998 prec=   0 -        -> VARCHAR(9999998)
STRING       len= 9999999 prec=   0 -        -> TEXT
STRING       len=10000000 prec=   0 -        -> TEXT
STRING       len=16777215 prec=   0 -        -> TEXT
STRING       len=16777216 prec=   0 -        -> TEXT

[keys]
INTEGER      len=      -1 prec=  -1 tk       -> BIGSERIAL
INTEGER      len=      -1 prec=  -1 pk       -> BIGSERIAL
INTEGER      len=      -1 prec=  -1 autoinc  -> BIGSERIAL
INTEGER      len=       0 prec=   0 tk       -> BIGSERIAL
INTEGER      len=       0 prec=   0 pk       -> BIGSERIAL
INTEGER      len=       0 prec=   0 autoinc  -> BIGSERIAL
INTEGER      len=       4 prec=   0 tk       -> BIGSERIAL
INTEGER      len=       4 prec=   0 pk       -> BIGSERIAL
INTEGER      len=       4 prec=   0 autoinc  -> BIGSERIAL
INTEGER      len=       9 prec=   0 tk       -> BIGSERIAL
INTEGER      len=       9 prec=   0 pk       -> BIGSERIAL
INTEGER      len=       9 prec=   0 autoinc  -> BIGSERIAL
INTEGER      len=      10 prec=   2 tk       -> BIGSERIAL
INTEGER      len=      10 prec=   2 pk       -> BIGSERIAL
INTEGER      len=      10 prec=   2 autoinc  -> BIGSERIAL
INTEGER      len=      15 prec=   0 tk       -> BIGSERIAL
INTEGER      len=      15 prec=   0 pk       -> BIGSERIAL
INTEGER      len=      15 prec=   0 autoinc  -> BIGSERIAL
INTEGER      len=      18 prec=   0 tk       -> BIGSERIAL
INTEGER      len=      18 prec=   0 pk       -> BIGSERIAL
INTEGER      len=      18 prec=   0 autoinc  -> BIGSERIAL
INTEGER      len=      20 prec=   0 tk       -> BIGSERIAL
INTEGER      len=      20 prec=   0 pk       -> BIGSERIAL
INTEGER      len=      20 prec=   0 autoinc  -> BIGSERIAL
INTEGER      len= 9999999 prec=   0 tk       -> BIGSERIAL
INTEGER      len= 9999999 prec=   0 pk       -> BIGSERIAL
INTEGER      len= 9999999 prec=   0 autoinc  -> BIGSERIAL
NUMBER       len=      -1 prec=  -1 tk       -> BIGSERIAL
NUMBER       len=      -1 prec=  -1 pk       -> BIGSERIAL
NUMBER       len=      -1 prec=  -1 autoinc  -> BIGSERIAL
NUMBER       len=       0 prec=   0 tk       -> BIGSERIAL
NUMBER       len=       0 prec=   0 pk       -> BIGSERIAL
NUMBER       len=       0 prec=   0 autoinc  -> BIGSERIAL
NUMBER       len=       4 prec=   0 tk       -> BIGSERIAL
NUMBER       len=       4 prec=   0 pk       -> BIGSERIAL
NUMBER       len=       4 prec=   0 autoinc  -> BIGSERIAL
NUMBER       len=       9 prec=   0 tk       -> BIGSERIAL
NUMBER       len=       9 prec=   0 pk       -> BIGSERIAL
NUMBER       len=       9 prec=   0 autoinc  -> BIGSERIAL
NUMBER       len=      10 prec=   2 tk       -> BIGSERIAL
NUMBER       len=      10 prec=   2 pk       -> BIGSERIAL
NUMBER       len=      10 prec=   2 autoinc  -> BIGSERIAL
NUMBER       len=      15 prec=   0 tk       -> BIGSERIAL
NUMBER       len=      15 prec=   0 pk       -> BIGSERIAL
NUMBER       len=      15 prec=   0 autoinc  -> BIGSERIAL
NUMBER       len=      18 prec=   0 tk       -> BIGSERIAL
NUMBER       len=      18 prec=   0 pk       -> BIGSERIAL
NUMBER       len=      18 prec=   0 autoinc  -> BIGSERIAL
NUMBER       len=      20 prec=   0 tk       -> BIGSERIAL
NUMBER       len=      20 prec=   0 pk       -> BIGSERIAL
NUMBER       len=      20 prec=   0 autoinc  -> BIGSERIAL
NUMBER       len= 9999999 prec=   0 tk       -> BIGSERIAL
NUMBER       len= 9999999 prec=   0 pk       -> BIGSERIAL
NUMBER       len= 9999999 prec=   0 autoinc  -> BIGSERIAL
BIGNUMBER    len=      -1 prec=  -1 tk       -> BIGSERIAL
BIGNUMBER    len=      -1 prec=  -1 pk       -> BIGSERIAL
BIGNUMBER    len=      -1 prec=  -1 autoinc  -> BIGSERIAL
BIGNUMBER    len=       0 prec=   0 tk       -> BIGSERIAL
BIGNUMBER    len=       0 prec=   0 pk       -> BIGSERIAL
BIGNUMBER    len=       0 prec=   0 autoinc  -> BIGSERIAL
BIGNUMBER    len=       4 prec=   0 tk       -> BIGSERIAL
BIGNUMBER    len=       4 prec=   0 pk       -> BIGSERIAL
BIGNUMBER    len=       4 prec=   0 autoinc  -> BIGSERIAL
BIGNUMBER    len=       9 prec=   0 tk       -> BIGSERIAL
BIGNUMBER    len=       9 prec=   0 pk       -> BIGSERIAL
BIGNUMBER    len=       9 prec=   0 autoinc  -> BIGSERIAL
BIGNUMBER    len=      10 prec=   2 tk       -> BIGSERIAL
BIGNUMBER    len=      10 prec=   2 pk       -> BIGSERIAL
BIGNUMBER    len=      10 prec=   2 autoinc  -> BIGSERIAL
BIGNUMBER    len=      15 prec=   0 tk       -> BIGSERIAL
BIGNUMBER    len=      15 prec=   0 pk       -> BIGSERIAL
BIGNUMBER    len=      15 prec=   0 autoinc  -> BIGSERIAL
BIGNUMBER    len=      18 prec=   0 tk       -> BIGSERIAL
BIGNUMBER    len=      18 prec=   0 pk       -> BIGSERIAL
BIGNUMBER    len=      18 prec=   0 autoinc  -> BIGSERIAL
BIGNUMBER    len=      20 prec=   0 tk       -> BIGSERIAL
BIGNUMBER    len=      20 prec=   0 pk       -> BIGSERIAL
BIGNUMBER    len=      20 prec=   0 autoinc  -> BIGSERIAL
BIGNUMBER    len= 9999999 prec=   0 tk       -> BIGSERIAL
BIGNUMBER    len= 9999999 prec=   0 pk       -> BIGSERIAL
BIGNUMBER    len= 9999999 prec=   0 autoinc  -> BIGSERIAL

[alter]
STRING       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COLUMN COL TEXT
STRING       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL TEXT; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
STRING       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COLUMN COL VARCHAR(10)
STRING       len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL VARCHAR(10); UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
STRING       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COLUMN COL VARCHAR(15)
STRING       len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL VARCHAR(15); UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
INTEGER      len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COLUMN COL BIGINT
INTEGER      len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL BIGINT; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
INTEGER      len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COLUMN COL BIGINT
INTEGER      len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL BIGINT; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
INTEGER      len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COLUMN COL BIGINT
INTEGER      len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL BIGINT; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
NUMBER       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COLUMN COL DOUBLE PRECISION
NUMBER       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL DOUBLE PRECISION; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
NUMBER       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COLUMN COL NUMERIC(10, 2)
NUMBER       len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL NUMERIC(10, 2); UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
NUMBER       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COLUMN COL BIGINT
NUMBER       len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL BIGINT; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
BIGNUMBER    len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COLUMN COL DOUBLE PRECISION
BIGNUMBER    len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL DOUBLE PRECISION; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
BIGNUMBER    len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COLUMN COL NUMERIC(10, 2)
BIGNUMBER    len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL NUMERIC(10, 2); UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
BIGNUMBER    len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COLUMN COL BIGINT
BIGNUMBER    len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL BIGINT; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
DATE         len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COLUMN COL TIMESTAMP
DATE         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL TIMESTAMP; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
DATE         len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COLUMN COL TIMESTAMP
DATE         len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL TIMESTAMP; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
DATE         len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COLUMN COL TIMESTAMP
DATE         len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL TIMESTAMP; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
TIMESTAMP    len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COLUMN COL TIMESTAMP
TIMESTAMP    len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL TIMESTAMP; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
TIMESTAMP    len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COLUMN COL TIMESTAMP
TIMESTAMP    len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL TIMESTAMP; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
TIMESTAMP    len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COLUMN COL TIMESTAMP
TIMESTAMP    len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL TIMESTAMP; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
BOOLEAN      len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COLUMN COL CHAR(1)
BOOLEAN      len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL CHAR(1); UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
BOOLEAN      len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COLUMN COL CHAR(1)
BOOLEAN      len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL CHAR(1); UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
BOOLEAN      len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COLUMN COL CHAR(1)
BOOLEAN      len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL CHAR(1); UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
BINARY       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COLUMN COL BYTEA
BINARY       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL BYTEA; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
BINARY       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COLUMN COL BYTEA
BINARY       len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL BYTEA; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
BINARY       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COLUMN COL BYTEA
BINARY       len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL BYTEA; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
INET         len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COLUMN COL INET
INET         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL INET; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
INET         len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COLUMN COL INET
INET         len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL INET; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
INET         len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COLUMN COL INET
INET         len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL INET; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
JSON         len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COLUMN COL JSONB
JSON         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL JSONB; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
JSON         len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COLUMN COL JSONB
JSON         len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL JSONB; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
JSON         len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COLUMN COL JSONB
JSON         len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL JSONB; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
VECTOR       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COLUMN COL TEXT
VECTOR       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL TEXT; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
VECTOR       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COLUMN COL TEXT
VECTOR       len=      10 prec=   2 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL TEXT; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
VECTOR       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COLUMN COL TEXT
VECTOR       len=      15 prec=   0 modify   -> ALTER TABLE TBL ADD COLUMN COL_KTL TEXT; UPDATE TBL SET COL_KTL=COL; ALTER TABLE TBL DROP COLUMN COL; ALTER TABLE TBL RENAME COL_KTL TO COL;
