memefish

memefish copied to clipboard

[](https://renovatebot.com) Welcome to [Renovate](https://togithub.com/renovatebot/renovate)! This is an onboarding PR to help you understand and configure settings before regular Pull Requests begin. 🚦 To activate Renovate, merge this Pull Request....

renovate-bot

I think many identifiers are needed to update to permit [FQNs(Full Qualified Names)](https://cloud.google.com/spanner/docs/schema-and-data-model#named-schemas) to achieve compatibility to current GoogleSQL dialect. Additionally, memefish should supports [`CREATE SCHEMA`, and `DROP SCHEMA`](https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language#schema_statements) DDL...

apstndb

This PR implements #98 except DDLs. I want to separate `{CREATE | DROP} PROPERTY GRAPH` DDL to another PR. * [x] `GRAPH_TABLE` operator * [x] Graph subqueries as GoogleSQL expression...

apstndb

[Spanner Graph](https://cloud.google.com/blog/products/databases/announcing-spanner-graph?hl=en) introduces ISO GQL and SQL/PGQ subsets to Cloud Spanner. It is coexists with queries and DDLs of GoogleSQL, so I think it is better to be implemented by...

apstndb

This incompatibility is detected by #90. ## Spec https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language#model_statements ``` { CREATE MODEL | CREATE OR REPLACE MODEL | CREATE MODEL IF NOT EXISTS } model_name [INPUT ( column_list )...

apstndb

This incompatibility is detected by #90. ## Spec https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language#create-change-stream ``` CREATE CHANGE STREAM change_stream_name [ FOR { table_columns [, ... ] | ALL } ] [ OPTIONS ( change_stream_option [,...

apstndb

This incompatibility is detected by #90. ## Spec https://cloud.google.com/spanner/docs/reference/standard-sql/functions-reference#safe_prefix ## Reproducing input ``` CREATE TABLE T ( id INT64, string_field STRING(MAX), gen BYTES(MAX) AS (SAFE.MD5(string_field)) STORED, ) PRIMARY KEY(id); ```...

apstndb

## Spec https://cloud.google.com/spanner/docs/reference/standard-sql/query-syntax#select_list ``` SELECT[ compute_hint_expr ] [ { ALL | DISTINCT } ] [ AS { typename | STRUCT | VALUE] } ] select_list ``` https://cloud.google.com/spanner/docs/reference/standard-sql/query-syntax#select_as_value https://cloud.google.com/spanner/docs/reference/standard-sql/query-syntax#value_tables ## Reproducing...

apstndb

This incompatibility is detected by #90. ## Spec It is not explicitly written in DDL reference, but it is supported with/without `NOT NULL`. https://cloud.google.com/spanner/docs/generated-column/how-to#modify-generated-column ## Reproducing input ``` ALTER TABLE...

apstndb

This incompatibility is detected by #90. ## Spec https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language#alter_table ``` ALTER TABLE table_name action where action is: ... DROP [ COLUMN ] column_name ... ``` ## Reproducing input ``` ALTER...

apstndb