test ALL the databases

With "github.com/mattn/go-sqlite3" driver: --- FAIL: TestPreparedStmt_SQLite (0.01 seconds) sql_test.go:306: Insert: database is locked

With "github.com/gwenn/gosqlite" driver (and sqlite3_log activated): === RUN TestPreparedStmt_SQLite LOG: Library used incorrectly, Dangling statement (not finalize): "INSERT INTO t (count) VALUES (?)" ... --- FAIL: TestPreparedStmt_SQLite (0.01 seconds) sql_test.go:306: Insert: The database file is locked: database is locked

I am using the weekly.2012-02-22 branch and SQLite 3.7.10.

The 'sel' Stmt locks the 'ins' Stmt because the 'sel' Stmt is "busy" (not reset/close).

A solution may be to Reset the 'sel' Stmt when '*Row#Scan' is called/finished but currently there is no such method in the Stmt interface. And the Stmt#Exec seems buggy: the connection is closed but not the associated Stmt!

Regards.

I want to use Sourcegraph for go-sql-test code search, browsing, and usage examples. Can an admin enable Sourcegraph for this repository? Just go to https://sourcegraph.com/github.com/bradfitz/go-sql-test. (It should only take 30 seconds.)

Thank you!

This is a cgo-based Postgres driver with support for LISTEN/NOTIFY. I'm a little hesitant to put in this pull request since building this package depends on libpq being installed in a normal place, but I suppose you have the same issue with the included go-sqlite driver.

Hi,

go version go1.11.3 linux/amd64

goroutine 16 [running]: github.com/ibmdb/go_ibm_db/api.SQLBindCol.func1(0x4000100010001, 0xc00005c338, 0xc000000004, 0xc00005c318, 0x4edfa0) /home/rakhil/go/src/github.com/ibmdb/go_ibm_db/api/zapi_unix.go:26 +0x4c github.com/ibmdb/go_ibm_db/api.SQLBindCol(0x4000100010001, 0xc00005c338, 0x4, 0xc00005c318, 0x0) /home/rakhil/go/src/github.com/ibmdb/go_ibm_db/api/zapi_unix.go:26 +0x59 github.com/ibmdb/go_ibm_db.(*BufferLen).Bind(0xc00005c318, 0x10001, 0x0, 0x440004, 0xc00005c338, 0x4, 0x8, 0xc000010350) /home/rakhil/go/src/github.com/ibmdb/go_ibm_db/column.go:29 +0x62 github.com/ibmdb/go_ibm_db.(*BindableColumn).Bind(0xc00005c300, 0x10001, 0x0, 0xc00005c300, 0x0, 0x0) /home/rakhil/go/src/github.com/ibmdb/go_ibm_db/column.go:202 +0x6c github.com/ibmdb/go_ibm_db.(*ODBCStmt).BindColumns(0xc000096140, 0x7d9de0, 0x0) /home/rakhil/go/src/github.com/ibmdb/go_ibm_db/odbcstmt.go:148 +0x1eb github.com/ibmdb/go_ibm_db.(*Stmt).Query(0xc0000802d0, 0x7d9de0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0) /home/rakhil/go/src/github.com/ibmdb/go_ibm_db/stmt.go:93 +0xe5 database/sql.ctxDriverStmtQuery(0x513000, 0xc000016168, 0x513100, 0xc0000802d0, 0x7d9de0, 0x0, 0x0, 0x0, 0x0, 0x0, ...) /work/rakhil/go/src/database/sql/ctxutil.go:94 +0x16b database/sql.rowsiFromStatement(0x513000, 0xc000016168, 0x512f00, 0xc000010290, 0xc00005c240, 0x0, 0x0, 0x0, 0x0, 0x0, ...) /work/rakhil/go/src/database/sql/sql.go:2511 +0x159 database/sql.(*Stmt).QueryContext(0xc0000a8000, 0x513000, 0xc000016168, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0) /work/rakhil/go/src/database/sql/sql.go:2463 +0x203 database/sql.(*Stmt).QueryRowContext(0xc0000a8000, 0x513000, 0xc000016168, 0x0, 0x0, 0x0, 0xc000016248) /work/rakhil/go/src/database/sql/sql.go:2521 +0x6d database/sql.(*Stmt).QueryRow(0xc0000a8000, 0x0, 0x0, 0x0, 0x0) /work/rakhil/go/src/database/sql/sql.go:2540 +0x61 main.main.func1(0xc0000a8000, 0xc0000a8090, 0xc00001c2a0) /home/rakhil/go/src/github.com/bradfitz/go-sql-test/src/akh.go:46 +0x87 created by main.main /home/rakhil/go/src/github.com/bradfitz/go-sql-test/src/akh.go:43 +0x472

THE DRIVER WORKS FINE FOR WINDOWS BUT IT PRODUCES THE ABOVE ERROR FOR LINUX.

Thanks

Hello, I don't know if you can reproduce the following problem. On my laptop, the tests fail: --- FAIL: TestPreparedStmt_SQLite (7.96 seconds) sql_test.go:367: Insert: database is locked sql_test.go:367: Insert: database is locked sql_test.go:367: Insert: database is locked sql_test.go:367: Insert: database is locked

I can make it passed by increasing the busy timeout in mattn driver:

diff --git a/sqlite3.go b/sqlite3.go
index 0a21d23..7532039 100644
--- a/sqlite3.go
+++ b/sqlite3.go
@@ -120,7 +120,7 @@ func (d *SQLiteDriver) Open(dsn string) (driver.Conn, error) {
                return nil, errors.New("sqlite succeeded without returning a database")
        }

-       rv = C.sqlite3_busy_timeout(db, 5000)
+       rv = C.sqlite3_busy_timeout(db, 10000)
        if rv != C.SQLITE_OK {
                return nil, errors.New(C.GoString(C.sqlite3_errmsg(db)))
        }

Regards.

Hi , I have added my driver in your src path and have written functions to my driver but why it is not picking up my driver insted it is picking ziutek driver.

runtime/cgo exec: "gcc": executable file not found in %PATH% github.com/ziutek/mymysql/native ..\github.com\ziutek\mymysql\native\codecs.go:286:3: cannot fallthrough final case in switch FAIL sqltest [build failed]

Thanks

This PR adds support for github.com/denisenkom/go-mssqldb, a pure Go driver for SQL Server.

I've updated the README with instructions for creating the database and setting the environment variables that the tests expect to be present.

The tests expect port 1433, the default port for the default SQL Server instance, to be listening on localhost; if the port is not open, then the tests will not run. The tests run against a database named gosqltest. The username and password are specified using environment variables named GOSQLTEST_MSSQL_USER and GOSQLTEST_MSSQL_PASS, respectively. GOSQLTEST_MSSQL_USER must be set, but GOSQLTEST_MSSQL_PASS does not; the tests will use a default password of gosqltest if the environment variable is not set.

I ran these tests on an OS X machine that had port 1433 forwarded to a Vagrant machine running SQL Server.

should go-sql-test also verify time.Time struct's location? As I've found that lib/pq has inconsistent behavior on retrieving datetime and time type column (https://github.com/lib/pq/issues/251)