-
Notifications
You must be signed in to change notification settings - Fork 8.3k
ALTER column on temporary table with projection forever stuck #74853
Copy link
Copy link
Closed
Labels
fuzzProblem found by one of the fuzzersProblem found by one of the fuzzerspotential bugTo be reviewed by developers and confirmed/rejected.To be reviewed by developers and confirmed/rejected.unexpected behaviourResult is unexpected, but not entirely wrong at the same time.Result is unexpected, but not entirely wrong at the same time.
Description
Describe the bug
This is an issue and I can't get the stack trace somehow. Also, while the ALTER statement is stuck, querying the system.mutations table from another client gets stuck too.
A side note. A projection gets accepted with either a GROUP BY or ORDER BY clause, but if I run this: https://fiddle.clickhouse.com/df18b861-0baf-40f2-bdae-3b72c4022f9e, the error message DB::Exception: ORDER BY cannot be empty is misleading, because it can be empty.
How to reproduce
Run:
CREATE TEMPORARY TABLE t0 (c0 Int, c1 Int, PROJECTION p0 (SELECT c0 GROUP BY c0)) ENGINE = MergeTree() ORDER BY tuple();
ALTER TABLE t0 CLEAR COLUMN c0; --stuckThen from another client try:
SELECT * FROM system.mutations; --stuckError message and/or stacktrace
No response
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
fuzzProblem found by one of the fuzzersProblem found by one of the fuzzerspotential bugTo be reviewed by developers and confirmed/rejected.To be reviewed by developers and confirmed/rejected.unexpected behaviourResult is unexpected, but not entirely wrong at the same time.Result is unexpected, but not entirely wrong at the same time.