~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to plugin/embedded_innodb/tests/r/basic_savepoint.result

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

Show diffs side-by-side

added

removed

plugin/embedded_innodb/tests/r/basic_savepoint.result

 

1

create table t1 (a int primary key);

 

2

begin;

 

3

insert into t1 values (1);

 

4

savepoint A;

 

5

insert into t1 values (2);

 

6

select count(*) from t1;

 

7

count(*)

 

8

2

 

9

rollback to savepoint A;

 

10

select count(*) from t1;

 

11

count(*)

 

12

1

 

13

commit;

 

14

select count(*) from t1;

 

15

count(*)

 

16

1

 

17

begin;

 

18

insert into t1 values (2);

 

19

insert into t1 values (3);

 

20

savepoint A;

 

21

insert into t1 values (4);

 

22

insert into t1 values (5);

 

23

savepoint B;

 

24

insert into t1 values (6);

 

25

savepoint C;

 

26

insert into t1 values (7);

 

27

rollback to savepoint A;

 

28

select count(*) from t1;

 

29

count(*)

 

30

3

 

31

commit;

 

32

drop table t1;

• Older »

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