duckdb / duckdb/duckdb-sqlite

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

Open
#162 1 comment 0 reactions 0 assignees View on GitHub
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:

Image

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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.