Method parseCreateIndex

pkg/sql/parser/ddl_index.go:26–136

parseCreateIndex parses CREATE [UNIQUE] INDEX statement

(unique bool)

// parseCreateIndex parses CREATE [UNIQUE] INDEX statement
func (p *Parser) parseCreateIndex(unique bool) (*ast.CreateIndexStatement, error) {
	stmt := &ast.CreateIndexStatement{
		Unique: unique,
	}

	// Check for IF NOT EXISTS
	if p.isType(models.TokenTypeIf) {
		p.advance() // Consume IF
		if !p.isType(models.TokenTypeNot) {
			return nil, p.expectedError("NOT after IF")
		}
		p.advance() // Consume NOT
		if !p.isType(models.TokenTypeExists) {
			return nil, p.expectedError("EXISTS after NOT")
		}
		p.advance() // Consume EXISTS
		stmt.IfNotExists = true
	}

	// Parse index name (supports schema.index qualification and double-quoted identifiers)
	indexName, err := p.parseQualifiedName()
	if err != nil {
		return nil, p.expectedError("index name")
	}
	stmt.Name = indexName

	// Expect ON
	if !p.isType(models.TokenTypeOn) {
		return nil, p.expectedError("ON")
	}
	p.advance() // Consume ON

	// Parse table name (supports schema.table qualification and double-quoted identifiers)
	indexTableName, err := p.parseQualifiedName()
	if err != nil {
		return nil, p.expectedError("table name")
	}
	stmt.Table = indexTableName

	// Parse optional USING
	if p.isType(models.TokenTypeUsing) {
		p.advance() // Consume USING
		if !p.isIdentifier() {
			return nil, p.expectedError("index method")
		}
		stmt.Using = p.currentToken.Token.Value
		p.advance()
	}

	// Expect opening parenthesis
	if !p.isType(models.TokenTypeLParen) {
		return nil, p.expectedError("(")
	}
	p.advance() // Consume (

	// Parse column list
	for {
		col := ast.IndexColumn{}