/ Ticket Change Details

Artifact ID: 530cc4a7a2f9f11aaa1b0433bf77ab416a50fd0d
Ticket: 10fb063b1179be53ea0b53bbb4459b5597541a4b
Duplicate row output on an OR query
User & Date: drh 2014-04-10 02:09:30

  1. Change foundin to ""
  2. Change icomment to:

    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.

  3. Change login to "drh"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Important"
  6. Change status to "Open"
  7. Change title to "Duplicate row output on an OR query"
  8. Change type to "Code_Defect"