SQLite

View Ticket
Login
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.