Function nodeCreateIndex

server/ast/create_index.go:27–79

nodeCreateIndex handles *tree.CreateIndex nodes.

(ctx *Context, node *tree.CreateIndex)

// nodeCreateIndex handles *tree.CreateIndex nodes.
func nodeCreateIndex(ctx *Context, node *tree.CreateIndex) (*vitess.AlterTable, error) {
	if node == nil {
		return nil, nil
	}
	if node.Concurrently {
		return nil, errors.Errorf("concurrent index creation is not yet supported")
	}
	if node.Using != "" && strings.ToLower(node.Using) != "btree" {
		return nil, errors.Errorf("index method %s is not yet supported", node.Using)
	}
	indexDef, err := nodeIndexTableDef(ctx, &tree.IndexTableDef{
		Name:        node.Name,
		Columns:     node.Columns,
		IndexParams: node.IndexParams,
	})
	if err != nil {
		return nil, err
	}
	tableName, err := nodeTableName(ctx, &node.Table)
	if err != nil {
		return nil, err
	}
	var indexType string
	if node.Unique {
		indexType = vitess.UniqueStr
	}
	var predicate vitess.Expr
	if node.Predicate != nil {
		predicate, err = nodeExpr(ctx, node.Predicate)
		if err != nil {
			return nil, err
		}
	}
	return &vitess.AlterTable{
		Table: tableName,
		Statements: []*vitess.DDL{
			{
				Action:      vitess.AlterStr,
				Table:       tableName,
				IfNotExists: node.IfNotExists,
				IndexSpec: &vitess.IndexSpec{
					Action:    vitess.CreateStr,
					FromName:  indexDef.Info.Name,
					ToName:    indexDef.Info.Name,
					Type:      indexType,
					Fields:    indexDef.Fields,
					Options:   indexDef.Options,
					Predicate: predicate,
				},
			},
		},
	}, nil
}