Function TestParseTopClause_Basic

pkg/sql/parser/select_helpers_test.go:132–146

----------------------------------------------------------------------------- parseTopClause ----------------------------------------------------------------------------- TestParseTopClause_Basic checks a simple TOP n clause (SQL Server dialect).

(t *testing.T)

// TestParseTopClause_Basic checks a simple TOP n clause (SQL Server dialect).
func TestParseTopClause_Basic(t *testing.T) {
	stmt := parseSQLWithDialect(t,
		"SELECT TOP 10 id, name FROM users",
		keywords.DialectSQLServer,
	)
	if stmt.Top == nil {
		t.Fatal("expected non-nil TopClause")
	}
	if stmt.Top.IsPercent {
		t.Error("IsPercent should be false")
	}
	if stmt.Top.WithTies {
		t.Error("WithTies should be false")
	}
}

// TestParseTopClause_Percent checks TOP n PERCENT.
func TestParseTopClause_Percent(t *testing.T) {