You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
Given a sample view on a sample table like this:
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: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.
Additional context
Harlequin v1.2.5.2 on ubuntu, installed via pipx.
The text was updated successfully, but these errors were encountered: