# org.apache.hop.databases.access.AccessDatabaseMeta
# Generated by AccessFieldDefinitionGoldenTest. 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 -        -> TEXT
STRING       len=       9 prec=   0 -        -> TEXT
STRING       len=      10 prec=   2 -        -> TEXT
STRING       len=      15 prec=   0 -        -> TEXT
STRING       len=      18 prec=   0 -        -> TEXT
STRING       len=      20 prec=   0 -        -> TEXT
STRING       len= 9999999 prec=   0 -        -> MEMO
INTEGER      len=      -1 prec=  -1 -        -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=       0 prec=   0 -        -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=       4 prec=   0 -        -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=       9 prec=   0 -        -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      10 prec=   2 -        -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      15 prec=   0 -        -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      18 prec=   0 -        -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      20 prec=   0 -        -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len= 9999999 prec=   0 -        -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
NUMBER       len=      -1 prec=  -1 -        -> DOUBLE
NUMBER       len=       0 prec=   0 -        -> DOUBLE
NUMBER       len=       4 prec=   0 -        -> DOUBLE
NUMBER       len=       9 prec=   0 -        -> DOUBLE
NUMBER       len=      10 prec=   2 -        -> DOUBLE
NUMBER       len=      15 prec=   0 -        -> DOUBLE
NUMBER       len=      18 prec=   0 -        -> DOUBLE
NUMBER       len=      20 prec=   0 -        -> DOUBLE
NUMBER       len= 9999999 prec=   0 -        -> DOUBLE
BIGNUMBER    len=      -1 prec=  -1 -        -> NUMERIC
BIGNUMBER    len=       0 prec=   0 -        -> NUMERIC
BIGNUMBER    len=       4 prec=   0 -        -> NUMERIC
BIGNUMBER    len=       9 prec=   0 -        -> NUMERIC
BIGNUMBER    len=      10 prec=   2 -        -> NUMERIC
BIGNUMBER    len=      15 prec=   0 -        -> NUMERIC
BIGNUMBER    len=      18 prec=   0 -        -> NUMERIC
BIGNUMBER    len=      20 prec=   0 -        -> NUMERIC
BIGNUMBER    len= 9999999 prec=   0 -        -> NUMERIC
DATE         len=      -1 prec=  -1 -        -> DATETIME
DATE         len=       0 prec=   0 -        -> DATETIME
DATE         len=       4 prec=   0 -        -> DATETIME
DATE         len=       9 prec=   0 -        -> DATETIME
DATE         len=      10 prec=   2 -        -> DATETIME
DATE         len=      15 prec=   0 -        -> DATETIME
DATE         len=      18 prec=   0 -        -> DATETIME
DATE         len=      20 prec=   0 -        -> DATETIME
DATE         len= 9999999 prec=   0 -        -> DATETIME
TIMESTAMP    len=      -1 prec=  -1 -        -> DATETIME
TIMESTAMP    len=       0 prec=   0 -        -> DATETIME
TIMESTAMP    len=       4 prec=   0 -        -> DATETIME
TIMESTAMP    len=       9 prec=   0 -        -> DATETIME
TIMESTAMP    len=      10 prec=   2 -        -> DATETIME
TIMESTAMP    len=      15 prec=   0 -        -> DATETIME
TIMESTAMP    len=      18 prec=   0 -        -> DATETIME
TIMESTAMP    len=      20 prec=   0 -        -> DATETIME
TIMESTAMP    len= 9999999 prec=   0 -        -> DATETIME
BOOLEAN      len=      -1 prec=  -1 -        -> YESNO
BOOLEAN      len=       0 prec=   0 -        -> YESNO
BOOLEAN      len=       4 prec=   0 -        -> YESNO
BOOLEAN      len=       9 prec=   0 -        -> YESNO
BOOLEAN      len=      10 prec=   2 -        -> YESNO
BOOLEAN      len=      15 prec=   0 -        -> YESNO
BOOLEAN      len=      18 prec=   0 -        -> YESNO
BOOLEAN      len=      20 prec=   0 -        -> YESNO
BOOLEAN      len= 9999999 prec=   0 -        -> YESNO
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 -        -> TEXT
INET         len=       0 prec=   0 -        -> TEXT
INET         len=       4 prec=   0 -        -> TEXT
INET         len=       9 prec=   0 -        -> TEXT
INET         len=      10 prec=   2 -        -> TEXT
INET         len=      15 prec=   0 -        -> TEXT
INET         len=      18 prec=   0 -        -> TEXT
INET         len=      20 prec=   0 -        -> TEXT
INET         len= 9999999 prec=   0 -        -> TEXT
JSON         len=      -1 prec=  -1 -        -> MEMO
JSON         len=       0 prec=   0 -        -> MEMO
JSON         len=       4 prec=   0 -        -> TEXT
JSON         len=       9 prec=   0 -        -> TEXT
JSON         len=      10 prec=   2 -        -> TEXT
JSON         len=      15 prec=   0 -        -> TEXT
JSON         len=      18 prec=   0 -        -> TEXT
JSON         len=      20 prec=   0 -        -> TEXT
JSON         len= 9999999 prec=   0 -        -> MEMO
VECTOR       len=      -1 prec=  -1 -        -> MEMO
VECTOR       len=       0 prec=   0 -        -> MEMO
VECTOR       len=       4 prec=   0 -        -> MEMO
VECTOR       len=       9 prec=   0 -        -> MEMO
VECTOR       len=      10 prec=   2 -        -> MEMO
VECTOR       len=      15 prec=   0 -        -> MEMO
VECTOR       len=      18 prec=   0 -        -> MEMO
VECTOR       len=      20 prec=   0 -        -> MEMO
VECTOR       len= 9999999 prec=   0 -        -> MEMO

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

