In-memory mode doesn't support multiple queries

[tonyyang-svail]

To reproduce

package main

import (
	"database/sql"
	_ "github.com/mattn/go-sqlite3"
)

func assertNoError(e error) {
	if e != nil {
		panic(e)
	}
}

func main() {
	db, e := sql.Open("sqlite3", ":memory:")
	assertNoError(e)
	_, e = db.Exec("create table my_table (class int);")
	assertNoError(e)
	_, e = db.Query("select * from my_table") // note that I didn't close the rows
	assertNoError(e)
	_, e = db.Query("select * from my_table") // error: no such table: my_table
	assertNoError(e)
}

I don't have this issue if the database is backed by a .db file.

[rittneje]

Known issue. Has to do with Go's connection pooling. See "Why I'm getting no such table error?" in the README.

[tonyyang-svail]

@rittneje Thanks so much for the prompt reply!

[tonyyang-svail]

Duplicate of #204