Skip to content

DETACH PARTITION vs merges = duplicates #7415

@filimonov

Description

@filimonov

test case:

create table test2 Engine=MergeTree ORDER BY number AS SELECT number, toString(rand()) x from numbers(100000000);
alter table test2 detach partition tuple();
detach table test2; attach table test2; -- or just restart clickhouse
alter table test2 attach partition tuple();
select count() from test2;

Expected 100000000, got 200000000

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugConfirmed user-visible misbehaviour in official release

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions