[Bug]: persistent diff when using heredoc in sql statements

[nwsparks]

trafficstars

Terraform Core Version

1.11.0

Terraform Vault Provider Version

4.8.0

Vault Server Version

1.19.2

Affected Resource(s)

• vault_database_secret_backend_role

Expected Behavior

no diff when statement doesn't change

Actual Behavior

persistent diff when no code changes

Relevant Error/Panic Output Snippet

Terraform Configuration Files

creation_statements = [
      <<-EOD
      DO $$
        BEGIN
          IF NOT EXISTS (SELECT FROM pg_roles WHERE rolname = '{{name}}') THEN
            CREATE ROLE {{name}} VALID UNTIL '{{expiration}}';
          END IF;
      END $$;
      EOD
      ,
      "GRANT ${local.role} TO {{name}};",
      "ALTER USER {{name}} WITH PASSWORD '{{password}}';",
      "ALTER ROLE {{name}} WITH LOGIN;"
    ]

Steps to Reproduce

use a creation statement with a heredoc like displayed above and apply, then apply again to see the diff.

even when it is a single list item it still does a persistent diff.

Debug Output

No response

Panic Output

No response

Important Factoids

No response

References

No response

Would you like to implement a fix?

No