Skip to content

Group id as an optional parameter scim_identities and scim_oauth_access_tokens

Smriti Garg requested to merge smriti/378597_group_id_optional_parameter_scimidentity_table into master

What does this MR do and why?

Solves Issue #378597 (closed)

Migration Output

main: == 20221107115247 ChangeScimIdentityGroupIdRemoveNull: migrating ==============
main: -- change_column_null(:scim_identities, :group_id, true)
main:    -> 0.0011s
main: == 20221107115247 ChangeScimIdentityGroupIdRemoveNull: migrated (0.0013s) =====

main: == 20221107115413 ChangeScimOauthAccessTokenGroupIdRemoveNull: migrating ======
main: -- change_column_null(:scim_oauth_access_tokens, :group_id, true)
main:    -> 0.0004s
main: == 20221107115413 ChangeScimOauthAccessTokenGroupIdRemoveNull: migrated (0.0004s)

Queries introduced and Query plan

select * from scim_identities;

https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/13191/commands/46267

select * from scim_identities where LOWER(extern_uid) = LOWER('00upybvbrb0slHYgn0h7')

https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/13231/commands/46417

Edited by Smriti Garg

Merge request reports