View Ticket
Ticket Hash: d87336c81c7d0873f1cc53225271062372de1856
Title: Debug assertion sqlite3TableColumnAffinity: Assertion `iCol<pTab->nCol' failed.
Status: Fixed Type: Code_Defect
Severity: Important Priority: High
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-25 23:54:39
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-25 00:39:04: (text/x-fossil-wiki)
Consider the following test case:

CREATE VIRTUAL TABLE t0 USING rtree(c0, c1, c2);
SELECT * FROM t0 WHERE ((0, 0) IN (SELECT COUNT(*), LAG(5) OVER(PARTITION BY 0) FROM t0), 0) <= (t0.c1, 0); -- sqlite3.c:98053: sqlite3TableColumnAffinity: Assertion `iCol<pTab->nCol' failed.

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