SQLite

View Ticket
Login
2019-12-28
01:53 Fixed ticket [de4b0414]: Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed plus 5 other changes (artifact: 60b955f0 user: drh)
01:52
When an INSERT is receiving content from a SELECT, run an OP_ReleaseReg opcode at the top of each iteration of the loop in order to prevent spurious OP_SCopy misuse complaints. Ticket [de4b04149b9fdeae] (check-in: 6afadd3b user: drh tags: trunk)
2019-12-27
22:11 New ticket [de4b0414] Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed. (artifact: 26b61d4b user: mrigger)

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:

The following test case causes a debug assertion to fail:

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.