Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_instant_alter_column_allowed_basic.test

raw
1 --source include/have_innodb.inc
2
3 SET @start_global_value = @@global.innodb_instant_alter_column_allowed;
4 SET GLOBAL innodb_instant_alter_column_allowed=never;
5
6 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
7 select @@session.innodb_instant_alter_column_allowed;
8 show global variables like 'innodb_instant_alter_column_allowed';
9 show session variables like 'innodb_instant_alter_column_allowed';
10 SELECT * FROM information_schema.global_variables
11 WHERE variable_name='innodb_instant_alter_column_allowed';
12 SELECT * FROM information_schema.session_variables
13 WHERE variable_name='innodb_instant_alter_column_allowed';
14
15 --error ER_WRONG_VALUE_FOR_VAR
16 set global innodb_instant_alter_column_allowed=no;
17 --error ER_WRONG_TYPE_FOR_VAR
18 set global innodb_instant_alter_column_allowed=1.1;
19 --error ER_WRONG_VALUE_FOR_VAR
20 set global innodb_instant_alter_column_allowed=-1;
21 select @@global.innodb_instant_alter_column_allowed;
22 --error ER_WRONG_VALUE_FOR_VAR
23 set global innodb_instant_alter_column_allowed=3;
24 select @@global.innodb_instant_alter_column_allowed;
25 set global innodb_instant_alter_column_allowed=2;
26 select @@global.innodb_instant_alter_column_allowed;
27 set global innodb_instant_alter_column_allowed=1;
28 select @@global.innodb_instant_alter_column_allowed;
29 set global innodb_instant_alter_column_allowed=0;
30 select @@global.innodb_instant_alter_column_allowed;
31 set global innodb_instant_alter_column_allowed=default;
32 select @@global.innodb_instant_alter_column_allowed;
33
34 SET GLOBAL innodb_instant_alter_column_allowed = @start_global_value;