Title: No parameter gets generated for CASE ? WHEN... · Issue #2847 · sqlc-dev/sqlc · GitHub
Open Graph Title: No parameter gets generated for CASE ? WHEN... · Issue #2847 · sqlc-dev/sqlc
X Title: No parameter gets generated for CASE ? WHEN... · Issue #2847 · sqlc-dev/sqlc
Description: Version 1.22.0 What happened? I use a CASE statement of the form CASE ? WHEN true THEN '1' WHEN false THEN '0' ELSE NULL END. The generated Go function has no parameters for the ?. Relevant log output No response Database schema CREATE T...
Open Graph Description: Version 1.22.0 What happened? I use a CASE statement of the form CASE ? WHEN true THEN '1' WHEN false THEN '0' ELSE NULL END. The generated Go function has no parameters for the ?. Relevant log out...
X Description: Version 1.22.0 What happened? I use a CASE statement of the form CASE ? WHEN true THEN '1' WHEN false THEN '0' ELSE NULL END. The generated Go function has no parameters for the ?. ...
Opengraph URL: https://github.com/sqlc-dev/sqlc/issues/2847
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"No parameter gets generated for CASE ? WHEN...","articleBody":"### Version\n\n1.22.0\n\n### What happened?\n\nI use a CASE statement of the form `CASE ? WHEN true THEN '1' WHEN false THEN '0' ELSE NULL END`.\r\n\r\nThe generated Go function has no parameters for the `?`.\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n```sql\nCREATE TABLE testing (\r\n id int PRIMARY KEY,\r\n value text\r\n);\n```\n\n\n### SQL queries\n\n```sql\nUPDATE testing\r\nSET value = CASE ? WHEN true THEN 'Hello' WHEN false THEN 'Goodbye' ELSE value END;\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\": \"mysql\",\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/c6a70bea34b4e836d2cc998f885ae6c51d2234632ebe9de53865c23a68588dc6\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/chowey","@type":"Person","name":"chowey"},"datePublished":"2023-10-13T03:36:40.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2847/sqlc/issues/2847"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:99ecb3e1-7bcd-4052-cb1d-35d36ec21224 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 8D16:1BE817:1E040D:2963CC:6A513335 |
| html-safe-nonce | 36f3ae50bcf3be1b08be13635b0ec3b711d323bc7a09ba5e51db84b599cf6f0e |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4RDE2OjFCRTgxNzoxRTA0MEQ6Mjk2M0NDOjZBNTEzMzM1IiwidmlzaXRvcl9pZCI6IjI2Nzg4Mzg5MzA0MjI0NDQ4NTMiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 4ba049353bcf277542036ef6d31ce38a5d2e63556ec5988db93df6bfd297f160 |
| hovercard-subject-tag | issue:1941170238 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlc-dev/sqlc/2847/issue_layout |
| twitter:image | https://opengraph.githubassets.com/404ab90eabdd62ece7a68e5efb98381df42bd8a534d0ca4a1bc761598ef4b519/sqlc-dev/sqlc/issues/2847 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/404ab90eabdd62ece7a68e5efb98381df42bd8a534d0ca4a1bc761598ef4b519/sqlc-dev/sqlc/issues/2847 |
| og:image:alt | Version 1.22.0 What happened? I use a CASE statement of the form CASE ? WHEN true THEN '1' WHEN false THEN '0' ELSE NULL END. The generated Go function has no parameters for the ?. Relevant log out... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | chowey |
| hostname | github.com |
| expected-hostname | github.com |
| None | e840f405b2718e8f2d55aafa9ff27dbce17e29d0c253011d05ea0fea3c78baff |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlc-dev/sqlc git https://github.com/sqlc-dev/sqlc.git |
| octolytics-dimension-user_id | 136738596 |
| octolytics-dimension-user_login | sqlc-dev |
| octolytics-dimension-repository_id | 193160679 |
| octolytics-dimension-repository_nwo | sqlc-dev/sqlc |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 193160679 |
| octolytics-dimension-repository_network_root_nwo | sqlc-dev/sqlc |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 4ae6027e8ba70c79dc08249bb6cdc1a09d788496 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width