memefish icon indicating copy to clipboard operation
memefish copied to clipboard

Incompatibility: SELECT AS VALUE is not supported

Open apstndb opened this issue 5 months ago • 0 comments

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 input

SELECT * FROM (SELECT AS VALUE STRUCT(123 AS a, FALSE AS b))

Current error

syntax error::1:26: expected token: STRUCT, but: <ident>

  1:  SELECT * FROM (SELECT AS VALUE STRUCT(123 AS a, FALSE AS b))
                               ^~~~~

apstndb avatar Sep 12 '24 16:09 apstndb