René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlc.slice() fails with 'column does not exist' error when used with subquery-computed column","articleBody":"### Version\r\n\r\n1.27.0\r\n\r\n### What happened?\r\n\r\nWhen using sqlc.slice() with a column computed in a subquery, sqlc generate fails with a \"column does not exist\" error. This occurs even though the column is correctly defined and aliased in the subquery.\r\n\r\n### Relevant log output\r\n\r\n```shell\r\nquery.sql:18:3: 396: column \"full_name\" does not exist\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE customers (\r\n  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,  \r\n  first_name varchar(255) not null,\r\n  last_name varchar(255) not null\r\n) ENGINE = INNODB DEFAULT CHARSET = utf8mb4;\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: GetFullNames :many\r\nSELECT\r\n full_name\r\nFROM\r\n  (\r\n    SELECT\r\n  \t concat(first_name, ' ', last_name) as full_name\r\n    FROM\r\n      customers\r\n  ) subquery\r\nWHERE\r\n  full_name IN (sqlc.slice (\"full_names\"));\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```\r\n{\r\n  \"version\": \"2\",\r\n  \"sql\": [\r\n    {\r\n      \"schema\": \"query.sql\",\r\n      \"queries\": \"query.sql\",\r\n      \"engine\": \"mysql\",\r\n      \"gen\": {\r\n        \"go\": {\r\n          \"package\": \"db\",\r\n          \"out\": \"db\"\r\n        }\r\n      }\r\n    }\r\n  ]\r\n}\r\n```\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/043ded77492cec27dbba4e964774d08836ad76227a585856ae284f13f9046f24\r\n\r\n### What operating system are you using?\r\n\r\nmacOS\r\n\r\n### What database engines are you using?\r\n\r\nMySQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/kawatakutaku","@type":"Person","name":"kawatakutaku"},"datePublished":"2024-11-23T03:37:47.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/3720/sqlc/issues/3720"}