babelfish-for-postgresql / babelfish_extensions / 26067206742

77%

push

github

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

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

53860 of 69934 relevant lines covered (77.02%)

617459.25 hits per line