| 132 | } |
| 133 | |
| 134 | func TestCreateViewStatement_SQL(t *testing.T) { |
| 135 | stmt := &CreateViewStatement{ |
| 136 | Name: "v1", |
| 137 | OrReplace: true, |
| 138 | Temporary: true, |
| 139 | IfNotExists: true, |
| 140 | Columns: []string{"a", "b"}, |
| 141 | Query: &SelectStatement{Columns: []Expression{&Identifier{Name: "x"}}}, |
| 142 | WithOption: "CHECK OPTION", |
| 143 | } |
| 144 | sql := stmt.SQL() |
| 145 | for _, want := range []string{"CREATE OR REPLACE TEMPORARY VIEW", "IF NOT EXISTS", "v1 (a, b) AS", "CHECK OPTION"} { |
| 146 | if !strings.Contains(sql, want) { |
| 147 | t.Errorf("missing %q in: %s", want, sql) |
| 148 | } |
| 149 | } |
| 150 | } |
| 151 | |
| 152 | func TestCreateMaterializedViewStatement_SQL(t *testing.T) { |
| 153 | stmt := &CreateMaterializedViewStatement{ |