SQLite

Ticket Change Details
Login
Overview

Artifact ID: 9c16e62231e4f3820fbee47744428c6334626dc39f62592f0a0dfa9355d0e751
Ticket: 41c1456a6e61c0e7bdffe719361eeab3c540d38a
Assertion `pColl1 && (pParse->nErr || pColl2)' failed.
User & Date: yongheng 2020-02-13 02:13:37
Changes

  1. foundin changed to: "trunk"
  2. icomment:
    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.
    
  3. login: "yongheng"
  4. mimetype: "text/plain"
  5. severity changed to: "Minor"
  6. status changed to: "Open"
  7. title changed to:
    Assertion `pColl1 && (pParse->nErr || pColl2)' failed.
    
  8. type changed to: "Code_Defect"