Azure / Azure/azure-rest-api-specs
Azure SQL Database: Identity has incorrect mutability
- Dominant language
- TypeSpec
- Stars
- 3.1k
- Forks
- 5.9k
- Avg merge
- 2d 22h
- Merged PRs (30d)
- 444
Description
This is the same issue as #16803 except for the `Databases` spec instead.
The `x-ms-mutability` property on the [identity property](https://github.com/Azure/azure-rest-api-specs/blob/15ba5b8a954afb74a6bb8902038835f0cddb9930/specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/Databases.json#L806C1-L813C11) of the database defintion is set to `read` and `create`:
It is possible to set this property after creation via the portal and [powershell](https://github.com/Azure/azure-powershell/blob/main/src/Sql/Sql/Database/Cmdlet/SetAzureSqlDatabase.cs), so I think this mutability setting is in error.
Contributor guide
Research direction
Start with specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/Databases.json at the identity property, then compare the related issue #16803 and SetAzureSqlDatabase.cs. Done means the database identity's x-ms-mutability matches the portal and PowerShell behavior for changes after creation.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, openapi, sql
- Domain
- api, cloud, databases
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 45/100