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





All Articles