Function TestRejectILIKEInMySQL

pkg/sql/parser/dialect_test.go:311–320

--------------------------------------------------------------------------- ILIKE dialect gate --------------------------------------------------------------------------- TestRejectILIKEInMySQL checks that ILIKE is rejected in MySQL mode.

(t *testing.T)

// TestRejectILIKEInMySQL checks that ILIKE is rejected in MySQL mode.
func TestRejectILIKEInMySQL(t *testing.T) {
	sql := "SELECT * FROM users WHERE name ILIKE '%alice%'"
	_, err := ParseWithDialect(sql, keywords.DialectMySQL)
	if err == nil {
		t.Fatal("expected error: ILIKE should be rejected in MySQL dialect")
	}
	if !containsAny(err.Error(), "ILIKE", "PostgreSQL", "LIKE", "mysql") {
		t.Errorf("error should mention ILIKE or MySQL, got: %v", err)
	}
}

// TestRejectILIKEInSQLServer checks that ILIKE is rejected in SQL Server mode.
func TestRejectILIKEInSQLServer(t *testing.T) {