An assertion failure in function sqlite3TableColumnAffinity()
(1.1) By Wang Ke (krking) on 2021-11-07 03:38:24 edited from 1.0 [link] [source]
We found an assertion failure in SQLite version 3.37.0 2021-11-06 20:25:29 with --enable-debug.
The test case is as follows:
CREATE TABLE t0(a); SELECT a FROM t0 LEFT JOIN (SELECT a AS b FROM t0) AS t1 WHERE (a,1)=(SELECT 2,2 UNION SELECT total(b),max(b) OVER(ORDER BY b) ORDER BY 2 DESC) AND b=4 ORDER BY b DESC;
sqlite3.c: char sqlite3TableColumnAffinity(const Table *, int): Assertion `iCol<pTab->nCol' failed.
assert( iCol<pTab->nCol );
Bisecting shows the issue may be related to check-in 0d11d777c8.
For other readers, this is not necessarily a problem in release builds.
The version with no debug enabled gives:
Error: in prepare, 2 columns assigned 1 values (1)
Hope the problem will be handled properly :)
(2) By Wang Ke (krking) on 2021-11-08 01:09:38 in reply to 1.1 [source]
It seems that the problem has been fixed on trunk.
Thanks for the fix!