It doesn't work for lastest golang version

[zhonglushu]

I just get some meaningless Numbers.

[jhngrant]

@zhonglushu are you able to say what database and driver are you using?

[zhonglushu]

Mysql，table schema like this:

[zhonglushu]

The driver is https://github.com/go-sql-driver/mysql

[jhngrant]

@zhonglushu to try and replicate this issue, are you also able to share a snippet of Go code? - both the code you are code using to call sqlx and the struct.

In case you haven't already tried, try a forced rebuilding of packages in your project using:

go build -a

[zhonglushu]

The sqlx code is:
` db, err := sqlx.Connect("mysql", "root:******@tcp(localhost:3306)/test?charset=utf8")
if err != nil {
panic(err.Error())
}

rows, err := db.Queryx("SELECT * FROM population")
	if err != nil {
		panic(err.Error())
	}
	m := map[string]interface{}{}
	for rows.Next() {
		err = rows.MapScan(m)
		if err != nil {
			panic(err.Error())
		}
		fmt.Println(m)
		fmt.Println("-------------")
	}`

the running result is:

[zhonglushu]

I found scan method can not convert columns read from the database into *interface{}

[jhngrant]

@zhonglushu I'm not seeing the same issue. Out of interesting, what does the output look like when you range over the map instead? :

	rows, err := db.Queryx("SELECT * FROM population")
	if err != nil {
		panic(err.Error())
	}
	m := map[string]interface{}{}
	for rows.Next() {
		err = rows.MapScan(m)
		if err != nil {
			panic(err.Error())
		}
		// fmt.Println(m)
		for i := range m {
			fmt.Printf("%v\n", m[i])
		}
                fmt.Println("-------------")
	}

[zhonglushu]

It doesn't work，I found scan method can not convert columns read from the database into *interface{}.
For example, the code below can work, but the result is unexpectedly:

    var name interface{}
    var code int
    var year int
    var total float64
    err = rows.Scan(&name, &code, &year, &total)
    if err != nil {
        fmt.Println("Get values from database error")
        fmt.Println(err.Error())
    }
    popuMap := make(map[string]interface{})
    popuMap["Region_name"] = name
    popuMap["Region_code"] = code
    popuMap["Year"] = year
    popuMap["Total_population"] = total

After I modify the code "var name interface{}" like this:

    var name string
    var code int
    var year int
    var total float64
    err = rows.Scan(&name, &code, &year, &total)
    if err != nil {
        fmt.Println("Get values from database error")
        fmt.Println(err.Error())
    }
    popuMap := make(map[string]interface{})
    popuMap["Region_name"] = name
    popuMap["Region_code"] = code
    popuMap["Year"] = year
    popuMap["Total_population"] = total

I found the code runs properly, why?

[jhngrant]

@zhonglushu This behavior seems to be specific to the 'github.com/go-sql-driver/mysql' driver.
See: go-sql-driver/mysql#366

[zhonglushu]

@jhngrant Thank you very much!