1
SET @global_start_value = @@global.innodb_sync_spin_loops;
2
SELECT @global_start_value;
5
'#--------------------FN_DYNVARS_046_01------------------------#'
6
SET @@global.innodb_sync_spin_loops = 0;
7
SET @@global.innodb_sync_spin_loops = DEFAULT;
8
SELECT @@global.innodb_sync_spin_loops;
9
@@global.innodb_sync_spin_loops
11
'#---------------------FN_DYNVARS_046_02-------------------------#'
12
SET innodb_sync_spin_loops = 1;
13
ERROR HY000: Variable 'innodb_sync_spin_loops' is a GLOBAL variable and should be set with SET GLOBAL
14
SELECT @@innodb_sync_spin_loops;
15
@@innodb_sync_spin_loops
17
SELECT local.innodb_sync_spin_loops;
18
ERROR 42S02: Unknown table 'local' in field list
19
SET global innodb_sync_spin_loops = 0;
20
SELECT @@global.innodb_sync_spin_loops;
21
@@global.innodb_sync_spin_loops
23
'#--------------------FN_DYNVARS_046_03------------------------#'
24
SET @@global.innodb_sync_spin_loops = 0;
25
SELECT @@global.innodb_sync_spin_loops;
26
@@global.innodb_sync_spin_loops
28
SET @@global.innodb_sync_spin_loops = 1;
29
SELECT @@global.innodb_sync_spin_loops;
30
@@global.innodb_sync_spin_loops
32
SET @@global.innodb_sync_spin_loops = 1000;
33
SELECT @@global.innodb_sync_spin_loops;
34
@@global.innodb_sync_spin_loops
36
'#--------------------FN_DYNVARS_046_04-------------------------#'
37
SET @@global.innodb_sync_spin_loops = -1;
38
SELECT @@global.innodb_sync_spin_loops;
39
@@global.innodb_sync_spin_loops
41
SET @@global.innodb_sync_spin_loops = "T";
42
ERROR 42000: Incorrect argument type to variable 'innodb_sync_spin_loops'
43
SELECT @@global.innodb_sync_spin_loops;
44
@@global.innodb_sync_spin_loops
46
SET @@global.innodb_sync_spin_loops = "Y";
47
ERROR 42000: Incorrect argument type to variable 'innodb_sync_spin_loops'
48
SELECT @@global.innodb_sync_spin_loops;
49
@@global.innodb_sync_spin_loops
51
SET @@global.innodb_sync_spin_loops = 1001;
52
SELECT @@global.innodb_sync_spin_loops;
53
@@global.innodb_sync_spin_loops
55
'#----------------------FN_DYNVARS_046_05------------------------#'
56
SELECT @@global.innodb_sync_spin_loops =
57
VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
58
WHERE VARIABLE_NAME='innodb_sync_spin_loops';
59
@@global.innodb_sync_spin_loops =
62
SELECT @@global.innodb_sync_spin_loops;
63
@@global.innodb_sync_spin_loops
65
SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
66
WHERE VARIABLE_NAME='innodb_sync_spin_loops';
69
'#---------------------FN_DYNVARS_046_06-------------------------#'
70
SET @@global.innodb_sync_spin_loops = OFF;
71
ERROR 42000: Incorrect argument type to variable 'innodb_sync_spin_loops'
72
SELECT @@global.innodb_sync_spin_loops;
73
@@global.innodb_sync_spin_loops
75
SET @@global.innodb_sync_spin_loops = ON;
76
ERROR 42000: Incorrect argument type to variable 'innodb_sync_spin_loops'
77
SELECT @@global.innodb_sync_spin_loops;
78
@@global.innodb_sync_spin_loops
80
'#---------------------FN_DYNVARS_046_07----------------------#'
81
SET @@global.innodb_sync_spin_loops = TRUE;
82
SELECT @@global.innodb_sync_spin_loops;
83
@@global.innodb_sync_spin_loops
85
SET @@global.innodb_sync_spin_loops = FALSE;
86
SELECT @@global.innodb_sync_spin_loops;
87
@@global.innodb_sync_spin_loops
89
SET @@global.innodb_sync_spin_loops = @global_start_value;
90
SELECT @@global.innodb_sync_spin_loops;
91
@@global.innodb_sync_spin_loops