SQLite

View Ticket
Login
Ticket Hash: 7b4fee9f6c20b6341b27432dc91c52b0d2ecf53c
Title: Expressions like (a IS NULL AND b = ?) optimized by a UNIQUE index matching a single row only
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2015-04-11 11:45:45
Version Found In: trunk
User Comments:
dan added on 2015-04-11 11:06:13: (text/x-fossil-wiki)
The following script:

<verbatim>
  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;
</verbatim>

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]

dan added on 2015-04-11 11:45:45: (text/x-fossil-wiki)
Fixed here: [e3b1f625]