babelfish-for-postgresql / babelfish_extensions / 12548004513

74%

BABEL_5_X_DEV: 77%

Build Type

push

github

Committed by web-flow

Commit Message

Mark table_constraints_internal() function as parallel safe and set current_db_id for parallel workers (#3322)

The INFORMATION_SCHEMA_TSQL.TABLE_CONSTRAINTS_INTERNAL() function was recently introduced
but not marked as PARALLEL SAFE. This prevented the query optimizer from utilizing parallel
plans in queries involving this function, leading to suboptimal performance for certain operations.

By marking the function as PARALLEL SAFE, we enable the use of parallel query execution plans,
which can significantly improve performance for large datasets.

This commit also addresses the issue of empty result sets in queries joining with sys.db_id()
or sys.db_name() in Enforced Parallel Query mode by setting the current_db_id in addition to
current_db_name for parallel workers.

Task: BABEL-5427, BABEL-5504

Signed-off-by: Sumit Jaiswal sumiji@amazon.com

Run Details

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

1 existing line in 1 file now uncovered.

43171 of 58494 relevant lines covered (73.8%)

146174.33 hits per line