"Scalar Function with name randomblob does not exist!" when inserting from duckdb to sqlite.
- Dominant language
- C
- Stars
- 291
- Forks
- 45
- Avg merge
- 10h 13m
- Merged PRs (30d)
- 18
Description
### 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?
- [x] 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?
- [x] I agree
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.