Function TestPoolContamination

pkg/sql/parser/negative_parser_test.go:476–589

TestPoolContamination verifies that parsing different SQL patterns through pooled parsers doesn't cause cross-contamination between parses.

(t *testing.T)

// TestPoolContamination verifies that parsing different SQL patterns through pooled
// parsers doesn't cause cross-contamination between parses.
func TestPoolContamination(t *testing.T) {
	// Pattern A: simple SELECT
	tokensA := []token.Token{
		{Type: models.TokenTypeSelect, Literal: "SELECT"},
		{Type: models.TokenTypeIdentifier, Literal: "id"},
		{Type: models.TokenTypeComma, Literal: ","},
		{Type: models.TokenTypeIdentifier, Literal: "name"},
		{Type: models.TokenTypeFrom, Literal: "FROM"},
		{Type: models.TokenTypeIdentifier, Literal: "users"},
		{Type: models.TokenTypeWhere, Literal: "WHERE"},
		{Type: models.TokenTypeIdentifier, Literal: "active"},
		{Type: models.TokenTypeEq, Literal: "="},
		{Type: models.TokenTypeTrue, Literal: "TRUE"},
	}

	// Pattern B: INSERT
	tokensB := []token.Token{
		{Type: models.TokenTypeInsert, Literal: "INSERT"},
		{Type: models.TokenTypeInto, Literal: "INTO"},
		{Type: models.TokenTypeIdentifier, Literal: "orders"},
		{Type: models.TokenTypeLParen, Literal: "("},
		{Type: models.TokenTypeIdentifier, Literal: "product"},
		{Type: models.TokenTypeComma, Literal: ","},
		{Type: models.TokenTypeIdentifier, Literal: "qty"},
		{Type: models.TokenTypeRParen, Literal: ")"},
		{Type: models.TokenTypeValues, Literal: "VALUES"},
		{Type: models.TokenTypeLParen, Literal: "("},
		{Type: models.TokenTypeString, Literal: "'widget'"},
		{Type: models.TokenTypeComma, Literal: ","},
		{Type: models.TokenTypeNumber, Literal: "42"},
		{Type: models.TokenTypeRParen, Literal: ")"},
	}

	// Pattern C: CREATE TABLE
	tokensC := []token.Token{
		{Type: models.TokenTypeCreate, Literal: "CREATE"},
		{Type: models.TokenTypeTable, Literal: "TABLE"},
		{Type: models.TokenTypeIdentifier, Literal: "products"},
		{Type: models.TokenTypeLParen, Literal: "("},
		{Type: models.TokenTypeIdentifier, Literal: "id"},
		{Type: models.TokenTypeIdentifier, Literal: "INT"},
		{Type: models.TokenTypeComma, Literal: ","},
		{Type: models.TokenTypeIdentifier, Literal: "name"},
		{Type: models.TokenTypeIdentifier, Literal: "TEXT"},
		{Type: models.TokenTypeRParen, Literal: ")"},
	}

	// Round 1: Parse A, return parser to pool
	p1 := GetParser()
	astA1, errA1 := p1.Parse(tokensA)
	PutParser(p1)

	// Round 2: Get parser from pool (likely same instance), parse B
	p2 := GetParser()
	astB, errB := p2.Parse(tokensB)
	PutParser(p2)

	// Round 3: Parse C