diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2019-02-27 23:32:02 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2019-02-27 23:27:43 -0500 |
| commit | b10340998f33a04452a499ae8d13f8af7e1e69b0 (patch) | |
| tree | e6c9abb41c9dfd6802c82bc03de2f7495d0c3032 /mysql-test/main | |
| parent | 9fd3e810e8af49105b65578292d271cca23f2c34 (diff) | |
| download | mariadb-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')
| -rw-r--r-- | mysql-test/main/long_unique_bugs.result | 4 | ||||
| -rw-r--r-- | mysql-test/main/long_unique_bugs.test | 8 |
2 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique_bugs.result b/mysql-test/main/long_unique_bugs.result index 05ddceb63f8..5de7566c8a3 100644 --- a/mysql-test/main/long_unique_bugs.result +++ b/mysql-test/main/long_unique_bugs.result @@ -53,3 +53,7 @@ create temporary table t1 (f blob, unique(f)) engine=innodb; insert into t1 values (1); replace into t1 values (1); drop table t1; +create table t (b blob, unique(b)) engine=myisam; +insert into t values ('foo'); +replace into t values ('foo'); +drop table t; 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; |