|
1860.2.1
by Stewart Smith
add test for READ_COMMITTED isolation level (currently fails with Innobase plugin at least) |
1 |
connect (a,localhost,root,,); |
2 |
connect (b,localhost,root,,); |
|
3 |
||
4 |
connection a; |
|
|
1860.2.7
by Stewart Smith
add test for READ COMMITTED isolation level |
5 |
--echo A
|
|
1860.2.1
by Stewart Smith
add test for READ_COMMITTED isolation level (currently fails with Innobase plugin at least) |
6 |
CREATE TABLE t1 (a int); |
7 |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; |
|
8 |
BEGIN; |
|
9 |
INSERT INTO t1 values (1); |
|
10 |
||
11 |
connection b; |
|
|
1860.2.7
by Stewart Smith
add test for READ COMMITTED isolation level |
12 |
--echo B
|
|
1860.2.1
by Stewart Smith
add test for READ_COMMITTED isolation level (currently fails with Innobase plugin at least) |
13 |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; |
14 |
BEGIN; |
|
15 |
SELECT * from t1; |
|
16 |
||
17 |
connection a; |
|
|
1860.2.7
by Stewart Smith
add test for READ COMMITTED isolation level |
18 |
--echo A
|
|
1860.2.1
by Stewart Smith
add test for READ_COMMITTED isolation level (currently fails with Innobase plugin at least) |
19 |
INSERT INTO t1 values (2); |
20 |
||
21 |
connection b; |
|
|
1860.2.7
by Stewart Smith
add test for READ COMMITTED isolation level |
22 |
--echo B
|
|
1860.2.1
by Stewart Smith
add test for READ_COMMITTED isolation level (currently fails with Innobase plugin at least) |
23 |
SELECT * from t1; |
24 |
COMMIT; |
|
25 |
BEGIN; |
|
26 |
SELECT * FROM t1; |
|
27 |
||
28 |
connection a; |
|
|
1860.2.7
by Stewart Smith
add test for READ COMMITTED isolation level |
29 |
--echo A
|
|
1860.2.1
by Stewart Smith
add test for READ_COMMITTED isolation level (currently fails with Innobase plugin at least) |
30 |
COMMIT; |
31 |
||
32 |
connection b; |
|
|
1860.2.7
by Stewart Smith
add test for READ COMMITTED isolation level |
33 |
--echo B
|
|
1860.2.1
by Stewart Smith
add test for READ_COMMITTED isolation level (currently fails with Innobase plugin at least) |
34 |
SELECT * from t1 order by a; |
35 |
COMMIT; |
|
36 |
BEGIN; |
|
37 |
SELECT * from t1 order by a; |
|
38 |
||
|
1890.2.20
by Stewart Smith
use explicit COMMIT in trx_isolation_read_committed test instead of implicit commit in DROP TABLE |
39 |
COMMIT; |
|
1860.2.1
by Stewart Smith
add test for READ_COMMITTED isolation level (currently fails with Innobase plugin at least) |
40 |
DROP TABLE t1; |
41 |
||
42 |
disconnect a; |
|
43 |
disconnect b; |
|
44 |
connection default; |