Title: Array indexes not correctly handled on update set · Issue #1532 · sqlc-dev/sqlc · GitHub
Open Graph Title: Array indexes not correctly handled on update set · Issue #1532 · sqlc-dev/sqlc
X Title: Array indexes not correctly handled on update set · Issue #1532 · sqlc-dev/sqlc
Description: I have a SQL query in my project that is attempting to update an array at a specific index but it is not being handled correctly. I was able to replicate this issue in a separate project and pasted the sample query below. -- name: Update...
Open Graph Description: I have a SQL query in my project that is attempting to update an array at a specific index but it is not being handled correctly. I was able to replicate this issue in a separate project and pasted...
X Description: I have a SQL query in my project that is attempting to update an array at a specific index but it is not being handled correctly. I was able to replicate this issue in a separate project and pasted...
Opengraph URL: https://github.com/sqlc-dev/sqlc/issues/1532
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Array indexes not correctly handled on update set","articleBody":"I have a SQL query in my project that is attempting to update an array at a specific index but it is not being handled correctly. I was able to replicate this issue in a separate project and pasted the sample query below.\r\n\r\n-- name: UpdateRow :one\r\nupdate temp\r\nset places[$1] = $2\r\nwhere id=$3\r\nRETURNING *;\r\n\r\nThe generated code treats places[$1] as an array input parameter instead of accepting $1 as the index of the places column.\r\n\r\n### Playground\r\n\r\nhttps://play.sqlc.dev/p/a7c1a274a647d8c2452f4bc9cd93f8a76bf09c43745ea428859433edec18aaa1","author":{"url":"https://github.com/stephanievance29","@type":"Person","name":"stephanievance29"},"datePublished":"2022-04-05T22:16:32.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/1532/sqlc/issues/1532"}| 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:ff0ee661-86c9-cd5b-1a00-c294bf05c438 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | E29E:18EF1B:8674EF8:BB0CDB1:6A5056F5 |
| html-safe-nonce | 2e83e4d162abe4ff01620f06405ca57281332049d92bcb6d488d5d18548d7d9c |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFMjlFOjE4RUYxQjo4Njc0RUY4OkJCMENEQjE6NkE1MDU2RjUiLCJ2aXNpdG9yX2lkIjoiMjA3NTc1NzQ1OTcxNzI0ODc1NyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 8af8e08e4f7242667892edbbce293907c3adf82fcb7f7b19d5c2c2439c172ae2 |
| hovercard-subject-tag | issue:1193776326 |
| 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/1532/issue_layout |
| twitter:image | https://opengraph.githubassets.com/1820f31c2103274ba09c1c8f0f02cd7c6868beb9811946981e63db619c2baba6/sqlc-dev/sqlc/issues/1532 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/1820f31c2103274ba09c1c8f0f02cd7c6868beb9811946981e63db619c2baba6/sqlc-dev/sqlc/issues/1532 |
| og:image:alt | I have a SQL query in my project that is attempting to update an array at a specific index but it is not being handled correctly. I was able to replicate this issue in a separate project and pasted... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | stephanievance29 |
| hostname | github.com |
| expected-hostname | github.com |
| None | d6dc8294eb500fa36bbc57472d61fe87c522f9c3c1d64f70f4926f66a66a7efb |
| 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 | 7ac0ad2f2c7e4b9056617355fd9e33e22b0c8df9 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width