(text/x-fossil-wiki)
Consider the following test case:
<pre>
PRAGMA encoding = 'UTF16';
CREATE TABLE t0(c0 REAL, c1);
INSERT INTO t0(c0) VALUES (''), (0);
CREATE INDEX i0 ON t0(c1) WHERE c0 GLOB 3;
UPDATE t0 SET c1=0; -- sqlite3.c:75871: sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed.
</pre>
When compiling with -DSQLITE_DEBUG, the UPDATE triggers an assertion error.
(text/x-fossil-wiki)
See also ticket [c62c5e58524b204d]. Both this ticket and that ticket are
false-positives in the sqlite3VdbeMemAboutToChange() assert mechanism that
is used to help verify that shallow-copies of register values are not
misused.
|