~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/embedded_innodb/tests/t/basic_savepoint.test

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

Show diffs side-by-side

added

removed

plugin/embedded_innodb/tests/t/basic_savepoint.test

 

1

create table t1 (a int);

 

2

begin;

 

3

insert into t1 values (1);

 

4

savepoint A;

 

5

insert into t1 values (2);

 

6

select count(*) from t1;

 

7

rollback to savepoint A;

 

8

select count(*) from t1;

 

9

commit;

 

10

select count(*) from t1;

 

11

begin;

 

12

insert into t1 values (2);

 

13

insert into t1 values (2);

 

14

savepoint A;

 

15

insert into t1 values (2);

 

16

insert into t1 values (2);

 

17

savepoint B;

 

18

insert into t1 values (2);

 

19

savepoint C;

 

20

insert into t1 values (2);

 

21

rollback to savepoint A;

 

22

select count(*) from t1;

 

23

commit;

 

24

drop table t1;

 

25

 

• Older »

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