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`.

Open
#23,922 4 comments 0 reactions 0 assignees View on GitHub
customer-reported needs-team-attention question Service Attention SQL
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.