query.sql:20:7: syntax error near "SELECT"

[jmgaooo]

Version

1.28.0

What happened?

sqlc generate failed.

package dao

query.sql:20:7: syntax error near "SELECT"

---

It should be related to sqlc.slice. If the SQL in sqlc.slice is placed at the end, this error does not occur.

Relevant log output

Database schema

SQL queries

Configuration

Playground URL

https://play.sqlc.dev/p/5602df5fd37eca5f6ac95dda7da33f112478c3a41c46cb63cf76126c458c2fdc

What operating system are you using?

Windows

What database engines are you using?

MySQL

What type of code are you generating?

Go

[LilMonk]

this should be what you are looking for:

-- name: SelectById :one
select
  *
from
  test_user
where
  id = $1; -- parameter was missing

  
-- name: SelectUsers :many
SELECT
  *
FROM
  test_user
WHERE
  id IN (sqlc.slice ("ids"));  -- ; was missing
  
-- name: GetUserPhone :one
SELECT
  phone
FROM
  test_user
WHERE
  id=$1; -- parameter was missing