memefish
memefish copied to clipboard
Incompatibility: SELECT AS VALUE is not supported
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))
^~~~~