Cannot have last column as date

[japettyjohn]

When doing a select where the last column is a date type the value is an empty slice and results in an index out of bounds error when parsing the value into a date on line 777 of oci8.go.

[mattn]

Sorry, I don't understand well. Could you please give me the patch?

[ricsmania]

Hi mattn,

Got this same problem. The code below reproduces the error. For it to happen the query must return at least 9 fields, the last one being a date. So:
"select 1,2,3, sysdate from dual" - works
"select 1,2,3,4,5,6,7,8, sysdate from dual" - doesn't work
"select 1,2,3,4,5,6,7,8, sysdate, 11 from dual" - works

I tried debugging it but so far I can't figure it out.

Thanks!

package main

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

func main() {
    db, err := sql.Open("oci8", "system/manager@localhost:1521/orcl")
    if err != nil {
        fmt.Println(err)
    }
    defer db.Close()
    rows, err := db.Query("select 1,2,3,4,5,6,7,8, sysdate from dual")
    if err != nil {
        fmt.Println(err)
    }
    for rows.Next() {
        fmt.Println("got row")
    }
}

[mattn]

@RicardoSmania Thanks. But I can't reproduce it.

[mattn]

Should be fixed.

[ricsmania]

Hi @mattn, it is fixed for me. Thanks!