← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: mordred
  • Date: 2010-04-20 00:00:46 UTC
  • mfrom: (1471.5.3 more-valgrind)
  • mto: This revision was merged to the branch mainline in revision 1498.
  • Revision ID: mordred@orisndriz09-20100420000046-263x5hazl0huw8u3
Merged in more-valgrind.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/embedded_innodb/tests/t/basic_savepoint.test
1
 
create table t1 (a int);
 
1
create table t1 (a int primary key);
2
2
begin;
3
3
insert into t1 values (1);
4
4
savepoint A;
10
10
select count(*) from t1;
11
11
begin;
12
12
insert into t1 values (2);
13
 
insert into t1 values (2);
 
13
insert into t1 values (3);
14
14
savepoint A;
15
 
insert into t1 values (2);
16
 
insert into t1 values (2);
 
15
insert into t1 values (4);
 
16
insert into t1 values (5);
17
17
savepoint B;
18
 
insert into t1 values (2);
 
18
insert into t1 values (6);
19
19
savepoint C;
20
 
insert into t1 values (2);
 
20
insert into t1 values (7);
21
21
rollback to savepoint A;
22
22
select count(*) from t1;
23
23
commit;