sqlc
sqlc copied to clipboard
fix(mysql): Fix the generation of between keyword in CTE
Fixes https://github.com/sqlc-dev/sqlc/issues/2983
The incorrectly generated code in this issue is generated as follows.
const listAuthorsWithCTE = `-- name: ListAuthorsWithCTE :many
WITH page AS (SELECT id FROM authors WHERE authors.created_at BETWEEN ? AND ?)
SELECT authors.id, name, bio, created_at, page.id FROM authors
INNER JOIN page ON page.id = authors.id
ORDER BY name
`
type ListAuthorsWithCTEParams struct {
FromCreatedAt time.Time
ToCreatedAt time.Time
}
rows, err := q.db.QueryContext(ctx, listAuthorsWithCTE, arg.FromCreatedAt, arg.ToCreatedAt)