Reply is not completely read error after running the query SELECT 1

[arianitu]

When I run the query:

create database test

I get the error:

reply is not completely read

I also get the same error when doing a drop database.

Database:
mysql Ver 15.1 Distrib 10.1.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Go version:
go version go1.6.2 darwin/amd64

OS:
OS X Yosemite: 10.10.5

I'm also using _ "github.com/ziutek/mymysql/godrv" and opened the connection with sql.Open()

[arianitu]

Here is the minimum program to reproduce this:

package main

import (
    "fmt"
    "database/sql"
    _"github.com/ziutek/mymysql/godrv"

)

func main() {
    db, err := sql.Open("mymysql", "tcp:localhost:3306*/root/password")
    if err != nil {
        fmt.Println(err)
        return
    }

    _, err = db.Exec("SELECT 1")
    if err != nil {
        fmt.Println(err)
        return
    }

    _, err = db.Exec("CREATE DATABASE test")
    if err != nil {
        fmt.Println(err)
        return
    }

}

[arianitu]

It appears SELECT 1 is the issue here actually, if I remove that, it works fine. I guess it fails on the 2nd query after execting a SELECT 1 query.

[ziutek]

You need to read result of "SELECT 1" query from server before send next query to it.

[arianitu]

So you can't use Exec to ignore results? I need to use QueryRow? I guess if it's expected behaviour of https://golang.org/pkg/database/sql/, you can close this.

I think the error is non obvious to a person using the driver regardless and should probably be changed.