sqlc

sqlc copied to clipboard

LIMIT results in Syntax Error

2

### Version 1.13.0 ### What happened? Hello! I tried to create a query with dynamic query/offset. Unfortunately, it returned an error. Tickets I discovered: https://github.com/kyleconroy/sqlc/issues?q=is%3Aissue+is%3Aopen+limit+label%3A%22%3Abooks%3A+mysql%22 Things I've tried: https://github.com/kyleconroy/sqlc/issues/1439 -...

rhodee

`Group by` and `left join using` gives a "column reference is ambiguous

3

### Version 1.12.0 ### What happened? When using `join ... using (key) group by key`, sqlc seems to think `key` references the columns in the joined tables instead of the...

Yamakaky

Querry appends .* to last column in SELECT when trying to use "table".*

1

### Version 1.12.0 ### What happened? When I join two tables and try to select everything from only one of them using the "table".* syntax the generated code has .*...

nd291195

Named parameters not working in subquery inside MySQL IN clause

1

### Version 1.12.0 ### What happened? On use subquery inside MySQL IN or NOT IN clauses, parameters not working. When I use `sqlc.arg()`, generated code not recognizes parameter. When I...

bryandantas

Invalid "Column is ambiguous error"

2

### Version 1.12.0 ### What happened? ```sql SELECT "UserRecords"."Username" FROM "Monitor" JOIN ( SELECT DISTINCT ON ("User") * FROM "UserRecords" ORDER BY "User", "CreatedAt" DESC) "UserRecords" ON "Monitor"."ID" = "UserRecords"."User"...

Davincible

### Version 1.12.0 ### What happened? A bug! Cf the playgound: https://play.sqlc.dev/p/12ef4fd5df98251667114c2086d5f3e8c9cf809098e8aa92ed7938a548fd3b24 Output code is not valid: ```go func (q *Queries) LocationByUuid(ctx context.Context, uuid uuid.UUID) (uuid.UUID, error) { row :=...

florentchauveau

Kotlin generator doesn't work with named parameters

1

### Version 1.12.0 ### What happened? Tried to use named parameters with the Kotlin code generator, but ran into an error. I recreated the issue in the unit tests and...

ahmed-envoy

### Version 1.12.0 ### What happened? When running sqlc v1.12.0 ➜ sqlc compile \# package db sql/query/advanced.sql:3:84: column "key" does not exist It appears sqlc compile is not aware of...

vmantese

Code for pgx/v4 doesn't compile with same named input and output param

1

### Version 1.12.0 ### What happened? I have a query that takes `id` as its only input, and also returns `id` as its only output. That causes the function arg...

Jille

### Version 1.12.0 ### What happened? go version: 1.18 (equal results with 1.17.8) Using TEXT[][] as the column type in postgresql generates a corresponding model with field of type []string,...

colli173