| 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 10.24 years ago |
Created: |
2015-04-11 11:06:13 10.24 years ago |
| Version Found In: | trunk | ||
| User Comments: | ||||
|
dan added on 2015-04-11 11:06:13:
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 dan added on 2015-04-11 11:45:45: Fixed here: [e3b1f625] | ||||