René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Args in mysql ORDER BY not respected","articleBody":"### Version\r\n\r\n1.25.0\r\n\r\n### What happened?\r\n\r\nThe postgres generator supports variables in the ORDER BY, but mysql does not.\r\n\r\n```sql\r\nSELECT * FROM authors\r\nORDER BY MOD(id, sqlc.arg(foo));\r\n```\r\n```go\r\nconst listAuthors = `-- name: ListAuthors :many\r\nSELECT id, name FROM authors\r\nORDER BY MOD(id, sqlc.arg(foo))\r\n```\r\n\r\n### Relevant log output\r\n\r\n_No response_\r\n\r\n### Database schema\r\n\r\n_No response_\r\n\r\n### SQL queries\r\n\r\n_No response_\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/a2272d7f92f2e1a2a6c122dd3e38fa8ec9625a107fc55b93a45c6db7558d85bc\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/seanlaff","@type":"Person","name":"seanlaff"},"datePublished":"2024-01-05T20:33:25.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/3113/sqlc/issues/3113"}