babelfish-for-postgresql / babelfish_extensions / 12645695682

77%

push

github

Fix behaviour of DATEDIFF() and DATEDIFF_BIG() functions for week and quarter dateparts (#3357)

1. Issues
DATEDIFF() and DATEDIFF_BIG() functions return incorrect results when using 'week' and 'quarter' as datepart unit.
DATEDIFF_BIG() function gives wrong error message in case of overflow.
2. Changes made to fix the issues
Fix calculation logic for considering a week if a Saturday-Sunday boundaries crossed.
Fix calculation logic for considering a quarter if a quarter boundary crossed.
Fix error message for DATEDIFF_BIG() function in case of overflow.

Added Test Cases for these issues
Task: BABEL- 5461, BABEL-5503
Authored-by: Anikait Agrawal agraani@amazon.com
Signed-off-by: Anikait Agrawal agraani@amazon.com

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

46640 of 62288 relevant lines covered (74.88%)

165429.42 hits per line