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 = 65530.34;
75ERROR 42000: Incorrect argument type to variable 'auto_increment_increment'
76SELECT @@global.auto_increment_increment;
77@@global.auto_increment_increment
7865535
79SET @@global.auto_increment_increment = test;
80ERROR 42000: Incorrect argument type to variable 'auto_increment_increment'
81SELECT @@global.auto_increment_increment;
82@@global.auto_increment_increment
8365535
84SET @@session.auto_increment_increment = 0;
85Warnings:
86Warning	1292	Truncated incorrect auto_increment_increment value: '0'
87SELECT @@session.auto_increment_increment;
88@@session.auto_increment_increment
891
90SET @@session.auto_increment_increment = -2;
91Warnings:
92Warning	1292	Truncated incorrect auto_increment_increment value: '-2'
93SELECT @@session.auto_increment_increment;
94@@session.auto_increment_increment
951
96SET @@session.auto_increment_increment = 65530.34;
97ERROR 42000: Incorrect argument type to variable 'auto_increment_increment'
98SET @@session.auto_increment_increment = 65550;
99Warnings:
100Warning	1292	Truncated incorrect auto_increment_increment value: '65550'
101SELECT @@session.auto_increment_increment;
102@@session.auto_increment_increment
10365535
104SET @@session.auto_increment_increment = test;
105ERROR 42000: Incorrect argument type to variable 'auto_increment_increment'
106SELECT @@session.auto_increment_increment;
107@@session.auto_increment_increment
10865535
109'#------------------FN_DYNVARS_001_06-----------------------#'
110SELECT @@global.auto_increment_increment = VARIABLE_VALUE
111FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
112WHERE VARIABLE_NAME='auto_increment_increment';
113@@global.auto_increment_increment = VARIABLE_VALUE
1141
115'#------------------FN_DYNVARS_001_07-----------------------#'
116SELECT @@session.auto_increment_increment = VARIABLE_VALUE
117FROM INFORMATION_SCHEMA.SESSION_VARIABLES
118WHERE VARIABLE_NAME='auto_increment_increment';
119@@session.auto_increment_increment = VARIABLE_VALUE
1201
121'#------------------FN_DYNVARS_001_08-----------------------#'
122SET @@global.auto_increment_increment = TRUE;
123SELECT @@global.auto_increment_increment;
124@@global.auto_increment_increment
1251
126SET @@global.auto_increment_increment = FALSE;
127Warnings:
128Warning	1292	Truncated incorrect auto_increment_increment value: '0'
129SELECT @@global.auto_increment_increment;
130@@global.auto_increment_increment
1311
132'#---------------------FN_DYNVARS_001_09----------------------#'
133SET @@global.auto_increment_increment = 10;
134SET @@session.auto_increment_increment = 11;
135SELECT @@auto_increment_increment = @@global.auto_increment_increment;
136@@auto_increment_increment = @@global.auto_increment_increment
1370
138'#---------------------FN_DYNVARS_001_10----------------------#'
139SET @@auto_increment_increment = 100;
140SELECT @@auto_increment_increment = @@local.auto_increment_increment;
141@@auto_increment_increment = @@local.auto_increment_increment
1421
143SELECT @@local.auto_increment_increment = @@session.auto_increment_increment;
144@@local.auto_increment_increment = @@session.auto_increment_increment
1451
146'#---------------------FN_DYNVARS_001_11----------------------#'
147SET auto_increment_increment = 1;
148SELECT @@auto_increment_increment;
149@@auto_increment_increment
1501
151SELECT local.auto_increment_increment;
152ERROR 42S02: Unknown table 'local' in field list
153SELECT session.auto_increment_increment;
154ERROR 42S02: Unknown table 'session' in field list
155SELECT auto_increment_increment = @@session.auto_increment_increment;
156ERROR 42S22: Unknown column 'auto_increment_increment' in 'field list'
157SET @@global.auto_increment_increment = @start_global_value;
158SELECT @@global.auto_increment_increment;
159@@global.auto_increment_increment
1601
161SET @@session.auto_increment_increment = @start_session_value;
162SELECT @@session.auto_increment_increment;
163@@session.auto_increment_increment
1641
165