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!