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