summaryrefslogtreecommitdiff
path: root/mysql-test/main/long_unique_bugs.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2019-02-26 22:55:39 -0500
committerSergei Golubchik <serg@mariadb.org>2019-02-27 23:27:43 -0500
commit3f5351542529529386e3d303c5e2b2635b0fb18b (patch)
tree421bf800db8fa62d792c1d1a9dbe829cdcab20bc /mysql-test/main/long_unique_bugs.test
parent20c89f9f376dfd05a1eef5b2abc136d2f32c277d (diff)
downloadmariadb-git-3f5351542529529386e3d303c5e2b2635b0fb18b.tar.gz
MDEV-18713 Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed in test_if_reopen upon REPLACE into table with key on blob
close table->update_handler in close_thread_tables(). it's not enough to do it in sql_update.cc only, because sql_insert.cc can also do updates (REPLACE) and even sql_delete.cc can (DELETE ... FOR PORTION OF)
Diffstat (limited to 'mysql-test/main/long_unique_bugs.test')
-rw-r--r--mysql-test/main/long_unique_bugs.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique_bugs.test b/mysql-test/main/long_unique_bugs.test
index d979a052547..f8e49471a74 100644
--- a/mysql-test/main/long_unique_bugs.test
+++ b/mysql-test/main/long_unique_bugs.test
@@ -26,3 +26,13 @@ alter table t1 add unique (b);
alter table t1 force;
show create table t1;
drop table t1;
+
+#
+# MDEV-18713 Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed in test_if_reopen upon REPLACE into table with key on blob
+#
+create table t1 (pk int, b blob, primary key(pk), unique(b)) engine=myisam;
+insert into t1 values (1,'foo');
+replace into t1 (pk) values (1);
+alter table t1 force;
+replace into t1 (pk) values (1);
+drop table t1;