Version

1.30.0

What happened?

I noticed a difference when generating queries with limit/offset between using a schema file vs a managed database connection. If the table uses an int64 primary key, then the limit and offset params should be int64. This works correctly with a managed database, but when using only a schema.sql, it generates as int32 instead.

In the config below, you can see the difference in behavior by uncommenting the managed db lines.

For simplicity, I ran sqlc for this as:

go run github.com/sqlc-dev/sqlc/cmd/sqlc@v1.30.0 generate

And then I looked at the generated params:

type ListItemsParams struct { Limit int32 Offset int32 }

Relevant log output

Database schema

CREATE TABLE items ( id BIGSERIAL PRIMARY KEY );

SQL queries

-- name: ListItems :many SELECT * FROM items LIMIT $1 OFFSET $2;

Configuration

version: "2" # servers: # - engine: postgresql # uri: "postgres://user:pass@localhost:5432/db?sslmode=prefer" sql: - engine: "postgresql" queries: "queries.sql" schema: "schema.sql" # database: # managed: true gen: go: package: "dbsqlc" out: "dbsqlc" emit_pointers_for_null_types: true sql_package: "pgx/v5"

Playground URL

No response

What operating system are you using?

macOS

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go