~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb-semi-consistent.result

• browse files at revision 779.2.5
• compare with another revision
• download diff
• download tarball
• view history from revision 779.2.5

• reverse the comparison (779.2.5 to 937.4.13)
• stop comparing with revision 937.4.13

Show diffs side-by-side

added

removed

tests/r/innodb-semi-consistent.result

9

9

set session transaction isolation level read committed;

10

10

set autocommit=0;

11

11

update t1 set a=10 where a=5;

 

12

ERROR HY000: Lock wait timeout exceeded; try restarting transaction

12

13

commit;

13

14

update t1 set a=10 where a=5;

14

15

select * from t1 where a=2 for update;

20

21

update t1 set a=12 where a=2;

21

22

ERROR HY000: Lock wait timeout exceeded; try restarting transaction

22

23

update t1 set a=13 where a=1;

 

24

ERROR HY000: Lock wait timeout exceeded; try restarting transaction

23

25

commit;

24

26

update t1 set a=14 where a=1;

25

27

commit;

26

28

select * from t1;

27

29

a

28

 

13

 

30

14

29

31

2

30

32

3

31

33

4

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1