(UnExpected Behaviour) Data deletion on the reference table

### IOT data ingestion

i have the following set up for tables

kafka engine table -> material view -> raw json table with merge engine with ttl of 7 days
Raw json table - > material view -> rollup table with merge engine with ttl of 18 months

on the roll up table i have only 7 days data available is this the expected behaviour, as per the document , the unerlying table only inserts the record, is it also delete the records based on the view we provide?

### Describe the unexpected behaviour

it should contain all the data for last 18 month, but it is only having 7 days of data?

### Which ClickHouse versions are affected?

25.4.2.31

### How to reproduce

kafka engine table -> material view -> raw json table with merge engine with ttl of 7 days
Raw json table - > material view -> rollup table with merge engine with ttl of 18 months

### Expected behavior

_No response_

### Error message and/or stacktrace

No errors

### Additional context

_No response_