Cannot select DECIMAL lists via JDBC

[michaeljohnalbers]

What happens?

When trying to run SELECT statements via JDBC where one of the selected columns is of DECIMAL[] type, the query fails throwing an exception.

To Reproduce

    public static void main(String[] args) throws SQLException{
        Connection c = DriverManager.getConnection("jdbc:duckdb:");
        try (Statement s = c.createStatement()) {
            s.execute("CREATE TABLE T1(a0 DECIMAL[])");
            s.executeQuery("SELECT * from T1");
        }
    }

Exception

Exception in thread "main" java.lang.NumberFormatException: For input string: "(18,3)[]"
	at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:67)
	at java.base/java.lang.Integer.parseInt(Integer.java:654)
	at java.base/java.lang.Short.parseShort(Short.java:137)
	at java.base/java.lang.Short.parseShort(Short.java:163)
	at org.duckdb.DuckDBColumnTypeMetaData.parseColumnTypeMetadata(DuckDBColumnTypeMetaData.java:16)
	at org.duckdb.DuckDBResultSetMetaData.<init>(DuckDBResultSetMetaData.java:38)
	at org.duckdb.DuckDBNative.duckdb_jdbc_prepared_statement_meta(Native Method)
	at org.duckdb.DuckDBPreparedStatement.prepare(DuckDBPreparedStatement.java:107)
	at org.duckdb.DuckDBPreparedStatement.executeQuery(DuckDBPreparedStatement.java:189)
	at com.modeanalytics.nugget.arrow.FlightSqlServerTest.main(FlightSqlServerTest.java:184)

OS:

MacOS Ventura 13.6

DuckDB Version:

0.9.1

DuckDB Client:

JDBC

Full Name:

Michael Albers

Affiliation:

ThoughtSpot

Have you tried this on the latest main branch?

I have tested with a main 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