1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
--source include/have_tokudb.inc
#
# Attempt to change row format with and without
# other ALTER TABLE statements.
#
SET DEFAULT_STORAGE_ENGINE='tokudb';
--disable_warnings
DROP TABLE IF EXISTS foo;
--enable_warnings
set session tokudb_disable_slow_alter=ON;
create table foo(a int auto_increment, b int, primary key (a));
insert into foo (b) values (11),(21),(32);
select * from foo;
alter table foo auto_increment=1000;
show create table foo;
insert into foo (b) values (11),(21),(32);
select * from foo;
show create table foo;
alter table foo auto_increment=10;
insert into foo (b) values (11),(21),(32);
select * from foo;
show create table foo;
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, add column c int;
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, drop column b;
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, add key b(b);
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, change b b bigint;
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, change b c int;
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, ROW_FORMAT=TOKUDB_LZMA;
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, change b b int DEFAULT 111;
DROP TABLE foo;
|