[Microsoft.Sql/servers/databases]: minCapacity should be decimal as string, instead of int | null

[danim-hub]

Resource Type

Microsoft.Sql/servers/databases

Api Version

2023-05-01-preview

Issue Type

Inaccurate property type(s)

Other Notes

The property type is indicated as json('decimal-as-string') in https://learn.microsoft.com/en-us/azure/templates/microsoft.sql/servers/databases?pivots=deployment-language-bicep.
I have it defined as '0.5', and I have the warning

main.bicep(195,18) : Warning BCP036: The property "minCapacity" expected a value of type "int | null" but the provided value is of type "string". If this is a resource type definition inaccuracy, report it using https://aka.ms/bicep-type-issues. [https://aka.ms/bicep/core-diagnostics#BCP036]

Bicep Repro

main.bicep extract:

resource database 'Microsoft.Sql/servers/databases@2023-05-01-preview' = {
  parent: dbServer
  location: location
  name: '${prefix}-db-${suffix}'
  properties: {
    collation: collation
    maxSizeBytes: maxSizeBytes
    sampleName: sampleName
    zoneRedundant: zoneRedundant
    licenseType: licenseType
    readScale: readScaleOut
    highAvailabilityReplicaCount: numberOfReplicas
    minCapacity: minCapacity
    autoPauseDelay: autoPauseDelay
    requestedBackupStorageRedundancy: requestedBackupStorageRedundancy
    isLedgerOn: false
    availabilityZone: availabilityZone
    useFreeLimit: useFreeLimit
    freeLimitExhaustionBehavior: freeLimitExhaustionBehavior
    maintenanceConfigurationId: maintenanceConfigurationId
  }
  sku: {
    name: skuName
    tier: tier
  }
}

main.bicepparam extract:

param minCapacity string = '0.5'

Confirm

• I have read the troubleshooting guide and looked for duplicates.