← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/haildb/tests/t/trx_isolation_read_uncommitted.test

  • Committer: Olaf van der Spek
  • Date: 2011-08-04 08:13:04 UTC
  • mfrom: (2384 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2385.
  • Revision ID: olafvdspek@gmail.com-20110804081304-rlejjpvoos17bjdf
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/haildb/tests/t/trx_isolation_read_uncommitted.test
1
 
connect (a,localhost,root,,);
2
 
connect (b,localhost,root,,);
3
 
 
4
 
connection a;
5
 
CREATE TABLE t1 (a int);
6
 
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
7
 
BEGIN;
8
 
INSERT INTO t1 values (1);
9
 
 
10
 
connection b;
11
 
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
12
 
BEGIN;
13
 
SELECT * from t1 order by a;
14
 
 
15
 
connection a;
16
 
INSERT INTO t1 values (2);
17
 
 
18
 
connection b;
19
 
SELECT * from t1 order by a;
20
 
COMMIT;
21
 
BEGIN;
22
 
SELECT * FROM t1 order by a;
23
 
 
24
 
connection a;
25
 
COMMIT;
26
 
 
27
 
connection b;
28
 
SELECT * from t1 order by a;
29
 
COMMIT;
30
 
BEGIN;
31
 
SELECT * from t1 order by a;
32
 
 
33
 
COMMIT;
34
 
DROP TABLE t1;
35
 
 
36
 
disconnect a;
37
 
disconnect b;
38
 
connection default;