`DROP TABLE if exists default.test_20221226 on cluster clickhouse;
CREATE TABLE default.test_20221226 on cluster clickhouse
(
   uid Int64,
   start Int64,
   end Int64,
   ck_insert_time DateTime default now()
)
ENGINE = ReplacingMergeTree(ck_insert_time)
ORDER BY (uid, start)
;

DROP TABLE if exists default.test_20221226_all on cluster clickhouse;
CREATE TABLE default.test_20221226_all on cluster clickhouse AS default.test_20221226
ENGINE = Distributed('clickhouse', 'default', 'test_20221226', cityHash64(uid))
;

DROP DICTIONARY if exists default.test_20221226_dict on cluster clickhouse;
CREATE DICTIONARY default.test_20221226_dict on cluster clickhouse
(
    uid Int64,
    start Int64,
    end Int64,
    ck_insert_time DateTime
)
PRIMARY KEY uid
SOURCE(CLICKHOUSE(HOST 'localhost' PORT 9000 USER 'default' PASSWORD 'default' DB 'default' TABLE 'test_20221226_all' UPDATE_FIELD 'ck_insert_time' UPDATE_LAG 60))
LIFETIME(MIN 10 MAX 60)
LAYOUT(RANGE_HASHED())
RANGE(MIN start MAX end)
;

INSERT INTO default.test_20221226_all(uid,start,end) values (1, 0, 100),(1, 101,200),(2,0,999),(2,1000,10000);

select * from default.test_20221226_all ;
uid	start	end	ck_insert_time
1	0	100	2022-12-26 11:38:34
1	101	200	2022-12-26 11:38:34
2	0	999	2022-12-26 11:38:34
2	1000	10000	2022-12-26 11:38:34

select * from default.test_20221226_dict ;
uid	start	end	ck_insert_time
1	0	100	2022-12-26 11:38:34
1	101	200	2022-12-26 11:38:34
2	0	999	2022-12-26 11:38:34
2	1000	10000	2022-12-26 11:38:34

`

after the DICTIONARY update. (one minute later)

`
select * from default.test_20221226_all ;
uid	start	end	ck_insert_time
1	0	100	2022-12-26 11:38:34
1	101	200	2022-12-26 11:38:34
2	0	999	2022-12-26 11:38:34
2	1000	10000	2022-12-26 11:38:34

select * from default.test_20221226_dict ;
uid	start	end	ck_insert_time
1	101	200	2022-12-26 11:38:34
2	1000	10000	2022-12-26 11:38:34

`

the result in dict is wrong, missing the first range for each PRIMARY KEY.

somthing wrong in my create sql? or a bug for this version. because i have used this plan in version 21.11.4.14, that's greats on it,



getFullName(),
                dict_struct.range_min->type->getName());
        auto * range_max_column_typed = typeid_cast<RangeColumnType *>(range_max_column.get());
        if (!range_max_column_typed)
            throw Exception(ErrorCodes::TYPE_MISMATCH,
                "Dictionary {} range max column type should be equal to {}",
                getFullName(),
                dict_struct.range_max->type->getName());
        auto & key_to_index_column_data = key_to_index_column->getData();
        auto & range_min_column_data = range_min_column_typed->getData();
        auto & range_max_column_data = range_max_column_typed->getData();
        const auto & container = std::get<KeyAttributeContainerType<RangeStorageType>>(key_attribute.container);
        const auto & invalid_intervals_container = std::get<InvalidIntervalsContainerType<RangeStorageType>>(key_attribute.invalid_intervals_container);
        keys.reserve(element_count);
        key_to_index_column_data.reserve(element_count);
        range_min_column_data.reserve(element_count);
        range_max_column_data.reserve(element_count);
        for (const auto & key : container)
        {
            for (const auto & [interval, index] : key.getMapped())
            {
                keys.emplace_back(key.getKey());
                key_to_index_column_data.emplace_back(index);
                range_min_column_data.push_back(interval.left);
                range_max_column_data.push_back(interval.right);
            }
        }
        for (const auto & invalid_interval_with_key : invalid_intervals_container)
        {
            keys.emplace_back(invalid_interval_with_key.key);