15771531976
76%
BABEL_5_X_DEV: 77%

Ran 20 Jun 2025 05:29AM UTC

Jobs 1

Files 119

Run time 1min

Badge

Embed ▾

Committed 20 Jun 2025 04:55AM UTC coverage: 75.568% (-0.003%) from 75.571%

Build # 15771531976

Build Type

push

github

Committed by

web-flow

Commit Message

Rectified sys.database_principals view which was missing SID (#3730) (#3856)

* Rectified sys.database_principals view which was missing SID

sys.database_principals.sid acts as a foreign key and links to sys.server_principals.sid
This is how SQL users are linked to their respective logins. Certain database_principals like db roles will not have a corresponding mapping in server_principals, hence they have a SID which is generated by default by sql server at creation.
In this view, we want to map the users (the defaults like dbo as well) to the server_principals. The owner of the database is the login which is linked to 'dbo'. Hence, we will be mapping the owner of the current db to 'dbo'. Other user-defined logins are already part of the view currently.

Task: BABEL-5789

Signed-off-by: Ayush Shah <ayushdsh@amazon.com>

---------

Signed-off-by: Ayush Shah <ayushdsh@amazon.com>

Run Details

48754 of 64517 relevant lines covered (75.57%)

324730.95 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
2	76.23	-0.62%	contrib/babelfishpg_tds/src/backend/tds/tdscomm.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	15771531976.1	20 Jun 2025 05:29AM UTC	119	75.57	GitHub Action Run

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

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 15771531976

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

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 15771531976

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

README BADGES
x