**Describe the bug**
```
milovidov-desktop :) SET allow_experimental_analyzer = 1

SET allow_experimental_analyzer = 1

Query id: b4494b8c-9f14-4d46-8db9-2cb992dcfcb6

Ok.

0 rows in set. Elapsed: 0.001 sec. 

milovidov-desktop :) SELECT arrayFilter(x -> notEmpty(concat(x)), [NULL, NULL]) FROM system.one ARRAY JOIN [1048577] AS elem, arrayMap(x -> concat(x, elem, ''), ['']) AS unused

SELECT arrayFilter(x -> notEmpty(concat(x)), [NULL, NULL])
FROM system.one
ARRAY JOIN
    [1048577] AS elem,
    arrayMap(x -> concat(x, elem, ''), ['']) AS unused

Query id: ca118c75-812b-4c83-bd30-1af64ed38635


0 rows in set. Elapsed: 0.003 sec. 

Received exception from server (version 22.13.1):
Code: 49. DB::Exception: Received from localhost:9000. DB::Exception: Cannot capture column 3 because it has incompatible type: got Array(UInt32), but UInt32 is expected.. (LOGICAL_ERROR)
```
identifier_lookup.identifier.getFullName(),
                table_expression_node->formatASTForErrorMessage());
        const auto & table_name = table_expression_data.table_name;
        const auto & database_name = table_expression_data.database_name;
        if (parts_size == 1 && path_start == table_name)
            return table_expression_node;
        else if (parts_size == 2 && path_start == database_name && identifier[1] == table_name)
            return table_expression_node;
        else
            return {};
    }
    auto resolve_identifier_from_storage_or_throw = [&](size_t identifier_column_qualifier_parts) -> QueryTreeNodePtr
    {
        auto identifier_view = IdentifierView(identifier);
        identifier_view.popFirst(identifier_column_qualifier_parts);
        /** Compound identifier cannot be resolved directly from storage if storage is not table.
          *
          * Example: SELECT test_table.id.value1.value2 FROM test_table;
          * In table storage column test_table.id.value1.value2 will exists.
          *
          * Example: SELECT test_subquery.compound_expression.value FROM (SELECT compound_expression AS value) AS test_subquery;
          * Here there is no column with name test_subquery.compound_expression.value, and additional wrap in tuple element is required.
          */
        ColumnNodePtr result_column;
        bool compound_identifier = identifier_view.getPartsSize() > 1;
        bool match_full_identifier = false;
        auto it = table_expression_data.column_name_to_column_node.find(std::string(identifier_view.getFullName()));
        if (it != table_expression_data.column_name_to_column_node.end())
        {
            match_full_identifier = true;