CollapsingMergeTree and split_intersecting_parts_ranges #73640
Description
create table test (
key Int8,
sign Int8
) engine = CollapsingMergeTree(sign) order by key;
insert into test values (5,-1);
optimize table test final; -- to move part to a level 1, to enable optimizations
select count() from test final
format Pretty;
+---------+
| count() |
+---------+
1. | 1 | -- expected 0 (FROM FINAL should not expose sign = -1)
+---------+
select count() from test final
settings split_intersecting_parts_ranges_into_layers_final=0,
split_parts_ranges_into_intersecting_and_non_intersecting_final=0
format Pretty;
+---------+
| count() |
+---------+
1. | 0 |
+---------+split_intersecting_parts_ranges_into_layers_final = 0
split_parts_ranges_into_intersecting_and_non_intersecting_final = 1
select count() from test final
settings split_intersecting_parts_ranges_into_layers_final=0,
split_parts_ranges_into_intersecting_and_non_intersecting_final=1
format Pretty;
DB::Exception: Not found column sign in block. There are only columns: . (NOT_FOUND_COLUMN_IN_BLOCK)