| 28 | } |
| 29 | |
| 30 | func TestFormatSQLWithDialect_SQLServer(t *testing.T) { |
| 31 | tree, err := ParseSQL("SELECT * FROM users u") |
| 32 | if err != nil { |
| 33 | t.Fatalf("parse: %v", err) |
| 34 | } |
| 35 | stmt := tree.Statements[0] |
| 36 | if err := Apply(stmt, SetLimit(100)); err != nil { |
| 37 | t.Fatalf("apply: %v", err) |
| 38 | } |
| 39 | |
| 40 | got := FormatSQLWithDialect(stmt, keywords.DialectSQLServer) |
| 41 | if !strings.Contains(got, "TOP 100") { |
| 42 | t.Errorf("sqlserver: expected TOP 100, got: %s", got) |
| 43 | } |
| 44 | if strings.Contains(got, "LIMIT") { |
| 45 | t.Errorf("sqlserver: should not contain LIMIT, got: %s", got) |
| 46 | } |
| 47 | } |
| 48 | |
| 49 | func TestFormatSQLWithDialect_Oracle(t *testing.T) { |
| 50 | tree, err := ParseSQL("SELECT * FROM users u") |