NullPointerException when reading JDBC ResultSet.getDate() from a Timestamp column

[lukaseder]

What happens?

This error occurs:

Exception in thread "main" java.lang.NullPointerException: Cannot load from object array because "this.varlen_data" is null
	at org.duckdb.DuckDBVector.getLazyString(DuckDBVector.java:224)
	at org.duckdb.DuckDBVector.getDate(DuckDBVector.java:280)
	at org.duckdb.DuckDBResultSet.getDate(DuckDBResultSet.java:366)
	at org.jooq.testscripts.JDBC.main(JDBC.java:42)

To Reproduce

try (Statement s = connection.createStatement();
    ResultSet rs = s.executeQuery("select now()")
) {
    while (rs.next()) {
        System.out.println(rs.getDate(1));
    }
}

Replace the call to rs.getDate(1) by rs.getTimestamp(1) as a workaround.

Note: I couldn't test with 0.10.1-SNAPSHOT due to duckdb/duckdb#11244

OS:

Microsoft Windows [Version 10.0.22631.3296]

DuckDB Version:

0.10.0

DuckDB Client:

JDBC

Full Name:

Lukas Eder

Affiliation:

Data Geekery

Have you tried this on the latest nightly build?

I have tested with a release build (and could not test with a nightly build)

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• Yes, I have

[lukaseder]

Related issue:

• NullPointerException when reading ResultSet.getInt() from GENERATE_SERIES query duckdb#7218

I think it would be worth reviewing all of these reasonable type conversions in the JDBC ResultSet.

[github-actions]

This issue is stale because it has been open 90 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions]

This issue was closed because it has been stale for 30 days with no activity.

[staticlibs]

@lukaseder

Hi Lukas, it is nice to meet you, we interacted in the past when I was packaging OpenJDK for Windows at Red Hat and you were (justifiably) complaining about the lack of transparency in those builds. This problem with getDate() should be fixed by #166. Overall your JDBC expertise is appreciated, I will look into other issues you created.

[lukaseder]

Hi Lukas, it is nice to meet you, we interacted in the past when I was packaging OpenJDK for Windows at Red Hat and you were (justifiably) complaining about the lack of transparency in those builds

I have no recollection of such an incident, I'm afraid 😅.

Thanks for looking into this

[staticlibs]

I have no recollection of such an incident, I'm afraid 😅.

I've looked up and found the reference in SO comments 😃.

BTW, I've submitted #168 PR to cover spatial types requested in #37.