SQLite

The following SQL results in an assertion fault:

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;

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.