query command can not to use *

[hyahm]

os: fedora

this is my code

db, err0 := sql.Open("mysql", "root:123456@tcp(127.0.0.1:3306)/test")
	if err0 != nil {
		log.Fatal(err0)
	}

	defer db.Close()

	
	//var row *sql.Rows
	// row,err := db.Query("select * from user")
	row,err := db.Query("select id,name,age from user")
	if err != nil {
		panic(err)
		os.Exit(1)
		// log.Fatal(err)

	}		
	
	for row.Next() {
		var id,age int
		var name string
		row.Scan(&id,&name,&age)
		
		fmt.Println(id,"\t",name,"\t",age)
	}

error log:

root@localhost gowork]# go run test.go 
panic: runtime error: slice bounds out of range

goroutine 1 [running]:
github.com/go-sql-driver/mysql.(*mysqlConn).readColumns(0xc42008e000, 0x3, 0x0, 0x0, 0x0, 0x0, 0x0)
	/root/go/src/github.com/go-sql-driver/mysql/packets.go:693 +0xa33
github.com/go-sql-driver/mysql.(*mysqlConn).query(0xc42008e000, 0x60d623, 0x12, 0x729d08, 0x0, 0x0, 0x0, 0x0, 0x58b010)
	/root/go/src/github.com/go-sql-driver/mysql/connection.go:408 +0x3cb
github.com/go-sql-driver/mysql.(*mysqlConn).QueryContext(0xc42008e000, 0x6f1160, 0xc420018118, 0x60d623, 0x12, 0x729d08, 0x0, 0x0, 0x7fc20e05b058, 0x4530c0, ...)
	/root/go/src/github.com/go-sql-driver/mysql/connection_go18.go:72 +0x112
database/sql.ctxDriverQuery(0x6f1160, 0xc420018118, 0x7fc20e05b058, 0xc42008e000, 0x60d623, 0x12, 0x729d08, 0x0, 0x0, 0x429d89, ...)
	/opt/go/src/database/sql/ctxutil.go:48 +0x277
database/sql.(*DB).queryDC.func1()
	/opt/go/src/database/sql/sql.go:1320 +0x99
database/sql.withLock(0x6efda0, 0xc420092000, 0xc420051c50)
	/opt/go/src/database/sql/sql.go:2873 +0x65
database/sql.(*DB).queryDC(0xc42007c140, 0x6f1160, 0xc420018118, 0x0, 0x0, 0xc420092000, 0xc420010690, 0x60d623, 0x12, 0x0, ...)
	/opt/go/src/database/sql/sql.go:1319 +0x6ba
database/sql.(*DB).query(0xc42007c140, 0x6f1160, 0xc420018118, 0x60d623, 0x12, 0x0, 0x0, 0x0, 0x1, 0x6, ...)
	/opt/go/src/database/sql/sql.go:1304 +0x147
database/sql.(*DB).QueryContext(0xc42007c140, 0x6f1160, 0xc420018118, 0x60d623, 0x12, 0x0, 0x0, 0x0, 0xc420051e50, 0xc420051e58, ...)
	/opt/go/src/database/sql/sql.go:1281 +0xd2
database/sql.(*DB).Query(0xc42007c140, 0x60d623, 0x12, 0x0, 0x0, 0x0, 0x0, 0x58d40c, 0x60a70a)
	/opt/go/src/database/sql/sql.go:1295 +0x82
main.main()
	/data/src/gowork/test.go:57 +0x132
exit status 2

solve

change sql command
"select * from user" to " select id from user "

can not to use * ?

[methane]

You can use * only when it returns exactly same type of columns.
In your case, SELECT * returns not id, name, age.

[hyahm]

in my local mysql , this table only this three columns id, name, age. ``` user | CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT '', `age` int(11) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ```

[methane]

What is version of Go and go-sql-driver/mysql ?

[methane]

And MySQL version?

[hyahm]

go-sql-driver/mysql is latest go version is 1.9.3 mysql version is 5.7.21

[methane]

