SQLite
View Ticket
Not logged in
Ticket UUID: 10fb063b1179be53ea0b53bbb4459b5597541a4b
Title: Duplicate row output on an OR query
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2014-04-10 02:24:43
Version Found In: 3.8.4.3
User Comments:
drh added on 2014-04-10 02:09:30:

The following query returns two rows instead of just one:

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;

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.