René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlc hallucinates ambiguous column references when no ambiguity exists ","articleBody":"### Version\n\n1.19.1\n\n### What happened?\n\nDiscovered while working on https://github.com/sqlc-dev/sqlc/pull/2537, sqlc returns an ambiguous column reference error for some queries which run fine with psql. See examples below.\r\n\r\nTo fix we'll need to update `findColumnForRef()` in `output_columns.go` I believe.\n\n### Relevant log output\n\n```shell\nquery.sql:9:1: column reference \"name\" is ambiguous: if you want to skip this validation, set 'strict_order_by' to false\n```\n\n\n### Database schema\n\n```sql\nCREATE TABLE authors (\r\n  id   BIGSERIAL PRIMARY KEY,\r\n  name text      NOT NULL,\r\n  bio  text\r\n);\n```\n\n\n### SQL queries\n\n```sql\nSELECT a.name\r\nFROM authors a JOIN authors b ON a.id = b.id\r\nORDER BY name;\r\n\r\nSELECT a.name AS name\r\nFROM authors a JOIN authors b ON a.id = b.id\r\nORDER BY name;\n```\n\n\n### Configuration\n\n```yaml\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}\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/8e9c3fa8f50201433c489b118a731130a7011574ec53d27bbe460eb1978f2f13\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/andrewmbenton","@type":"Person","name":"andrewmbenton"},"datePublished":"2023-07-27T21:56:07.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/2538/sqlc/issues/2538"}