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

[Bug] Drop table column fail when table has roll up #48612

Open
2 of 3 tasks
seawinde opened this issue Mar 4, 2025 · 1 comment
Open
2 of 3 tasks

[Bug] Drop table column fail when table has roll up #48612

seawinde opened this issue Mar 4, 2025 · 1 comment
Assignees

Comments

@seawinde
Copy link
Contributor

seawinde commented Mar 4, 2025

Search before asking

  • I had searched in the issues and found no similar issues.

Version

master

What's Wrong?

CREATE TABLE t (
    id int null,
    k largeint null,
    d date null,
    k1 int
)
PARTITION BY RANGE (`id`) (
    partition p1 values [(1), (2))
)
DISTRIBUTED BY HASH(`k`, `id`) BUCKETS 16
PROPERTIES (
    "replication_num" = "1"
);

create materialized view mv_t as select d from t group by d;

alter table t add rollup rollupIndex(d);

quit reconnect and doesn't use db

alter table db.t drop column k1;

// this sql would fail
alter table db.t drop column k1;

What You Expected?

run the sql as following
alter table db.t drop column k1;
should success

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

@edmondsky
Copy link

Hi, may I take on this issue? Please assign it to me. Thanks!

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