Inconsistent whitespace handling in numeric cast from varchar

[findepi]

Whitespace is not allowed when casting to integer (or other exact numeric types including bigint, decimal)

trino> SELECT CAST(' 123' AS integer);
Query 20240911_093239_00097_snjt3 failed: Cannot cast ' 123' to INT

trino> SELECT CAST('123 ' AS integer);
Query 20240911_093248_00098_snjt3 failed: Cannot cast '123 ' to INT

trino> SELECT CAST(' 123 ' AS integer);
Query 20240911_093336_00104_snjt3 failed: Cannot cast ' 123 ' to INT

but it's allowed when casting to real, double

trino> SELECT CAST(' 123 ' AS real);
 _col0
-------
 123.0

trino> SELECT CAST(' 123 ' AS double);
 _col0
-------
 123.0