RFC: Parse TINYINT(1) as bool

[methane]

MySQL doesn't have actual bool type. Boolean is alias of TINYINT(1).

Using TINYINT(1) for regular integer is not so common.
How about treating TINYINT(1) as bool for better experience?

var b any
db.QueryRow("SELECT true").Scan(&b) // b is bool(true), not int64(1).

[dolmen]

CREATE TABLE tbl (x TINYINT(1));
INSERT INTO tbl VALUES (-128),(127);
SELECT * FROM tbl;

+------+
| x    |
+------+
| -128 |
|  127 |
+------+
2 rows in set (0,33 sec)

[methane]

OK. Assuming TINYINT(1) is bool is not 100% safe.
I think we should keep status quo.

[methane]

Using TINYINT(1) for Boolean is MySQL's spec.
I am thinking about adding tinyint1isbool option. It changes behavior for signed tinyint(1) like:

• DatabaseTypeName() is Boolean
• ScanType() is bool
• Scan(*any) returns bool

[kirs]

I would be very supportive of having an option like tinyint1isbool, since as of today there's no good way to get Length() of a column in a result set, and it's been really tricky in my app's use case to figure if it's boolean or an actual tinyint.