babelfish-for-postgresql / babelfish_extensions / 15192357426

77%

push

github

Fix AM/PM and timezone parsing for DATETIMEOFFSET (#3775)

The clean_input_str() function, while removing leading spaces,
incorrectly removes the space between AM/PM and timezone indicators
(e.g., converting "PM -07:00" to "PM-07:00"), causing the subsequent
date parser function `ParseDateTime` to fail to recognize the components
completely.

Modified the space-handling logic in clean_input_str() to preserve
spaces before timezone indicators in datetimeoffset context, provided
that the time information has already been seen (after encountering
colons in the input string). This ensures the timezone offset remains
properly separated from the preceding time information, allowing
`ParseDateTime` to correctly parse both components.

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

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

48612 of 64487 relevant lines covered (75.38%)

306527.01 hits per line