1
# test that varchar(X) to varchar(X) not null is not supported (different type)
4
DROP TABLE IF EXISTS t;
7
SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON;
9
# nullable -> not null not supporte
10
CREATE TABLE t (a VARCHAR(100), b VARCHAR(256)) ENGINE=TokuDB;
12
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
13
--error ER_UNSUPPORTED_EXTENSION
14
ALTER TABLE t CHANGE COLUMN a a VARCHAR(1) NOT NULL;
16
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
17
--error ER_UNSUPPORTED_EXTENSION
18
ALTER TABLE t CHANGE COLUMN a a VARCHAR(255) NOT NULL;
20
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
21
--error ER_UNSUPPORTED_EXTENSION
22
ALTER TABLE t CHANGE COLUMN a a VARCHAR(256) NOT NULL;
24
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
25
--error ER_UNSUPPORTED_EXTENSION
26
ALTER TABLE t CHANGE COLUMN b b VARCHAR(255) NOT NULL;
28
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
29
--error ER_UNSUPPORTED_EXTENSION
30
ALTER TABLE t CHANGE COLUMN b b VARCHAR(1024) NOT NULL;
32
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
33
--error ER_UNSUPPORTED_EXTENSION
34
ALTER TABLE t CHANGE COLUMN b b VARCHAR(256) NOT NULL;
38
# not null -> nullable not supported
39
CREATE TABLE t (a VARCHAR(100) NOT NULL, b VARCHAR(256) NOT NULL) ENGINE=TokuDB;
41
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
42
--error ER_UNSUPPORTED_EXTENSION
43
ALTER TABLE t CHANGE COLUMN a a VARCHAR(1);
45
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
46
--error ER_UNSUPPORTED_EXTENSION
47
ALTER TABLE t CHANGE COLUMN a a VARCHAR(255);
49
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
50
--error ER_UNSUPPORTED_EXTENSION
51
ALTER TABLE t CHANGE COLUMN a a VARCHAR(256);
53
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
54
--error ER_UNSUPPORTED_EXTENSION
55
ALTER TABLE t CHANGE COLUMN b b VARCHAR(255);
57
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
58
--error ER_UNSUPPORTED_EXTENSION
59
ALTER TABLE t CHANGE COLUMN b b VARCHAR(1024);
61
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
62
--error ER_UNSUPPORTED_EXTENSION
63
ALTER TABLE t CHANGE COLUMN b b VARCHAR(256);