Function TestSnowflakeKeywordsBaseOverlap

pkg/sql/keywords/snowflake_test.go:162–193

TestSnowflakeKeywordsBaseOverlap verifies that keywords which exist in both the base set and the Snowflake set don't cause issues (the base definition takes precedence since addKeywordsWithCategory skips duplicates).

(t *testing.T)

// the base set and the Snowflake set don't cause issues (the base definition
// takes precedence since addKeywordsWithCategory skips duplicates).
func TestSnowflakeKeywordsBaseOverlap(t *testing.T) {
	k := New(DialectSnowflake, true)

	// These keywords exist in the base set and should retain their base token types
	baseOverlapKeywords := []struct {
		word         string
		expectedType models.TokenType
	}{
		{"ARRAY", models.TokenTypeArray},
		{"LATERAL", models.TokenTypeLateral},
		{"QUALIFY", models.TokenTypeKeyword},
		{"SAMPLE", models.TokenTypeKeyword},
		{"CLUSTER", models.TokenTypeKeyword},
		{"OFFSET", models.TokenTypeOffset},
		{"SHARE", models.TokenTypeShare},
		{"LIST", models.TokenTypeKeyword},
	}

	for _, tt := range baseOverlapKeywords {
		t.Run(tt.word, func(t *testing.T) {
			if !k.IsKeyword(tt.word) {
				t.Errorf("Overlapping keyword %q should exist in Snowflake dialect", tt.word)
			}

			tokenType := k.GetTokenType(tt.word)
			if tokenType != tt.expectedType {
				t.Errorf("GetTokenType(%q) = %v, want %v (base definition should take precedence)",
					tt.word, tokenType, tt.expectedType)
			}
		})
	}
}

// TestSnowflakeDialectKeywords verifies DialectKeywords returns the Snowflake keyword list.
func TestSnowflakeDialectKeywords(t *testing.T) {