mysql tinyint compiles to bool

[xcaptain]

As the image shows, I added a kind field to the authors table, then run sqlc generate, in the model, the kind field's type becomes bool, the expected type should be int8

[xcaptain]

https://github.com/kyleconroy/sqlc/blob/21a6cda2667d18cee40b6847a8558d2961f5d771/internal/mysql/gen.go#L297-L301

May have found the cause, but don't know why convert tinyint to bool

[kyleconroy]

This is indeed a bug. I need to do some investigation work around how the MySQL driver handles boolean types.

[markschmid]

I've looked into how 1.6.0 handles this. Is it correct that 1.6.0 does not support mysql boolean types?
Intuitively, I'd have expected the following mysql column definitions to be translated to golang data type bool, yet all of them are translated to int32: BOOL, BOOLEAN, TINYINT(1)