Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.innodb_sync_spin_loops;
2 SELECT @global_start_value;
3 @global_start_value
4 30
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
10 30
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
16 30
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
22 0
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
27 0
28 SET @@global.innodb_sync_spin_loops = 65535;
29 SELECT @@global.innodb_sync_spin_loops;
30 @@global.innodb_sync_spin_loops
31 65535
32 SET @@global.innodb_sync_spin_loops = 4294967295;
33 SELECT @@global.innodb_sync_spin_loops;
34 @@global.innodb_sync_spin_loops
35 4294967295
36 '#--------------------FN_DYNVARS_046_04-------------------------#'
37 SET @@global.innodb_sync_spin_loops = 4294967296;
38 SELECT @@global.innodb_sync_spin_loops IN (4294967296,4294967295);
39 @@global.innodb_sync_spin_loops IN (4294967296,4294967295)
40 1
41 SET @@global.innodb_sync_spin_loops = 12345678901;
42 SELECT @@global.innodb_sync_spin_loops IN (12345678901,4294967295);
43 @@global.innodb_sync_spin_loops IN (12345678901,4294967295)
44 1
45 SET @@global.innodb_sync_spin_loops = 18446744073709551615;
46 SELECT @@global.innodb_sync_spin_loops IN (18446744073709551615,4294967295);
47 @@global.innodb_sync_spin_loops IN (18446744073709551615,4294967295)
48 1
49 '#--------------------FN_DYNVARS_046_05-------------------------#'
50 SET @@global.innodb_sync_spin_loops = -1;
51 Warnings:
52 Warning 1292 Truncated incorrect innodb_sync_spin_loops value: '-1'
53 SELECT @@global.innodb_sync_spin_loops;
54 @@global.innodb_sync_spin_loops
55 0
56 SET @@global.innodb_sync_spin_loops = "T";
57 ERROR 42000: Incorrect argument type to variable 'innodb_sync_spin_loops'
58 SELECT @@global.innodb_sync_spin_loops;
59 @@global.innodb_sync_spin_loops
60 0
61 SET @@global.innodb_sync_spin_loops = "Y";
62 ERROR 42000: Incorrect argument type to variable 'innodb_sync_spin_loops'
63 SELECT @@global.innodb_sync_spin_loops;
64 @@global.innodb_sync_spin_loops
65 0
66 SET @@global.innodb_sync_spin_loops = 65535.01;
67 ERROR 42000: Incorrect argument type to variable 'innodb_sync_spin_loops'
68 SELECT @@global.innodb_sync_spin_loops;
69 @@global.innodb_sync_spin_loops
70 0
71 SET @@global.innodb_sync_spin_loops = -1024;
72 Warnings:
73 Warning 1292 Truncated incorrect innodb_sync_spin_loops value: '-1024'
74 SELECT @@global.innodb_sync_spin_loops;
75 @@global.innodb_sync_spin_loops
76 0
77 SET @@global.innodb_sync_spin_loops = " ";
78 ERROR 42000: Incorrect argument type to variable 'innodb_sync_spin_loops'
79 SELECT @@global.innodb_sync_spin_loops;
80 @@global.innodb_sync_spin_loops
81 0
82 SET @@global.innodb_sync_spin_loops = ' ';
83 ERROR 42000: Incorrect argument type to variable 'innodb_sync_spin_loops'
84 SELECT @@global.innodb_sync_spin_loops;
85 @@global.innodb_sync_spin_loops
86 0
87 '#----------------------FN_DYNVARS_046_06------------------------#'
88 SELECT @@global.innodb_sync_spin_loops =
89 VARIABLE_VALUE FROM performance_schema.global_variables
90 WHERE VARIABLE_NAME='innodb_sync_spin_loops';
91 @@global.innodb_sync_spin_loops =
92 VARIABLE_VALUE
93 1
94 SELECT @@global.innodb_sync_spin_loops;
95 @@global.innodb_sync_spin_loops
96 0
97 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
98 WHERE VARIABLE_NAME='innodb_sync_spin_loops';
99 VARIABLE_VALUE
100 0
101 '#---------------------FN_DYNVARS_046_07-------------------------#'
102 SET @@global.innodb_sync_spin_loops = OFF;
103 ERROR 42000: Incorrect argument type to variable 'innodb_sync_spin_loops'
104 SELECT @@global.innodb_sync_spin_loops;
105 @@global.innodb_sync_spin_loops
106 0
107 SET @@global.innodb_sync_spin_loops = ON;
108 ERROR 42000: Incorrect argument type to variable 'innodb_sync_spin_loops'
109 SELECT @@global.innodb_sync_spin_loops;
110 @@global.innodb_sync_spin_loops
111 0
112 '#---------------------FN_DYNVARS_046_08----------------------#'
113 SET @@global.innodb_sync_spin_loops = TRUE;
114 SELECT @@global.innodb_sync_spin_loops;
115 @@global.innodb_sync_spin_loops
116 1
117 SET @@global.innodb_sync_spin_loops = FALSE;
118 SELECT @@global.innodb_sync_spin_loops;
119 @@global.innodb_sync_spin_loops
120 0
121 SET @@global.innodb_sync_spin_loops = @global_start_value;
122 SELECT @@global.innodb_sync_spin_loops;
123 @@global.innodb_sync_spin_loops
124 30