Fix issue with google.golang.org/protobuf v1.36.X+

[codyoss]

When we upgrade our bazel codegen to this new version we get a strange compile error from our gapic targets. Running bazelisk build --sandbox_debug //google/bigtable/admin/v2:admin_go_gapic generates lots of error like: cannot use name (type string) as type int32 in field value. This happens for all LROs. For now we are manually patching in an old version but this should be removed ASAP once we have identified the defect.

[codyoss]

Correction from the previous comment. This is currently only affecting targets that use LROs AND import any well known proto type. This kinda makes sense as it is the update to the protobuf Go lib that is causing this bug to appear.

This is also not reproducible with the standard Go toolchain. Said another way, this seems to be some sort of dependency/linking problem in the Bazel Go ecosystem. There is a lot of magic in this space with backed in gazelle overrides and custom overrides on imports that it is making it difficult to figure out the root cause of the issue.

I git bisected the Go protobuf code and the commit that breaks our Bazel builds seems to be the introduction of the opaque API: eb7b4686555aa65a6adcb9d68f209a61d5ca37ec