sqlc icon indicating copy to clipboard operation
sqlc copied to clipboard

fix(mysql): Fix the generation of between keyword in CTE

Open eyasy1217 opened this issue 1 year ago • 0 comments

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)

eyasy1217 avatar Jan 28 '24 11:01 eyasy1217