googleapis / googleapis/google-cloud-go

spansql : can't parse normalize function in golang

Open
#9,768 2 comments 0 reactions 1 assignee Claimed by @rahul2393 View on GitHub
api: spanner triage me
Dominant language
Go
Stars
4.5k
Forks
1.6k
Avg merge
1d 13h
Merged PRs (30d)
109

Description

**Client**

spansql

**Environment**

**Go Environment**

$ go version
go version go1.21.4 windows/386

$ go env

**Code**

If you want to parse following sql
CREATE TABLE person
(
personId STRING( MAX) NOT NULL,
nickName STRING( MAX),
nickNameSearchTerm2 STRING( MAX) AS (NORMALIZE(nickName,NFD)) STORED,
) PRIMARY KEY(personId);`,

spansql.ParseDDL gives following error
got "(" while expecting ")"

You can't use ,NORMALIZE(nickName,NFD in the function code
other action succeeds well

is it possible to allow NORMALIZE in the expression

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.