MapScan got []uint8 for BIGINT and VARCHAR types

[greensea]

I am selecting rows from MySQL, and using MapScan() to scan data. The row data is BIGINT and VARCHAR, so I am expecting to get int64 and string (or []byte) data. But I got []uint8 for those data. Here is the code:

package main

import (
	"fmt"
	"time"

	_ "github.com/go-sql-driver/mysql"
	"github.com/jmoiron/sqlx"
)

var DSN string = "user:pass@tcp(192.168.1.88:3306)/db?charset=utf8mb4"

func main() {
	db, _ := sqlx.Open("mysql", DSN)
	db.Exec(`DOP TABLE t`)

	db.Exec(`CREATE TABLE t (
		id INT,
		name varchar(32)
	)`)

	db.Exec("INSERT INTO t (id, name) VALUES(?, ?)", time.Now().Unix(), "SomeName")

	row := db.QueryRowx("SELECT * FROM t")
	result := make(map[string]interface{})
	row.MapScan(result)

	fmt.Println(result)
}

The output is:

map[t.id:[49 54 52 52 57 57 57 50 49 54] t.name:[83 111 109 101 78 97 109 101]]
Data Type is: []uint8
Data Type is: []uint8

The name column is []uint8 data, ok that's acceptable, I can convert it to string manually. But the data of the id column is wired, it is timestamp "1644999985" represented in ASCII code. I think this is not the correct behavior.

[ipsusila]

I think the issue is not specific to sqlx but its related to the mysql driver. See https://github.com/go-sql-driver/mysql/issues/407

[s6816112]

try add where 1 = 1. maybe can slove this problem.