Source
A query using a correlated column inside a window function fails with internal error 300010:391167117
…contains a correlation. SOLUTION: To resolve this issue, avoid using correlated columns inside a window function. This can be achieved by moving the window aggregation function to the outer query.
Local timestamp functions return incorrect timezone offset value for dates after 2038
ISSUE: Incorrect value when using TRY_TO_TIMESTAMP_LTZ function for dates after 2038. The output of TRY_TO_TIMESTAMP_LTZ goes wrong starting in 2038. The hour value in the output is 23 instead of 00 and the offset is off by 1 hour.