| Ticket Hash: | 9080b6227fabb4666c60f01b7676c12ccb06ffa6 | |||
| Title: | Constant expression in partial index results in row not being fetched | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Important | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-08-10 15:06:29 | |||
| Version Found In: | 3.29.0 | |||
| User Comments: | ||||
|
mrigger added on 2019-08-09 23:00:43:
Consider the test case below: CREATE TABLE t0(c0); INSERT INTO t0(c0) VALUES (0); CREATE INDEX i0 ON t0(NULL > c0) WHERE (NULL NOT NULL); SELECT * FROM t0 WHERE ((NULL IS FALSE) IS FALSE); -- expected: row is fetched: actual: row is not fetched I would expect the row in the table being fetched. However, it is only fetched if the index is not created. | ||||