diff options
| author | Monty <monty@mariadb.org> | 2020-03-30 21:59:07 +0300 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2020-04-19 17:33:51 +0300 |
| commit | e3130d22e1fbd9060fe3009a2d3b3152932efe97 (patch) | |
| tree | da7e895dfd4eb965c7aef8875614399be303be38 /mysql-test/main/keyread.test | |
| parent | 8399af81be0a87d1c0ea09164c05a9ac8eb715e2 (diff) | |
| download | mariadb-git-e3130d22e1fbd9060fe3009a2d3b3152932efe97.tar.gz | |
Fixed some assert crashes related to keyread.
- MDEV-22062 Assertion `!table->file->keyread_enabled()' failed in
close_thread_table()
- MDEV-22077 table->no_keyread .. failed in join_read_first()
- MDEV-22237 Assertion `!table->file->keyread_enabled()' failed in
handler::ha_reset on DELETE
Diffstat (limited to 'mysql-test/main/keyread.test')
| -rw-r--r-- | mysql-test/main/keyread.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/keyread.test b/mysql-test/main/keyread.test index d9d3002d392..6500f840b66 100644 --- a/mysql-test/main/keyread.test +++ b/mysql-test/main/keyread.test @@ -8,3 +8,23 @@ 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; |