Repository navigation
Subquery Alias causing panic #153
Description
I tried to do a more efficient distinct query (the second query) and noticed that the generation panics on the alias of a subquery. The first query shows a simpler example on how to cause this issue.
panic: walk: unexpected node type *pg_query.Alias
-- schema.sql
CREATE TABLE authors (
id BIGSERIAL PRIMARY KEY,
name TEXT NOT NULL,
bio TEXT
);-- name: SubAuthors :many
SELECT sub.name FROM (SELECT * FROM authors) sub
-- name: ListDistinctAuthors :many
WITH RECURSIVE temp (t) AS (
(SELECT name from authors LIMIT 1)
UNION ALL
(SELECT name FROM temp, LATERAL (SELECT name FROM authors where name > t LIMIT 1) sub)
)
SELECT t from temp;
Activity
internal/dinosql: Dereference alias nodes on walk
internal/dinosql: Dereference alias nodes on walk (#158)