Function TestGetSQLFunctionSignature

pkg/lsp/handler_test.go:647–674

TestGetSQLFunctionSignature tests function signature lookup

(t *testing.T)

// TestGetSQLFunctionSignature tests function signature lookup
func TestGetSQLFunctionSignature(t *testing.T) {
	functions := []string{
		"COUNT", "SUM", "AVG", "MIN", "MAX",
		"COALESCE", "NULLIF", "CAST", "SUBSTRING",
		"TRIM", "UPPER", "LOWER", "LENGTH", "CONCAT",
		"ROW_NUMBER", "RANK", "DENSE_RANK", "LAG", "LEAD",
		"FIRST_VALUE", "LAST_VALUE", "NTILE",
	}

	for _, fn := range functions {
		t.Run(fn, func(t *testing.T) {
			sig := getSQLFunctionSignature(fn)
			if sig == nil {
				t.Errorf("expected signature for %s, got nil", fn)
				return
			}
			if sig.Label == "" {
				t.Errorf("expected non-empty label for %s", fn)
			}
		})
	}

	// Test unknown function
	sig := getSQLFunctionSignature("UNKNOWN_FUNCTION")
	if sig != nil {
		t.Error("expected nil for unknown function")
	}
}