Closed
Description
This is a rare case. I think fixing this issue is very low priority.
When using UNION ALL
in mysql, a problem occurred when LIMIT ? OFFSET ?
was specified.
Specifically, Limit is not added to the Params
field.
The version I checked is "sqlc v1.15.0"
-- name: ListAuthors :many
SELECT * FROM authors
WHERE country = 'DE'
UNION ALL
SELECT * FROM authors2
WHERE country = 'US'
LIMIT ? OFFSET ?;
Originally posted by @subc in #1665 (comment)
Here's a playground URL: https://play.sqlc.dev/p/1d2500a755be62afea94857e1b060343e71d993152f37a14dde691688f8981e8