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] |