Function parseSQLWithDialect

pkg/sql/parser/select_helpers_test.go:44–68

----------------------------------------------------------------------------- helpers ----------------------------------------------------------------------------- parseSQLWithDialect tokenizes and parses sql using the given dialect, returning the first SelectStatement from the resulting AST.

(t *testing.T, sql string, dialect keywords.SQLDialect)

// parseSQLWithDialect tokenizes and parses sql using the given dialect,
// returning the first SelectStatement from the resulting AST.
func parseSQLWithDialect(t *testing.T, sql string, dialect keywords.SQLDialect) *ast.SelectStatement {
	t.Helper()
	tkz, err := tokenizer.NewWithDialect(dialect)
	if err != nil {
		t.Fatalf("tokenizer.NewWithDialect(%s): %v", dialect, err)
	}
	tokens, err := tkz.Tokenize([]byte(sql))
	if err != nil {
		t.Fatalf("tokenize(%q): %v", sql, err)
	}
	p := NewParser(WithDialect(string(dialect)))
	defer p.Release()
	result, err := p.ParseFromModelTokens(tokens)
	if err != nil {
		t.Fatalf("parse(%q): %v", sql, err)
	}
	if len(result.Statements) == 0 {
		t.Fatalf("expected at least one statement, got none")
	}
	stmt, ok := result.Statements[0].(*ast.SelectStatement)
	if !ok {
		t.Fatalf("expected *ast.SelectStatement, got %T", result.Statements[0])
	}
	return stmt
}

// -----------------------------------------------------------------------------
// parseDistinctModifier