SQLite Forum

Query assertion not satisfied
Login

Query assertion failed

(1.1) By Yu Liang (LY1598773890) on 2021-05-22 03:42:42 edited from 1.0 [source]

Hi all

For query:

CREATE TABLE v0 ( v1 CHAR(30), v2 CHAR(30) );
CREATE INDEX v19 ON v0 ( v2, v1 );
SELECT * FROM v0 WHERE ( v2 = ( SELECT v2 FROM v0 ORDER BY lead ( v2 ) OVER ( ) = '0' AND SUM ( v1 * ( 9223372036854775807 - v2 ) ) > v2 AND EXISTS ( SELECT * FROM v0 x WHERE v1 = v2 AND v1 != v1 ) AND NOT EXISTS ( SELECT * FROM v0 x WHERE v2 = v2 AND v2 != v2 AND v1 > v2 ) AND v2 = v1 AND v1 = 'av1 c' ) );

When testing the above query with DEBUG flag on the latest development branch, Fossil: d42dbd9dfeb9233dcf9bb7af617289bc51a12379, assertion failed and program exit. The error information is shown below:

sqlite3: sqlite3.c:101215: sqlite3TableColumnAffinity: Assertion `iCol<pTab->nCol' failed.
Aborted (core dumped)

Looking forward to your reply.

(2) By Yu Liang (LY1598773890) on 2021-05-23 01:00:13 in reply to 1.1 [link] [source]

It seems an update has been applied to fix this issue, as shown in: https://sqlite.org/src/info/b986600520696b0c

Thank you for the patch and the information provided in the update.