Overview
| Artifact ID: | bac716244fddac1fe8417c1dd1c9fa6e2b91ab028d3981e8c69fbe70e3de95aa |
|---|---|
| Ticket: | f8f472cbc77ba9c9251feb1d2b6674e1e0587e0e
Partial index and BETWEEN issue |
| User & Date: | mrigger 2019-08-30 15:43:35 |
Changes
- foundin changed to: "3.29.0"
- icomment:
In the example below, an INDEX causes a query to malfunction: <pre> CREATE TABLE t0 (c0); CREATE INDEX i0 ON t0(1) WHERE c0 NOT NULL; INSERT INTO t0(c0) VALUES (NULL); SELECT * FROM t0 WHERE '' BETWEEN t0.c0 AND 1 IN (FALSE); -- unexpected: row is not fetched </pre> The expression should evaluate to TRUE: <pre> SELECT '' BETWEEN t0.c0 AND 1 IN (FALSE) FROM t0; -- TRUE </pre>
- login: "mrigger"
- mimetype: "text/x-fossil-wiki"
- severity changed to: "Critical"
- status changed to: "Open"
- title changed to: "Partial index and BETWEEN issue"
- type changed to: "Code_Defect"