| Ticket Hash: | b383b90278186263fccf509bdf655febae59a0b5 | |||
| Title: | Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed (2) | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Important | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-12-24 01:53:36 | |||
| Version Found In: | 3.30.0 | |||
| User Comments: | ||||
mrigger added on 2019-12-23 23:19:27:
(text/x-fossil-wiki)
Consider the following test case: <pre> CREATE TABLE t0(c0 TEXT, CHECK(c0 BETWEEN 0 AND +c0)); INSERT INTO t0 VALUES (0); UPDATE t0 SET c0 = 0; -- sqlite3.c:86402: sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed. </pre> When compiling with -DSQLITE_DEBUG, the UPDATE triggers an assertion error. This might be related to [https://www.sqlite.org/src/tktview?name=188f912b51]. | ||||