← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

Viewing changes to mysql-test/suite/sys_vars/r/last_insert_id_func.result

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/r/last_insert_id_func.result
 
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 ##