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.