summaryrefslogtreecommitdiff
path: root/mysql-test/main/long_unique_delayed.result
blob: 52365249097ccafd30b94a6e6be6a2674860bc36 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
#
# Test insert delayed with long unique keys
#
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;
count(*)
11
drop table t1;
#
# MDEV-19848
# Server crashes in check_vcol_forward_refs upon INSERT DELAYED into
# table with long blob key
#
CREATE  TABLE t1 (a BLOB, UNIQUE(a)) ENGINE=MyISAM;
INSERT DELAYED t1 () VALUES ();
DROP TABLE t1;