Problem when deparsing Queries with UNION

[primeapple]

And another one:

"SELECT * FROM "test" UNION SELECT * FROM "test2""
We have the (quite stupid) query:

WITH test AS (SELECT * FROM student),
test2 AS (SELECT * FROM student)
SELECT * FROM test
UNION
SELECT * FROM test2
ORDER BY id DESC

When we parse and deparse this query we get something very very funny:

SELECT * FROM "test" UNION SELECT * FROM "test2"

Now this is amazing. It seems, that when you deparse something with UNION, you forget everything else (WITH, ORDER BY, probably HAVING, ...)

[lfittl]

Fixed by 823155c