15757886306
77%

Ran 19 Jun 2025 01:04PM UTC

Jobs 1

Files 119

Run time 1min

Badge

Embed ▾

Committed 19 Jun 2025 12:29PM UTC coverage: 75.658%. Remained the same

Build # 15757886306

Build Type

push

github

Committed by

web-flow

Commit Message

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

* 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

48974 of 64731 relevant lines covered (75.66%)

317383.52 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	15757886306.1	19 Jun 2025 01:04PM UTC	119	75.66	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 15757886306
77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 15757886306

babelfish-for-postgresql / babelfish_extensions / 15757886306 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 15757886306

babelfish-for-postgresql / babelfish_extensions / 15757886306
77%

README BADGES
x