SQLite

Ticket Change Details
Login
Overview

Artifact ID: 55b13ed5ca2e970cc1c3df2fffec7cc934a1f2704a9fb49d53c40894dfe395ed
Ticket: d0866b26f83e9c55e30de0821f5deb2a0bf6a7e6
Window function in correlated subquery causes assertion fault
User & Date: drh 2019-01-01 13:02:56
Changes

  1. icomment:
    OSSFuzz found the following counter-example to the fix described above:
    
    <blockquote><verbatim>
    SELECT(WITH c AS(VALUES(1))SELECT '' FROM c,c) x WHERE x+x;
    </verbatim></blockquote>
    
    The query above fails with check-in [4678cb1044f0b4dc8] but works before then.
    
  2. login: "drh"
  3. mimetype: "text/x-fossil-wiki"
  4. resolution changed to: "Open"
  5. status changed to: "Open"