drh added on 2018-09-27 11:03:57:
(text/x-fossil-wiki)
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.
|