blob: d9d3002d392fc82ea0c3be2ba1b697b4fc3d7e6b (
plain)
1
2
3
4
5
6
7
8
9
10
|
--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;
|
