[Microsoft.Sql/servers/databases@2023-08-01-preview]: properties.elasticPoolId is inaccurate when using what-if

[stijnherreman]

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

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.