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

[sinbai]

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"
}

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @azureSQLGitHub.

Issue Details

---

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"
}

Author:	sinbai
Assignees:	-
Labels:	question, SQL, Service Attention, customer-reported, needs-team-attention
Milestone:	-

[navba-MSFT]

Adding Service team to look into this.

[tdoshin]

@navba-MSFT May I ask what service team you added to look into this? Seems we dont have an update as of yet