dell123 :) create table dt_overflow(d Date, i int) engine MergeTree partition by d order by i;

CREATE TABLE dt_overflow
(
    `d` Date,
    `i` int
)
ENGINE = MergeTree
PARTITION BY d
ORDER BY i

Query id: db7e8b24-f7d1-4fed-a20b-6d79e8249e70

Ok.

0 rows in set. Elapsed: 0.048 sec.

dell123 :) insert into dt_overflow values('2106-11-11', 1);

INSERT INTO dt_overflow VALUES

Query id: 0574a991-158a-4cc4-88d7-ef7fa39c0d88

Ok.

1 rows in set. Elapsed: 0.005 sec.

dell123 :) select * from dt_overflow;

SELECT *
FROM dt_overflow

Query id: c9d2111e-d79d-4d18-85ea-043c24f96f5f

┌──────────d─┬─i─┐
│ 2106-02-07 │ 1 │
└────────────┴───┘

1 rows in set. Elapsed: 0.003 sec.

dell123 :) insert into dt_overflow values('2106-11-12', 1);

INSERT INTO dt_overflow VALUES

Query id: 005e5882-89fe-47d0-84ee-878fb28ecbf8


Received exception from server (version 20.13.1):
Code: 246. DB::Exception: Received from localhost:9000. DB::Exception: Partition value mismatch between two parts with the same partition ID. Existing part: 21060207_1_1_0, newly added part: 21060207_2_2_0.

1 rows in set. Elapsed: 0.385 sec.

dell123 :)