Wrong ROW_NUMBER for SELECT upon using CAST()

SELECT CAST('.00000000000000000000000000000000000001e111111111111111111111' AS DECIMAL(38,0)) AS a;

The above statement gives ROW_NUMBER=0 and also incorrect warning message (0).
Branch: bb-10.7-row_number