5GHjSfUc

1CREATE TABLE IF NOT EXISTS sugestoes (
2        id     INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
3        texto  VARCHAR(250),
4        autor  VARCHAR(250),
5        itens  VARCHAR(250),
6        pontos INTEGER
7    );
8	
9CREATE TABLE IF NOT EXISTS vertices (
10        id            INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
11        id_node_pai   INTEGER,
12        id_node_filho INTEGER,
13        FOREIGN KEY (id_node_pai)   REFERENCES sugestoes(id),
14        FOREIGN KEY (id_node_filho) REFERENCES sugestoes(id)
15    );
16	
17WITH vertices AS (
18    SELECT p.autor FROM sugestoes p, vertices e
19        WHERE e.id_node_pai = p.id
20    UNION ALL
21    SELECT f.autor FROM sugestoes f
22        INNER JOIN vertices d
23        ON f.id = d.id_node_filho
24)
25    SELECT * FROM vertices;
26	
27Error: circular reference: vertices