[Go] How to use prepared statements with timestamps

[si-fernandes]

Describe the usage question you have. Please include as many useful details as possible.

Hello,

I'm trying to implement a prepared statement that has a timestamp parameter.
I have prepared statements working with strings, but with timestamps I'm getting a schema mismatch error.
I'm using v14.

The query for the prepared statement is SELECT * FROM x where name = $1 AND $2 <= timestamp.
I have no problems with the first parameter.
I'm building the second parameter using the type arrow.FixedWidthTypes.Timestamp_ns.
I've tried passing a time.Time as the value and it failed. Then I tried an arrow.Timestamp but that also failed with the same error.

The error I'm getting is:

Parameter schema does not equal Placeholder schema. (...) 
Received: (...) Field {name: \"$2\", data_type: Timestamp(Nanosecond, Some(\"UTC\")), nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }
Expected: (...)Field { name: \"$2\", data_type: Timestamp(Nanosecond, None), nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }

I would like to know what's the best way to overcome this timezone difference in the schemas.

Thank you

EDIT:
I have also tried casting the timestamp to timestamptz in the query, but that leads to the mismatch

Received: Timestamp(Nanosecond, Some(\"UTC\"))
Expected: Timestamp(Nanosecond, Some(\"+00:00\"))

Component(s)

Go

[srimal-randoli]

@si-fernandes I'm experiencing the same issue. Were you able to find any solution for this?

[zeroshade]

Given the error shown:

Parameter schema does not equal Placeholder schema. (...) 
Received: (...) Field {name: \"$2\", data_type: Timestamp(Nanosecond, Some(\"UTC\")), nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }
Expected: (...)Field { name: \"$2\", data_type: Timestamp(Nanosecond, None), nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }

You should be able to just create a timestamp type with no time zone to solve it:

&arrow.TimestampType{Unit: arrow.Nanosecond}

The default arrow.FixedWidthTypes.Timestamp_ns uses a Time zone of "UTC" whereas constructing the timestamp type yourself will leave the time zone as the empty string, which would match the expected None from your error.

If that doesn't work, can you provide the code you're using to make the call and what flight SQL server you're calling?

[srimal-randoli]

@zeroshade I'm using GizmoSQL(https://github.com/gizmodata/gizmosql) as my FlightSQL server with a DuckDB backend. Here is my code. And it seems like the ADBC driver is unable to handle time.Time values.

package main

import (
	"context"
	"database/sql"
	"fmt"
	"log"
	"testing"
	"time"

	_ "github.com/apache/arrow-adbc/go/adbc/sqldriver/flightsql"
)

var dsnTemplate = "uri=grpc://%s;username=%s;password=%s"

const (
	FLIGHT_SQL_USER = "gizmosql_username"
	FLIGHT_SQL_PASS = "password123"
	FLIGHT_SQL_HOST = "localhost:31337"
)

// This example uses Go's native SQL driver
func TestFlightSQL(t *testing.T) {
	dsn := fmt.Sprintf(dsnTemplate,
		FLIGHT_SQL_HOST,
		FLIGHT_SQL_USER,
		FLIGHT_SQL_PASS,
	)

	db, err := sql.Open("flightsql", dsn)
	if err != nil {
		log.Fatalf("opening a connection failed: %v", err)
	}

	defer db.Close()

	timestamp := time.Now()

	// Table schema
	// CREATE TABLE IF NOT EXISTS flight_test.events (id INTEGER, event_time TIMESTAMP)
	result, err := db.ExecContext(context.Background(), `INSERT INTO flight_test.events (id, event_time) VALUES (1, $1)`, timestamp)
	if err != nil {
		log.Fatal(err)
	}

	log.Print(result)
}

This is the output

=== RUN   TestFlightSQL
2025/07/06 07:13:16 sql: converting argument $1 type: Invalid Argument: expected parameter of type timestamp[us]
FAIL	gitlab.com/srimaln91/flight-sql-client	0.046s

[zeroshade]

This is being handled by the driver in arrow-adbc, see here

[zeroshade]

Closing this as this issue is handled downstream by the driver in arrow-adbc (see apache/arrow-adbc#3109).