Method parseTemporalPointExpression

pkg/sql/parser/mariadb.go:335–353

parseTemporalPointExpression parses a temporal point expression for FOR SYSTEM_TIME clauses. Handles typed string literals like TIMESTAMP '2024-01-01' and DATE '2024-01-01', as well as plain string literals and other primary expressions.

()

// Handles typed string literals like TIMESTAMP '2024-01-01' and DATE '2024-01-01',
// as well as plain string literals and other primary expressions.
func (p *Parser) parseTemporalPointExpression() (ast.Expression, error) {
	// Handle TIMESTAMP 'str', DATE 'str', TIME 'str' typed literals.
	word := strings.ToUpper(p.currentToken.Token.Value)
	if word == "TIMESTAMP" || word == "DATE" || word == "TIME" {
		typeKeyword := p.currentToken.Token.Value
		p.advance()
		if !p.isStringLiteral() {
			return nil, fmt.Errorf("expected string literal after %s, got %q", typeKeyword, p.currentToken.Token.Value)
		}
		// The tokenizer strips surrounding single quotes from string literal tokens,
		// so p.currentToken.Token.Value is the raw string content (e.g. "2023-01-01 00:00:00").
		// We reconstruct the canonical form: TYPE 'value'.
		value := typeKeyword + " '" + p.currentToken.Token.Value + "'"
		p.advance()
		return &ast.LiteralValue{Value: value, Type: "timestamp"}, nil
	}
	// Fall back to primary expression (handles plain string literals, numbers, identifiers).
	return p.parsePrimaryExpression()
}

// parseConnectByCondition parses the condition expression for CONNECT BY.
// It handles the PRIOR prefix operator in either position: