Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.select_into_disk_sync_delay;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 SET @start_session_value = @@session.select_into_disk_sync_delay;
6 SELECT @start_session_value;
7 @start_session_value
8 0
9 '#--------------------FN_DYNVARS_002_01-------------------------#'
10 SET @@global.select_into_disk_sync_delay = 1000;
11 SET @@global.select_into_disk_sync_delay = DEFAULT;
12 SELECT @@global.select_into_disk_sync_delay;
13 @@global.select_into_disk_sync_delay
14 0
15 SET @@session.select_into_disk_sync_delay = 3000;
16 SET @@session.select_into_disk_sync_delay = DEFAULT;
17 SELECT @@session.select_into_disk_sync_delay;
18 @@session.select_into_disk_sync_delay
19 0
20 '#--------------------FN_DYNVARS_002_02-------------------------#'
21 SET @@global.select_into_disk_sync_delay = @start_global_value;
22 SELECT @@global.select_into_disk_sync_delay = 10;
23 @@global.select_into_disk_sync_delay = 10
24 0
25 SET @@session.select_into_disk_sync_delay = @start_session_value;
26 SELECT @@session.select_into_disk_sync_delay = 20;
27 @@session.select_into_disk_sync_delay = 20
28 0
29 '#--------------------FN_DYNVARS_002_03-------------------------#'
30 SET @@global.select_into_disk_sync_delay = 5;
31 SELECT @@global.select_into_disk_sync_delay;
32 @@global.select_into_disk_sync_delay
33 5
34 SET @@global.select_into_disk_sync_delay = 12;
35 SELECT @@global.select_into_disk_sync_delay;
36 @@global.select_into_disk_sync_delay
37 12
38 SET @@global.select_into_disk_sync_delay = 100;
39 SELECT @@global.select_into_disk_sync_delay;
40 @@global.select_into_disk_sync_delay
41 100
42 '#--------------------FN_DYNVARS_002_04-------------------------#'
43 SET @@session.select_into_disk_sync_delay = 4;
44 SELECT @@session.select_into_disk_sync_delay;
45 @@session.select_into_disk_sync_delay
46 4
47 SET @@session.select_into_disk_sync_delay = 8;
48 SELECT @@session.select_into_disk_sync_delay;
49 @@session.select_into_disk_sync_delay
50 8
51 SET @@session.select_into_disk_sync_delay = 17;
52 SELECT @@session.select_into_disk_sync_delay;
53 @@session.select_into_disk_sync_delay
54 17
55 '#------------------FN_DYNVARS_002_05-----------------------#'
56 SET @@global.select_into_disk_sync_delay = -1;
57 Warnings:
58 Warning 1292 Truncated incorrect select_into_disk_sync_delay value: '-1'
59 SELECT @@global.select_into_disk_sync_delay;
60 @@global.select_into_disk_sync_delay
61 0
62 SET @@global.select_into_disk_sync_delay = -1024;
63 Warnings:
64 Warning 1292 Truncated incorrect select_into_disk_sync_delay value: '-1024'
65 SELECT @@global.select_into_disk_sync_delay;
66 @@global.select_into_disk_sync_delay
67 0
68 SET @@global.select_into_disk_sync_delay = 3747474747474747474;
69 Warnings:
70 Warning 1292 Truncated incorrect select_into_disk_sync_delay value: '3747474747474747474'
71 SELECT @@global.select_into_disk_sync_delay;
72 @@global.select_into_disk_sync_delay
73 31536000
74 SET @@global.select_into_disk_sync_delay = ON;
75 ERROR 42000: Incorrect argument type to variable 'select_into_disk_sync_delay'
76 SELECT @@global.select_into_disk_sync_delay;
77 @@global.select_into_disk_sync_delay
78 31536000
79 SET @@global.select_into_disk_sync_delay = OFF;
80 ERROR 42000: Incorrect argument type to variable 'select_into_disk_sync_delay'
81 SELECT @@global.select_into_disk_sync_delay;
82 @@global.select_into_disk_sync_delay
83 31536000
84 SET @@global.select_into_disk_sync_delay = test;
85 ERROR 42000: Incorrect argument type to variable 'select_into_disk_sync_delay'
86 SELECT @@global.select_into_disk_sync_delay;
87 @@global.select_into_disk_sync_delay
88 31536000
89 SET @@session.select_into_disk_sync_delay = -1;
90 Warnings:
91 Warning 1292 Truncated incorrect select_into_disk_sync_delay value: '-1'
92 SELECT @@session.select_into_disk_sync_delay;
93 @@session.select_into_disk_sync_delay
94 0
95 SET @@session.select_into_disk_sync_delay = -2;
96 Warnings:
97 Warning 1292 Truncated incorrect select_into_disk_sync_delay value: '-2'
98 SELECT @@session.select_into_disk_sync_delay;
99 @@session.select_into_disk_sync_delay
100 0
101 SET @@session.select_into_disk_sync_delay = ON;
102 ERROR 42000: Incorrect argument type to variable 'select_into_disk_sync_delay'
103 SELECT @@session.select_into_disk_sync_delay;
104 @@session.select_into_disk_sync_delay
105 0
106 SET @@session.select_into_disk_sync_delay = OFF;
107 ERROR 42000: Incorrect argument type to variable 'select_into_disk_sync_delay'
108 SELECT @@session.select_into_disk_sync_delay;
109 @@session.select_into_disk_sync_delay
110 0
111 SET @@session.select_into_disk_sync_delay = test;
112 ERROR 42000: Incorrect argument type to variable 'select_into_disk_sync_delay'
113 SELECT @@session.select_into_disk_sync_delay;
114 @@session.select_into_disk_sync_delay
115 0
116 SET @@session.select_into_disk_sync_delay = 85858585858585858585;
117 ERROR 42000: Incorrect argument type to variable 'select_into_disk_sync_delay'
118 SELECT @@session.select_into_disk_sync_delay;
119 @@session.select_into_disk_sync_delay
120 0
121 '#------------------FN_DYNVARS_002_06-----------------------#'
122 SELECT @@global.select_into_disk_sync_delay = VARIABLE_VALUE
123 FROM performance_schema.global_variables
124 WHERE VARIABLE_NAME='select_into_disk_sync_delay';
125 @@global.select_into_disk_sync_delay = VARIABLE_VALUE
126 1
127 '#------------------FN_DYNVARS_002_07-----------------------#'
128 SELECT @@session.select_into_disk_sync_delay = VARIABLE_VALUE
129 FROM performance_schema.session_variables
130 WHERE VARIABLE_NAME='select_into_disk_sync_delay';
131 @@session.select_into_disk_sync_delay = VARIABLE_VALUE
132 1
133 '#---------------------FN_DYNVARS_001_09----------------------#'
134 SET @@global.select_into_disk_sync_delay = 10;
135 SET @@session.select_into_disk_sync_delay = 1000;
136 SELECT @@select_into_disk_sync_delay = @@global.select_into_disk_sync_delay;
137 @@select_into_disk_sync_delay = @@global.select_into_disk_sync_delay
138 0
139 '#---------------------FN_DYNVARS_001_10----------------------#'
140 SET @@select_into_disk_sync_delay = 1000;
141 SELECT @@select_into_disk_sync_delay = @@local.select_into_disk_sync_delay;
142 @@select_into_disk_sync_delay = @@local.select_into_disk_sync_delay
143 1
144 SELECT @@local.select_into_disk_sync_delay = @@session.select_into_disk_sync_delay;
145 @@local.select_into_disk_sync_delay = @@session.select_into_disk_sync_delay
146 1
147 '#---------------------FN_DYNVARS_001_11----------------------#'
148 SET select_into_disk_sync_delay = 1000;
149 SELECT @@select_into_disk_sync_delay;
150 @@select_into_disk_sync_delay
151 1000
152 SELECT local.select_into_disk_sync_delay;
153 ERROR 42S02: Unknown table 'local' in field list
154 SELECT session.select_into_disk_sync_delay;
155 ERROR 42S02: Unknown table 'session' in field list
156 SELECT select_into_disk_sync_delay = @@session.select_into_disk_sync_delay;
157 ERROR 42S22: Unknown column 'select_into_disk_sync_delay' in 'field list'
158 '#---------------------FN_DYNVARS_001_12----------------------#'
159 CREATE USER foo, bar;
160 GRANT SESSION_VARIABLES_ADMIN ON *.* TO bar;
161 SELECT @@session.select_into_disk_sync_delay;
162 @@session.select_into_disk_sync_delay
163 10
164 SET @@session.select_into_disk_sync_delay = 2000;
165 ERROR 42000: Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
166 SELECT @@session.select_into_disk_sync_delay;
167 @@session.select_into_disk_sync_delay
168 10
169 SET @@session.select_into_disk_sync_delay = 2000;
170 SET @@global.select_into_disk_sync_delay = 2000;
171 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
172 SELECT @@session.select_into_disk_sync_delay;
173 @@session.select_into_disk_sync_delay
174 2000
175 DROP USER foo, bar;
176 SET @@global.select_into_disk_sync_delay = @start_global_value;
177 SELECT @@global.select_into_disk_sync_delay;
178 @@global.select_into_disk_sync_delay
179 0
180 SET @@session.select_into_disk_sync_delay = @start_session_value;
181 SELECT @@session.select_into_disk_sync_delay;
182 @@session.select_into_disk_sync_delay
183 0