Function TestRejectLimitInSQLServer

pkg/sql/parser/dialect_test.go:194–203

--------------------------------------------------------------------------- LIMIT dialect gate --------------------------------------------------------------------------- TestRejectLimitInSQLServer checks that LIMIT is rejected when the dialect is explicitly set to SQL Server.

(t *testing.T)

// TestRejectLimitInSQLServer checks that LIMIT is rejected when the dialect is
// explicitly set to SQL Server.
func TestRejectLimitInSQLServer(t *testing.T) {
	sql := "SELECT id, name FROM users LIMIT 10"
	_, err := ParseWithDialect(sql, keywords.DialectSQLServer)
	if err == nil {
		t.Fatal("expected error: LIMIT should be rejected in SQL Server dialect")
	}
	if !containsAny(err.Error(), "LIMIT", "SQL Server", "TOP", "FETCH") {
		t.Errorf("error should mention LIMIT or SQL Server, got: %v", err)
	}
}

// TestAcceptLimitInMySQL checks that LIMIT is accepted in MySQL dialect.
func TestAcceptLimitInMySQL(t *testing.T) {