René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"CTE with RECURSIVE and UNION ALL","articleBody":"### Version\r\n\r\n1.15.0\r\n\r\n### What happened?\r\n\r\nI try to generate go code with a recursive CTE, which uses `UNION ALL` and it fails.\r\n\r\nMy query is quite complex, but here is a simple reproduction:\r\n\r\n\r\n### Relevant log output\r\n\r\n```shell\r\nquery.sql:7:8: column \"n\" does not exist\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n_None_\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: CTERecursive :many\r\nWITH RECURSIVE t(n) AS (\r\n    VALUES (1)\r\n  UNION ALL\r\n    SELECT n+1 FROM t WHERE n \u003c 100\r\n)\r\nSELECT n FROM t;\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\n{\r\n  \"version\": \"1\",\r\n  \"packages\": [\r\n    {\r\n      \"path\": \"go\",\r\n      \"name\": \"querytest\",\r\n      \"schema\": \"query.sql\",\r\n      \"queries\": \"query.sql\"\r\n    }\r\n  ]\r\n}\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/5c0c86493af9912a8d54ab083a92edcd4105ea8baf30681e1abe761a0cce1246\r\n\r\n### What operating system are you using?\r\n\r\nLinux\r\n\r\n### What database engines are you using?\r\n\r\nPostgreSQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/oliverpool","@type":"Person","name":"oliverpool"},"datePublished":"2022-10-26T16:06:53.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/1912/sqlc/issues/1912"}