Function PutSelectStatement

pkg/sql/ast/pool.go:663–718

PutSelectStatement returns a SelectStatement to the pool Uses iterative cleanup via PutExpression to handle deeply nested expressions

(stmt *SelectStatement)

// PutSelectStatement returns a SelectStatement to the pool
// Uses iterative cleanup via PutExpression to handle deeply nested expressions
func PutSelectStatement(stmt *SelectStatement) {
	if stmt == nil {
		return
	}

	// Collect all expressions to clean up
	expressions := make([]Expression, 0, len(stmt.Columns)+len(stmt.OrderBy)+3)

	// Collect column expressions
	for _, col := range stmt.Columns {
		if col != nil {
			expressions = append(expressions, col)
		}
	}

	// Collect ORDER BY expressions
	for _, orderBy := range stmt.OrderBy {
		if orderBy.Expression != nil {
			expressions = append(expressions, orderBy.Expression)
		}
	}

	// Collect WHERE expression
	if stmt.Where != nil {
		expressions = append(expressions, stmt.Where)
	}

	// Note: Limit and Offset are *int, not Expression, so no cleanup needed

	// Clean up all expressions using iterative approach
	for _, expr := range expressions {
		PutExpression(expr)
	}

	// Reset fields
	for i := range stmt.Columns {
		stmt.Columns[i] = nil
	}
	stmt.Columns = stmt.Columns[:0]

	for i := range stmt.OrderBy {
		stmt.OrderBy[i].Expression = nil
	}
	stmt.OrderBy = stmt.OrderBy[:0]

	stmt.TableName = ""
	stmt.PrewhereClause = nil
	stmt.Where = nil
	stmt.Limit = nil
	stmt.Offset = nil
	stmt.Fetch = nil
	stmt.For = nil

	// Return to pool
	selectStmtPool.Put(stmt)
}

// GetIdentifier gets an Identifier from the pool