8000 ducked ui: Invalid Input Error: Cannot prepare multiple statements at once! · Issue #16966 · duckdb/duckdb · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

ducked ui: Invalid Input Error: Cannot prepare multiple statements at once! #16966

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.

Sign up for GitHub

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

Jump to bottom
Closed
2 tasks done
jmishra01 opened this issue Apr 3, 2025 · 1 comment
Closed
2 tasks done

ducked ui: Invalid Input Error: Cannot prepare multiple statements at once! #16966

jmishra01 opened this issue Apr 3, 2025 · 1 comment
Labels
needs triage

Comments

@jmishra01
Copy link
jmishra01 commented Apr 3, 2025 •
edited
Loading

What happens?

I try to execute PIVOT query, mention in the Duckdb's documentation, and it throw Invalid input error

Query

PIVOT cities
ON year
USING sum(population);

In terminal, PIVOT query working fine.

To Reproduce

Terminal command:
ducked -ui

CREATE TABLE cities (
    country VARCHAR, name VARCHAR, year INTEGER, population INTEGER
);
INSERT INTO cities VALUES
    ('NL', 'Amsterdam', 2000, 1005),
    ('NL', 'Amsterdam', 2010, 1065),
    ('NL', 'Amsterdam', 2020, 1158),
    ('US', 'Seattle', 2000, 564),
    ('US', 'Seattle', 2010, 608),
    ('US', 'Seattle', 2020, 738),
    ('US', 'New York City', 2000, 8015),
    ('US', 'New York City', 2010, 8175),
    ('US', 'New York City', 2020, 8772);

SELECT *
FROM cities;

PIVOT cities
ON year
USING sum(population);

OS:

Mac

DuckDB Version:

v1.2.1 8e52ec4

DuckDB Client:

UI

Hardware:

No response

Full Name:

Jitendra Mishra

Affiliation:

Lumenore

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have not tested with any build

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

  • Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

  • Yes, I have
@szarnyasg
Copy link
Collaborator

Hi @jmishra01, thanks for opening this issue. This is a duplicate of duckdb/duckdb-ui#57, please consider subscribing to that issue for updates.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
needs triage
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@szarnyasg @jmishra01
0