22.4.5

```sql
SELECT dummy
FROM cluster(test_cluster_two_shards, system.one)
WHERE dummy IN (
    SELECT dummy
    FROM cluster(test_cluster_two_shards, system.one)
)
LIMIT 1 BY dummy
SETTINGS distributed_product_mode = 'local'


Received exception from server (version 22.4.5):
Code: 43. DB::Exception: Received from localhost:9000. 
DB::Exception: Cannot create column of type Set. (ILLEGAL_TYPE_OF_ARGUMENT)

```

22.3.4.20
```sql
SELECT dummy
FROM cluster(test_cluster_two_shards, system.one)
WHERE dummy IN (
    SELECT dummy
    FROM cluster(test_cluster_two_shards, system.one)
)
LIMIT 1 BY dummy
SETTINGS distributed_product_mode = 'local'

┌─dummy─┐
│     0 │
└───────┘
```
bool hasGlobalSubqueries() { return has_global_subqueries; }
    bool hasTableJoin() const { return syntax->ast_join; }
    bool useGroupingSetKey() const { return aggregation_keys_list.size() > 1; }
    const NamesAndTypesList & aggregationKeys() const { return aggregation_keys; }
    bool hasConstAggregationKeys() const { return has_const_aggregation_keys; }
    const NamesAndTypesLists & aggregationKeysList() const { return aggregation_keys_list; }
    const AggregateDescriptions & aggregates() const { return aggregate_descriptions; }
    std::unique_ptr<QueryPlan> getJoinedPlan();
    
    const TemporaryTablesMapping & getExternalTables() const { return external_tables; }
    ActionsDAGPtr simpleSelectActions();
    
    void appendSelect(ExpressionActionsChain & chain, bool only_types);
    
    ActionsDAGPtr appendProjectResult(ExpressionActionsChain & chain) const;
    
    void makeSetsForIndex(const ASTPtr & node);
private:
    StorageMetadataPtr metadata_snapshot;
    
    NameSet required_result_columns;
    SelectQueryOptions query_options;
    JoinPtr makeTableJoin(
        const ASTTablesInSelectQueryElement & join_element,
        const ColumnsWithTypeAndName & left_columns,
        ActionsDAGPtr & left_convert_actions);
    const ASTSelectQuery * getAggregatingQuery() const;
    /** These methods allow you to build a chain of transformations over a block, that receives values in the desired sections of the query.
      *
      * Example usage: