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
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
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
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!