
**Describe what's wrong**

I am testing projection. An exception was found during query: ```DB::Exception: Not found column toStartOfHour(datetime) in block.```

**Does it reproduce on recent release?**

v22.3.4.20-lts


**How to reproduce**

* My ClickHouse server version is 22.3.4.20 and 22.7.1

```
CREATE TABLE video_log
(
 `datetime` DateTime, -- 20,000 records per second
 `user_id` UInt64, -- Cardinality == 100,000,000
 `device_id` UInt64, -- Cardinality == 200,000,000
 `domain` LowCardinality(String), -- Cardinality == 100
 `bytes` UInt64, -- Ranging from 128 to 1152
 `duration` UInt64 -- Ranging from 100 to 400
)
ENGINE = MergeTree
PARTITION BY toDate(datetime) -- Daily partitioning
ORDER BY (user_id, device_id); -- Can only favor one column here

CREATE TABLE rng
(
 `user_id_raw` UInt64,
 `device_id_raw` UInt64,
 `domain_raw` UInt64,
 `bytes_raw` UInt64,
 `duration_raw` UInt64
)
ENGINE = GenerateRandom(1024);

INSERT INTO video_log SELECT
 toUnixTimestamp(toDateTime(today()))
 + (rowNumberInAllBlocks() / 20000),
 user_id_raw % 100000000 AS user_id,
 device_id_raw % 200000000 AS device_id,
 domain_raw % 100,
 (bytes_raw % 1024) + 128,
 (duration_raw % 300) + 100
FROM rng
LIMIT 17280000;

ALTER TABLE video_log ADD PROJECTION p_norm
 (
 SELECT
 datetime,
 device_id,
 bytes,
 duration
 ORDER BY device_id
 );

ALTER TABLE video_log MATERIALIZE PROJECTION p_norm;

ALTER TABLE video_log ADD PROJECTION p_agg
 (
 SELECT
 toStartOfHour(datetime) AS hour,
 domain,
 sum(bytes),
 avg(duration)
 GROUP BY
 hour,
 domain
 );

ALTER TABLE video_log MATERIALIZE PROJECTION p_agg;

```
```

SELECT
    toStartOfHour(datetime) AS hour,
    sum(bytes),
    avg(duration)
FROM video_log
WHERE (toDate(hour) = today()) AND (device_id = '100')
GROUP BY hour

Query id: ffc3bc0c-26cf-4415-9a00-d2184130c30d


0 rows in set. Elapsed: 0.035 sec. 

Received exception from server (version 22.7.1):
Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column toStartOfHour(datetime) in block. (NOT_FOUND_COLUMN_IN_BLOCK)

```



const StorageInMemoryMetadata & new_metadata, const StorageInMemoryMetadata & old_metadata, bool attach) const
{
    if (!new_metadata.sorting_key.definition_ast)
        throw Exception("ORDER BY cannot be empty", ErrorCodes::BAD_ARGUMENTS);
    KeyDescription new_sorting_key = new_metadata.sorting_key;
    KeyDescription new_primary_key = new_metadata.primary_key;
    size_t sorting_key_size = new_sorting_key.column_names.size();
    size_t primary_key_size = new_primary_key.column_names.size();
    if (primary_key_size > sorting_key_size)
        throw Exception("Primary key must be a prefix of the sorting key, but its length: "
            + toString(primary_key_size) + " is greater than the sorting key length: " + toString(sorting_key_size),
            ErrorCodes::BAD_ARGUMENTS);
    NameSet primary_key_columns_set;
    for (size_t i = 0; i < sorting_key_size; ++i)
    {
        const String & sorting_key_column = new_sorting_key.column_names[i];
        if (i < primary_key_size)
        {
            const String & pk_column = new_primary_key.column_names[i];
            if (pk_column != sorting_key_column)
                throw Exception("Primary key must be a prefix of the sorting key, but the column in the position "
                    + toString(i) + " is " + sorting_key_column +", not " + pk_column,
                    ErrorCodes::BAD_ARGUMENTS);
            if (!primary_key_columns_set.emplace(pk_column).second)
                throw Exception("Primary key contains duplicate columns", ErrorCodes::BAD_ARGUMENTS);
        }
    }
    auto all_columns = new_metadata.columns.getAllPhysical();