The following SQL results in an assertion fault:

<blockquote><verbatim>
WITH RECURSIVE
  t(id, parent) AS (VALUES(1,2)),
  q(id, parent, rn) AS (
    VALUES(1,2,3)
    UNION ALL
    SELECT t.*, ROW_NUMBER() OVER (ORDER BY t.id) AS rn
      FROM q JOIN t ON t.parent = q.id
  )
SELECT * FROM q;
</verbatim></blockquote>

As the SQL makes use of window functions, this defect only affects SQLite
version 3.25 and its patches.  The problem was reported on the sqlite-users
mailing list by Yaroslav Schekin.