Azure / Azure/bicep-types-az

Microsoft.Sql/servers/databases minCapacity is wrong type in validation

Open
#2,136 1 comment 0 reactions 0 assignees View on GitHub
Service Attention SQL
Dominant language
TypeScript
Stars
108
Forks
44
Avg merge
18h 53m
Merged PRs (30d)
29

Description

### Resource Type

Microsoft.Sql/servers/databases

### Api Version

2023-05-01-preview

### Issue Type

Inaccurate property type(s)

### Other Notes

The validation errors says that minCapacity should be an INT type but it is a json('decimal-as-string') in the documentation and the value placed here in my bicep is '0.5' which is appropriate. It shows a warning but it should not.

### Bicep Repro

resource sqlServerDatabase 'Microsoft.Sql/servers/databases@2023-05-01-preview' = {
parent: sqlServerInstance
name: sqlServerDBName
location: location
//Let Default Tags Apply
sku: sqlServerDBSku
properties: {
collation: 'SQL_Latin1_General_CP1_CI_AS'
maxSizeBytes: 34359738368
catalogCollation: 'SQL_Latin1_General_CP1_CI_AS'
zoneRedundant: false
readScale: 'Disabled'
autoPauseDelay: 60
requestedBackupStorageRedundancy: 'Local'
minCapacity: '0.5'
isLedgerOn: false
availabilityZone: 'NoPreference'
}
}

### Confirm

- [X] I have read the troubleshooting guide and looked for duplicates.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the Microsoft.Sql/servers/databases resource definition for API version 2023-05-01-preview and trace how minCapacity is represented in validation metadata. Reproduce the warning using the Bicep example, then confirm that the documented decimal-as-string value '0.5' no longer triggers an incorrect integer-type warning.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, typescript
Domain
cloud, tooling
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.