René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Error when using CTE and self join","articleBody":"### Version\r\n\r\n1.17.2\r\n\r\n### What happened?\r\n\r\nWhen using CTE (WITH clause) in query and self join, sqlc doesn't see any columns. When using join from another table/view it works as expected.\r\n\r\n### Relevant log output\r\n\r\n```shell\r\nsqlc generate failed.\r\n\r\n# package db\r\nquery.sql:6:5: column \"id\" does not exist\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n_No response_\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: Q :many\r\nWITH\r\n    items1 AS (SELECT 'id'::TEXT AS id, 'name'::TEXT AS name),\r\n    items2 AS (SELECT 'id'::TEXT AS id, 'name'::TEXT AS name)\r\nSELECT\r\n    i1.id AS id1,\r\n    i2.id AS id2\r\nFROM\r\n    items1 i1\r\n        JOIN items1 i2 ON 1 = 1;\r\n        -- change ^ above items1 to items2 to fix\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\": \"db\",\r\n      \"engine\": \"postgresql\",\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/af3970dbc2ab065393d42b65a2bedf37b0d73734214ca9a42579829dfb8e6de7\r\n\r\n### What operating system are you using?\r\n\r\n_No response_\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/matbur","@type":"Person","name":"matbur"},"datePublished":"2023-03-07T12:37:47.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/2132/sqlc/issues/2132"}