```sql

create table A ( A date) Engine=MergeTree order by A TTL A+interval 1 year;

alter table A reset SETTING TTL;

show create table A;

CREATE TABLE default.A
(
    `A` Date
)
ENGINE = MergeTree
ORDER BY A
TTL A + toIntervalYear(1)
SETTINGS index_granularity = 8192
```
const DataPartStates & affordable_states,
    const DataPartsLock & ,
    DataPartStateVector * out_states,
    bool require_projection_parts) const
{
    DataPartsVector res;
    DataPartsVector buf;
    for (auto state : affordable_states)
    {
        auto range = getDataPartsStateRange(state);
        if (require_projection_parts)
        {
            for (const auto & part : range)
            {
                for (const auto & [_, projection_part] : part->getProjectionParts())
                    res.push_back(projection_part);
            }
        }
        else
        {