Catalog Error: Scalar Function with name unixepoch does not exist!

[cboden]

What happens?

When loading a SQLite database that has a view using the unixepoch function, the CLI bails on every call.

Catalog Error: Scalar Function with name unixepoch does not exist!
Did you mean "union_extract"?

To Reproduce

Create a test database

sqlite3 test.db

Setup the schema

CREATE TABLE whoops (time INTEGER);
INSERT INTO whoops VALUES ('2024-09-12');
CREATE VIEW ts AS SELECT unixepoch(time) FROM whoops;
SELECT * FROM ts;

Open with DuckDB

duckdb test.db

Run any operation:

SHOW TABLES;

OS:

macOS

SQLite Version:

3.41.2

DuckDB Version:

1.1.0

DuckDB Client:

CLI

Full Name:

Chris Boden

Affiliation:

I am using this for a hobby application: https://brewed.today

Have you tried this on the latest main branch?

• I agree

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

• I agree