mirror of
https://github.com/MariaDB/server.git
synced 2025-04-22 07:05:33 +02:00
43 lines
931 B
Text
43 lines
931 B
Text
create table t1 (a int auto_increment, b bigint(20), primary key (b,a)) engine=tokudb;
|
|
start transaction;
|
|
insert t1 (b) values (1);
|
|
connect con2,localhost,root;
|
|
set tokudb_lock_timeout=1;
|
|
insert t1 (b) values (1);
|
|
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
|
|
set tokudb_lock_timeout=default;
|
|
insert t1 (b) values (1);
|
|
connection default;
|
|
insert t1 (b) values (1);
|
|
commit;
|
|
connection con2;
|
|
commit;
|
|
select * from t1;
|
|
a b
|
|
1 1
|
|
2 1
|
|
3 1
|
|
connection default;
|
|
alter table t1 partition by range (b) (partition p0 values less than (9));
|
|
start transaction;
|
|
insert t1 (b) values (2);
|
|
connection con2;
|
|
set tokudb_lock_timeout=1;
|
|
insert t1 (b) values (2);
|
|
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
|
|
set tokudb_lock_timeout=default;
|
|
insert t1 (b) values (2);
|
|
connection default;
|
|
insert t1 (b) values (2);
|
|
commit;
|
|
connection con2;
|
|
commit;
|
|
select * from t1;
|
|
a b
|
|
1 1
|
|
2 1
|
|
3 1
|
|
1 2
|
|
2 2
|
|
3 2
|
|
drop table t1;
|