Always reproduced (ClickHouse server version 22.3.2.1):
`
udf code, python version 3.9.6
#!/usr/bin/python

import sys
import time

if __name__ == '__main__':
    for line in sys.stdin:
        print("Python4 " + line, end='')
        sys.stdout.flush()
`

SELECT test_function_python('clickhouse')

Query id: 57da3834-1238-4da6-a984-48d4c1bb4a04

┌─test_function_python('clickhouse')─┐
│ Python4 clickhouse                 │
└────────────────────────────────────┘

1 rows in set. Elapsed: 0.001 sec.

SELECT test_function_python('clickhouse') AS uuu
GROUP BY uuu

Query id: c14131e5-e7aa-4585-a9f5-8e4b3e29fe44


0 rows in set. Elapsed: 0.002 sec.

Received exception from server (version 22.3.2):
Code: 46. DB::Exception: Received from 10.254.134.108:9000. DB::Exception: Unknown function test_function_python. (UNKNOWN_FUNCTION)


SELECT uuu
FROM
(
    SELECT test_function_python('clickhouse') AS uuu
) AS tmp
GROUP BY uuu

Query id: 20ca737b-35e1-418a-ab8e-2a296ac44e28

┌─uuu────────────────┐
│ Python4 clickhouse │
└────────────────────┘

1 rows in set. Elapsed: 0.002 sec.
optimizeWithConstraints(select_query, result.aliases, result.source_columns_set,
            tables_with_columns, result.storage_snapshot->metadata, settings.optimize_append_index);
        if (settings.optimize_substitute_columns)
            optimizeSubstituteColumn(select_query, result.aliases, result.source_columns_set,
                tables_with_columns, result.storage_snapshot->metadata, result.storage);
    }
    
    optimizeGroupBy(select_query, context);
    
    if (settings.optimize_group_by_function_keys)
        optimizeGroupByFunctionKeys(select_query);
    
    if (settings.optimize_move_functions_out_of_any)
        optimizeAnyFunctions(query);
    if (settings.optimize_normalize_count_variants)
        optimizeCountConstantAndSumOne(query);
    if (settings.optimize_rewrite_sum_if_to_count_if)
        optimizeSumIfFunctions(query);
    
    if (settings.optimize_injective_functions_inside_uniq)
        optimizeInjectiveFunctionsInsideUniq(query, context);
    
    if (settings.optimize_aggregators_of_group_by_keys
        && !select_query->group_by_with_totals
        && !select_query->group_by_with_rollup
        && !select_query->group_by_with_cube)
    {
        optimizeAggregateFunctionsOfGroupByKeys(select_query, query);
    }