Ticket Hash: | b86894020e985dc5a9392a1f073f90150120a707 | |||
Title: | DISTINCT malfunctions for IS NULL | |||
Status: | Closed | Type: | Code_Defect | |
Severity: | Critical | Priority: | Immediate | |
Subsystem: | Unknown | Resolution: | Fixed | |
Last Modified: | 2019-08-21 14:55:33 | |||
Version Found In: | 3.29.0 | |||
User Comments: | ||||
mrigger added on 2019-08-21 11:50:19:
In the following test case, a row is unexpectedly not fetched. CREATE TABLE t0 (c0, c1 NOT NULL DEFAULT 1, c2, PRIMARY KEY (c0, c1)); INSERT INTO t0(c2) VALUES (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL); INSERT INTO t0(c2) VALUES ('a'); ANALYZE t0; SELECT DISTINCT * FROM t0 WHERE NULL IS t0.c0; -- unexpected: |1|a is not part of the result set Note that changing NULL IS t0.c0 to t0.c0 IS NULL results in the query working correctly. dan added on 2019-08-21 14:55:33: Fixed by [d02490a2]. |