Function TestNormalizeQueryHash

server/querylog_test.go:53–95

(t *testing.T)

			if got != tt.want {
				t.Errorf("classifyQuery(%q) = %q, want %q", tt.cmdType, got, tt.want)
			}
		})
	}
}

func TestNormalizeQueryHash(t *testing.T) {
	// Same query with different literal values should produce the same hash
	h1 := normalizeQueryHash("SELECT * FROM users WHERE id = 1")
	h2 := normalizeQueryHash("SELECT * FROM users WHERE id = 2")
	if h1 != h2 {
		t.Errorf("Expected same hash for queries differing only in literals, got %d and %d", h1, h2)
	}

	// Same query with different string literals
	h3 := normalizeQueryHash("SELECT * FROM users WHERE name = 'alice'")
	h4 := normalizeQueryHash("SELECT * FROM users WHERE name = 'bob'")
	if h3 != h4 {
		t.Errorf("Expected same hash for queries differing only in string literals, got %d and %d", h3, h4)
	}

	// Different queries should produce different hashes
	h5 := normalizeQueryHash("SELECT * FROM users WHERE id = 1")
	h6 := normalizeQueryHash("SELECT * FROM orders WHERE id = 1")
	if h5 == h6 {
		t.Errorf("Expected different hashes for different queries, both got %d", h5)
	}

	// Whitespace normalization
	h7 := normalizeQueryHash("SELECT  *  FROM  users  WHERE  id = 1")
	h8 := normalizeQueryHash("SELECT * FROM users WHERE id = 1")
	if h7 != h8 {
		t.Errorf("Expected same hash after whitespace normalization, got %d and %d", h7, h8)
	}

	// Case normalization
	h9 := normalizeQueryHash("select * from users where id = 1")
	h10 := normalizeQueryHash("SELECT * FROM users WHERE id = 1")
	if h9 != h10 {
		t.Errorf("Expected same hash after case normalization, got %d and %d", h9, h10)
	}

	// Keywords in IS predicates should not be normalized away as literals.
	h11 := normalizeQueryHash("SELECT * FROM users WHERE active IS TRUE")
	h12 := normalizeQueryHash("SELECT * FROM users WHERE active IS NULL")
	if h11 == h12 {
		t.Errorf("Expected different hashes for IS TRUE vs IS NULL predicates, both got %d", h11)