René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"keyword with causing \"column does not exist\"","articleBody":"### Version\n\n1.12.0\n\n### What happened?\n\nI wanted to make an update query that also returns some more detailed data from other tables. The update query itself works fine, but the \"WITH\" statement causes the \"column does not exist\" error during code generation in already tested update query.\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n```sql\ncreate table attribute_value\r\n(\r\n    id              bigserial not null,\r\n    val             text      not null,\r\n    attribute       bigint    not null\r\n);\r\n\r\ncreate table attribute\r\n(\r\n    id              bigserial      not null,\r\n    name            text           not null\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: UpdateAttributeValueDoesntWork :one\r\nwith updated_attribute as (UPDATE attribute_value\r\n    SET\r\n        val = CASE WHEN @filter_value::bool THEN @value ELSE val END\r\n    WHERE attribute_value.id = @id\r\n    RETURNING id,attribute,val)\r\nselect updated_attribute.id, val, name\r\nfrom updated_attribute\r\n         left join attribute on updated_attribute.attribute = attribute.id;\r\n\t\t \r\n-- name: UpdateAttributeValueWorks :one\r\nUPDATE attribute_value\r\n    SET\r\n        val = CASE WHEN @filter_value::bool THEN @value ELSE val END\r\n    WHERE attribute_value.id = @id\r\n    RETURNING id,attribute,val;\n```\n\n\n### Configuration\n\n_No response_\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/ba79ccad12759729ce4f260f70f3250de323a0050d2172e53d06f5ec1f83ee0d\n\n### What operating system are you using?\n\nLinux\n\n### What database engines are you using?\n\nPostgreSQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/konekomind","@type":"Person","name":"konekomind"},"datePublished":"2022-03-28T10:25:33.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":9},"url":"https://github.com/1515/sqlc/issues/1515"}