Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

spansql : unable to parse ddl of cloudspanner #11203

Open
geerttouquet opened this issue Nov 28, 2024 · 0 comments
Open

spansql : unable to parse ddl of cloudspanner #11203

geerttouquet opened this issue Nov 28, 2024 · 0 comments
Assignees
Labels
api: spanner Issues related to the Spanner API. triage me I really want to be triaged.

Comments

@geerttouquet
Copy link

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<STRING(20)>,

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<STRING(20)>,
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);

@geerttouquet geerttouquet added the triage me I really want to be triaged. label Nov 28, 2024
@product-auto-label product-auto-label bot added the api: spanner Issues related to the Spanner API. label Nov 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
api: spanner Issues related to the Spanner API. triage me I really want to be triaged.
Projects
None yet
Development

No branches or pull requests

2 participants