duckdb / duckdb/duckdb-java

Interval fields returned as `String`

Open
#580 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
127
Forks
80
Avg merge
13h 49m
Merged PRs (30d)
48

Description

### Description

DuckDB supports interval types, but the DuckDB JDBC Driver returns these fields as `String`. In comparison the PostgreSQL JDBC Driver returns a custom [`org.postgresql.util.PGInterval`](https://jdbc.postgresql.org/documentation/publicapi/org/postgresql/util/PGInterval.html) instance.

### Expectation

This makes the integrations for the DuckDB JDBC Driver problematic in certain situations. I would expect a custom class to be returned similar to the `org.duckdb.user.DuckDBUserArray`, `org.duckdb.user.DuckDBMap`, or `org.duckdb.user.DuckDBUserStruct` classes.

Even if this new class behaves the same as a `String` instance, using a different class would make it possible for the implementations to convert that to a proper `Duration` type at the end, or whatever the end-user prefers.

### Repro case

https://github.com/raszi/duckdb-interval-testcase

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.