Function TestDistinctOveruseRule

pkg/advisor/optimizer_test.go:259–288

--------------------------------------------------------------------------- OPT-004: SELECT DISTINCT Overuse ---------------------------------------------------------------------------

(t *testing.T)

// ---------------------------------------------------------------------------

func TestDistinctOveruseRule(t *testing.T) {
	opt := New()

	tests := []struct {
		name    string
		sql     string
		wantHit bool
	}{
		{
			name:    "DISTINCT without JOIN triggers info",
			sql:     "SELECT DISTINCT status FROM orders",
			wantHit: true,
		},
		{
			name:    "No DISTINCT does not trigger",
			sql:     "SELECT status FROM orders",
			wantHit: false,
		},
	}

	for _, tt := range tests {
		t.Run(tt.name, func(t *testing.T) {
			result := mustAnalyze(t, opt, tt.sql)
			got := hasSuggestion(result, "OPT-004")
			if got != tt.wantHit {
				t.Errorf("hasSuggestion(OPT-004) = %v, want %v for SQL %q", got, tt.wantHit, tt.sql)
			}
		})
	}
}

func TestDistinctOveruseRuleDirect(t *testing.T) {
	rule := &DistinctOveruseRule{}