StackOverflowError when compiling recursive query about sqldelight

[jschnall]

I have a similar issue with MySQL, SQLDelight Version 2.0.2. I tested the query with Table Plus and it seems fine.

Table:

CREATE TABLE Folder (
    id BIGINT NOT NULL AUTO_INCREMENT,
    name VARCHAR(64) NOT NULL,
    parent_id BIGINT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (parent_id) REFERENCES Folder(id)
);

Query:

WITH RECURSIVE ancestor(id, parent_id) AS (
  SELECT id, parent_id
  FROM Folder
  WHERE id = :folder_id
UNION ALL
  SELECT f.id, f.parent_id
  FROM Folder f
  INNER JOIN ancestor a ON a.parent_id = f.id LIMIT 255
)
SELECT * FROM ancestor;