Spanner Database Table Column addition recreates all other existing tables

[durjoydas]

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 the issue is assigned to the "modular-magician" user, it is either in the process of being autogenerated, or is planned to be autogenerated soon. If the issue is assigned to a user, that user is claiming responsibility for the issue. If the issue is assigned to "hashibot", a community member has claimed the issue already.

Description

• destroy and then create replacement Terraform will perform the following actions:   # module.cdh_spanner.module.spanner_dbs["robt-prod-secondary-db01"].google_spanner_database.this must be replaced -/+ resource "google_spanner_database" "this" {       ~ ddl                      = [ # forces replacement             # (3 unchanged elements hidden)             "CREATE TABLE dummy_test ( NAME STRING(1024) NOT NULL, ADDRESS STRING(1024) NOT NULL, ) PRIMARY KEY(NAME)",           - "CREATE TABLE dummy_test1 ( NAME STRING(1024) NOT NULL, ADDRESS STRING(1024) NOT NULL, ) PRIMARY KEY(NAME)",         ]       ~ id                       = "robt-prod-secondary-inst01/robt-prod-secondary-db01" -> (known after apply)         name                     = "robt-prod-secondary-db01"       ~ state                    = "READY" -> (known after apply)         # (5 unchanged attributes hidden)     } Plan: 1 to add, 0 to change, 1 to destroy.

New or Affected Resource(s)

google_spanner_database existing tables

• google_XXXXX

Potential Terraform Configuration

# Propose what you think the configuration to take advantage of this feature should look like.
# We may not use it verbatim, but it's helpful in understanding your intent.

References

• 0000

[rileykarson]

Note: DDL (https://registry.terraform.io/providers/hashicorp/google/latest/docs/resources/spanner_database#ddl) updates are append-only, recreating the resource otherwise, but are not documented as such

[zli82016]

Unassigning myself as I wasn't able to work on this one last week

[rileykarson]

The provider's working as expected here, it's just not well-documented why.

[trodge]

b/280337816