SQLite

View Ticket
Login
Ticket Hash: 41c1456a6e61c0e7bdffe719361eeab3c540d38a
Title: Assertion `pColl1 && (pParse->nErr || pColl2)' failed.
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2020-02-13 11:47:33
Version Found In: trunk
User Comments:
yongheng added on 2020-02-13 02:13:37:
Consider the following POC:
---
CREATE TABLE v0 ( v1 ) ;
CREATE TABLE v2 ( v5 INTEGER PRIMARY KEY , v4 INT , v3 CHAR(100) ) ;
SELECT DISTINCT * FROM v0 LEFT JOIN v2 ON v5 = v4 AND v5 = ( SELECT zipfile ( lower ( '17' ) , v1 ) FROM v0 ORDER BY random () ) WHERE v2 . v4 > 10 ;
---

It triggers an assertion in debug version of trunk.

drh added on 2020-02-13 11:47:33: (text/x-fossil-wiki)
The incorrect assert() was added yesterday.