Function nodeDropFunction

server/ast/drop_function.go:27–70

nodeDropFunction handles *tree.DropFunction nodes.

(ctx *Context, node *tree.DropFunction)

// nodeDropFunction handles *tree.DropFunction nodes.
func nodeDropFunction(ctx *Context, node *tree.DropFunction) (vitess.Statement, error) {
	if node == nil {
		return nil, nil
	}

	if node.DropBehavior == tree.DropCascade {
		return nil, fmt.Errorf("DROP FUNCTION with CASCADE is not supported yet")
	}

	if len(node.Functions) == 0 {
		return nil, fmt.Errorf("no function name specified for DROP FUNCTION")
	}

	functions := make([]*pgnodes.RoutineWithParams, len(node.Functions))
	for i, fn := range node.Functions {
		var args []pgnodes.RoutineParam
		for _, a := range fn.Args {
			if a.Mode != tree.RoutineArgModeOut {
				_, dt, err := nodeResolvableTypeReference(ctx, a.Type, false)
				if err != nil {
					return nil, err
				}
				args = append(args, pgnodes.RoutineParam{
					Name: a.Name.String(),
					Type: dt,
				})
			}
		}
		objName := fn.Name.ToTableName()
		functions[i] = &pgnodes.RoutineWithParams{
			Args:        args,
			SchemaName:  objName.Schema(),
			RoutineName: objName.Object(),
		}
	}

	return vitess.InjectedStatement{
		Statement: pgnodes.NewDropFunction(
			node.IfExists,
			functions,
			node.DropBehavior == tree.DropCascade),
		Children: nil,
	}, nil
}