Debian Codegraph @

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

raw
1 drop table if exists t1;
2 ## Creating new table ##
3 CREATE TABLE t1
4 (
5 id INT NOT NULL auto_increment,
6 PRIMARY KEY (id),
7 name VARCHAR(30)
8 ) ENGINE = INNODB;
9 '#--------------------FN_DYNVARS_059_01-------------------------#'
10 ## Verifying initial value of ##
11 SELECT @@session.last_insert_id;
12 @@session.last_insert_id
13 0
14 ## Inserting records in table t1 ##
15 INSERT into t1(name) values('Record_1');
16 INSERT into t1(name) values('Record_2');
17 SELECT * from t1;
18 id name
19 1 Record_1
20 2 Record_2
21 ## Verifying value of variable after inserting some rows ##
22 SELECT @@session.last_insert_id = 2;
23 @@session.last_insert_id = 2
24 1
25 '#--------------------FN_DYNVARS_059_02-------------------------#'
26 ## Creating & connecting to new connection test_con1 ##
27 SET @@autocommit = 0;
28 ## Verifying initial value of variable in new connection ##
29 SELECT @@session.last_insert_id;
30 @@session.last_insert_id
31 0
32 ## Inserting rows in table t1 ##
33 START TRANSACTION;
34 INSERT into t1(name) values('Record_3');
35 INSERT into t1(name) values('Record_4');
36 INSERT into t1(name) values('Record_5');
37 ## Verifying value of variable without committing rows ##
38 SELECT @@session.last_insert_id;
39 @@session.last_insert_id
40 5
41 '#--------------------FN_DYNVARS_059_03-------------------------#'
42 ## Creating & connecting to new connection test_con2 ##
43 ## Inserting values through new connection ##
44 INSERT into t1(name) values('Record_6');
45 INSERT into t1(name) values('Record_7');
46 SELECT * from t1;
47 id name
48 1 Record_1
49 2 Record_2
50 6 Record_6
51 7 Record_7
52 ## Verifying value of variable in second connection ##
53 SELECT @@last_insert_id;
54 @@last_insert_id
55 7
56 '#--------------------FN_DYNVARS_059_04-------------------------#'
57 ## Switching to test_con1 ##
58 ## Verifying all records in table & value of variable ##
59 SELECT * from t1;
60 id name
61 1 Record_1
62 2 Record_2
63 3 Record_3
64 4 Record_4
65 5 Record_5
66 6 Record_6
67 7 Record_7
68 SELECT @@session.last_insert_id;
69 @@session.last_insert_id
70 5
71 ## Commiting records in table ##
72 COMMIT;
73 SELECT @@session.last_insert_id;
74 @@session.last_insert_id
75 5
76 ## Switching to test_con2 & verifying value of variable in it ##
77 SELECT @@session.last_insert_id;
78 @@session.last_insert_id
79 7
80 '#--------------------FN_DYNVARS_059_05-------------------------#'
81 ## Setting value of variable ##
82 SET @@session.last_insert_id = 100;
83 SELECT @@session.last_insert_id;
84 @@session.last_insert_id
85 100
86 ## Inserting new record and verifying variable's effect on it ##
87 INSERT into t1(name) values('Record_8');
88 SELECT @@session.last_insert_id;
89 @@session.last_insert_id
90 8
91 ## Dropping table t1 ##
92 drop table t1;
93 ## Disconnecting both the connections ##