There is no error under Decimal v2 when there is an overflow when casting String to Decimal

select cast(123 as decimal(2, 0));
ERROR: UDF ERROR: Decimal expression overflowed

select cast("123" as decimal(2, 0))
+-----------------------------+
| cast('123' as decimal(2,0)) |
+-----------------------------+
| NULL                        |
+-----------------------------+