Sqlite syntax error "WITH"
I have this code with this error: "Query error: next to 'WITH": syntax error Unable to execute statement "from SqliteMan and from Node -webkit (latest).
WITH RECURSIVE FT_CTE(*) AS (
SELECT pID, cID FROM brFTNode_Children
WHERE pID = 1
UNION ALL
SELECT e.pID, e.cID FROM brFTNode_Children e
INNER JOIN FT_CTE ftCTE ON (ftCTE.cID = e.pID)
)
SELECT * FROM FT_CTE;
The Sqlite doc clearly states that it supports the WITH clause.
Any idea?
+3
source to share
No one has answered this question yet
See similar questions:
or similar: