mysql-test/suite/sys_vars/t/alter_algorithm_basic.test
raw| 1 | SET @start_global_value = @@global.alter_algorithm; |
| 2 | |
| 3 | SELECT @@global.alter_algorithm; |
| 4 | SET GLOBAL alter_algorithm=2; |
| 5 | SELECT @@global.alter_algorithm; |
| 6 | --error ER_WRONG_VALUE_FOR_VAR |
| 7 | SET GLOBAL alter_algorithm=5; |
| 8 | SELECT @@global.alter_algorithm; |
| 9 | |
| 10 | SET SESSION alter_algorithm=INSTANT; |
| 11 | SHOW SESSION VARIABLES LIKE 'alter_algorithm'; |