14137851681
76%
BABEL_5_X_DEV: 77%

Ran 28 Mar 2025 09:37PM UTC

Jobs 1

Files 115

Run time 1min

Badge

Embed ▾

Committed 28 Mar 2025 09:04PM UTC coverage: 75.081%. Remained the same

Build # 14137851681

Build Type

push

github

Committed by

web-flow

Commit Message

handle conversion of empty string to datetime in (#3624)

The conversion of empty strings to datetime (CONVERT(datetime, '')) shows inconsistent behavior between versions 4.x and 5.x. While a previous fix addressed this across all versions, it had to be reverted due to PostgreSQL parallel worker limitations. Specifically, helper functions were executing in parallel despite being marked PARALLEL UNSAFE, and sub-transactions aren't supported in parallel workers before PG17 (per PostgreSQL community discussion).

This PR resolves the issue by implementing empty string handling directly in the sys.babelfish_conv_string_to_datetime functions, ensuring proper functionality in version 4.x while maintaining compatibility with PostgreSQL's parallel processing constraints.

Issues Resolved: BABEL-5687
Signed-off-by: Herambh Shah <herambhs@amazon.com>

Run Details

47745 of 63591 relevant lines covered (75.08%)

233372.28 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	14137851681.1	28 Mar 2025 09:37PM UTC	115	75.08	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 14137851681
76%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 14137851681

babelfish-for-postgresql / babelfish_extensions / 14137851681 76% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 14137851681

babelfish-for-postgresql / babelfish_extensions / 14137851681
76%
BABEL_5_X_DEV: 77%

README BADGES
x