Function dropFunction

server/node/drop_function.go:111–143

(ctx *sql.Context, funcColl *functions.Collection, fn *RoutineWithParams, ifExists bool)

}

func dropFunction(ctx *sql.Context, funcColl *functions.Collection, fn *RoutineWithParams, ifExists bool) error {
	// TODO: provide db
	schema, err := core.GetSchemaName(ctx, nil, fn.SchemaName)
	if err != nil {
		return err
	}
	var funcId = id.NewFunction(schema, fn.RoutineName)
	if len(fn.Args) == 0 {
		funcs, err := funcColl.GetFunctionOverloads(ctx, funcId)
		if err != nil {
			return err
		}
		if len(funcs) == 1 {
			funcId = funcs[0].ID
		} else if len(funcs) > 1 {
			funcExists := funcColl.HasFunction(ctx, funcId)
			if !funcExists {
				return errors.Errorf(`function name "%s" is not unique`, fn.RoutineName)
			}
		}
	} else {
		var argTypes = make([]id.Type, len(fn.Args))
		for i, arg := range fn.Args {
			argTypes[i] = arg.Type.ID
		}
		funcId = id.NewFunction(schema, fn.RoutineName, argTypes...)
	}
	funcExists := funcColl.HasFunction(ctx, funcId)
	if !funcExists && ifExists {
		return nil
	}
	return funcColl.DropFunction(ctx, funcId)
}