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.