SQLite assertion failure
(1) By Yu Liang (LY1598773890) on 2022-03-02 19:59:11 [source]
Query:
CREATE TABLE v0 ( c1 INT );
CREATE INDEX i2 ON v0 ( ( c1 BETWEEN 0 AND 10 ), c1 );
CREATE VIEW v3 AS SELECT * FROM v0 AS a4 NATURAL JOIN v0 AS a5 WHERE ( c1 BETWEEN 0 AND 10 ) OR ( TRUE );
INSERT INTO v0 VALUES ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ), ( 0 ); -- Insert multiple 0s, here we insert 20 of 0s.
CREATE VIEW v24 AS SELECT * FROM v3 AS a25 NATURAL JOIN v3 AS a26;
CREATE VIEW v29 AS SELECT c1, c1 FROM v24, v3 USING ( c1 ) GROUP BY c1;
ANALYZE;
SELECT c1 FROM v29;
Run on Debug Version
sqlite3: sqlite3.c:93352: int sqlite3VdbeExec(Vdbe *): Assertion `pOp->p2>0 && pOp->p2<p->nOp' failed.
[1] 311527 abort (core dumped) ./sqlite3
Run on Non-Debug Version:
Returns 0
after a long wait time due to the multiple joins.
Bisect:
1 BAD 2022-03-02 17:50:59 86c5fa2f301e4bdb
5 BAD 2022-01-12 20:31:14 9282bcde301cee2a
7 BAD 2021-12-29 13:32:36 d4870c08893ea998
8 BAD 2021-12-16 14:59:25 d156123885abe6bf
9 BAD 2021-12-13 19:59:55 cdcde00b2d68eeb3
10 BAD 2021-12-10 21:01:24 8e98ba1eeb1a5a61
11 BAD 2021-12-09 20:06:18 633bfeeea2bccdd4
12 GOOD 2021-12-09 16:26:45 1eefd957ff35e961 CURRENT
6 GOOD 2021-12-09 14:09:47 94fdbeffaf501daf
4 GOOD 2021-11-06 10:59:27 a024764cef955099
3 GOOD 2021-07-09 00:12:05 eb8af9a494fb68c0
2 GOOD 2020-12-01 16:14:00 a26b6597e3ae2722
20:06:18 [633bfeeea2] *MERGE* Add support for Bloom-filters as a performance optimization for joins. (user: drh tags: trunk)
Looking forward to replies. :-)
(2) By Yu Liang (LY1598773890) on 2022-03-05 19:16:34 in reply to 1 [link] [source]
Hi all. :-)
Just checking whether there are any updates on the reported Assertion Failure?
Really appreciate with the efforts that the maintainers put in to confirm and fix the potential problems we reported. Thank you all.
(3) By Richard Hipp (drh) on 2022-03-05 21:06:11 in reply to 2 [link] [source]
Fixed by check-in ad3ffa1a75a5a032. I just neglected to update this forum thread.
The change is on trunk and on branch-3.38 and is included in the latest snapshot tarball on the download page.