summaryrefslogtreecommitdiff
path: root/mysql-test/main/long_unique_bugs.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2019-02-27 23:32:02 +0100
committerSergei Golubchik <serg@mariadb.org>2019-02-27 23:27:43 -0500
commitb10340998f33a04452a499ae8d13f8af7e1e69b0 (patch)
treee6c9abb41c9dfd6802c82bc03de2f7495d0c3032 /mysql-test/main/long_unique_bugs.test
parent9fd3e810e8af49105b65578292d271cca23f2c34 (diff)
downloadmariadb-git-b10340998f33a04452a499ae8d13f8af7e1e69b0.tar.gz
MDEV-18748 REPLACE doesn't work with unique blobs on MyISAM table
on long unique conflict, set table->file->dup_ref for engines that support it
Diffstat (limited to 'mysql-test/main/long_unique_bugs.test')
-rw-r--r--mysql-test/main/long_unique_bugs.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique_bugs.test b/mysql-test/main/long_unique_bugs.test
index f00b3171a54..0246ea7962a 100644
--- a/mysql-test/main/long_unique_bugs.test
+++ b/mysql-test/main/long_unique_bugs.test
@@ -64,3 +64,11 @@ create temporary table t1 (f blob, unique(f)) engine=innodb;
insert into t1 values (1);
replace into t1 values (1);
drop table t1;
+
+#
+# MDEV-18748 REPLACE doesn't work with unique blobs on MyISAM table
+#
+create table t (b blob, unique(b)) engine=myisam;
+insert into t values ('foo');
+replace into t values ('foo');
+drop table t;