/ View Ticket
Login
Ticket Hash: 5eadca17c4dde90cd72c384fb269ace796163008
Title: Debug assertion rtreeRelease: Assertion `pRtree->nNodeRef==0 || pRtree->bCorrupt' failed
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Extensions Resolution: Fixed
Last Modified: 2019-12-23 20:42:05
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-23 20:03:07: (text/x-fossil-wiki)
Consider the following test case:

<pre>
CREATE VIRTUAL TABLE rt0 USING rtree(c0, c1, c2);
CREATE TABLE t0(c0);
INSERT INTO t0 VALUES (0), (1);
INSERT INTO rt0(c0) VALUES (0), (1);
CREATE VIEW v0 AS SELECT 0 LIMIT 0;
SELECT * FROM t0 LEFT JOIN rt0 INNER JOIN v0; -- sqlite3.c:185720: rtreeRelease: Assertion `pRtree->nNodeRef==0 || pRtree->bCorrupt' failed.
</pre>

When compiling with -DSQLITE_DEBUG, the SELECT triggers an assertion error.