# org.apache.hop.databases.netezza.NetezzaDatabaseMeta
# Generated by NetezzaFieldDefinitionGoldenTest. Do not hand-edit.
# Records current behaviour including known bugs. See the class javadoc.

[plain]
STRING       len=      -1 prec=  -1 -        -> varchar(-1)
STRING       len=       0 prec=   0 -        -> varchar(0)
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 -        -> varchar(32767)
INTEGER      len=      -1 prec=  -1 -        -> 
INTEGER      len=       0 prec=   0 -        -> 
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 -        -> bigint
INTEGER      len= 9999999 prec=   0 -        -> bigint
NUMBER       len=      -1 prec=  -1 -        -> 
NUMBER       len=       0 prec=   0 -        -> 
NUMBER       len=       4 prec=   0 -        -> smallint
NUMBER       len=       9 prec=   0 -        -> integer
NUMBER       len=      10 prec=   2 -        -> double
NUMBER       len=      15 prec=   0 -        -> bigint
NUMBER       len=      18 prec=   0 -        -> bigint
NUMBER       len=      20 prec=   0 -        -> bigint
NUMBER       len= 9999999 prec=   0 -        -> bigint
BIGNUMBER    len=      -1 prec=  -1 -        -> 
BIGNUMBER    len=       0 prec=   0 -        -> 
BIGNUMBER    len=       4 prec=   0 -        -> smallint
BIGNUMBER    len=       9 prec=   0 -        -> integer
BIGNUMBER    len=      10 prec=   2 -        -> double
BIGNUMBER    len=      15 prec=   0 -        -> bigint
BIGNUMBER    len=      18 prec=   0 -        -> bigint
BIGNUMBER    len=      20 prec=   0 -        -> bigint
BIGNUMBER    len= 9999999 prec=   0 -        -> bigint
DATE         len=      -1 prec=  -1 -        -> date
DATE         len=       0 prec=   0 -        -> date
DATE         len=       4 prec=   0 -        -> date
DATE         len=       9 prec=   0 -        -> date
DATE         len=      10 prec=   2 -        -> date
DATE         len=      15 prec=   0 -        -> date
DATE         len=      18 prec=   0 -        -> date
DATE         len=      20 prec=   0 -        -> date
DATE         len= 9999999 prec=   0 -        -> date
TIMESTAMP    len=      -1 prec=  -1 -        -> UNKNOWN
TIMESTAMP    len=       0 prec=   0 -        -> UNKNOWN
TIMESTAMP    len=       4 prec=   0 -        -> UNKNOWN
TIMESTAMP    len=       9 prec=   0 -        -> UNKNOWN
TIMESTAMP    len=      10 prec=   2 -        -> UNKNOWN
TIMESTAMP    len=      15 prec=   0 -        -> UNKNOWN
TIMESTAMP    len=      18 prec=   0 -        -> UNKNOWN
TIMESTAMP    len=      20 prec=   0 -        -> UNKNOWN
TIMESTAMP    len= 9999999 prec=   0 -        -> UNKNOWN
BOOLEAN      len=      -1 prec=  -1 -        -> boolean
BOOLEAN      len=       0 prec=   0 -        -> boolean
BOOLEAN      len=       4 prec=   0 -        -> boolean
BOOLEAN      len=       9 prec=   0 -        -> boolean
BOOLEAN      len=      10 prec=   2 -        -> boolean
BOOLEAN      len=      15 prec=   0 -        -> boolean
BOOLEAN      len=      18 prec=   0 -        -> boolean
BOOLEAN      len=      20 prec=   0 -        -> boolean
BOOLEAN      len= 9999999 prec=   0 -        -> boolean
BINARY       len=      -1 prec=  -1 -        -> UNKNOWN
BINARY       len=       0 prec=   0 -        -> UNKNOWN
BINARY       len=       4 prec=   0 -        -> UNKNOWN
BINARY       len=       9 prec=   0 -        -> UNKNOWN
BINARY       len=      10 prec=   2 -        -> UNKNOWN
BINARY       len=      15 prec=   0 -        -> UNKNOWN
BINARY       len=      18 prec=   0 -        -> UNKNOWN
BINARY       len=      20 prec=   0 -        -> UNKNOWN
BINARY       len= 9999999 prec=   0 -        -> UNKNOWN
INET         len=      -1 prec=  -1 -        -> varchar(45)
INET         len=       0 prec=   0 -        -> varchar(45)
INET         len=       4 prec=   0 -        -> varchar(45)
INET         len=       9 prec=   0 -        -> varchar(45)
INET         len=      10 prec=   2 -        -> varchar(45)
INET         len=      15 prec=   0 -        -> varchar(45)
INET         len=      18 prec=   0 -        -> varchar(45)
INET         len=      20 prec=   0 -        -> varchar(45)
INET         len= 9999999 prec=   0 -        -> varchar(45)
JSON         len=      -1 prec=  -1 -        -> varchar(32767)
JSON         len=       0 prec=   0 -        -> varchar(32767)
JSON         len=       4 prec=   0 -        -> varchar(4)
JSON         len=       9 prec=   0 -        -> varchar(9)
JSON         len=      10 prec=   2 -        -> varchar(10)
JSON         len=      15 prec=   0 -        -> varchar(15)
JSON         len=      18 prec=   0 -        -> varchar(18)
JSON         len=      20 prec=   0 -        -> varchar(20)
JSON         len= 9999999 prec=   0 -        -> varchar(32767)
VECTOR       len=      -1 prec=  -1 -        -> varchar(32767)
VECTOR       len=       0 prec=   0 -        -> varchar(32767)
VECTOR       len=       4 prec=   0 -        -> varchar(32767)
VECTOR       len=       9 prec=   0 -        -> varchar(32767)
VECTOR       len=      10 prec=   2 -        -> varchar(32767)
VECTOR       len=      15 prec=   0 -        -> varchar(32767)
VECTOR       len=      18 prec=   0 -        -> varchar(32767)
VECTOR       len=      20 prec=   0 -        -> varchar(32767)
VECTOR       len= 9999999 prec=   0 -        -> varchar(32767)

