1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/main/keyread.test b/mysql-test/main/keyread.test
new file mode 100644
index 00000000..6500f840
--- /dev/null
+++ b/mysql-test/main/keyread.test
@@ -0,0 +1,30 @@
+--source include/have_innodb.inc
+
+#
+# MDEV-12293 Assertion `table->no_keyread || !table->covering_keys.is_set(tab->index) || table->file->keyread == tab->index' failed
+#
+create table t1 (f1 int not null, f2 int, f3 int, primary key (f1,f2), key(f2,f3)) engine=innodb;
+create view v1 as select * from t1 where f2 = 1;
+select distinct f1 from v1;
+drop view v1;
+drop table t1;
+
+#
+# MDEV-22062 Assertion `!table->file->keyread_enabled()' failed in
+# close_thread_table
+#
+
+CREATE TABLE t1 (a INT NOT NULL, UNIQUE(a)) ENGINE=InnoDB;
+INSERT INTO t1 VALUES (1),(2);
+DELETE FROM t1 ORDER BY a LIMIT 1;
+SELECT * FROM t1;
+DROP TABLE t1;
+
+#
+# MDEV-22237 Assertion `!table->file->keyread_enabled()' failed in
+# handler::ha_reset on DELETE
+#
+
+CREATE TABLE t1 (a CHAR KEY,b BLOB) ENGINE=InnoDB;
+DELETE FROM t1 ORDER BY a LIMIT 1;
+DROP TABLE t1;