amazon-aurora / babelfish_extensions / 28386047059

76%

main: 77%

push

github

fix: Add range validation in DATE to DATETIME2 cast (#4799)

CAST(DATE AS DATETIME2) hangs for dates outside the valid datetime2
range (0001-01-01 to 9999-12-31) because the multiplication
dateVal * USECS_PER_DAY overflows int64.

Add a pre-multiplication bounds check in date_datetime2() to raise
'data out of range for datetime2' for out-of-range input dates.

Task: BABEL-4527

Signed-off-by: Kristian Lejao <klejao@amazon.com>

4 of 4 new or added lines in 1 file covered. (100.0%)

50834 of 66556 relevant lines covered (76.38%)

398894.65 hits per line