SQLite User Forum

Query triggers Assertion Failure
Login

Query triggers Assertion Failure

(1) By Yu Liang (LY1598773890) on 2023-04-26 16:13:46 [source]

The latest trunk version of SQLite (5d4431bc44) and released version 3.41.1 triggers Assertion Failure when executing the following query:

CREATE TABLE v0 ( c1 INT, c2 INT, c3 FLOAT ); 
REPLACE INTO v0 AS a14 VALUES ( 99999999999999999999.999999, 0, 0 ); 
CREATE UNIQUE INDEX i28 ON v0 ( decimal_mul ( c3, c3 ) * c1 ); 
UPDATE v0 AS a30 SET c3  = shell_putsnl ( c1 & c1 ); 

The error message is (from 5d4431bc44):

sqlite3: sqlite3.c:82085: sqlite3ValueText: Assertion `sqlite3VdbeMemValidStrRep(pVal)' failed.
Aborted

The build option is:

./configure --enable-debug --enable-all
make

It seems to be just a faulty assertion. By disabling --enable-debug in configure, the code is executed correctly.

(2) By Yu Liang (LY1598773890) on 2023-04-27 01:53:44 in reply to 1 [link] [source]

The bug is fixed in commit 3e2da8a7e35c8391. Thank you for the quick patch!