Slide 4
Slide 4 text
memefish: features
● Parse Spanner SQL
○ AST with source code location for diagnostics
○ Also, generate Spanner SQL from AST
● Check expression type and semantics in SQL
○ SELECT X + 1 FROM (SELECT “foo” AS X)
type error: operator + requires two INT64/FLOAT64
○ SELECT X, Y FROM (SELECT 1 AS X, 2 AS Y) AS T GROUP BY T.X
semantic error: cannot use non-aggregate key: Y
○ SELECT X FROM (SELECT 1 AS X), (SELECT 2 AS X)
semantic error: ambiguous name: X
4
Establish foundation to analyze Spanner SQL