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