Skip to content

ducklake fails to update ducklake_table_column_stats table after alter table statement #625

@izidoromth

Description

@izidoromth

What happens?

Ducklake won't add columns added with the ALTER TABLE statement into the ducklake_table_column_stats table.

It happens using both duckdb or postgresql as catalog.

To Reproduce

ATTACH 'ducklake:my_ducklake.ducklake' AS my_ducklake;
USE my_ducklake;

CREATE TABLE test_table (column_one INTEGER);

INSERT INTO test_table VALUES (1);
INSERT INTO test_table VALUES (2);
INSERT INTO test_table VALUES (3);

ALTER TABLE test_table ADD COLUMN column_two INTEGER;

INSERT INTO test_table VALUES (4, 1);
INSERT INTO test_table VALUES (5, 2);
INSERT INTO test_table VALUES (6, 3);

SELECT * FROM __ducklake_metadata_my_ducklake.ducklake_table_column_stats;

OS:

Ubuntu 24.04.3 LTS

DuckDB Version:

v1.4.1

DuckLake Version:

0.3

DuckDB Client:

CLI

Hardware:

No response

Full Name:

Matheus Izidoro de Almeida

Affiliation:

Institute for Research and Urban Planning of Curitiba

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

I have tested with a stable release

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions