sql: Scan error on column index 1, name "timestamp": unsupported Scan, storing driver.Value type []uint8 into type *time.Time

[Jille]

Version

1.10.0

What happened?

sqlc assumes parseTime=true is enabled or it fails with this cryptic error message. (It's easy now that I know that setting exists though.)

I don't suppose we can do a compile check for this, so the next best thing is an at-init check? Documenting this in an easy to find place would also help.

Relevant log output

sql: Scan error on column index 1, name "timestamp": unsupported Scan, storing driver.Value type []uint8 into type *time.Time

Database schema

CREATE TABLE authors (
  id   BIGSERIAL PRIMARY KEY,
  time DATETIME NOT NULL
);
​

SQL queries

-- name: ListAuthors :many
SELECT * FROM authors;

Configuration

version: 1
packages:
  - path: "gendb"
    engine: "mysql"
    schema: "schema.sql"
    queries: "queries.sql"
    emit_prepared_queries: true

Playground URL

https://play.sqlc.dev/p/cc8dac471c61806d52951840aa88779ed61f52d5895f0b70d8be446833bf3ea7

What operating system are you using?

Linux

What database engines are you using?

MySQL

What type of code are you generating?

Go

[kyleconroy]

I don't think there's an easy way to do this at runtime, since the database connection URL can't be accessed.

I do agree that the MySQL documentation should be much clearer about this, both in the getting started guide and the reference docs.

[bweston92]

Just looked through the source for the MySQL driver that is most used, it appears once it is set there is nowhere outside of the package it can be overridden.

Certainly needs documentation though.

[renanbastos93]

Hey guys I did many tests here and found a way to solve in MySQL. I changed datetime to bigint so sqlc converts to int64, even so, I always saved unixtime in the database well, working on so good for me.

[kyleconroy]

Added documentation to the bottom of the getting started guide: https://docs.sqlc.dev/en/stable/tutorials/getting-started-mysql.html