| Ticket Hash: | 3ab4a9f02ce8dce62c09af5fa79354fb34a1e24c | |||
| Title: | Debug assertion sqlite3VdbeExec: Assertion `pC!=0' failed | |||
| Status: | Closed | Type: | Code_Defect | |
| Severity: | Critical | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-12-23 14:36:55 | |||
| Version Found In: | 3.30.0 | |||
| User Comments: | ||||
mrigger added on 2019-12-23 09:35:06:
(text/x-fossil-wiki)
Consider the following test case: <pre> CREATE TABLE t0(c0 UNIQUE); SELECT * FROM t0 WHERE (t0.c0, 1) IN(SELECT NTILE(1) OVER(), 0 FROM t0); -- sqlite3.c:90197: sqlite3VdbeExec: Assertion `pC!=0' failed. </pre> When compiling with -DSQLITE_DEBUG, the SELECT triggers an assertion error. The underlying bug might be the same as [d9ed4ebef1], which, however, results in a segfault. dan added on 2019-12-23 14:36:55: (text/x-fossil-wiki) Fixed by [0b1dbd60]. | ||||