Azure / Azure/azure-rest-api-specs
[sql database] When creating a database with sku set to `HS_Gen5_8` and `maxSizeBytes` set to `8796093022208`, the API returns a value of `-1` for `maxSizeBytes`.
- Dominant language
- TypeSpec
- Stars
- 3.1k
- Forks
- 5.9k
- Avg merge
- 3d 2h
- Merged PRs (30d)
- 424
Description
Swagger: https://github.com/Azure/azure-rest-api-specs/blob/main/specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/Databases.json
Put https://management.azure.com/subscriptions/xxx/resourceGroups/test/providers/Microsoft.Sql/servers/testserver/databases/testsql?api-version=2021-11-01
```
{
"location":"eastus",
"properties":{
"autoPauseDelay":-1,
"collation":"SQL_Latin1_General_CP1_CI_AS",
"createMode":"Default",
"elasticPoolId":"",
"highAvailabilityReplicaCount":4,
"isLedgerOn":false,
"licenseType":"LicenseIncluded",
"maintenanceConfigurationId":"/subscriptions/xxx/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
"maxSizeBytes":8796093022208,
"minCapacity":0,
"readScale":"Enabled",
"requestedBackupStorageRedundancy":"Geo",
"zoneRedundant":false
},
"sku":{
"name":"HS_Gen5_8"
},
"tags":{
}
}
```
Get https://management.azure.com/subscriptions/xxx/resourceGroups/test/providers/Microsoft.Sql/servers/testserver/databases/testsql?api-version=2021-11-01
```
{
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 8
},
"kind": "v12.0,user,vcore,hyperscale",
"properties": {
"collation": "SQL_Latin1_General_CP1_CI_AS",
"maxSizeBytes": -1,
"status": "Online",
"databaseId": "46e99415-f271-4f99-9823-cd0021cf7a9f",
"creationDate": "2023-05-11T03:07:38.467Z",
"currentServiceObjectiveName": "HS_Gen5_8",
"requestedServiceObjectiveName": "HS_Gen5_8",
"defaultSecondaryLocation": "westus",
"catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
"zoneRedundant": false,
"licenseType": "LicenseIncluded",
"earliestRestoreDate": "2023-05-11T03:07:38.467Z",
"readScale": "Enabled",
"highAvailabilityReplicaCount": 4,
"currentSku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 8
},
"autoPauseDelay": -1,
"currentBackupStorageRedundancy": "Geo",
"requestedBackupStorageRedundancy": "Geo",
"maintenanceConfigurationId": "/subscriptions/xxxproviders/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
"isLedgerOn": false,
"isInfraEncryptionEnabled": false
},
"location": "eastus",
"tags": {},
"id": "/subscriptions/xxx/resourceGroups/test/providers/Microsoft.Sql/servers/testserver/databases/testsql",
"name": "test2",
"type": "Microsoft.Sql/servers/databases"
}
```
Contributor guide
Research direction
Start with specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/Databases.json and inspect the maxSizeBytes definition. Compare the supplied PUT request with the GET response, focusing on the HS_Gen5_8 SKU and 8796093022208 value. Done means the discrepancy is resolved or the specification behavior is clearly accounted for.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- openapi
- Domain
- api
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100