1
SET @start_global_value = @@global.auto_increment_offset;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.auto_increment_offset;
6
SELECT @start_session_value;
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
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
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
25
SET @@session.auto_increment_offset = @start_session_value;
26
SELECT @@session.auto_increment_offset = 1;
27
@@session.auto_increment_offset = 1
29
'#--------------------FN_DYNVARS_002_03-------------------------#'
30
SET @@global.auto_increment_offset = 1;
31
SELECT @@global.auto_increment_offset;
32
@@global.auto_increment_offset
34
SET @@global.auto_increment_offset = 60020;
35
SELECT @@global.auto_increment_offset;
36
@@global.auto_increment_offset
38
SET @@global.auto_increment_offset = 65535;
39
SELECT @@global.auto_increment_offset;
40
@@global.auto_increment_offset
42
'#--------------------FN_DYNVARS_002_04-------------------------#'
43
SET @@session.auto_increment_offset = 1;
44
SELECT @@session.auto_increment_offset;
45
@@session.auto_increment_offset
47
SET @@session.auto_increment_offset = 50050;
48
SELECT @@session.auto_increment_offset;
49
@@session.auto_increment_offset
51
SET @@session.auto_increment_offset = 65535;
52
SELECT @@session.auto_increment_offset;
53
@@session.auto_increment_offset
55
'#------------------FN_DYNVARS_002_05-----------------------#'
56
SET @@global.auto_increment_offset = 0;
58
Warning 1292 Truncated incorrect auto-increment-offset value: '0'
59
SELECT @@global.auto_increment_offset;
60
@@global.auto_increment_offset
62
SET @@global.auto_increment_offset = -1024;
64
Warning 1292 Truncated incorrect auto-increment-offset value: '0'
65
SELECT @@global.auto_increment_offset;
66
@@global.auto_increment_offset
68
SET @@global.auto_increment_offset = 65536;
70
Warning 1292 Truncated incorrect auto_increment_offset value: '65536'
71
SELECT @@global.auto_increment_offset;
72
@@global.auto_increment_offset
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
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
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
89
SET @@session.auto_increment_offset = 0;
91
Warning 1292 Truncated incorrect auto-increment-offset value: '0'
92
SELECT @@session.auto_increment_offset;
93
@@session.auto_increment_offset
95
SET @@session.auto_increment_offset = -2;
97
Warning 1292 Truncated incorrect auto-increment-offset value: '0'
98
SELECT @@session.auto_increment_offset;
99
@@session.auto_increment_offset
101
SET @@session.auto_increment_offset = 65550;
103
Warning 1292 Truncated incorrect auto_increment_offset value: '65550'
104
SELECT @@session.auto_increment_offset;
105
@@session.auto_increment_offset
107
'Bug # 34837: Errors are not coming on assigning invalid values to variable'
108
SET @@session.auto_increment_offset = ON;
109
ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
110
SELECT @@session.auto_increment_offset;
111
@@session.auto_increment_offset
113
SET @@session.auto_increment_offset = OFF;
114
ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
115
SELECT @@session.auto_increment_offset;
116
@@session.auto_increment_offset
118
SET @@session.auto_increment_offset = test;
119
ERROR 42000: Incorrect argument type to variable 'auto_increment_offset'
120
SELECT @@session.auto_increment_offset;
121
@@session.auto_increment_offset
123
'#------------------FN_DYNVARS_002_06-----------------------#'
124
SELECT @@global.auto_increment_offset = VARIABLE_VALUE
125
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
126
WHERE VARIABLE_NAME='auto_increment_offset';
127
@@global.auto_increment_offset = VARIABLE_VALUE
129
'#------------------FN_DYNVARS_002_07-----------------------#'
130
SELECT @@session.auto_increment_offset = VARIABLE_VALUE
131
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
132
WHERE VARIABLE_NAME='auto_increment_offset';
133
@@session.auto_increment_offset = VARIABLE_VALUE
135
'#------------------FN_DYNVARS_002_08-----------------------#'
136
SET @@global.auto_increment_offset = TRUE;
137
SELECT @@global.auto_increment_offset;
138
@@global.auto_increment_offset
140
SET @@global.auto_increment_offset = FALSE;
142
Warning 1292 Truncated incorrect auto-increment-offset value: '0'
143
SELECT @@global.auto_increment_offset;
144
@@global.auto_increment_offset
146
'#---------------------FN_DYNVARS_001_09----------------------#'
147
SET @@global.auto_increment_offset = 10;
148
SET @@session.auto_increment_offset = 11;
149
SELECT @@auto_increment_offset = @@global.auto_increment_offset;
150
@@auto_increment_offset = @@global.auto_increment_offset
152
'#---------------------FN_DYNVARS_001_10----------------------#'
153
SET @@auto_increment_offset = 100;
154
SELECT @@auto_increment_offset = @@local.auto_increment_offset;
155
@@auto_increment_offset = @@local.auto_increment_offset
157
SELECT @@local.auto_increment_offset = @@session.auto_increment_offset;
158
@@local.auto_increment_offset = @@session.auto_increment_offset
160
'#---------------------FN_DYNVARS_001_11----------------------#'
161
SET auto_increment_offset = 1;
162
SELECT @@auto_increment_offset;
163
@@auto_increment_offset
165
SELECT local.auto_increment_offset;
166
ERROR 42S02: Unknown table 'local' in field list
167
SELECT session.auto_increment_offset;
168
ERROR 42S02: Unknown table 'session' in field list
169
SELECT auto_increment_offset = @@session.auto_increment_offset;
170
ERROR 42S22: Unknown column 'auto_increment_offset' in 'field list'
171
SET @@global.auto_increment_offset = @start_global_value;
172
SELECT @@global.auto_increment_offset;
173
@@global.auto_increment_offset
175
SET @@session.auto_increment_offset = @start_session_value;
176
SELECT @@session.auto_increment_offset;
177
@@session.auto_increment_offset