type error in parameter puts the driver in an inconsistent state

[andybalholm]

When I send a query parameter that is the wrong type, I get an (expected) error message like "invalid input syntax for integer". But then any queries I run after that return errors too: usually something like "pq: unexpected parse response: '3'"

So apparently when the driver receives an "invalid input syntax" error, it needs to read some more messages before returning—or just close the connection and open a new one.

I'm using PostgreSQL 9.1alpha2

Sample program that exhibits this error:

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/bmizerany/pq"
)

func main() {
    db, err := sql.Open("postgres", "user=postgres dbname=postgres sslmode=disable")
    if err != nil {
        fmt.Println(err)
        return
    }

    _, err = db.Exec("create table test (i integer)")
    if err != nil {
        fmt.Println(err)
        return
    }

    _, err = db.Query("select * from test where i=$1", "hhh")
    fmt.Println(err)

    _, err = db.Query("select * from test where i=$1", 1)
    fmt.Println(err)
}

[bmizerany]

OK. That should do it. Thank you for reporting this.

[andybalholm]

On Apr 6, 2012, at 3:22 PM, Blake Mizerany wrote:

OK. That should do it. Thank you for reporting this.

It works now. Thanks for the quick fix.

Andy Balholm
(509) 276-2065
andy@balholm.com