Unimplemented type for cast (INTERVAL -> TIME)

[guenp]

In the ODBC spec (see sqlext.h), the data type INTERVAL has the same data type identifier as TIME. When casting a DuckDB INTERVAL to an ODBC INTERVAL, I get the following error:

ODBC: ERROR [22007] ODBC_DuckDB->GetDataStmtResult Not implemented Error: Unimplemented type for cast (INTERVAL -> TIME)

Repro steps:

1. Create a new DuckDB database with an INTERVAL variable:

create or replace table test AS (
    select
        x * (INTERVAL 5 HOUR) as customer_interval_field
    from generate_series(1, 10) g(x)
);

2. Load the data into Power Query with the following script:

let
    Database = "path\to\test.db",
    OdbcDatasource = DuckDB.Contents(Database)
in
    OdbcDatasource{[Item="test"]}[Data]

3. This throws the error:

ODBC: ERROR [22007] ODBC_DuckDB->GetDataStmtResult Not implemented Error: Unimplemented type for cast (INTERVAL -> TIME)

This may need to be addressed in the DuckDB ODBC driver.

Related to #5 .

[guenp]

A similar error when using a TIME field:

ODBC: ERROR [22007] ODBC_DuckDB->GetDataStmtResult Not implemented Error: Unimplemented type for cast (TIME -> DATE)

[guenp]

Similar issue when using UUID field:

Unimplemented type for cast (UUID -> DOUBLE)

[guenp]

There was a related workaround needed for the Tableau connector: https://github.com/MotherDuck-Open-Source/duckdb-tableau-connector/blob/main/tableau_connectors/duckdb_jdbc/dialect.tdd

[guenp]

Here is a related issue with TIMESTAMP that I was able to reproduce: duckdb/duckdb#9963

[guenp]

Relevant issue: https://community.fabric.microsoft.com/t5/Desktop/Duration-type-columns-are-not-recognized-from-an-ODBC-connection/td-p/2156211

[guenp]

Most recent screenshot post-fix (also casting UUID to VARCHAR):