babelfish-for-postgresql / babelfish_extensions / 15895220318

76%

BABEL_5_X_DEV: 77%

push

github

Support empty string handling for date and time datatypes (#3881)

Add TSQL-compatible handling of empty string ('') for date and time types, defaulting to '1900-01-01' for date and time, similar to datetime, datetime2, datetimeoffset, smalldatetime.

Changes:
1. Add helper functions to initialize the default date and time variables
   and to check for strings with whitespaces.
2. Modify varchar2date() and varchar2time() to handle empty/whitespace
   casts from varchar types to date and time types.
3. Update tsql_coerce_string_literal_hook to handle empty/whitespace
   casts from string literals to date and time datatypes.
4. Default empty/whitespace strings to '1900-01-01' for date and
   '00:00:00.0000000' for time.
5. Updated existing date-time related test cases. Added more tests cases
   for wider test coverage.

Task: BABEL-3433

(cherry picked from commit 7840f56ff)

Signed-off-by: Manisha Deshpande <mmdeshp@amazon.com>

41 of 42 new or added lines in 7 files covered. (97.62%)

49224 of 64984 relevant lines covered (75.75%)

324171.76 hits per line