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
|
--source include/have_tokudb.inc
SET DEFAULT_STORAGE_ENGINE='tokudb';
--disable_warnings
DROP TABLE IF EXISTS bar;
--enable_warnings
set session tokudb_disable_slow_alter=ON;
create temporary table bar (a int, key(a));
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table bar add column c int;
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
create index blah on bar(a);
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
drop index a on bar;
set session tokudb_disable_slow_alter=OFF;
insert into bar values (1),(2),(3);
alter table bar add column b int default 1 first;
select * from bar;
create index blah on bar (b);
select sum(b) from bar;
drop index a on bar;
drop table bar;
|
