Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_instant_alter_column_allowed_basic.result

raw
1 SET @start_global_value = @@global.innodb_instant_alter_column_allowed;
2 SET GLOBAL innodb_instant_alter_column_allowed=never;
3 select @@session.innodb_instant_alter_column_allowed;
4 ERROR HY000: Variable 'innodb_instant_alter_column_allowed' is a GLOBAL variable
5 show global variables like 'innodb_instant_alter_column_allowed';
6 Variable_name Value
7 innodb_instant_alter_column_allowed never
8 show session variables like 'innodb_instant_alter_column_allowed';
9 Variable_name Value
10 innodb_instant_alter_column_allowed never
11 SELECT * FROM information_schema.global_variables
12 WHERE variable_name='innodb_instant_alter_column_allowed';
13 VARIABLE_NAME VARIABLE_VALUE
14 INNODB_INSTANT_ALTER_COLUMN_ALLOWED never
15 SELECT * FROM information_schema.session_variables
16 WHERE variable_name='innodb_instant_alter_column_allowed';
17 VARIABLE_NAME VARIABLE_VALUE
18 INNODB_INSTANT_ALTER_COLUMN_ALLOWED never
19 set global innodb_instant_alter_column_allowed=no;
20 ERROR 42000: Variable 'innodb_instant_alter_column_allowed' can't be set to the value of 'no'
21 set global innodb_instant_alter_column_allowed=1.1;
22 ERROR 42000: Incorrect argument type to variable 'innodb_instant_alter_column_allowed'
23 set global innodb_instant_alter_column_allowed=-1;
24 ERROR 42000: Variable 'innodb_instant_alter_column_allowed' can't be set to the value of '-1'
25 select @@global.innodb_instant_alter_column_allowed;
26 @@global.innodb_instant_alter_column_allowed
27 never
28 set global innodb_instant_alter_column_allowed=3;
29 ERROR 42000: Variable 'innodb_instant_alter_column_allowed' can't be set to the value of '3'
30 select @@global.innodb_instant_alter_column_allowed;
31 @@global.innodb_instant_alter_column_allowed
32 never
33 set global innodb_instant_alter_column_allowed=2;
34 select @@global.innodb_instant_alter_column_allowed;
35 @@global.innodb_instant_alter_column_allowed
36 add_drop_reorder
37 set global innodb_instant_alter_column_allowed=1;
38 select @@global.innodb_instant_alter_column_allowed;
39 @@global.innodb_instant_alter_column_allowed
40 add_last
41 set global innodb_instant_alter_column_allowed=0;
42 select @@global.innodb_instant_alter_column_allowed;
43 @@global.innodb_instant_alter_column_allowed
44 never
45 set global innodb_instant_alter_column_allowed=default;
46 select @@global.innodb_instant_alter_column_allowed;
47 @@global.innodb_instant_alter_column_allowed
48 add_drop_reorder
49 SET GLOBAL innodb_instant_alter_column_allowed = @start_global_value;