[Microsoft.Sql/servers/databases@2023-08-01-preview]: properties.elasticPoolId is inaccurate when using what-if
- 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-08-01-preview
### Issue Type
Other
### Other Notes
When using `what-if` for the initial creation, `properties.elasticPoolId` is missing.
```
+ Microsoft.Sql/servers/.../databases/foo [2023-08-01-preview]
apiVersion: "2023-08-01-preview"
id: "/subscriptions/.../resourceGroups/.../providers/Microsoft.Sql/servers/.../databases/foo"
location: "westeurope"
name: "foo"
type: "Microsoft.Sql/servers/databases"
```
When using `what-if` for subsequent updates, `properties.elasticPoolId` is marked as Noeffect.
```
= Microsoft.Sql/servers/.../databases/foo [2023-08-01-preview]
x properties.elasticPoolId: "/subscriptions/.../resourceGroups/.../providers/Microsoft.Sql/servers/.../elasticPools/..."
```
### Bicep Repro
```bicep
resource database 'Microsoft.Sql/servers/databases@2023-08-01-preview' = {
name: 'foo'
parent: sqlServer
location: defaultLocation
properties: {
elasticPoolId: elasticPool.id
}
}
```
### 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 Bicep reproduction and the Microsoft.Sql/servers/databases@2023-08-01-preview type definition. Run what-if for both initial creation and a subsequent update, then trace how properties.elasticPoolId is represented in each result. Done means the property is present for creation and is not incorrectly marked Noeffect for updates.
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