René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"`Group by` and `left join using` gives a \"column reference is ambiguous","articleBody":"### Version\r\n\r\n1.12.0\r\n\r\n### What happened?\r\n\r\nWhen using `join ... using (key) group by key`, sqlc seems to think `key` references the columns in the joined tables instead of the synthetic `key` column generated by `using`. `where` and `having` doesn't seem to have this problem, they work as expected.\r\n\r\nThis seem to be a regression since I have no problem with this kind of query in the 1.10.0 I use.\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:7:46: column reference \"fk\" is ambiguous\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n```sql\r\ncreate table t1 (\r\n        fk integer not null unique\r\n);\r\ncreate table t2 (\r\n        fk integer not null references t1(fk)\r\n);\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\nselect * from t1 join t2 using (fk) group by fk;\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n_No response_\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/f9717de599d83359e7f1fdf15bbe7e3ed9cb57ce7c6b4c9dd6576a6445b140cd\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\n_No response_","author":{"url":"https://github.com/Yamakaky","@type":"Person","name":"Yamakaky"},"datePublished":"2022-02-10T10:16:17.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/1425/sqlc/issues/1425"}