1SET @start_global_value = @@global.alter_algorithm; 2SET GLOBAL alter_algorithm=1.1; 3ERROR 42000: Incorrect argument type to variable 'alter_algorithm' 4SET GLOBAL alter_algorithm=-1; 5ERROR 42000: Variable 'alter_algorithm' can't be set to the value of '-1' 6SET GLOBAL alter_algorithm=weird; 7ERROR 42000: Variable 'alter_algorithm' can't be set to the value of 'weird' 8SET GLOBAL alter_algorithm=4; 9SELECT @@global.alter_algorithm; 10@@global.alter_algorithm 11INSTANT 12SET GLOBAL alter_algorithm=3; 13SELECT @@global.alter_algorithm; 14@@global.alter_algorithm 15NOCOPY 16SET GLOBAL alter_algorithm=0; 17SELECT @@global.alter_algorithm; 18@@global.alter_algorithm 19DEFAULT 20SET GLOBAL alter_algorithm=1; 21SELECT @@global.alter_algorithm; 22@@global.alter_algorithm 23COPY 24SET GLOBAL alter_algorithm=2; 25SELECT @@global.alter_algorithm; 26@@global.alter_algorithm 27INPLACE 28SET GLOBAL alter_algorithm=5; 29ERROR 42000: Variable 'alter_algorithm' can't be set to the value of '5' 30SELECT @@global.alter_algorithm; 31@@global.alter_algorithm 32INPLACE 33SET GLOBAL alter_algorithm=NOCOPY; 34SET alter_algorithm=1.1; 35ERROR 42000: Incorrect argument type to variable 'alter_algorithm' 36SET alter_algorithm=-1; 37ERROR 42000: Variable 'alter_algorithm' can't be set to the value of '-1' 38SET alter_algorithm=weird; 39ERROR 42000: Variable 'alter_algorithm' can't be set to the value of 'weird' 40SET alter_algorithm=4; 41SELECT @@alter_algorithm; 42@@alter_algorithm 43INSTANT 44SET alter_algorithm=3; 45SELECT @@alter_algorithm; 46@@alter_algorithm 47NOCOPY 48SET alter_algorithm=0; 49SELECT @@alter_algorithm; 50@@alter_algorithm 51DEFAULT 52SET alter_algorithm=1; 53SELECT @@alter_algorithm; 54@@alter_algorithm 55COPY 56SET alter_algorithm=2; 57SELECT @@alter_algorithm; 58@@alter_algorithm 59INPLACE 60SET alter_algorithm=5; 61ERROR 42000: Variable 'alter_algorithm' can't be set to the value of '5' 62SELECT @@alter_algorithm; 63@@alter_algorithm 64INPLACE 65SET SESSION alter_algorithm=INSTANT; 66SHOW SESSION VARIABLES LIKE 'alter_algorithm'; 67Variable_name Value 68alter_algorithm INSTANT 69SET SESSION alter_algorithm=DEFAULT; 70SHOW SESSION VARIABLES LIKE 'alter_algorithm'; 71Variable_name Value 72alter_algorithm NOCOPY 73SET SESSION alter_algorithm='DEFAULT'; 74SHOW SESSION VARIABLES LIKE 'alter_algorithm'; 75Variable_name Value 76alter_algorithm DEFAULT 77SET SESSION alter_algorithm=DEFAULT; 78SHOW SESSION VARIABLES LIKE 'alter_algorithm'; 79Variable_name Value 80alter_algorithm NOCOPY 81SET GLOBAL alter_algorithm=DEFAULT; 82SHOW SESSION VARIABLES LIKE 'alter_algorithm'; 83Variable_name Value 84alter_algorithm NOCOPY 85SET SESSION alter_algorithm=DEFAULT; 86SHOW SESSION VARIABLES LIKE 'alter_algorithm'; 87Variable_name Value 88alter_algorithm DEFAULT 89SET GLOBAL alter_algorithm = @start_global_value; 90