| Ticket Hash: | b0cb8aff561a6dcd716697daa9b8ea51413b124c | |||
| Title: | Debug assertion sqlite3ExprSkipCollateAndLikely: Assertion `pExpr->op==TK_COLLATE' failed | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Minor | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-12-22 18:55:38 | |||
| Version Found In: | 3.30.0 | |||
| User Comments: | ||||
|
mrigger added on 2019-12-22 09:48:03:
Consider the following test case: CREATE TABLE t0(c0); CREATE INDEX i0 ON t0((c0 NOTNULL) COLLATE BINARY); SELECT * FROM t0 WHERE(c0 NOTNULL) COLLATE BINARY BETWEEN 0 AND c0; -- sqlite3.c:98025: sqlite3ExprSkipCollateAndLikely: Assertion `pExpr->op==TK_COLLATE' failed. When compiling with -DSQLITE_DEBUG, the SELECT triggers an assertion error. | ||||