René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Duplication of fields when generating for pgx/v5","articleBody":"### Version\n\n1.24.0\n\n### What happened?\n\nMultiple fields with the same name are generated\r\n\r\n_It will work correctly if you use enumerations ($1, $2, etc.) or sqlc.arg(number)_\n\n### Relevant log output\n\n```shell\ntype UpdateParams struct {\r\n\tNumber int32\r\n\tID     int32\r\n\tNumber int32\r\n}\n```\n\n\n### Database schema\n\n```sql\nCREATE TABLE public.demo (\r\n    id INT PRIMARY KEY,\r\n    number integer NOT NULL\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: Update :one\r\nUPDATE demo\r\nSET number = @number\r\nWHERE id = @id\r\n\tAND number = @number - 1\r\nRETURNING true AS updated;\n```\n\n\n### Configuration\n\n```yaml\n{\r\n  \"version\": \"2\",\r\n  \"sql\": [{\r\n    \"schema\": \"schema.sql\",\r\n    \"queries\": \"query.sql\",\r\n    \"engine\": \"postgresql\",\r\n    \"gen\": {\r\n      \"go\": {\r\n        \"out\": \"db\",\r\n        \"sql_package\": \"pgx/v5\"\r\n      }\r\n    }\r\n  }]\r\n}\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/bc917ef4b923f377b2843a77398b3245df8b2c95b8330d1dffd015d4cd355c84\n\n### What operating system are you using?\n\nmacOS\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/AlexanderMint","@type":"Person","name":"AlexanderMint"},"datePublished":"2023-12-26T01:28:54.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/3080/sqlc/issues/3080"}