babelfish-for-postgresql / babelfish_extensions / 15353076117

74%

BABEL_5_X_DEV: 77%

Build Type

push

github

Committed by web-flow

Commit Message

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

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

(cherry picked from commit cfc65c3be)

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

Run Details

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

2 existing lines in 1 file now uncovered.

43797 of 59155 relevant lines covered (74.04%)

211818.55 hits per line