/ Ticket Change Details
Login
Overview

Artifact ID: a72fb3c97ebc5f3b884c2663997c6ddb08f529fb
Ticket: 7b4fee9f6c20b6341b27432dc91c52b0d2ecf53c
Expressions like (a IS NULL AND b = ?) optimized by a UNIQUE index matching a single row only
User & Date: dan 2015-04-11 11:06:13
Changes

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

    The following script:

      create table t(x, y, unique(x, y));
      insert into t values(null, 1);
      insert into t values(null, 1);
      select * from t where x is null and y = 1;
    

    is returning one row instead of two.

    Introduced here: [90e36676476e8db0]

    First appeared in version 3.8.5

    Isolated on the mailing list here: http://osdir.com/ml/general/2015-04/msg13265.html

  3. Change login to "dan"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Critical"
  6. Change status to "Open"
  7. Change title to:

    Expressions like (a IS NULL AND b = ?) optimized by a UNIQUE index matching a single row only

  8. Change type to "Code_Defect"