← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/trx_isolation_read_committed.result

  • Committer: Joseph Daly
  • Date: 2010-10-30 01:01:48 UTC
  • mfrom: (1891 staging)
  • mto: This revision was merged to the branch mainline in revision 1900.
  • Revision ID: skinny.moey@gmail.com-20101030010148-k39lnrftv4bkbux9
merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/trx_isolation_read_committed.result
 
1
A
 
2
CREATE TABLE t1 (a int);
 
3
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
 
4
BEGIN;
 
5
INSERT INTO t1 values (1);
 
6
B
 
7
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
 
8
BEGIN;
 
9
SELECT * from t1;
 
10
a
 
11
A
 
12
INSERT INTO t1 values (2);
 
13
B
 
14
SELECT * from t1;
 
15
a
 
16
COMMIT;
 
17
BEGIN;
 
18
SELECT * FROM t1;
 
19
a
 
20
A
 
21
COMMIT;
 
22
B
 
23
SELECT * from t1 order by a;
 
24
a
 
25
1
 
26
2
 
27
COMMIT;
 
28
BEGIN;
 
29
SELECT * from t1 order by a;
 
30
a
 
31
1
 
32
2
 
33
DROP TABLE t1;