SQLite Forum

Query assertion not satisfied with DEBUG build
Login

Query assertion not satisfied with DEBUG build

(1) By Yu Liang (LY1598773890) on 2021-05-20 19:09:39 [source]

Hi all

For query:

CREATE TABLE v0 ( v4 );
CREATE VIEW v8 AS SELECT v4 FROM v0 UNION ALL SELECT v4 FROM v0;
CREATE TABLE v25 ( v30, v32 );
UPDATE v25 SET ( v32, v30 ) = ( SELECT 10, 10 ) FROM v0, v8;

Assertion failed when tested with --enable-debug flag and the latest development build: Fossil: 67bde01614edd944b769ab28488bac1dbbf17d88beee62ca7f1e45681aa3d402. The execution outputs the following error message:

sqlite3: sqlite3.c:102701: sqlite3ExprListDup: Assertion `pOldExpr->pLeft==pOldExpr->pRight' failed.
Aborted (core dumped)

Looking forward to your reply.

(2) By Richard Hipp (drh) on 2021-05-20 23:29:00 in reply to 1 [link] [source]

Thanks for the report.

This is a faulty assert(), so it is harmless in production builds where assert() statements are omitted. The fix is at check-in 240f7494bfa3. There was a similar bug fixed at check-in 59812e7ef705226c.