Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.auto_increment_offset;
2 SELECT @start_global_value;
3 @start_global_value
4 1
5 SET @start_session_value = @@session.auto_increment_offset;
6 SELECT @start_session_value;
7 @start_session_value
8 1
9 '#--------------------FN_DYNVARS_002_01-------------------------#'
10 SET @@global.auto_increment_offset = 100;
11 SET @@global.auto_increment_offset = DEFAULT;
12 SELECT @@global.auto_increment_offset;
13 @@global.auto_increment_offset
14 1
15 SET @@session.auto_increment_offset = 200;
16 SET @@session.auto_increment_offset = DEFAULT;
17 SELECT @@session.auto_increment_offset;
18 @@session.auto_increment_offset
19 1
20 '#--------------------FN_DYNVARS_002_02-------------------------#'
21 SET @@global.auto_increment_offset = @start_global_value;
22 SELECT @@global.auto_increment_offset = 1;
23 @@global.auto_increment_offset = 1
24 1
25 SET @@session.auto_increment_offset = @start_session_value;
26 SELECT @@session.auto_increment_offset = 1;
27 @@session.auto_increment_offset = 1
28 1
29 '#--------------------FN_DYNVARS_002_03-------------------------#'
30 SET @@global.auto_increment_offset = 1;
31 SELECT @@global.auto_increment_offset;
32 @@global.auto_increment_offset
33 1
34 SET @@global.auto_increment_offset = 60020;
35 SELECT @@global.auto_increment_offset;
36 @@global.auto_increment_offset
37 60020
38 SET @@global.auto_increment_offset = 65535;
39 SELECT @@global.auto_increment_offset;
40 @@global.auto_increment_offset
41 65535
42 '#--------------------FN_DYNVARS_002_04-------------------------#'
43 SET @@session.auto_increment_offset = 1;
44 SELECT @@session.auto_increment_offset;
45 @@session.auto_increment_offset
46 1
47 SET @@session.auto_increment_offset = 50050;
48 SELECT @@session.auto_increment_offset;
49 @@session.auto_increment_offset
50 50050
51 SET @@session.auto_increment_offset = 65535;
52 SELECT @@session.auto_increment_offset;
53 @@session.auto_increment_offset
54 65535
55 '#------------------FN_DYNVARS_002_05-----------------------#'
56 SET @@global.auto_increment_offset = 0;
57 Warnings:
58 Warning 1292 Truncated incorrect auto_increment_offset value: '0'
59 SELECT @@global.auto_increment_offset;
60 @@global.auto_increment_offset
61 1
62 SET @@global.auto_increment_offset = -1024;
63 Warnings:
64 Warning 1292 Truncated incorrect auto_increment_offset value: '-1024'
65 SELECT @@global.auto_increment_offset;
66 @@global.auto_increment_offset
67 1
68 SET @@global.auto_increment_offset = 65536;
69 Warnings:
70 Warning 1292 Truncated incorrect auto_increment_offset value: '65536'
71 SELECT @@global.auto_increment_offset;
72 @@global.auto_increment_offset
73 65535
74 SET @@global.auto_increment_offset = 4294967295;
75 Warnings:
76 Warning 1292 Truncated incorrect auto_increment_offset value: '4294967295'
77 SELECT @@global.auto_increment_offset;
78 @@global.auto_increment_offset
79 65535
80 SET @@global.auto_increment_offset = 65535.4;
81 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
82 SELECT @@global.auto_increment_offset;
83 @@global.auto_increment_offset
84 65535
85 SET @@global.auto_increment_offset = ON;
86 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
87 SELECT @@global.auto_increment_offset;
88 @@global.auto_increment_offset
89 65535
90 SET @@global.auto_increment_offset = OFF;
91 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
92 SELECT @@global.auto_increment_offset;
93 @@global.auto_increment_offset
94 65535
95 SET @@global.auto_increment_offset = test;
96 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
97 SELECT @@global.auto_increment_offset;
98 @@global.auto_increment_offset
99 65535
100 SET @@session.auto_increment_offset = 0;
101 Warnings:
102 Warning 1292 Truncated incorrect auto_increment_offset value: '0'
103 SELECT @@session.auto_increment_offset;
104 @@session.auto_increment_offset
105 1
106 SET @@session.auto_increment_offset = -1024;
107 Warnings:
108 Warning 1292 Truncated incorrect auto_increment_offset value: '-1024'
109 SELECT @@session.auto_increment_offset;
110 @@session.auto_increment_offset
111 1
112 SET @@session.auto_increment_offset = 65536;
113 Warnings:
114 Warning 1292 Truncated incorrect auto_increment_offset value: '65536'
115 SELECT @@session.auto_increment_offset;
116 @@session.auto_increment_offset
117 65535
118 SET @@session.auto_increment_offset = 4294967295;
119 Warnings:
120 Warning 1292 Truncated incorrect auto_increment_offset value: '4294967295'
121 SELECT @@session.auto_increment_offset;
122 @@session.auto_increment_offset
123 65535
124 SET @@session.auto_increment_offset = 65535.4;
125 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
126 SELECT @@session.auto_increment_offset;
127 @@session.auto_increment_offset
128 65535
129 SET @@session.auto_increment_offset = ON;
130 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
131 SELECT @@session.auto_increment_offset;
132 @@session.auto_increment_offset
133 65535
134 SET @@session.auto_increment_offset = OFF;
135 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
136 SELECT @@session.auto_increment_offset;
137 @@session.auto_increment_offset
138 65535
139 SET @@session.auto_increment_offset = test;
140 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
141 SELECT @@session.auto_increment_offset;
142 @@session.auto_increment_offset
143 65535
144 '#------------------FN_DYNVARS_002_06-----------------------#'
145 SELECT @@global.auto_increment_offset = VARIABLE_VALUE
146 FROM performance_schema.global_variables
147 WHERE VARIABLE_NAME='auto_increment_offset';
148 @@global.auto_increment_offset = VARIABLE_VALUE
149 1
150 '#------------------FN_DYNVARS_002_07-----------------------#'
151 SELECT @@session.auto_increment_offset = VARIABLE_VALUE
152 FROM performance_schema.session_variables
153 WHERE VARIABLE_NAME='auto_increment_offset';
154 @@session.auto_increment_offset = VARIABLE_VALUE
155 1
156 '#------------------FN_DYNVARS_002_08-----------------------#'
157 SET @@global.auto_increment_offset = TRUE;
158 SELECT @@global.auto_increment_offset;
159 @@global.auto_increment_offset
160 1
161 SET @@global.auto_increment_offset = FALSE;
162 Warnings:
163 Warning 1292 Truncated incorrect auto_increment_offset value: '0'
164 SELECT @@global.auto_increment_offset;
165 @@global.auto_increment_offset
166 1
167 '#---------------------FN_DYNVARS_001_09----------------------#'
168 SET @@global.auto_increment_offset = 10;
169 SET @@session.auto_increment_offset = 11;
170 SELECT @@auto_increment_offset = @@global.auto_increment_offset;
171 @@auto_increment_offset = @@global.auto_increment_offset
172 0
173 '#---------------------FN_DYNVARS_001_10----------------------#'
174 SET @@auto_increment_offset = 100;
175 SELECT @@auto_increment_offset = @@local.auto_increment_offset;
176 @@auto_increment_offset = @@local.auto_increment_offset
177 1
178 SELECT @@local.auto_increment_offset = @@session.auto_increment_offset;
179 @@local.auto_increment_offset = @@session.auto_increment_offset
180 1
181 '#---------------------FN_DYNVARS_001_11----------------------#'
182 SET auto_increment_offset = 1;
183 SELECT @@auto_increment_offset;
184 @@auto_increment_offset
185 1
186 SELECT local.auto_increment_offset;
187 ERROR 42S02: Unknown table 'local' in field list
188 SELECT session.auto_increment_offset;
189 ERROR 42S02: Unknown table 'session' in field list
190 SELECT auto_increment_offset = @@session.auto_increment_offset;
191 ERROR 42S22: Unknown column 'auto_increment_offset' in 'field list'
192 SET @@global.auto_increment_offset = @start_global_value;
193 SELECT @@global.auto_increment_offset;
194 @@global.auto_increment_offset
195 1
196 SET @@session.auto_increment_offset = @start_session_value;
197 SELECT @@session.auto_increment_offset;
198 @@session.auto_increment_offset
199 1