1SET @start_global_value = @@global.auto_increment_increment;
2SELECT @start_global_value;
3@start_global_value
41
5SET @start_session_value = @@session.auto_increment_increment;
6SELECT @start_session_value;
7@start_session_value
81
9'#--------------------FN_DYNVARS_001_01-------------------------#'
10SET @@global.auto_increment_increment = 100;
11SET @@global.auto_increment_increment = DEFAULT;
12SELECT @@global.auto_increment_increment;
13@@global.auto_increment_increment
141
15SET @@session.auto_increment_increment = 200;
16SET @@session.auto_increment_increment = DEFAULT;
17SELECT @@session.auto_increment_increment;
18@@session.auto_increment_increment
191
20'#--------------------FN_DYNVARS_001_02-------------------------#'
21SET @@global.auto_increment_increment = DEFAULT;
22SELECT @@global.auto_increment_increment = 1;
23@@global.auto_increment_increment = 1
241
25SET @@session.auto_increment_increment = DEFAULT;
26SELECT @@session.auto_increment_increment = 1;
27@@session.auto_increment_increment = 1
281
29'#--------------------FN_DYNVARS_001_03-------------------------#'
30SET @@global.auto_increment_increment = 1;
31SELECT @@global.auto_increment_increment;
32@@global.auto_increment_increment
331
34SET @@global.auto_increment_increment = 60020;
35SELECT @@global.auto_increment_increment;
36@@global.auto_increment_increment
3760020
38SET @@global.auto_increment_increment = 65535;
39SELECT @@global.auto_increment_increment;
40@@global.auto_increment_increment
4165535
42'#--------------------FN_DYNVARS_001_04-------------------------#'
43SET @@session.auto_increment_increment = 1;
44SELECT @@session.auto_increment_increment;
45@@session.auto_increment_increment
461
47SET @@session.auto_increment_increment = 50050;
48SELECT @@session.auto_increment_increment;
49@@session.auto_increment_increment
5050050
51SET @@session.auto_increment_increment = 65535;
52SELECT @@session.auto_increment_increment;
53@@session.auto_increment_increment
5465535
55'#------------------FN_DYNVARS_001_05-----------------------#'
56SET @@global.auto_increment_increment = 0;
57Warnings:
58Warning	1292	Truncated incorrect auto_increment_increment value: '0'
59SELECT @@global.auto_increment_increment;
60@@global.auto_increment_increment
611
62SET @@global.auto_increment_increment = -1024;
63Warnings:
64Warning	1292	Truncated incorrect auto_increment_increment value: '-1024'
65SELECT @@global.auto_increment_increment;
66@@global.auto_increment_increment
671
68SET @@global.auto_increment_increment = 65536;
69Warnings:
70Warning	1292	Truncated incorrect auto_increment_increment value: '65536'
71SELECT @@global.auto_increment_increment;
72@@global.auto_increment_increment
7365535
74SET @@global.auto_increment_increment = 4294967295;
75Warnings:
76Warning	1292	Truncated incorrect auto_increment_increment value: '4294967295'
77SELECT @@global.auto_increment_increment;
78@@global.auto_increment_increment
7965535
80SET @@global.auto_increment_increment = 65530.34;
81ERROR 42000: Incorrect argument type to variable 'auto_increment_increment'
82SELECT @@global.auto_increment_increment;
83@@global.auto_increment_increment
8465535
85SET @@global.auto_increment_increment = test;
86ERROR 42000: Incorrect argument type to variable 'auto_increment_increment'
87SELECT @@global.auto_increment_increment;
88@@global.auto_increment_increment
8965535
90SET @@session.auto_increment_increment = 0;
91Warnings:
92Warning	1292	Truncated incorrect auto_increment_increment value: '0'
93SELECT @@session.auto_increment_increment;
94@@session.auto_increment_increment
951
96SET @@session.auto_increment_increment = -1024;
97Warnings:
98Warning	1292	Truncated incorrect auto_increment_increment value: '-1024'
99SELECT @@session.auto_increment_increment;
100@@session.auto_increment_increment
1011
102SET @@session.auto_increment_increment = 65530.34;
103ERROR 42000: Incorrect argument type to variable 'auto_increment_increment'
104SELECT @@global.auto_increment_increment;
105@@global.auto_increment_increment
10665535
107SET @@session.auto_increment_increment = 65536;
108Warnings:
109Warning	1292	Truncated incorrect auto_increment_increment value: '65536'
110SELECT @@session.auto_increment_increment;
111@@session.auto_increment_increment
11265535
113SET @@session.auto_increment_increment = 4294967295;
114Warnings:
115Warning	1292	Truncated incorrect auto_increment_increment value: '4294967295'
116SELECT @@session.auto_increment_increment;
117@@session.auto_increment_increment
11865535
119SET @@session.auto_increment_increment = test;
120ERROR 42000: Incorrect argument type to variable 'auto_increment_increment'
121SELECT @@session.auto_increment_increment;
122@@session.auto_increment_increment
12365535
124'#------------------FN_DYNVARS_001_06-----------------------#'
125SELECT @@global.auto_increment_increment = VARIABLE_VALUE
126FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
127WHERE VARIABLE_NAME='auto_increment_increment';
128@@global.auto_increment_increment = VARIABLE_VALUE
1291
130'#------------------FN_DYNVARS_001_07-----------------------#'
131SELECT @@session.auto_increment_increment = VARIABLE_VALUE
132FROM INFORMATION_SCHEMA.SESSION_VARIABLES
133WHERE VARIABLE_NAME='auto_increment_increment';
134@@session.auto_increment_increment = VARIABLE_VALUE
1351
136'#------------------FN_DYNVARS_001_08-----------------------#'
137SET @@global.auto_increment_increment = TRUE;
138SELECT @@global.auto_increment_increment;
139@@global.auto_increment_increment
1401
141SET @@global.auto_increment_increment = FALSE;
142Warnings:
143Warning	1292	Truncated incorrect auto_increment_increment value: '0'
144SELECT @@global.auto_increment_increment;
145@@global.auto_increment_increment
1461
147'#---------------------FN_DYNVARS_001_09----------------------#'
148SET @@global.auto_increment_increment = 10;
149SET @@session.auto_increment_increment = 11;
150SELECT @@auto_increment_increment = @@global.auto_increment_increment;
151@@auto_increment_increment = @@global.auto_increment_increment
1520
153'#---------------------FN_DYNVARS_001_10----------------------#'
154SET @@auto_increment_increment = 100;
155SELECT @@auto_increment_increment = @@local.auto_increment_increment;
156@@auto_increment_increment = @@local.auto_increment_increment
1571
158SELECT @@local.auto_increment_increment = @@session.auto_increment_increment;
159@@local.auto_increment_increment = @@session.auto_increment_increment
1601
161'#---------------------FN_DYNVARS_001_11----------------------#'
162SET auto_increment_increment = 1;
163SELECT @@auto_increment_increment;
164@@auto_increment_increment
1651
166SELECT local.auto_increment_increment;
167ERROR 42S02: Unknown table 'local' in field list
168SELECT session.auto_increment_increment;
169ERROR 42S02: Unknown table 'session' in field list
170SELECT auto_increment_increment = @@session.auto_increment_increment;
171ERROR 42S22: Unknown column 'auto_increment_increment' in 'field list'
172SET @@global.auto_increment_increment = @start_global_value;
173SELECT @@global.auto_increment_increment;
174@@global.auto_increment_increment
1751
176SET @@session.auto_increment_increment = @start_session_value;
177SELECT @@session.auto_increment_increment;
178@@session.auto_increment_increment
1791
180