René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlc generates separate params for same arg","articleBody":"### Version\n\n1.30.0\n\n### What happened?\n\nQuery: \n```\n-- name: SearchAuthorsFullText :many\nSELECT * FROM authors\nWHERE MATCH(name) AGAINST(sqlc.arg(search_term))\nORDER BY name = sqlc.arg(search_term) DESC,\nMATCH(name) AGAINST(sqlc.arg(search_term)) DESC\nLIMIT ?;\n```\ngenerates\n\n```\ntype SearchAuthorsFullTextParams struct {\n\tSearchTerm     string `json:\"searchTerm\"`\n\tSearchTerm_3   string `json:\"searchTerm3\"`\n\tLimit          int32  `json:\"limit\"`\n}\n```\n\nThe playground link does not show this behavior (actually shows a different bug), most likely because you can't use version past 1.25\n\n### Relevant log output\n\n```shell\n\n```\n\n### Database schema\n\n```sql\nCREATE TABLE authors (\n  id   int  NOT NULL AUTO_INCREMENT,\n  name text      NOT NULL,\n  bio  text,\n  PRIMARY KEY(`id`),\n  FULLTEXT KEY `idx_fulltext` (`name`)\n);\n```\n\n### SQL queries\n\n```sql\n-- name: SearchAuthorsFullText :many\nSELECT * FROM authors\nWHERE MATCH(name) AGAINST(sqlc.arg(search_term))\nORDER BY name = sqlc.arg(search_term) DESC,\nMATCH(name) AGAINST(sqlc.arg(search_term)) DESC\nLIMIT ?;\n```\n\n### Configuration\n\n```yaml\n{\n  \"version\": \"2\",\n  \"sql\": [{\n    \"schema\": \"schema.sql\",\n    \"queries\": \"query.sql\",\n    \"engine\": \"mysql\",\n    \"gen\": {\n      \"go\": {\n        \"out\": \"db\"\n      }\n    }\n  }]\n}\n```\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/2054232c1df35a1d15e7c611771cb04d8dffcb438dd083597dce561f24ad1541\n\n### What operating system are you using?\n\nmacOS\n\n### What database engines are you using?\n\nMySQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/andylin-0","@type":"Person","name":"andylin-0"},"datePublished":"2026-04-16T17:11:20.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/4376/sqlc/issues/4376"}