← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

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

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/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 ##