Skip to content

ALTER column on temporary table with projection forever stuck #74853

@PedroTadim

Description

@PedroTadim

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; --stuck

Then from another client try:

SELECT * FROM system.mutations; --stuck

Error message and/or stacktrace

No response

Metadata

Metadata

Assignees

Labels

fuzzProblem found by one of the fuzzerspotential bugTo be reviewed by developers and confirmed/rejected.unexpected behaviourResult is unexpected, but not entirely wrong at the same time.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions