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

Binder error on opening view due to outdated duckdb client #728

Open
3 tasks done
ml31415 opened this issue Jan 9, 2025 · 2 comments
Open
3 tasks done

Binder error on opening view due to outdated duckdb client #728

ml31415 opened this issue Jan 9, 2025 · 2 comments

Comments

@ml31415
Copy link

ml31415 commented Jan 9, 2025

Given a sample view on a sample table like this:

CREATE TABLE test_table (
    id INTEGER,
    value1 INTEGER,
    value2 INTEGER
);
INSERT INTO test_table (id, value1, value2)
VALUES
    (1, 10, 20),
    (2, 30, NULL),
    (3, NULL, 40);
CREATE VIEW test_view AS
SELECT
    id,
    GREATEST(value1, value2) AS max_value
FROM test_table;

When I re-open the stored database as created above and run a simple SELECT * FROM test_view within harlequin, I get the following error message:

DuckDB raised an error when compiling or running your query:
Binder Error: Contents of view were altered: types don't match! Expected [INTEGER, INTEGER], but found [INTEGER, BIGINT] instead

All this works fine in the plain recent duckdb client. Forcing harlequin to use recent duckdb 1.1.3 fixes this issue. So I guess, the dependencies just should be updated.

  • I have consulted the Troubleshooting guide.
  • I have searched Issues and Discussions in this repo.
  • Feature requests should be initiated as Discussions. This is a bug report.

Additional context
Harlequin v1.2.5.2 on ubuntu, installed via pipx.

@tconbeer
Copy link
Owner

tconbeer commented Jan 9, 2025

Which version of DuckDB raised this error?

@ml31415
Copy link
Author

ml31415 commented Jan 10, 2025

0.10.3 if I remember correctly.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants