What happens?

Create a table with a computed column, then run a query on duckdb_columns(). The following error ensues:

SQL Error: FATAL Error: Failed: database has been invalidated because of a previous fatal error. The database must be restarted prior to being used again.
Original error: "INTERNAL Error: Calling DefaultValue() on a generated column"

This is a regression in 0.9.0-SNAPSHOT (using the JDBC driver). It didn't happen in 0.8.1

To Reproduce

create table t (i int, j int as (1));
select * from duckdb_columns;

OS:

Microsoft Windows [Version 10.0.22621.2134]

DuckDB Version:

0.9.0-SNAPSHOT

DuckDB Client:

JDBC

Full Name:

Lukas Eder

Affiliation:

Data Geekery

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