mirror of
https://github.com/MariaDB/server.git
synced 2025-04-20 22:25:30 +02:00
38 lines
779 B
Text
38 lines
779 B
Text
# verify that duplicate savepoint names in innodb and tokudb work the same
|
|
source include/have_innodb.inc;
|
|
source include/have_tokudb.inc;
|
|
disable_warnings;
|
|
drop table if exists ti;
|
|
enable_warnings;
|
|
create table ti (id int primary key) engine=innodb;
|
|
begin;
|
|
insert into ti values (0);
|
|
savepoint b;
|
|
insert into ti values (1);
|
|
savepoint a2;
|
|
insert into ti values (2);
|
|
savepoint b;
|
|
insert into ti values (3);
|
|
rollback to a2;
|
|
commit;
|
|
select * from ti;
|
|
|
|
disable_warnings;
|
|
drop table if exists tt;
|
|
enable_warnings;
|
|
create table tt (id int primary key) engine=tokudb;
|
|
begin;
|
|
insert into tt values (0);
|
|
savepoint b;
|
|
insert into tt values (1);
|
|
savepoint a2;
|
|
insert into tt values (2);
|
|
savepoint b;
|
|
insert into tt values (3);
|
|
rollback to a2;
|
|
commit;
|
|
select * from tt;
|
|
|
|
drop table ti,tt;
|
|
|
|
|