Open toga4 opened 11 months ago
Tagged as a bug for rotation triaging, seems kind of like a process/testing thing though. Feel free to change.
Just a friendly bump 😄
It looks like there is already a PR (https://github.com/googleapis/google-cloud-go/pull/8968 ) ready to go for this so fingers crossed that this can be resolved soon.
This issue blocks our CI pipeline because we are relying on spanner emulator which does not support ON DELETE actions. We would really like to upgrade to the latest Go spanner SDK to take advantage of the open telemetry support (https://github.com/googleapis/google-cloud-go/blob/main/spanner/CHANGES.md#1570-2024-02-13)
I am sure that we are not the only ones blocked by this.
@the-wendell FYI, this workaround might work for you:
I was able to upgrade my go spanner version by using spanner emulator version 1.5.10
, note it has to be that exact emulator version. Newer or older emulator versions break. (See https://github.com/cloudspannerecosystem/wrench/issues/95#issuecomment-1839201325 and https://github.com/GoogleCloudPlatform/cloud-spanner-emulator/issues/147#issuecomment-1839184657)
Client
Spanner spansql
Environment
Go Playground
Go Environment
Go 1.21
Code
e.g.
Expected behavior
Outputs without foreign key action
Actual behavior
Outputs with
ON DELETE NO ACTION
added.Additional context
The current behavior causes a problem when trying to apply DDL to the spanner-emulator using migration tools like wrench. Since the emulator does not support foreign key actions, this behavior results in the output of DDLs that are not accepted by the emulator.
Related to https://github.com/cloudspannerecosystem/wrench/issues/95