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 = ON;
75 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
76 SELECT @@global.auto_increment_offset;
77 @@global.auto_increment_offset
78 65535
79 SET @@global.auto_increment_offset = OFF;
80 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
81 SELECT @@global.auto_increment_offset;
82 @@global.auto_increment_offset
83 65535
84 SET @@global.auto_increment_offset = test;
85 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
86 SELECT @@global.auto_increment_offset;
87 @@global.auto_increment_offset
88 65535
89 SET @@session.auto_increment_offset = 0;
90 Warnings:
91 Warning 1292 Truncated incorrect auto_increment_offset value: '0'
92 SELECT @@session.auto_increment_offset;
93 @@session.auto_increment_offset
94 1
95 SET @@session.auto_increment_offset = -2;
96 Warnings:
97 Warning 1292 Truncated incorrect auto_increment_offset value: '-2'
98 SELECT @@session.auto_increment_offset;
99 @@session.auto_increment_offset
100 1
101 SET @@session.auto_increment_offset = 65550;
102 Warnings:
103 Warning 1292 Truncated incorrect auto_increment_offset value: '65550'
104 SELECT @@session.auto_increment_offset;
105 @@session.auto_increment_offset
106 65535
107 SET @@session.auto_increment_offset = ON;
108 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
109 SELECT @@session.auto_increment_offset;
110 @@session.auto_increment_offset
111 65535
112 SET @@session.auto_increment_offset = OFF;
113 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
114 SELECT @@session.auto_increment_offset;
115 @@session.auto_increment_offset
116 65535
117 SET @@session.auto_increment_offset = test;
118 ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
119 SELECT @@session.auto_increment_offset;
120 @@session.auto_increment_offset
121 65535
122 '#------------------FN_DYNVARS_002_06-----------------------#'
123 SELECT @@global.auto_increment_offset = VARIABLE_VALUE
124 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
125 WHERE VARIABLE_NAME='auto_increment_offset';
126 @@global.auto_increment_offset = VARIABLE_VALUE
127 1
128 '#------------------FN_DYNVARS_002_07-----------------------#'
129 SELECT @@session.auto_increment_offset = VARIABLE_VALUE
130 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
131 WHERE VARIABLE_NAME='auto_increment_offset';
132 @@session.auto_increment_offset = VARIABLE_VALUE
133 1
134 '#------------------FN_DYNVARS_002_08-----------------------#'
135 SET @@global.auto_increment_offset = TRUE;
136 SELECT @@global.auto_increment_offset;
137 @@global.auto_increment_offset
138 1
139 SET @@global.auto_increment_offset = FALSE;
140 Warnings:
141 Warning 1292 Truncated incorrect auto_increment_offset value: '0'
142 SELECT @@global.auto_increment_offset;
143 @@global.auto_increment_offset
144 1
145 '#---------------------FN_DYNVARS_001_09----------------------#'
146 SET @@global.auto_increment_offset = 10;
147 SET @@session.auto_increment_offset = 11;
148 SELECT @@auto_increment_offset = @@global.auto_increment_offset;
149 @@auto_increment_offset = @@global.auto_increment_offset
150 0
151 '#---------------------FN_DYNVARS_001_10----------------------#'
152 SET @@auto_increment_offset = 100;
153 SELECT @@auto_increment_offset = @@local.auto_increment_offset;
154 @@auto_increment_offset = @@local.auto_increment_offset
155 1
156 SELECT @@local.auto_increment_offset = @@session.auto_increment_offset;
157 @@local.auto_increment_offset = @@session.auto_increment_offset
158 1
159 '#---------------------FN_DYNVARS_001_11----------------------#'
160 SET auto_increment_offset = 1;
161 SELECT @@auto_increment_offset;
162 @@auto_increment_offset
163 1
164 SELECT local.auto_increment_offset;
165 ERROR 42S02: Unknown table 'local' in SELECT
166 SELECT session.auto_increment_offset;
167 ERROR 42S02: Unknown table 'session' in SELECT
168 SELECT auto_increment_offset = @@session.auto_increment_offset;
169 ERROR 42S22: Unknown column 'auto_increment_offset' in 'SELECT'
170 SET @@global.auto_increment_offset = @start_global_value;
171 SELECT @@global.auto_increment_offset;
172 @@global.auto_increment_offset
173 1
174 SET @@session.auto_increment_offset = @start_session_value;
175 SELECT @@session.auto_increment_offset;
176 @@session.auto_increment_offset
177 1