babelfish-for-postgresql / babelfish_extensions / 28400413134

76%

BABEL_6_X_DEV: 77%

push

github

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

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

398042.76 hits per line