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
- foundin changed to: "trunk"
- icomment:
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]
- login: "dan"
- mimetype: "text/x-fossil-wiki"
- severity changed to: "Critical"
- status changed to: "Open"
- title changed to:
Expressions like (a IS NULL AND b = ?) optimized by a UNIQUE index matching a single row only
- type changed to: "Code_Defect"