babelfish-for-postgresql / babelfish_extensions / 17848039869

77%

Build Type

push

github

Committed by web-flow

Commit Message

Support Select Top N Percent  (#4041)

Description
This PR implements comprehensive support for SELECT TOP N PERCENT syntax in Babelfish, addressing JIRA-BABEL-1358. The implementation adds percentage-based row limiting functionality to align with SQL Server behavior.

Problem
Babelfish previously only supported SELECT TOP N (fixed count) but lacked support for SELECT TOP N PERCENT (percentage-based limiting), which is a commonly used SQL Server feature for selecting a percentage of rows from result sets.

Related Links -
Engine Link - babelfish-for-postgresql/postgresql_modified_for_babelfish#615

Issue: BABEL-1358
Signed-off-by: Herambh Shah <herambhs@amazon.com>

Run Details

93 of 96 new or added lines in 1 file covered. (96.88%)

1 existing line in 1 file now uncovered.

51082 of 66797 relevant lines covered (76.47%)

380820.79 hits per line