Debian Codegraph @

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

raw
1 select @@global.last_insert_id;
2 ERROR HY000: Variable 'last_insert_id' is a SESSION variable
3 select @@session.last_insert_id;
4 @@session.last_insert_id
5 0
6 show global variables like 'last_insert_id';
7 Variable_name Value
8 show session variables like 'last_insert_id';
9 Variable_name Value
10 last_insert_id 0
11 select * from performance_schema.global_variables where variable_name='last_insert_id';
12 VARIABLE_NAME VARIABLE_VALUE
13 select * from performance_schema.session_variables where variable_name='last_insert_id';
14 VARIABLE_NAME VARIABLE_VALUE
15 last_insert_id 0
16 set global last_insert_id=99;
17 ERROR HY000: Variable 'last_insert_id' is a SESSION variable and can't be used with SET GLOBAL
18 set session last_insert_id=42;
19 select @@global.last_insert_id;
20 ERROR HY000: Variable 'last_insert_id' is a SESSION variable
21 select @@session.last_insert_id;
22 @@session.last_insert_id
23 42
24 show global variables like 'last_insert_id';
25 Variable_name Value
26 show session variables like 'last_insert_id';
27 Variable_name Value
28 last_insert_id 42
29 select * from performance_schema.global_variables where variable_name='last_insert_id';
30 VARIABLE_NAME VARIABLE_VALUE
31 select * from performance_schema.session_variables where variable_name='last_insert_id';
32 VARIABLE_NAME VARIABLE_VALUE
33 last_insert_id 42
34 set session last_insert_id=1.1;
35 ERROR 42000: Incorrect argument type to variable 'last_insert_id'
36 set session last_insert_id=1e1;
37 ERROR 42000: Incorrect argument type to variable 'last_insert_id'
38 set session last_insert_id="foo";
39 ERROR 42000: Incorrect argument type to variable 'last_insert_id'