[keys]
INTEGER      len=      -1 prec=  -1 tk       -> AUTOINCREMENT
INTEGER      len=      -1 prec=  -1 pk       -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      -1 prec=  -1 autoinc  -> AUTOINCREMENT
INTEGER      len=       0 prec=   0 tk       -> AUTOINCREMENT
INTEGER      len=       0 prec=   0 pk       -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=       0 prec=   0 autoinc  -> AUTOINCREMENT
INTEGER      len=       4 prec=   0 tk       -> AUTOINCREMENT
INTEGER      len=       4 prec=   0 pk       -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=       4 prec=   0 autoinc  -> AUTOINCREMENT
INTEGER      len=       9 prec=   0 tk       -> AUTOINCREMENT
INTEGER      len=       9 prec=   0 pk       -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=       9 prec=   0 autoinc  -> AUTOINCREMENT
INTEGER      len=      10 prec=   2 tk       -> AUTOINCREMENT
INTEGER      len=      10 prec=   2 pk       -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      10 prec=   2 autoinc  -> AUTOINCREMENT
INTEGER      len=      15 prec=   0 tk       -> AUTOINCREMENT
INTEGER      len=      15 prec=   0 pk       -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      15 prec=   0 autoinc  -> AUTOINCREMENT
INTEGER      len=      18 prec=   0 tk       -> AUTOINCREMENT
INTEGER      len=      18 prec=   0 pk       -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      18 prec=   0 autoinc  -> AUTOINCREMENT
INTEGER      len=      20 prec=   0 tk       -> AUTOINCREMENT
INTEGER      len=      20 prec=   0 pk       -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      20 prec=   0 autoinc  -> AUTOINCREMENT
INTEGER      len= 9999999 prec=   0 tk       -> AUTOINCREMENT
INTEGER      len= 9999999 prec=   0 pk       -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len= 9999999 prec=   0 autoinc  -> AUTOINCREMENT
NUMBER       len=      -1 prec=  -1 tk       -> DOUBLE
NUMBER       len=      -1 prec=  -1 pk       -> DOUBLE
NUMBER       len=      -1 prec=  -1 autoinc  -> DOUBLE
NUMBER       len=       0 prec=   0 tk       -> DOUBLE
NUMBER       len=       0 prec=   0 pk       -> DOUBLE
NUMBER       len=       0 prec=   0 autoinc  -> DOUBLE
NUMBER       len=       4 prec=   0 tk       -> DOUBLE
NUMBER       len=       4 prec=   0 pk       -> DOUBLE
NUMBER       len=       4 prec=   0 autoinc  -> DOUBLE
NUMBER       len=       9 prec=   0 tk       -> DOUBLE
NUMBER       len=       9 prec=   0 pk       -> DOUBLE
NUMBER       len=       9 prec=   0 autoinc  -> DOUBLE
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       -> DOUBLE
NUMBER       len=      15 prec=   0 pk       -> DOUBLE
NUMBER       len=      15 prec=   0 autoinc  -> DOUBLE
NUMBER       len=      18 prec=   0 tk       -> DOUBLE
NUMBER       len=      18 prec=   0 pk       -> DOUBLE
NUMBER       len=      18 prec=   0 autoinc  -> DOUBLE
NUMBER       len=      20 prec=   0 tk       -> DOUBLE
NUMBER       len=      20 prec=   0 pk       -> DOUBLE
NUMBER       len=      20 prec=   0 autoinc  -> DOUBLE
NUMBER       len= 9999999 prec=   0 tk       -> DOUBLE
NUMBER       len= 9999999 prec=   0 pk       -> DOUBLE
NUMBER       len= 9999999 prec=   0 autoinc  -> DOUBLE
BIGNUMBER    len=      -1 prec=  -1 tk       -> NUMERIC
BIGNUMBER    len=      -1 prec=  -1 pk       -> NUMERIC
BIGNUMBER    len=      -1 prec=  -1 autoinc  -> NUMERIC
BIGNUMBER    len=       0 prec=   0 tk       -> NUMERIC
BIGNUMBER    len=       0 prec=   0 pk       -> NUMERIC
BIGNUMBER    len=       0 prec=   0 autoinc  -> NUMERIC
BIGNUMBER    len=       4 prec=   0 tk       -> NUMERIC
BIGNUMBER    len=       4 prec=   0 pk       -> NUMERIC
BIGNUMBER    len=       4 prec=   0 autoinc  -> NUMERIC
BIGNUMBER    len=       9 prec=   0 tk       -> NUMERIC
BIGNUMBER    len=       9 prec=   0 pk       -> NUMERIC
BIGNUMBER    len=       9 prec=   0 autoinc  -> NUMERIC
BIGNUMBER    len=      10 prec=   2 tk       -> NUMERIC
BIGNUMBER    len=      10 prec=   2 pk       -> NUMERIC
BIGNUMBER    len=      10 prec=   2 autoinc  -> NUMERIC
BIGNUMBER    len=      15 prec=   0 tk       -> NUMERIC
BIGNUMBER    len=      15 prec=   0 pk       -> NUMERIC
BIGNUMBER    len=      15 prec=   0 autoinc  -> NUMERIC
BIGNUMBER    len=      18 prec=   0 tk       -> NUMERIC
BIGNUMBER    len=      18 prec=   0 pk       -> NUMERIC
BIGNUMBER    len=      18 prec=   0 autoinc  -> NUMERIC
BIGNUMBER    len=      20 prec=   0 tk       -> NUMERIC
BIGNUMBER    len=      20 prec=   0 pk       -> NUMERIC
BIGNUMBER    len=      20 prec=   0 autoinc  -> NUMERIC
BIGNUMBER    len= 9999999 prec=   0 tk       -> NUMERIC
BIGNUMBER    len= 9999999 prec=   0 pk       -> NUMERIC
BIGNUMBER    len= 9999999 prec=   0 autoinc  -> NUMERIC

