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. |