SQLite

View Ticket
Login
Ticket Hash: 0911b5d161b039c60b27e382fe4ce7c0aa05eff5
Title: Debug assertion sqlite3MemCompare: Assertion `pMem1->enc==pMem2->enc || pMem1->db->mallocFailed' failed
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-23 03:38:01
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-22 23:43:26: (text/x-fossil-wiki)
Consider the following test case:

<pre>
PRAGMA encoding = 'UTF16';
CREATE VIRTUAL TABLE t0 USING fts5(c0);
INSERT INTO t0(c0) VALUES (x'00');
SELECT * FROM t0 WHERE CAST(SUBSTR(c0, 0) AS TEXT) > 0; -- sqlite3.c:81076: sqlite3MemCompare: Assertion `pMem1->enc==pMem2->enc || pMem1->db->mallocFailed' failed.
</pre>

When compiling with -DSQLITE_DEBUG, the SELECT triggers an assertion error.