Provider constraints are incompatible with the latest beta-private cluster submodule

[clausstrommer]

TL;DR

The latest beta-private-cluster submodule has the version constraint >= 5.0.0 of hashicorp/google and hashicorp/google-beta. The SQL submodules have the version constraint < 5.0.0 for those modules.

Expected behavior

Google submodules should not have mutually exclusive provider version constraints.

Observed behavior

Version constraint resolution fails with

│ Error: Failed to query available provider packages
│ 
│ Could not retrieve the list of available versions for provider
│ hashicorp/google: no available releases match the given constraints >=
│ 3.33.0, >= 3.39.0, >= 3.43.0, >= 3.53.0, >= 3.79.0, >= 3.83.0, >= 4.0.0, >=
│ 4.18.0, >= 4.25.0, >= 4.41.0, != 4.49.0, >= 4.51.0, >= 4.64.0, >= 4.80.0,
│ >= 5.0.0, < 5.0.0, < 6.0.0
╵

╷
│ Error: Failed to query available provider packages
│ 
│ Could not retrieve the list of available versions for provider
│ hashicorp/google-beta: no available releases match the given constraints >=
│ 3.43.0, >= 3.79.0, >= 4.64.0, >= 4.80.0, >= 5.0.0, < 5.0.0, < 6.0.0

Terraform Configuration

module "sql" {
  source  = "GoogleCloudPlatform/sql-db/google//modules/postgresql"
  version = ">= 15.0"

  (any minimal configuration you wish to use)
}

module "gke" {
  source  = "terraform-google-modules/kubernetes-engine/google//modules/beta-private-cluster"
  version = ">= 17.2"

  (any minimal configuration you wish to use)
}

### Terraform Version

```sh
1.5.x

Additional information

Published dependency versions:

• GKE private-beta v29.0.0
• CloudSQL v17.0.0

[clausstrommer]

Additional info: The version dependencies in master have been updated, but this is not reflected in the published version of the submodules.

[navilg]

private-cluster module and postgresql module's google version's are conflicting. One needs hashicorp/google version >= 5.0.0 and one needs < 5.0.0.

Any workaround we can use until next release ? I see its mitigated in master branch but not yet released.

[g-awmalik]

We'll be releasing upgraded modules supporting v5 soon. Please watch this PR

[g-awmalik]

All modules should now be pulling tgp version >= 5 with v17.0.1