perma-diff on google_sql_database_instance resource password_validation_policy setting

[Klaitos]

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 +1 or me too comments, 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.
• If an issue is assigned to a user, that user is claiming responsibility for the issue.
• Customers working with a Google Technical Account Manager or Customer Engineer can ask them to reach out internally to expedite investigation and resolution of this issue.

Terraform Version & Provider Version(s)

Terraform v1.9.8
on arm

• provider registry.terraform.io/hashicorp/google v6.13.0
• provider registry.terraform.io/hashicorp/google-beta v6.13.0

Affected Resource(s)

google_sql_database_instance

Terraform Configuration

resource "google_sql_database_instance" "instance" {
  name             = "test"
  region           = "europe-west1"
  database_version = "POSTGRES_17"

    password_validation_policy {
      min_length                  = 8
      reuse_interval              = 2
      complexity                  = "COMPLEXITY_DEFAULT"
      disallow_username_substring = true
      password_change_interval    = "21600s"
      enable_password_policy      = true
    }
}

Debug Output

No response

Expected Behavior

Provider does not want to remove password policy as it not exists

Actual Behavior

The provider show a remove block on the password policy

Steps to reproduce

1. terraform apply
2. remove the password policy block
   3.terraform apply
   3.terraform apply , the password policy show as not deleted in plan

Important Factoids

No response

References

No response