google_sql_database_instance Unremovable deprecation warning for require_ssl about terraform-provider-google HOT 3 OPEN

Confirmed issue!

According to terraform registry require_ssl is optional, but after creating the resource, and then when we attempt to remove the field it results on an error 400:

Error, failed to update instance settings for : googleapi: Error 400: Invalid request: For a Postgres instance, sslMode value TRUSTED_CLIENT_CERTIFICATE_REQUIRED and requireSsl value false are conflicting. When sslMode=TRUSTED_CLIENT_CERTIFICATE_REQUIRED, requireSsl must be true. When requireSsl=false, sslMode must be ALLOW_UNENCRYPTED_AND_ENCRYPTED or ENCRYPTED_ONLY. It's recommended that you only set sslMode.

from terraform-provider-google.

I have the same issue with CloudSQL MySQL while using Terraform 1.8.2 while using sslMode only:

Error: Error, failed to update instance settings for : googleapi: Error 400: Invalid request: For a MySQL instance, sslMode value TRUSTED_CLIENT_CERTIFICATE_REQUIRED and requireSsl value false are conflicting. When sslMode=TRUSTED_CLIENT_CERTIFICATE_REQUIRED, requireSsl must be true. When requireSsl=false, sslMode must be ALLOW_UNENCRYPTED_AND_ENCRYPTED or ENCRYPTED_ONLY. It's recommended that you only set sslMode., invalid

and while using sslMode with require_ssl I got a warning:

require_ssl will be fully deprecated in a future major release. For now, please use ssl_mode with a compatible require_ssl value instead.

from terraform-provider-google.

Looks like this issue is related to Conflict between require_ssl and ssl_mode settings for google_sql_database_instance #17443.

from terraform-provider-google.