Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

inserting data from generate_series into motherduck table returns error #542

Open
wuputah opened this issue Jan 15, 2025 · 0 comments
Open
Labels
bug Something isn't working MotherDuck Issues related to MotherDuck

Comments

@wuputah
Copy link
Collaborator

wuputah commented Jan 15, 2025

Description

Given:

CREATE TABLE md (i integer) USING duckdb;

An insert using generate_series call will fail as follows:

INSERT INTO md SELECT generate_series(1, 1000);
ERROR:  (PGDuckDB/Duckdb_ExecCustomScan) Conversion Error: Unimplemented type for cast (BIGINT[] -> INTEGER)
LINE 1: INSERT INTO my_db.main.md (i) SELECT generate_series(1, 1000) AS generate...

Most likely, this would have to be fixed in duckdb itself, since I think this is a mismatch between Postgres and DuckDB behavior, but posting here first.

@wuputah wuputah added bug Something isn't working MotherDuck Issues related to MotherDuck labels Jan 15, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working MotherDuck Issues related to MotherDuck
Projects
None yet
Development

No branches or pull requests

1 participant