summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/long_unique_delayed.test
blob: c0de4a749136e40b0f53da8358a6bd0949c31a34 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
--source include/not_embedded.inc

--echo #
--echo # Test insert delayed with long unique keys
--echo #

create table t1(a blob unique) engine=myisam;
insert delayed into t1 values(1),(2),(3),(56),('sachin'),('maria'),(123456789034567891),(null),(null),(123456789034567890),('maria');
insert delayed into t1 values(1),(9);
flush tables t1;
select count(*) from t1;
drop table t1;

--echo #
--echo # MDEV-19848
--echo # Server crashes in check_vcol_forward_refs upon INSERT DELAYED into
--echo # table with long blob key
--echo #

CREATE  TABLE t1 (a BLOB, UNIQUE(a)) ENGINE=MyISAM;
INSERT DELAYED t1 () VALUES ();
DROP TABLE t1;