googleapis / googleapis/google-cloud-go

spanner :spansql.ParseDLL unable to parse ddl of cloudspanner : columns with types ARRAY<STRING(20)>

Open
#11,203 1 comment 0 reactions 1 assignee Claimed by @harshachinta 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

in spansql v1.55.0 the following ddl can be parsed without any problem
with the recent version the spansql.ParseDDL gives now an error that it can not parse '"STRING"

the problem is the column formularies ARRAY,

tthe ddl statement of the cloudspanner table

CREATE TABLE samV2CompoundingFormula (
compoundingFormulaId STRING(MAX) NOT NULL,
productId STRING(MAX),
code STRING(MAX) NOT NULL,
codeType STRING(MAX) NOT NULL,
synonym STRING(MAX) NOT NULL,
language STRING(MAX) NOT NULL,
rank INT64 NOT NULL,
formularies ARRAY,
send_clientId STRING(MAX) NOT NULL,
send_clientVersion STRING(MAX) NOT NULL,
send_middleTierId STRING(MAX) NOT NULL,
send_middleTierVersion STRING(MAX) NOT NULL,
send_sessionId STRING(MAX) NOT NULL,
send_tenantId STRING(MAX) NOT NULL,
send_entityId STRING(MAX),
send_userId STRING(MAX) NOT NULL,
send_userRoleId STRING(MAX) NOT NULL,
send_version TIMESTAMP NOT NULL OPTIONS (
allow_commit_timestamp = true
),
validFrom TIMESTAMP NOT NULL,
validTo TIMESTAMP,
samVersion STRING(MAX),
) PRIMARY KEY(compoundingFormulaId DESC);

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.