1
DROP TABLE IF EXISTS t;
2
SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON;
3
CREATE TABLE t (a VARBINARY(100) NOT NULL DEFAULT '', b VARBINARY(256) NOT NULL DEFAULT '') ENGINE=TokuDB;
7
`a` varbinary(100) NOT NULL DEFAULT '',
8
`b` varbinary(256) NOT NULL DEFAULT ''
9
) ENGINE=TokuDB DEFAULT CHARSET=latin1
10
ALTER TABLE t CHANGE COLUMN a a VARBINARY(255) NOT NULL DEFAULT 'a';
14
`a` varbinary(255) NOT NULL DEFAULT 'a',
15
`b` varbinary(256) NOT NULL DEFAULT ''
16
) ENGINE=TokuDB DEFAULT CHARSET=latin1
17
ALTER TABLE t CHANGE COLUMN a a VARBINARY(256) NOT NULL DEFAULT 'b';
21
`a` varbinary(256) NOT NULL DEFAULT 'b',
22
`b` varbinary(256) NOT NULL DEFAULT ''
23
) ENGINE=TokuDB DEFAULT CHARSET=latin1
24
ALTER TABLE t CHANGE COLUMN b b VARBINARY(255) NOT NULL DEFAULT 'c';
25
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
26
ALTER TABLE t CHANGE COLUMN b b VARBINARY(1024) NOT NULL DEFAULT 'd';
30
`a` varbinary(256) NOT NULL DEFAULT 'b',
31
`b` varbinary(1024) NOT NULL DEFAULT 'd'
32
) ENGINE=TokuDB DEFAULT CHARSET=latin1
33
ALTER TABLE t CHANGE COLUMN b b VARBINARY(256) NOT NULL DEFAULT 'e';
34
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version