Function TestRejectTopInMySQL

pkg/sql/parser/dialect_test.go:238–247

--------------------------------------------------------------------------- TOP dialect gate --------------------------------------------------------------------------- TestRejectTopInMySQL checks that TOP is rejected when dialect is MySQL.

(t *testing.T)

// TestRejectTopInMySQL checks that TOP is rejected when dialect is MySQL.
func TestRejectTopInMySQL(t *testing.T) {
	sql := "SELECT TOP 10 id, name FROM users"
	_, err := ParseWithDialect(sql, keywords.DialectMySQL)
	if err == nil {
		t.Fatal("expected error: TOP should be rejected in MySQL dialect")
	}
	if !containsAny(err.Error(), "TOP", "mysql", "LIMIT") {
		t.Errorf("error should mention TOP or MySQL, got: %v", err)
	}
}

// TestRejectTopInPostgreSQL checks that TOP is rejected when dialect is PostgreSQL.
func TestRejectTopInPostgreSQL(t *testing.T) {