SQLite

View Ticket
Login
Ticket Hash: de4b04149b9fdeae6a0225b3e58608a54821575f
Title: Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-28 01:53:00
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-27 22:11:55: (text/x-fossil-wiki)
The following test case causes a debug assertion to fail:

<pre>
PRAGMA foreign_keys = true;
CREATE TABLE t0(c0 INT AS(2) UNIQUE, c1 TEXT UNIQUE,
               FOREIGN KEY(c0) REFERENCES t0(c1));
INSERT INTO t0(c1) VALUES(0.16334143182538696), (0); -- sqlite3.c:75926: sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed.
</pre>