googleapis / google-cloud-go

Google Cloud Client Libraries for Go.
https://cloud.google.com/go/docs/reference
Apache License 2.0
3.78k stars 1.3k forks source link

Spanner/SpanSQL: Support CREATE VIEW with Security Type DEFINER #8661

Closed SDorgan closed 9 months ago

SDorgan commented 1 year ago

Client Spanner spansql

Environment Go Playground

Go Environment Go 1.21

Code

package main

import (
    "fmt"

    "cloud.google.com/go/spanner/spansql"
)

func main() {
    fmt.Println(spansql.ParseDDL("ddl", "CREATE VIEW myView SQL SECURITY DEFINER AS SELECT u.Name FROM Users u"))
}

https://go.dev/play/p/x_tUX5Iv8-a

Expected behavior

Parses

Actual behavior

<nil> ddl:1.32: got "DEFINER" while expecting "INVOKER"

Documentation The security type can be either INVOKER or DEFINER

SDorgan commented 9 months ago

Hi there again, sorry to bother. Is there an ETA on the fix? I see the PR's been open for a few months now