(text/x-fossil-wiki)
The following query returns two rows instead of just one:
<blockquote><verbatim>
create table t(c0,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17);
create index tc0 on t(c0);
create index tc1 on t(c1);
create index tc2 on t(c2);
create index tc3 on t(c3);
create index tc4 on t(c4);
create index tc5 on t(c5);
create index tc6 on t(c6);
create index tc7 on t(c7);
create index tc8 on t(c8);
create index tc9 on t(c9);
create index tc10 on t(c10);
create index tc11 on t(c11);
create index tc12 on t(c12);
create index tc13 on t(c13);
create index tc14 on t(c14);
create index tc15 on t(c15);
create index tc16 on t(c16);
create index tc17 on t(c17);
insert into t(c0, c16) VALUES (1,1);
select * from t where
c0=1 or c1=1 or c2=1 or c3=1 or
c4=1 or c5=1 or c6=1 or c7=1 or
c8=1 or c9=1 or c10=1 or c11=1 or
c12=1 or c13=1 or c14=1 or c15=1 or
c16=1 or c17=1;
</verbatim></blockquote>
This problem has been latent in the code for about 5 years, since checkin
[b101cf70b75c9772aaf] of version 3.6.14. The bug was found by Peter Reid
and reported on the sqlite-dev mailing list.
|