Debian Codegraph @

mysql-test/suite/sys_vars/r/insert_id_basic.result

raw
1 SET @start_value = @@session.insert_id;
2 SELECT @start_value;
3 @start_value
4 0
5 '#--------------------FN_DYNVARS_051_01------------------------#'
6 SET @@session.insert_id = 99;
7 'Variable is giving error on assigning Default value';
8 SELECT @@session.insert_id;
9 @@session.insert_id
10 99
11 '#---------------------FN_DYNVARS_051_02-------------------------#'
12 SET @@session.insert_id = @start_value;
13 SELECT @@session.insert_id = 0;
14 @@session.insert_id = 0
15 1
16 '#--------------------FN_DYNVARS_051_03------------------------#'
17 SET @@session.insert_id = 0;
18 SELECT @@session.insert_id;
19 @@session.insert_id
20 0
21 SET @@session.insert_id = 1099;
22 SELECT @@session.insert_id;
23 @@session.insert_id
24 1099
25 SET @@session.insert_id = 1800;
26 SELECT @@session.insert_id;
27 @@session.insert_id
28 1800
29 SET @@session.insert_id = 65535;
30 SELECT @@session.insert_id;
31 @@session.insert_id
32 65535
33 '#--------------------FN_DYNVARS_051_04-------------------------#'
34 SET @@session.insert_id = -1;
35 Warnings:
36 Warning 1292 Truncated incorrect insert_id value: '-1'
37 SELECT @@session.insert_id;
38 @@session.insert_id
39 0
40 SET @@session.insert_id = 100000000000;
41 SELECT @@session.insert_id;
42 @@session.insert_id
43 100000000000
44 SET @@session.insert_id = 10000.01;
45 ERROR 42000: Incorrect argument type to variable 'insert_id'
46 SELECT @@session.insert_id;
47 @@session.insert_id
48 100000000000
49 SET @@session.insert_id = -1024;
50 Warnings:
51 Warning 1292 Truncated incorrect insert_id value: '-1024'
52 SELECT @@session.insert_id;
53 @@session.insert_id
54 0
55 SET @@session.insert_id = 42949672950;
56 SELECT @@session.insert_id;
57 @@session.insert_id
58 42949672950
59 SET @@session.insert_id = ON;
60 ERROR 42000: Incorrect argument type to variable 'insert_id'
61 SELECT @@session.insert_id;
62 @@session.insert_id
63 42949672950
64 SET @@session.insert_id = 'test';
65 ERROR 42000: Incorrect argument type to variable 'insert_id'
66 SELECT @@session.insert_id;
67 @@session.insert_id
68 42949672950
69 '#-------------------FN_DYNVARS_051_05----------------------------#'
70 SET @@global.insert_id = 0;
71 ERROR HY000: Variable 'insert_id' is a SESSION variable and can't be used with SET GLOBAL
72 SELECT @@global.insert_id;
73 ERROR HY000: Variable 'insert_id' is a SESSION variable
74 '#----------------------FN_DYNVARS_051_06------------------------#'
75 SELECT @@global.insert_id = VARIABLE_VALUE
76 FROM performance_schema.global_variables
77 WHERE VARIABLE_NAME='insert_id';
78 ERROR HY000: Variable 'insert_id' is a SESSION variable
79 SELECT @@session.insert_id = VARIABLE_VALUE
80 FROM performance_schema.session_variables
81 WHERE VARIABLE_NAME='insert_id';
82 @@session.insert_id = VARIABLE_VALUE
83 1
84 '#-------------------FN_DYNVARS_051_07----------------------------#'
85 SET @@global.insert_id = 0;
86 ERROR HY000: Variable 'insert_id' is a SESSION variable and can't be used with SET GLOBAL
87 SELECT @@global.insert_id;
88 ERROR HY000: Variable 'insert_id' is a SESSION variable
89 '#---------------------FN_DYNVARS_051_08----------------------#'
90 SET @@session.insert_id = TRUE;
91 SELECT @@session.insert_id;
92 @@session.insert_id
93 1
94 SET @@session.insert_id = FALSE;
95 SELECT @@session.insert_id;
96 @@session.insert_id
97 0
98 '#---------------------FN_DYNVARS_051_09----------------------#'
99 SET @@session.insert_id = 1;
100 SELECT @@insert_id = @@session.insert_id;
101 @@insert_id = @@session.insert_id
102 1
103 SELECT @@session.insert_id = @@local.insert_id;
104 @@session.insert_id = @@local.insert_id
105 1
106 '#---------------------FN_DYNVARS_051_10----------------------#'
107 SET insert_id = 1;
108 SELECT @@insert_id;
109 @@insert_id
110 1
111 SET local.insert_id = 1;
112 ERROR 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
113 SELECT local.insert_id;
114 ERROR 42S02: Unknown table 'local' in field list
115 SET session.insert_id = 1;
116 ERROR 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
117 SELECT session.insert_id;
118 ERROR 42S02: Unknown table 'session' in field list
119 SELECT insert_id = @@session.insert_id;
120 ERROR 42S22: Unknown column 'insert_id' in 'field list'
121 SET @@session.insert_id = @start_value;
122 SELECT @@session.insert_id;
123 @@session.insert_id
124 0