[alter]
STRING       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COL TEXT
STRING       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET TEXT
STRING       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COL TEXT
STRING       len=      10 prec=   2 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET TEXT
STRING       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COL TEXT
STRING       len=      15 prec=   0 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET TEXT
INTEGER      len=      -1 prec=  -1 add      -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      -1 prec=  -1 modify   -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      10 prec=   2 add      -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      10 prec=   2 modify   -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      15 prec=   0 add      -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
INTEGER      len=      15 prec=   0 modify   -> !! NullPointerException: Cannot invoke "String.equals(Object)" because "tk" is null
NUMBER       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COL DOUBLE
NUMBER       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET DOUBLE
NUMBER       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COL DOUBLE
NUMBER       len=      10 prec=   2 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET DOUBLE
NUMBER       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COL DOUBLE
NUMBER       len=      15 prec=   0 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET DOUBLE
BIGNUMBER    len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COL NUMERIC
BIGNUMBER    len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET NUMERIC
BIGNUMBER    len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COL NUMERIC
BIGNUMBER    len=      10 prec=   2 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET NUMERIC
BIGNUMBER    len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COL NUMERIC
BIGNUMBER    len=      15 prec=   0 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET NUMERIC
DATE         len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COL DATETIME
DATE         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET DATETIME
DATE         len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COL DATETIME
DATE         len=      10 prec=   2 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET DATETIME
DATE         len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COL DATETIME
DATE         len=      15 prec=   0 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET DATETIME
TIMESTAMP    len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COL DATETIME
TIMESTAMP    len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET DATETIME
TIMESTAMP    len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COL DATETIME
TIMESTAMP    len=      10 prec=   2 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET DATETIME
TIMESTAMP    len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COL DATETIME
TIMESTAMP    len=      15 prec=   0 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET DATETIME
BOOLEAN      len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COL YESNO
BOOLEAN      len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET YESNO
BOOLEAN      len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COL YESNO
BOOLEAN      len=      10 prec=   2 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET YESNO
BOOLEAN      len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COL YESNO
BOOLEAN      len=      15 prec=   0 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET YESNO
BINARY       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COL UNKNOWN
BINARY       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET UNKNOWN
BINARY       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COL UNKNOWN
BINARY       len=      10 prec=   2 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET UNKNOWN
BINARY       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COL UNKNOWN
BINARY       len=      15 prec=   0 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET UNKNOWN
INET         len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COL TEXT
INET         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET TEXT
INET         len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COL TEXT
INET         len=      10 prec=   2 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET TEXT
INET         len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COL TEXT
INET         len=      15 prec=   0 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET TEXT
JSON         len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COL MEMO
JSON         len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET MEMO
JSON         len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COL TEXT
JSON         len=      10 prec=   2 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET TEXT
JSON         len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COL TEXT
JSON         len=      15 prec=   0 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET TEXT
VECTOR       len=      -1 prec=  -1 add      -> ALTER TABLE TBL ADD COL MEMO
VECTOR       len=      -1 prec=  -1 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET MEMO
VECTOR       len=      10 prec=   2 add      -> ALTER TABLE TBL ADD COL MEMO
VECTOR       len=      10 prec=   2 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET MEMO
VECTOR       len=      15 prec=   0 add      -> ALTER TABLE TBL ADD COL MEMO
VECTOR       len=      15 prec=   0 modify   -> ALTER TABLE TBL ALTER COLUMN COL SET MEMO
