amazon-aurora / babelfish_extensions / 25739201313

77%

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%)

53835 of 69864 relevant lines covered (77.06%)

396168.67 hits per line