-
Notifications
You must be signed in to change notification settings - Fork 923
does mysql support passing a slice as a parameter to a query? #1430
Unanswered
nsharecome
asked this question in
Q&A
-
go version go1.16.5,I use v1 or v2 both debug error
markquery.sql
-- name: GetMarkList :many
SELECT * FROM ct_mark_record
WHERE REF= ANY(1ドル::int[])
LIMIT ?, ?;
sqlc.json
{
"version": "1",
"packages": [
{
"name": "mark",
"path": "mark",
"schema": "script/markschema.sql",
"queries": "script/markquery.sql",
"engine": "mysql"
}
]
}
output
$ sqlc generate
package mark
script/markquery.sql:3:19: syntax error near "1ドル::int[])" ```
Beta Was this translation helpful? Give feedback.
All reactions
Replies: 1 comment
-
Sadly not yet, but you can see a few workarounds here #695
Beta Was this translation helpful? Give feedback.
All reactions
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment