Closed tomrom-pomelo closed 9 months ago
When adding a spanner view like
CREATE VIEW SomeView SQL SECURITY INVOKER AS SELECT Table1.Id, Table2.SomeColumn FROM Table1 LEFT JOIN Table2 ON Table1.Id = Table2.Table1Id;
hammer diff fails with the following error:
hammer diff
Error: unexpected ddl statement: &spansql.CreateView{Name:"SomeView", OrReplace:false, Query:spansql.Query{Select:spansql.Select{Distinct:false, List:[]spansql.Expr{spansql.PathExp{"Table1", "Id"}, spansql.PathExp{"Table2", "SomeColumn"}}, From:[]spansql.SelectFrom{spansql.SelectFromJoin{Type:3, LHS:spansql.SelectFromTable{Table:"Table1", Alias:"", Hints:map[string]string(nil)}, RHS:spansql.SelectFromTable{Table:"Table2", Alias:"", Hints:map[string]string(nil)}, On:spansql.ComparisonOp{Op:4, LHS:spansql.PathExp{"Table1", "Id"}, RHS:spansql.PathExp{"Table2", "Table1Id"}, RHS2:spansql.Expr(nil)}, Using:[]spansql.ID(nil), Hints:map[string]string(nil)}}, Where:spansql.BoolExpr(nil), GroupBy:[]spansql.Expr(nil), TableSamples:[]*spansql.TableSample(nil), ListAliases:[]spansql.ID(nil)}, Order:[]spansql.Order(nil), Limit:spansql.LiteralOrParam(nil), Offset:spansql.LiteralOrParam(nil)}, Position:spansql.Position{Line:153, Offset:7819}}
Is there/will there be support for diffing and applying views?
When adding a spanner view like
hammer diff
fails with the following error:Is there/will there be support for diffing and applying views?