"Scalar Function with name randomblob does not exist!" when inserting from duckdb to sqlite.

[kylejbrk]

What happens?

I have a table that was created in sqlite. The table uses the randomblob as a default type for the id field.
when i go to insert some values from duckdb i run into the following error:

is there a way i can still write to this table from duckdb? unfortunately the table needs to keep that default type.

To Reproduce

In sqlite:

CREATE TABLE test_default (
    id INTEGER PRIMARY KEY,
    token BLOB DEFAULT (randomblob(16))
);

In DuckDB:

ATTACH 'test.db' AS test (TYPE sqlite);

INSERT INTO test.test_default
values (1, 2);

OS:

macOS

SQLite Version:

3.38.1

DuckDB Version:

1.3.2

DuckDB Client:

DBT

Full Name:

Kyle Burke

Affiliation:

None

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

[kylejbrk]

I found a workaround for this was to just make a python udf with the same name.