Function TestKeywords_WindowFunctionKeywords

pkg/sql/keywords/keywords_test.go:500–533

TestKeywords_WindowFunctionKeywords tests Phase 2.5 window function keywords

(t *testing.T)

// TestKeywords_WindowFunctionKeywords tests Phase 2.5 window function keywords
func TestKeywords_WindowFunctionKeywords(t *testing.T) {
	k := New(DialectGeneric, true)

	// Window function keywords
	windowKeywords := []string{
		"OVER", "ROWS", "RANGE", "CURRENT", "ROW", "UNBOUNDED",
		"PRECEDING", "FOLLOWING",
	}

	for _, word := range windowKeywords {
		if !k.IsKeyword(word) {
			t.Errorf("Window keyword %q should exist", word)
		}
		if !k.IsReserved(word) {
			t.Errorf("Window keyword %q should be reserved", word)
		}
	}

	// Window function names (non-reserved)
	windowFunctions := []string{
		"ROW_NUMBER", "RANK", "DENSE_RANK", "NTILE",
		"LAG", "LEAD", "FIRST_VALUE", "LAST_VALUE",
	}

	for _, word := range windowFunctions {
		if !k.IsKeyword(word) {
			t.Errorf("Window function %q should exist", word)
		}
		// These should NOT be reserved (they're function names)
		if k.IsReserved(word) {
			t.Errorf("Window function %q should NOT be reserved", word)
		}
	}
}

// TestKeywords_CompoundKeywordVariations tests various compound keyword formats
func TestKeywords_CompoundKeywordVariations(t *testing.T) {