azurerm_mssql_database max_size_gb doesn't allow 100MB or 500MB values

[flcdrg]

Is there an existing issue for this?

• I have searched the existing issues

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave comments along the lines of "+1", "me too" or "any updates", they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment and review the contribution guide to help.

Terraform Version

1.9.8

AzureRM Provider Version

3.89.0

Affected Resource(s)/Data Source(s)

azurerm_mssql_database

Terraform Configuration Files

resource "azurerm_mssql_database" "database" {
  name        = "sqldb"
  server_id   = azurerm_mssql_server.mssql.id
  sku_name    = "Basic"
  max_size_gb = 0 # or 0.1 or 0.5
}

Debug Output/Panic Output

-

Expected Behaviour

It should be possible to specify 100MB or 500MB as a database size (as per the Azure Portal

Actual Behaviour

Error: expected max_size_gb to be in the range (1 - 4096), got 0

or

Error: Attribute must be a whole number, got 0.1

Steps to Reproduce

terraform plan

Important Factoids

No response

References

When using Azure Portal, you can specify 100MB which evaluates to maxBytes 104857600, or 500MB, which evaluates to maxBytes 524288000

[Chambras]

Hi @flcdrg have you tried with the latest version? 3.89.0 is kind of old :)

[flcdrg]

Just tested with 3.117.0

Trying 0.1 results in validation error "Error: Attribute must be a whole number, got 0.1"
Trying 0 results in validation error "Error: expected max_size_gb to be in the range (1 - 4096), got 0"

[flcdrg]

And for good measure 4.14.0

Trying 0 results in validation error "Error: expected max_size_gb to be in the range (1 - 4096), got 0"
and trying 0.5 results in validation error "Error: Attribute must be a whole number, got 0.5"

So latest provider does not seem to help.