[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(32767)
STRING       len=   65532 prec=   0 -        -> varchar(32767)
STRING       len=   65533 prec=   0 -        -> varchar(32767)
STRING       len=   65534 prec=   0 -        -> varchar(32767)
STRING       len=   65535 prec=   0 -        -> varchar(32767)
STRING       len=   65536 prec=   0 -        -> varchar(32767)
STRING       len= 1999999 prec=   0 -        -> varchar(32767)
STRING       len= 2000000 prec=   0 -        -> varchar(32767)
STRING       len= 2000001 prec=   0 -        -> varchar(32767)
STRING       len= 9999998 prec=   0 -        -> varchar(32767)
STRING       len= 9999999 prec=   0 -        -> varchar(32767)
STRING       len=10000000 prec=   0 -        -> varchar(32767)
STRING       len=16777215 prec=   0 -        -> varchar(32767)
STRING       len=16777216 prec=   0 -        -> varchar(32767)

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

[alter]
STRING       len=      -1 prec=  -1 add      -> null
STRING       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
STRING       len=      10 prec=   2 add      -> null
STRING       len=      10 prec=   2 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
STRING       len=      15 prec=   0 add      -> null
STRING       len=      15 prec=   0 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
INTEGER      len=      -1 prec=  -1 add      -> null
INTEGER      len=      -1 prec=  -1 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
INTEGER      len=      10 prec=   2 add      -> null
INTEGER      len=      10 prec=   2 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
INTEGER      len=      15 prec=   0 add      -> null
INTEGER      len=      15 prec=   0 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
NUMBER       len=      -1 prec=  -1 add      -> null
NUMBER       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
NUMBER       len=      10 prec=   2 add      -> null
NUMBER       len=      10 prec=   2 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
NUMBER       len=      15 prec=   0 add      -> null
NUMBER       len=      15 prec=   0 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
BIGNUMBER    len=      -1 prec=  -1 add      -> null
BIGNUMBER    len=      -1 prec=  -1 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
BIGNUMBER    len=      10 prec=   2 add      -> null
BIGNUMBER    len=      10 prec=   2 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
BIGNUMBER    len=      15 prec=   0 add      -> null
BIGNUMBER    len=      15 prec=   0 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
DATE         len=      -1 prec=  -1 add      -> null
DATE         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
DATE         len=      10 prec=   2 add      -> null
DATE         len=      10 prec=   2 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
DATE         len=      15 prec=   0 add      -> null
DATE         len=      15 prec=   0 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
TIMESTAMP    len=      -1 prec=  -1 add      -> null
TIMESTAMP    len=      -1 prec=  -1 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
TIMESTAMP    len=      10 prec=   2 add      -> null
TIMESTAMP    len=      10 prec=   2 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
TIMESTAMP    len=      15 prec=   0 add      -> null
TIMESTAMP    len=      15 prec=   0 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
BOOLEAN      len=      -1 prec=  -1 add      -> null
BOOLEAN      len=      -1 prec=  -1 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
BOOLEAN      len=      10 prec=   2 add      -> null
BOOLEAN      len=      10 prec=   2 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
BOOLEAN      len=      15 prec=   0 add      -> null
BOOLEAN      len=      15 prec=   0 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
BINARY       len=      -1 prec=  -1 add      -> null
BINARY       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
BINARY       len=      10 prec=   2 add      -> null
BINARY       len=      10 prec=   2 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
BINARY       len=      15 prec=   0 add      -> null
BINARY       len=      15 prec=   0 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
INET         len=      -1 prec=  -1 add      -> null
INET         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
INET         len=      10 prec=   2 add      -> null
INET         len=      10 prec=   2 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
INET         len=      15 prec=   0 add      -> null
INET         len=      15 prec=   0 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
JSON         len=      -1 prec=  -1 add      -> null
JSON         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
JSON         len=      10 prec=   2 add      -> null
JSON         len=      10 prec=   2 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
JSON         len=      15 prec=   0 add      -> null
JSON         len=      15 prec=   0 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
VECTOR       len=      -1 prec=  -1 add      -> null
VECTOR       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
VECTOR       len=      10 prec=   2 add      -> null
VECTOR       len=      10 prec=   2 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
VECTOR       len=      15 prec=   0 add      -> null
VECTOR       len=      15 prec=   0 modify   -> ALTER TABLE TBL MODIFY COLUMN COL ;
