summaryrefslogtreecommitdiff
path: root/mysql-test/r/keyread.result
blob: d8e9659d4bb20dacd1f4bd227741134153ea6801 (plain)
1
2
3
4
5
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;