Method parseMultiplicativeExpression

pkg/sql/parser/expressions.go:176–206

parseMultiplicativeExpression parses expressions with *, /, and % operators

()

// parseMultiplicativeExpression parses expressions with *, /, and % operators
func (p *Parser) parseMultiplicativeExpression() (ast.Expression, error) {
	// Parse the left side using JSON operator expression (higher precedence)
	left, err := p.parseJSONExpression()
	if err != nil {
		return nil, err
	}

	// Handle *, /, and % operators (left-associative)
	// Note: TokenTypeAsterisk is used for both * (SELECT) and multiplication
	// We check context: after an expression, asterisk means multiplication
	for p.isType(models.TokenTypeAsterisk) || p.isType(models.TokenTypeMul) ||
		p.isType(models.TokenTypeDiv) || p.isType(models.TokenTypeMod) {
		opPos := p.currentLocation()
		operator := p.currentToken.Token.Value
		p.advance() // Consume operator

		right, err := p.parseJSONExpression()
		if err != nil {
			return nil, err
		}

		left = &ast.BinaryExpression{
			Left:     left,
			Operator: operator,
			Right:    right,
			Pos:      opPos,
		}
	}

	return left, nil
}

// parseJSONExpression parses JSON/JSONB operators (PostgreSQL) and type casting
// Handles: ->, ->>, #>, #>>, @>, <@, ?, ?|, ?&, #-, ::