Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.alter_algorithm;
2 SELECT @@global.alter_algorithm;
3 @@global.alter_algorithm
4 DEFAULT
5 SET GLOBAL alter_algorithm=2;
6 Warnings:
7 Warning 4200 The setting 'alter_algorithm' is ignored. It only exists for compatibility with old installations and will be removed in a future release
8 SELECT @@global.alter_algorithm;
9 @@global.alter_algorithm
10 DEFAULT
11 SET GLOBAL alter_algorithm=5;
12 ERROR 42000: Variable 'alter_algorithm' can't be set to the value of '5'
13 SELECT @@global.alter_algorithm;
14 @@global.alter_algorithm
15 DEFAULT
16 SET SESSION alter_algorithm=INSTANT;
17 Warnings:
18 Warning 4200 The setting 'alter_algorithm' is ignored. It only exists for compatibility with old installations and will be removed in a future release
19 SHOW SESSION VARIABLES LIKE 'alter_algorithm';
20 Variable_name Value
21 alter_algorithm DEFAULT