babelfish-for-postgresql / babelfish_extensions / 15889588684

77%

push

github

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


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
Signed-off-by: Manisha Deshpande <mmdeshp@amazon.com>

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

49427 of 65181 relevant lines covered (75.83%)

316536.12 hits per line