Method stmt_drop_routine

sql/sql_lex.cc:13126–13175

Process a drop routine statement: DROP {FUNCTION|PROCEDURE|PACKAGE|PACKAGE BODY} [IF NOT EXISTS ] [db.]name; @param sph - The stored routine @param options - The IF EXISTS clause @param db - The database name. It can be {NULL,0}, which means the routine name is not qualified with the database name. @param name - The routine name

  @returns       - false ok success, true on error.
*/
bool LEX::stmt_drop_routine(const Sp_handler *sph,
                            const DDL_options_st &options,
                            const Lex_ident_sys_st &db,
                            const Lex_ident_sys_st &name)
{
  DBUG_ASSERT(name.str);
  if (unlikely(sphead))
  {
    my_error(ER_SP_NO_DROP_SP, MYF(0), sph->type_lex_cstring().str);
    return true;
  }
  if (Lex_ident_routine::check_name_with_error(name))
    return true;
  enum_sql_command sqlcom= sph->sqlcom_drop();
  Lex_ident_db_normalized dbn;
  if (db.str)
  {
    // An explicit database name is given
    if (!(dbn= thd->to_ident_db_normalized_with_error(db)).str)
      return true;
  }
  else if (thd->db.str || sqlcom != SQLCOM_DROP_FUNCTION)
  {
    /*
      There is no an explicit database name in the DROP statement.
      Two cases are possible:
      a. The current database is not NULL.
      b. The current database is NULL and the command is either of these:
         - DROP PACKAGE
         - DROP PACKAGE BODY
         - DROP PROCEDURE
         copy_db_normalized() raises ER_NO_DB_ERROR.
    */
    if (!(dbn= copy_db_normalized()).str)
      return true;
  }
  else
  {
    /*
      This is a "DROP FUNCTION name" statement.
      There is no an explicit database name given.
      The current database is not set.
      It can still be a valid DROP FUNCTION - for an UDF.
      Keep dbn=={NULL,0}.
    */
  }
  set_command(sqlcom, options);
  spname= new (thd->mem_root) sp_name(dbn, name, db.str != NULL);
  return false;
}


bool LEX::stmt_alter_function_start(sp_name *name)