Method parseWhereClause

pkg/sql/parser/select_clauses.go:424–446

parseWhereClause parses "WHERE " if present. Returns nil (no error) when WHERE is absent.

()

// parseWhereClause parses "WHERE <expr>" if present.
// Returns nil (no error) when WHERE is absent.
func (p *Parser) parseWhereClause() (ast.Expression, error) {
	if !p.isType(models.TokenTypeWhere) {
		return nil, nil
	}
	p.advance() // Consume WHERE

	// Guard against a WHERE keyword with no following expression.
	if p.isType(models.TokenTypeEOF) || p.isType(models.TokenTypeSemicolon) ||
		p.isType(models.TokenTypeGroup) || p.isType(models.TokenTypeOrder) ||
		p.isType(models.TokenTypeLimit) || p.isType(models.TokenTypeHaving) ||
		p.isType(models.TokenTypeUnion) || p.isType(models.TokenTypeExcept) ||
		p.isType(models.TokenTypeIntersect) || p.isType(models.TokenTypeRParen) ||
		p.isType(models.TokenTypeFetch) || p.isType(models.TokenTypeFor) {
		return nil, goerrors.ExpectedTokenError(
			"expression after WHERE",
			p.currentToken.Token.Type.String(),
			p.currentLocation(),
			"WHERE clause requires a boolean expression",
		)
	}

	return p.parseExpression()
}

// parseGroupByClause parses "GROUP BY <expr> [, ...]" including ROLLUP, CUBE,
// GROUPING SETS, and MySQL's trailing WITH ROLLUP / WITH CUBE syntax.