1SET @start_value = @@session.insert_id;
2SELECT @start_value;
3@start_value
40
5'#--------------------FN_DYNVARS_051_01------------------------#'
6SET @@session.insert_id = 99;
7'Variable is giving error on assigning Default value';
8SELECT @@session.insert_id;
9@@session.insert_id
1099
11'#---------------------FN_DYNVARS_051_02-------------------------#'
12SET @@session.insert_id = @start_value;
13SELECT @@session.insert_id = 0;
14@@session.insert_id = 0
151
16'#--------------------FN_DYNVARS_051_03------------------------#'
17SET @@session.insert_id = 0;
18SELECT @@session.insert_id;
19@@session.insert_id
200
21SET @@session.insert_id = 1099;
22SELECT @@session.insert_id;
23@@session.insert_id
241099
25SET @@session.insert_id = 1800;
26SELECT @@session.insert_id;
27@@session.insert_id
281800
29SET @@session.insert_id = 65535;
30SELECT @@session.insert_id;
31@@session.insert_id
3265535
33'#--------------------FN_DYNVARS_051_04-------------------------#'
34SET @@session.insert_id = -1;
35Warnings:
36Warning	1292	Truncated incorrect insert_id value: '-1'
37SELECT @@session.insert_id;
38@@session.insert_id
390
40SET @@session.insert_id = 100000000000;
41SELECT @@session.insert_id;
42@@session.insert_id
43100000000000
44SET @@session.insert_id = 10000.01;
45ERROR 42000: Incorrect argument type to variable 'insert_id'
46SELECT @@session.insert_id;
47@@session.insert_id
48100000000000
49SET @@session.insert_id = -1024;
50Warnings:
51Warning	1292	Truncated incorrect insert_id value: '-1024'
52SELECT @@session.insert_id;
53@@session.insert_id
540
55SET @@session.insert_id = 42949672950;
56SELECT @@session.insert_id;
57@@session.insert_id
5842949672950
59SET @@session.insert_id = ON;
60ERROR 42000: Incorrect argument type to variable 'insert_id'
61SELECT @@session.insert_id;
62@@session.insert_id
6342949672950
64SET @@session.insert_id = 'test';
65ERROR 42000: Incorrect argument type to variable 'insert_id'
66SELECT @@session.insert_id;
67@@session.insert_id
6842949672950
69'#-------------------FN_DYNVARS_051_05----------------------------#'
70SET @@global.insert_id = 0;
71ERROR HY000: Variable 'insert_id' is a SESSION variable and can't be used with SET GLOBAL
72SELECT @@global.insert_id;
73ERROR HY000: Variable 'insert_id' is a SESSION variable
74'#----------------------FN_DYNVARS_051_06------------------------#'
75SELECT @@global.insert_id = VARIABLE_VALUE
76FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
77WHERE VARIABLE_NAME='insert_id';
78ERROR HY000: Variable 'insert_id' is a SESSION variable
79SELECT @@session.insert_id = VARIABLE_VALUE
80FROM INFORMATION_SCHEMA.SESSION_VARIABLES
81WHERE VARIABLE_NAME='insert_id';
82@@session.insert_id = VARIABLE_VALUE
831
84'#-------------------FN_DYNVARS_051_07----------------------------#'
85SET @@global.insert_id = 0;
86ERROR HY000: Variable 'insert_id' is a SESSION variable and can't be used with SET GLOBAL
87SELECT @@global.insert_id;
88ERROR HY000: Variable 'insert_id' is a SESSION variable
89'#---------------------FN_DYNVARS_051_08----------------------#'
90SET @@session.insert_id = TRUE;
91SELECT @@session.insert_id;
92@@session.insert_id
931
94SET @@session.insert_id = FALSE;
95SELECT @@session.insert_id;
96@@session.insert_id
970
98'#---------------------FN_DYNVARS_051_09----------------------#'
99SET @@session.insert_id = 1;
100SELECT @@insert_id = @@session.insert_id;
101@@insert_id = @@session.insert_id
1021
103SELECT @@session.insert_id = @@local.insert_id;
104@@session.insert_id = @@local.insert_id
1051
106'#---------------------FN_DYNVARS_051_10----------------------#'
107SET insert_id = 1;
108SELECT @@insert_id;
109@@insert_id
1101
111SET local.insert_id = 1;
112ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.insert_id = 1' at line 1
113SELECT local.insert_id;
114ERROR 42S02: Unknown table 'local' in field list
115SET session.insert_id = 1;
116ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.insert_id = 1' at line 1
117SELECT session.insert_id;
118ERROR 42S02: Unknown table 'session' in field list
119SELECT insert_id = @@session.insert_id;
120ERROR 42S22: Unknown column 'insert_id' in 'field list'
121SET @@session.insert_id = @start_value;
122SELECT @@session.insert_id;
123@@session.insert_id
1240
125