diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2017-04-18 17:44:30 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-04-30 14:58:11 +0200 |
| commit | d17093b2edfbd1422f224c553eb73c9263eeeb1a (patch) | |
| tree | 8ee98abc364e490152f01d0185cf4eb3e1047a34 /mysql-test/r/keyread.result | |
| parent | 54e24fcbd537827e32ec029ab6b8af640fd08819 (diff) | |
| download | mariadb-git-d17093b2edfbd1422f224c553eb73c9263eeeb1a.tar.gz | |
MDEV-12293 Assertion `table->no_keyread || !table->covering_keys.is_set(tab->index) || table->file->keyread == tab->index' failed
sometimes the optimizer starts a keyread on some index
and later (but before any actual index accesses) changes
it to a keyread on a different index
Diffstat (limited to 'mysql-test/r/keyread.result')
| -rw-r--r-- | mysql-test/r/keyread.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/keyread.result b/mysql-test/r/keyread.result new file mode 100644 index 00000000000..d8e9659d4bb --- /dev/null +++ b/mysql-test/r/keyread.result @@ -0,0 +1,6 @@ +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; +f1 +drop view v1; +drop table t1; |