I can run your SQL without any error, with MySQL 5.7.21.
Your traceback seems server returned corrupted packet. But I'm not sure.

What is printed when you run SELECT * FROM user from MySQL command line?

[methane]

Or could you dump packets by tcpdump?
tcpdump can be used to dump packets to pcap file which can be browsed by wireshark.

e.g. sudo tcpdump port 3306 -w dump.pcap

[percona-csalguero]

is there any reliable way of testing this?
I tested it and it works as expected

mysql> show create table test.user\G
*************************** 1. row ***************************
       Table: user
Create Table: CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT '',
  `age` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8
1 row in set (0,00 sec)

mysql> select * from user;
+----+----------------------+------------+
| id | name                 | age        |
+----+----------------------+------------+
|  6 | Wanda Lawson         |  583532949 |
|  7 | Michael Dunn         | 1342458479 |
|  8 | Beverly Cook         |  280366509 |
|  9 | Carolyn Welch        | 1801160058 |
| 10 | Ruth Moreno I II III |  914091476 |
| 11 | Irene Robinson I II  | 1022430181 |
| 12 | Gerald Stewart       |  165910161 |
| 13 | Mildred Thomas       | 1255569388 |
| 14 | Mrs. Ms. Miss Kather | 1375471152 |
| 15 | Raymond Kelly        | 1705409249 |
+----+----------------------+------------+
10 rows in set (0,00 sec)

then the go program:

import (
        "database/sql"
        "fmt"
        "log"

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

func main() {
        db, err0 := sql.Open("mysql", "msandbox:msandbox@tcp(127.0.0.1:12345)/test")
        if err0 != nil {
                log.Fatal(err0)
        }

        defer db.Close()

        row, err := db.Query("select * from user")
        if err != nil {
                panic(err)
        }

        for row.Next() {
                var id, age int
                var name string
                row.Scan(&id, &name, &age)

                fmt.Println(id, "\t", name, "\t", age)
        }

}

and the output

go run a.go
6        Wanda Lawson    583532949
7        Michael Dunn    1342458479
8        Beverly Cook    280366509
9        Carolyn Welch   1801160058
10       Ruth Moreno I II III    914091476
11       Irene Robinson I II     1022430181
12       Gerald Stewart          165910161
13       Mildred Thomas          1255569388
14       Mrs. Ms. Miss Kather    1375471152
15       Raymond Kelly   1705409249

[hyahm]

thank you very much for your answer sDatabase changed mysql> select * from user; +----+--------+------+ | id | name | age | +----+--------+------+ | 1 | cander | 45 | | 2 | cander | 45 | | 3 | cander | 45 | | 4 | cander | 45 | | 5 | cander | 45 | | 6 | cander | 45 | | 7 | cander | 45 | | 8 | cander | 45 | | 9 | cander | 45 | | 10 | cander | 45 | | 11 | cander | 45 | | 12 | cander | 45 | +----+--------+------+ At 2018-02-27 15:35:34, "INADA Naoki" <notifications@github.com> wrote: I can run your SQL without any error, with MySQL 5.7.21. Your traceback seems server returned corrupted packet. But I'm not sure. What is printed when you run SELECT * FROM user from MySQL command line? — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

[hyahm]

thank you very much for your help I know the question my id column is primary key I change it ,and it success

[methane]

@727023460 I can't get what you meaning.

Do you mean you faced the issue when you're using schema without primary key,
and the issue is disappeared when you added primary key?

(Although your comment said you're using primary key...)

[hyahm]

no, without primary key have no issue but add primary key , the issue is appeared At 2018-02-28 11:27:59, "INADA Naoki" <notifications@github.com> wrote: @727023460 I can't get what you meaning. Do you mean you faced the issue when you're using schema without primary key, and the issue is disappeared when you added primary key? (Although your comment said you're using primary key...) — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[methane]

But I and @percona-csalguero can't reproduce your issue with primary key.

By the way, how did you install MySQL 5.7.21?
I don't use Fedora, but it seems Fedora uses MariaDB.