re: index with enum as first column

2002-09-25 Thread Egor Egorov
Julian, Wednesday, September 25, 2002, 2:20:05 PM, you wrote: JL> drop table if exists t1; JL> create table t1 ( JL> e enum('N', 'Y') not null, JL> i int not null, JL> c1 char(255), c2 char(255), c3 char(255), c4 char(255), JL> c5 char(255), c6 char(255), c7 char(255), c8 char(255), JL>

index with enum as first column

2002-09-25 Thread Julian Ladisch
>How-To-Repeat: drop table if exists t1; create table t1 ( e enum('N', 'Y') not null, i int not null, c1 char(255), c2 char(255), c3 char(255), c4 char(255), c5 char(255), c6 char(255), c7 char(255), c8 char(255), primary key (e, i) ); insert into t1 (e, i) values ('N', 1), ('Y', 2),