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.
String key = toString(hash.first) + '_' + toString(hash.second);
            group_by_hashes.insert(key);
        }
    }
    auto sorting_key_columns = result.storage_snapshot ? result.storage_snapshot->metadata->getSortingKeyColumns() : Names{};
    bool is_sorting_key_prefix = true;
    for (size_t i = 0; i < order_by->children.size(); ++i)
    {
        auto * order_by_element = order_by->children[i]->as<ASTOrderByElement>();
        auto & ast_func = order_by_element->children[0];
        if (!ast_func->as<ASTFunction>())
            continue;
        if (i >= sorting_key_columns.size() || ast_func->getColumnName() != sorting_key_columns[i])
            is_sorting_key_prefix = false;
        
        
        if (is_sorting_key_prefix)
            continue;
        MonotonicityCheckVisitor::Data data{tables_with_columns, context, group_by_hashes};
        MonotonicityCheckVisitor(data).visit(ast_func);
        if (!data.isRejected())
        {
            ast_func = data.identifier->clone();
            ast_func->setAlias("");
            if (!data.monotonicity.is_positive)
                order_by_element->direction *= -1;
        }
    }
}
void optimizeRedundantFunctionsInOrderBy(const ASTSelectQuery * select_query, ContextPtr context)