sp.cc 52.6 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
/* Copyright (C) 2002 MySQL AB

   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.

   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */

#include "mysql_priv.h"
#include "sp.h"
#include "sp_head.h"
20
#include "sp_cache.h"
21
#include "sql_trigger.h"
22

23 24
#include <my_user.h>

25 26
static bool
create_string(THD *thd, String *buf,
27
	      int sp_type,
28
	      sp_name *name,
29 30 31
	      const char *params, ulong paramslen,
	      const char *returns, ulong returnslen,
	      const char *body, ulong bodylen,
32 33 34
	      st_sp_chistics *chistics,
              const LEX_STRING *definer_user,
              const LEX_STRING *definer_host);
35 36 37 38 39
static int
db_load_routine(THD *thd, int type, sp_name *name, sp_head **sphp,
                ulong sql_mode, const char *params, const char *returns,
                const char *body, st_sp_chistics &chistics,
                const char *definer, longlong created, longlong modified);
40

41 42 43 44 45 46
/*
 *
 * DB storage of Stored PROCEDUREs and FUNCTIONs
 *
 */

47 48
enum
{
49
  MYSQL_PROC_FIELD_DB = 0,
50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
  MYSQL_PROC_FIELD_NAME,
  MYSQL_PROC_FIELD_TYPE,
  MYSQL_PROC_FIELD_SPECIFIC_NAME,
  MYSQL_PROC_FIELD_LANGUAGE,
  MYSQL_PROC_FIELD_ACCESS,
  MYSQL_PROC_FIELD_DETERMINISTIC,
  MYSQL_PROC_FIELD_SECURITY_TYPE,
  MYSQL_PROC_FIELD_PARAM_LIST,
  MYSQL_PROC_FIELD_RETURNS,
  MYSQL_PROC_FIELD_BODY,
  MYSQL_PROC_FIELD_DEFINER,
  MYSQL_PROC_FIELD_CREATED,
  MYSQL_PROC_FIELD_MODIFIED,
  MYSQL_PROC_FIELD_SQL_MODE,
  MYSQL_PROC_FIELD_COMMENT,
  MYSQL_PROC_FIELD_COUNT
};
67

68 69
bool mysql_proc_table_exists= 1;

70 71 72
/* Tells what SP_DEFAULT_ACCESS should be mapped to */
#define SP_DEFAULT_ACCESS_MAPPING SP_CONTAINS_SQL

73 74 75 76 77 78

/*
  Close mysql.proc, opened with open_proc_table_for_read().

  SYNOPSIS
    close_proc_table()
79 80 81 82
      thd     Thread context
      backup  Pointer to Open_tables_state instance which holds
              information about tables which were open before we
              decided to access mysql.proc.
83 84
*/

85
void close_proc_table(THD *thd, Open_tables_state *backup)
86
{
87
  close_thread_tables(thd);
88
  thd->restore_backup_open_tables_state(backup);
89
}
90

91 92 93 94 95 96

/*
  Open the mysql.proc table for read.

  SYNOPSIS
    open_proc_table_for_read()
97 98 99 100
      thd     Thread context
      backup  Pointer to Open_tables_state instance where information about
              currently open tables will be saved, and from which will be
              restored when we will end work with mysql.proc.
101 102 103 104 105 106 107 108 109 110 111 112 113

  NOTES
    Thanks to restrictions which we put on opening and locking of
    this table for writing, we can open and lock it for reading
    even when we already have some other tables open and locked.
    One must call close_proc_table() to close table opened with
    this call.

  RETURN
    0	Error
    #	Pointer to TABLE object of mysql.proc
*/

114
TABLE *open_proc_table_for_read(THD *thd, Open_tables_state *backup)
115 116 117
{
  TABLE_LIST tables;
  TABLE *table;
118
  bool not_used;
119
  DBUG_ENTER("open_proc_table");
120

121
  /*
122 123
    Speed up things if mysql.proc doesn't exists. mysql_proc_table_exists
    is set when we create or read stored procedure or on flush privileges.
124
  */
125 126
  if (!mysql_proc_table_exists)
    DBUG_RETURN(0);
127

128
  thd->reset_n_backup_open_tables_state(backup);
129 130 131 132

  bzero((char*) &tables, sizeof(tables));
  tables.db= (char*) "mysql";
  tables.table_name= tables.alias= (char*)"proc";
133
  if (!(table= open_table(thd, &tables, thd->mem_root, &not_used,
134
                          MYSQL_LOCK_IGNORE_FLUSH)))
135
  {
136
    thd->restore_backup_open_tables_state(backup);
137 138
    mysql_proc_table_exists= 0;
    DBUG_RETURN(0);
139
  }
140

141 142 143 144
  DBUG_ASSERT(table->s->system_table);

  table->reginfo.lock_type= TL_READ;
  /*
145 146
    We have to ensure we are not blocked by a flush tables, as this
    could lead to a deadlock if we have other tables opened.
147 148
  */
  if (!(thd->lock= mysql_lock_tables(thd, &table, 1,
149
                                     MYSQL_LOCK_IGNORE_FLUSH, &not_used)))
150
  {
151
    close_proc_table(thd, backup);
152
    DBUG_RETURN(0);
153
  }
154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216
  DBUG_RETURN(table);
}


/*
  Open the mysql.proc table for update.

  SYNOPSIS
    open_proc_table_for_update()
      thd  Thread context

  NOTES
    Table opened with this call should closed using close_thread_tables().

  RETURN
    0	Error
    #	Pointer to TABLE object of mysql.proc
*/

static TABLE *open_proc_table_for_update(THD *thd)
{
  TABLE_LIST tables;
  TABLE *table;
  DBUG_ENTER("open_proc_table");

  bzero((char*) &tables, sizeof(tables));
  tables.db= (char*) "mysql";
  tables.table_name= tables.alias= (char*)"proc";
  tables.lock_type= TL_WRITE;

  table= open_ltable(thd, &tables, TL_WRITE);

  /*
    Under explicit LOCK TABLES or in prelocked mode we should not
    say that mysql.proc table does not exist if we are unable to
    open and lock it for writing since this condition may be
    transient.
  */
  if (!(thd->locked_tables || thd->prelocked_mode) || table)
    mysql_proc_table_exists= test(table);

  DBUG_RETURN(table);
}


/*
  Find row in open mysql.proc table representing stored routine.

  SYNOPSIS
    db_find_routine_aux()
      thd    Thread context
      type   Type of routine to find (function or procedure)
      name   Name of routine
      table  TABLE object for open mysql.proc table.

  RETURN VALUE
    SP_OK           - Routine found
    SP_KEY_NOT_FOUND- No routine with given name
*/

static int
db_find_routine_aux(THD *thd, int type, sp_name *name, TABLE *table)
{
217
  byte key[MAX_KEY_LENGTH];	// db, name, optional key length type
218
  DBUG_ENTER("db_find_routine_aux");
219
  DBUG_PRINT("enter", ("type: %d name: %.*s",
220
		       type, name->m_name.length, name->m_name.str));
221

222 223 224 225 226 227 228
  /*
    Create key to find row. We have to use field->store() to be able to
    handle VARCHAR and CHAR fields.
    Assumption here is that the three first fields in the table are
    'db', 'name' and 'type' and the first key is the primary key over the
    same fields.
  */
229 230
  if (name->m_name.length > table->field[1]->field_length)
    DBUG_RETURN(SP_KEY_NOT_FOUND);
231 232 233
  table->field[0]->store(name->m_db.str, name->m_db.length, &my_charset_bin);
  table->field[1]->store(name->m_name.str, name->m_name.length,
                         &my_charset_bin);
234
  table->field[2]->store((longlong) type, TRUE);
235 236 237
  key_copy(key, table->record[0], table->key_info,
           table->key_info->key_length);

238
  if (table->file->index_read_idx(table->record[0], 0,
239
				  key, table->key_info->key_length,
240
				  HA_READ_KEY_EXACT))
241
    DBUG_RETURN(SP_KEY_NOT_FOUND);
242

243 244 245
  DBUG_RETURN(SP_OK);
}

unknown's avatar
unknown committed
246

247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267
/*
  Find routine definition in mysql.proc table and create corresponding
  sp_head object for it.

  SYNOPSIS
    db_find_routine()
      thd   Thread context
      type  Type of routine (TYPE_ENUM_PROCEDURE/...)
      name  Name of routine
      sphp  Out parameter in which pointer to created sp_head
            object is returned (0 in case of error).

  NOTE
    This function may damage current LEX during execution, so it is good
    idea to create temporary LEX and make it active before calling it.

  RETURN VALUE
    0     - Success
    non-0 - Error (may be one of special codes like SP_KEY_NOT_FOUND)
*/

268
static int
269
db_find_routine(THD *thd, int type, sp_name *name, sp_head **sphp)
270
{
271
  extern int MYSQLparse(void *thd);
272
  TABLE *table;
273
  const char *params, *returns, *body;
274
  int ret;
275
  const char *definer;
unknown's avatar
unknown committed
276 277
  longlong created;
  longlong modified;
278
  st_sp_chistics chistics;
unknown's avatar
unknown committed
279 280 281
  char *ptr;
  uint length;
  char buff[65];
282
  String str(buff, sizeof(buff), &my_charset_bin);
283
  ulong sql_mode;
284
  Open_tables_state open_tables_state_backup;
unknown's avatar
unknown committed
285
  DBUG_ENTER("db_find_routine");
286
  DBUG_PRINT("enter", ("type: %d name: %.*s",
287
		       type, name->m_name.length, name->m_name.str));
288

289
  *sphp= 0;                                     // In case of errors
290
  if (!(table= open_proc_table_for_read(thd, &open_tables_state_backup)))
291 292 293
    DBUG_RETURN(SP_OPEN_TABLE_FAILED);

  if ((ret= db_find_routine_aux(thd, type, name, table)) != SP_OK)
294
    goto done;
295

296
  if (table->s->fields != MYSQL_PROC_FIELD_COUNT)
297 298 299 300 301
  {
    ret= SP_GET_FIELD_FAILED;
    goto done;
  }

302
  bzero((char *)&chistics, sizeof(chistics));
unknown's avatar
unknown committed
303
  if ((ptr= get_field(thd->mem_root,
304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322
		      table->field[MYSQL_PROC_FIELD_ACCESS])) == NULL)
  {
    ret= SP_GET_FIELD_FAILED;
    goto done;
  }
  switch (ptr[0]) {
  case 'N':
    chistics.daccess= SP_NO_SQL;
    break;
  case 'C':
    chistics.daccess= SP_CONTAINS_SQL;
    break;
  case 'R':
    chistics.daccess= SP_READS_SQL_DATA;
    break;
  case 'M':
    chistics.daccess= SP_MODIFIES_SQL_DATA;
    break;
  default:
323
    chistics.daccess= SP_DEFAULT_ACCESS_MAPPING;
324 325
  }

unknown's avatar
unknown committed
326
  if ((ptr= get_field(thd->mem_root,
327
		      table->field[MYSQL_PROC_FIELD_DETERMINISTIC])) == NULL)
328 329 330 331
  {
    ret= SP_GET_FIELD_FAILED;
    goto done;
  }
332
  chistics.detistic= (ptr[0] == 'N' ? FALSE : TRUE);    
unknown's avatar
unknown committed
333

unknown's avatar
unknown committed
334
  if ((ptr= get_field(thd->mem_root,
335
		      table->field[MYSQL_PROC_FIELD_SECURITY_TYPE])) == NULL)
unknown's avatar
unknown committed
336 337 338 339
  {
    ret= SP_GET_FIELD_FAILED;
    goto done;
  }
340
  chistics.suid= (ptr[0] == 'I' ? SP_IS_NOT_SUID : SP_IS_SUID);
unknown's avatar
unknown committed
341

unknown's avatar
unknown committed
342
  if ((params= get_field(thd->mem_root,
343 344 345 346
			 table->field[MYSQL_PROC_FIELD_PARAM_LIST])) == NULL)
  {
    params= "";
  }
unknown's avatar
unknown committed
347

348 349
  if (type == TYPE_ENUM_PROCEDURE)
    returns= "";
unknown's avatar
unknown committed
350
  else if ((returns= get_field(thd->mem_root,
351 352 353 354 355 356
			       table->field[MYSQL_PROC_FIELD_RETURNS])) == NULL)
  {
    ret= SP_GET_FIELD_FAILED;
    goto done;
  }

unknown's avatar
unknown committed
357
  if ((body= get_field(thd->mem_root,
358
		       table->field[MYSQL_PROC_FIELD_BODY])) == NULL)
unknown's avatar
unknown committed
359 360 361 362
  {
    ret= SP_GET_FIELD_FAILED;
    goto done;
  }
363 364

  // Get additional information
unknown's avatar
unknown committed
365
  if ((definer= get_field(thd->mem_root,
366 367 368 369 370 371 372 373
			  table->field[MYSQL_PROC_FIELD_DEFINER])) == NULL)
  {
    ret= SP_GET_FIELD_FAILED;
    goto done;
  }

  modified= table->field[MYSQL_PROC_FIELD_MODIFIED]->val_int();
  created= table->field[MYSQL_PROC_FIELD_CREATED]->val_int();
unknown's avatar
unknown committed
374

unknown's avatar
unknown committed
375
  sql_mode= (ulong) table->field[MYSQL_PROC_FIELD_SQL_MODE]->val_int();
376

377 378
  table->field[MYSQL_PROC_FIELD_COMMENT]->val_str(&str, &str);

unknown's avatar
unknown committed
379
  ptr= 0;
380
  if ((length= str.length()))
381
    ptr= thd->strmake(str.ptr(), length);
382 383
  chistics.comment.str= ptr;
  chistics.comment.length= length;
unknown's avatar
unknown committed
384

385
  close_proc_table(thd, &open_tables_state_backup);
386
  table= 0;
387

388 389 390 391 392 393 394 395 396
  ret= db_load_routine(thd, type, name, sphp,
                       sql_mode, params, returns, body, chistics,
                       definer, created, modified);
                       
 done:
  if (table)
    close_proc_table(thd, &open_tables_state_backup);
  DBUG_RETURN(ret);
}
unknown's avatar
unknown committed
397

398

399 400 401 402 403 404
static int
db_load_routine(THD *thd, int type, sp_name *name, sp_head **sphp,
                ulong sql_mode, const char *params, const char *returns,
                const char *body, st_sp_chistics &chistics,
                const char *definer, longlong created, longlong modified)
{
unknown's avatar
unknown committed
405
  LEX *old_lex= thd->lex, newlex;
406 407 408 409
  String defstr;
  char olddb[128];
  bool dbchanged;
  ulong old_sql_mode= thd->variables.sql_mode;
unknown's avatar
unknown committed
410 411
  ha_rows old_select_limit= thd->variables.select_limit;
  sp_rcontext *old_spcont= thd->spcont;
412 413 414 415 416 417 418 419 420
  
  char definer_user_name_holder[USERNAME_LENGTH + 1];
  LEX_STRING_WITH_INIT definer_user_name(definer_user_name_holder,
                                         USERNAME_LENGTH);

  char definer_host_name_holder[HOSTNAME_LENGTH + 1];
  LEX_STRING_WITH_INIT definer_host_name(definer_host_name_holder,
                                         HOSTNAME_LENGTH);
  
unknown's avatar
unknown committed
421
  int ret;
422 423 424 425 426 427 428

  thd->variables.sql_mode= sql_mode;
  thd->variables.select_limit= HA_POS_ERROR;

  thd->lex= &newlex;
  newlex.current_select= NULL;

429 430 431 432
  parse_user(definer, strlen(definer),
             definer_user_name.str, &definer_user_name.length,
             definer_host_name.str, &definer_host_name.length);

433
  defstr.set_charset(system_charset_info);
434 435 436 437 438 439 440

  /*
    We have to add DEFINER clause and provide proper routine characterstics in
    routine definition statement that we build here to be able to use this
    definition for SHOW CREATE PROCEDURE later.
   */

441 442 443 444 445 446
  if (!create_string(thd, &defstr,
		     type,
		     name,
		     params, strlen(params),
		     returns, strlen(returns),
		     body, strlen(body),
447
		     &chistics, &definer_user_name, &definer_host_name))
unknown's avatar
unknown committed
448 449
  {
    ret= SP_INTERNAL_ERROR;
450
    goto end;
unknown's avatar
unknown committed
451
  }
452

453 454 455 456
  dbchanged= FALSE;
  if ((ret= sp_use_new_db(thd, name->m_db.str, olddb, sizeof(olddb),
			  1, &dbchanged)))
    goto end;
457

458
  lex_start(thd, (uchar*)defstr.c_ptr(), defstr.length());
459

unknown's avatar
merge  
unknown committed
460
  thd->spcont= 0;
461
  if (MYSQLparse(thd) || thd->is_fatal_error || newlex.sphead == NULL)
462 463 464 465 466 467 468 469 470 471 472
  {
    sp_head *sp= newlex.sphead;

    if (dbchanged && (ret= mysql_change_db(thd, olddb, 1)))
      goto end;
    delete sp;
    ret= SP_PARSE_ERROR;
  }
  else
  {
    if (dbchanged && (ret= mysql_change_db(thd, olddb, 1)))
unknown's avatar
unknown committed
473
      goto end;
474
    *sphp= newlex.sphead;
475
    (*sphp)->set_definer(&definer_user_name, &definer_host_name);
unknown's avatar
unknown committed
476
    (*sphp)->set_info(created, modified, &chistics, sql_mode);
477 478
    (*sphp)->optimize();
  }
unknown's avatar
unknown committed
479
end:
unknown's avatar
unknown committed
480
  thd->spcont= old_spcont;
481
  thd->variables.sql_mode= old_sql_mode;
unknown's avatar
unknown committed
482 483
  thd->variables.select_limit= old_select_limit;
  thd->lex= old_lex;
484
  return ret;
485 486
}

unknown's avatar
unknown committed
487

unknown's avatar
unknown committed
488 489 490
static void
sp_returns_type(THD *thd, String &result, sp_head *sp)
{
unknown's avatar
unknown committed
491
  TABLE table;
unknown's avatar
unknown committed
492
  TABLE_SHARE share;
unknown's avatar
unknown committed
493
  Field *field;
unknown's avatar
unknown committed
494 495
  bzero((char*) &table, sizeof(table));
  bzero((char*) &share, sizeof(share));
unknown's avatar
unknown committed
496
  table.in_use= thd;
unknown's avatar
unknown committed
497
  table.s = &share;
498
  field= sp->create_result_field(0, 0, &table);
unknown's avatar
unknown committed
499 500 501 502
  field->sql_type(result);
  delete field;
}

503
static int
504
db_create_routine(THD *thd, int type, sp_head *sp)
505
{
506
  int ret;
507
  TABLE *table;
508
  char definer[USER_HOST_BUFF_SIZE];
509 510
  char olddb[128];
  bool dbchanged;
unknown's avatar
unknown committed
511
  DBUG_ENTER("db_create_routine");
512 513
  DBUG_PRINT("enter", ("type: %d name: %.*s",type,sp->m_name.length,
                       sp->m_name.str));
514

515 516 517 518 519 520 521 522
  dbchanged= FALSE;
  if ((ret= sp_use_new_db(thd, sp->m_db.str, olddb, sizeof(olddb),
			  0, &dbchanged)))
  {
    ret= SP_NO_DB_ERROR;
    goto done;
  }

523
  if (!(table= open_proc_table_for_update(thd)))
524 525
    ret= SP_OPEN_TABLE_FAILED;
  else
526
  {
527
    restore_record(table, s->default_values); // Get default values for fields
528 529

    /* NOTE: all needed privilege checks have been already done. */
530
    strxnmov(definer, sizeof(definer)-1, thd->lex->definer->user.str, "@",
531
            thd->lex->definer->host.str, NullS);
532

533
    if (table->s->fields != MYSQL_PROC_FIELD_COUNT)
534 535 536 537
    {
      ret= SP_GET_FIELD_FAILED;
      goto done;
    }
538 539 540 541 542
    if (sp->m_name.length > table->field[MYSQL_PROC_FIELD_NAME]->field_length)
    {
      ret= SP_BAD_IDENTIFIER;
      goto done;
    }
543 544 545 546 547
    if (sp->m_body.length > table->field[MYSQL_PROC_FIELD_BODY]->field_length)
    {
      ret= SP_BODY_TOO_LONG;
      goto done;
    }
548 549
    table->field[MYSQL_PROC_FIELD_DB]->
      store(sp->m_db.str, sp->m_db.length, system_charset_info);
550 551 552 553 554 555
    table->field[MYSQL_PROC_FIELD_NAME]->
      store(sp->m_name.str, sp->m_name.length, system_charset_info);
    table->field[MYSQL_PROC_FIELD_TYPE]->
      store((longlong)type);
    table->field[MYSQL_PROC_FIELD_SPECIFIC_NAME]->
      store(sp->m_name.str, sp->m_name.length, system_charset_info);
556 557 558
    if (sp->m_chistics->daccess != SP_DEFAULT_ACCESS)
      table->field[MYSQL_PROC_FIELD_ACCESS]->
	store((longlong)sp->m_chistics->daccess);
559 560
    table->field[MYSQL_PROC_FIELD_DETERMINISTIC]->
      store((longlong)(sp->m_chistics->detistic ? 1 : 2));
561
    if (sp->m_chistics->suid != SP_IS_DEFAULT_SUID)
562 563 564 565
      table->field[MYSQL_PROC_FIELD_SECURITY_TYPE]->
	store((longlong)sp->m_chistics->suid);
    table->field[MYSQL_PROC_FIELD_PARAM_LIST]->
      store(sp->m_params.str, sp->m_params.length, system_charset_info);
unknown's avatar
unknown committed
566 567 568 569
    if (sp->m_type == TYPE_ENUM_FUNCTION)
    {
      String retstr(64);
      sp_returns_type(thd, retstr, sp);
570
      table->field[MYSQL_PROC_FIELD_RETURNS]->
unknown's avatar
unknown committed
571 572
	store(retstr.ptr(), retstr.length(), system_charset_info);
    }
573 574 575
    table->field[MYSQL_PROC_FIELD_BODY]->
      store(sp->m_body.str, sp->m_body.length, system_charset_info);
    table->field[MYSQL_PROC_FIELD_DEFINER]->
576
      store(definer, (uint)strlen(definer), system_charset_info);
577
    ((Field_timestamp *)table->field[MYSQL_PROC_FIELD_CREATED])->set_time();
578
    ((Field_timestamp *)table->field[MYSQL_PROC_FIELD_MODIFIED])->set_time();
579 580 581 582 583 584
    table->field[MYSQL_PROC_FIELD_SQL_MODE]->
      store((longlong)thd->variables.sql_mode);
    if (sp->m_chistics->comment.str)
      table->field[MYSQL_PROC_FIELD_COMMENT]->
	store(sp->m_chistics->comment.str, sp->m_chistics->comment.length,
	      system_charset_info);
585

586 587
    if ((sp->m_type == TYPE_ENUM_FUNCTION) &&
        !trust_function_creators && mysql_bin_log.is_open())
588 589 590 591
    {
      if (!sp->m_chistics->detistic)
      {
	/*
592
	  Note that this test is not perfect; one could use
593 594 595 596 597 598 599 600 601 602 603 604 605 606
	  a non-deterministic read-only function in an update statement.
	*/
	enum enum_sp_data_access access=
	  (sp->m_chistics->daccess == SP_DEFAULT_ACCESS) ?
	  SP_DEFAULT_ACCESS_MAPPING : sp->m_chistics->daccess;
	if (access == SP_CONTAINS_SQL ||
	    access == SP_MODIFIES_SQL_DATA)
	{
	  my_message(ER_BINLOG_UNSAFE_ROUTINE,
		     ER(ER_BINLOG_UNSAFE_ROUTINE), MYF(0));
	  ret= SP_INTERNAL_ERROR;
	  goto done;
	}
      }
607
      if (!(thd->security_ctx->master_access & SUPER_ACL))
608 609 610 611 612 613 614 615
      {
	my_message(ER_BINLOG_CREATE_ROUTINE_NEED_SUPER,
		   ER(ER_BINLOG_CREATE_ROUTINE_NEED_SUPER), MYF(0));
	ret= SP_INTERNAL_ERROR;
	goto done;
      }
    }

unknown's avatar
unknown committed
616
    ret= SP_OK;
617
    if (table->file->ha_write_row(table->record[0]))
618
      ret= SP_WRITE_ROW_FAILED;
619 620 621
    else if (mysql_bin_log.is_open())
    {
      thd->clear_error();
622 623 624 625 626 627 628 629

      String log_query;
      log_query.set_charset(system_charset_info);
      log_query.append(STRING_WITH_LEN("CREATE "));
      append_definer(thd, &log_query, &thd->lex->definer->user,
                     &thd->lex->definer->host);
      log_query.append(thd->lex->stmt_definition_begin);

630
      /* Such a statement can always go directly to binlog, no trans cache */
631
      thd->binlog_query(THD::MYSQL_QUERY_TYPE,
632
                        log_query.c_ptr(), log_query.length(), FALSE, FALSE);
633 634
    }

635 636
  }

637
done:
638
  close_thread_tables(thd);
639
  if (dbchanged)
640
    (void)mysql_change_db(thd, olddb, 1);
641 642
  DBUG_RETURN(ret);
}
643

unknown's avatar
unknown committed
644

645
static int
646
db_drop_routine(THD *thd, int type, sp_name *name)
647 648 649
{
  TABLE *table;
  int ret;
unknown's avatar
unknown committed
650
  DBUG_ENTER("db_drop_routine");
651
  DBUG_PRINT("enter", ("type: %d name: %.*s",
652
		       type, name->m_name.length, name->m_name.str));
653

654 655 656
  if (!(table= open_proc_table_for_update(thd)))
    DBUG_RETURN(SP_OPEN_TABLE_FAILED);
  if ((ret= db_find_routine_aux(thd, type, name, table)) == SP_OK)
657
  {
658
    if (table->file->ha_delete_row(table->record[0]))
659 660
      ret= SP_DELETE_ROW_FAILED;
  }
661
  close_thread_tables(thd);
662 663 664
  DBUG_RETURN(ret);
}

unknown's avatar
unknown committed
665

unknown's avatar
unknown committed
666
static int
667
db_update_routine(THD *thd, int type, sp_name *name, st_sp_chistics *chistics)
unknown's avatar
unknown committed
668 669 670
{
  TABLE *table;
  int ret;
unknown's avatar
unknown committed
671
  DBUG_ENTER("db_update_routine");
672
  DBUG_PRINT("enter", ("type: %d name: %.*s",
673
		       type, name->m_name.length, name->m_name.str));
unknown's avatar
unknown committed
674

675 676 677
  if (!(table= open_proc_table_for_update(thd)))
    DBUG_RETURN(SP_OPEN_TABLE_FAILED);
  if ((ret= db_find_routine_aux(thd, type, name, table)) == SP_OK)
unknown's avatar
unknown committed
678 679
  {
    store_record(table,record[1]);
unknown's avatar
unknown committed
680
    table->timestamp_field_type= TIMESTAMP_NO_AUTO_SET;
unknown's avatar
unknown committed
681
    ((Field_timestamp *)table->field[MYSQL_PROC_FIELD_MODIFIED])->set_time();
682 683 684 685 686 687
    if (chistics->suid != SP_IS_DEFAULT_SUID)
      table->field[MYSQL_PROC_FIELD_SECURITY_TYPE]->
	store((longlong)chistics->suid);
    if (chistics->daccess != SP_DEFAULT_ACCESS)
      table->field[MYSQL_PROC_FIELD_ACCESS]->
	store((longlong)chistics->daccess);
688 689 690
    if (chistics->comment.str)
      table->field[MYSQL_PROC_FIELD_COMMENT]->store(chistics->comment.str,
						    chistics->comment.length,
unknown's avatar
unknown committed
691
						    system_charset_info);
692
    if ((table->file->ha_update_row(table->record[1],table->record[0])))
unknown's avatar
unknown committed
693 694
      ret= SP_WRITE_ROW_FAILED;
  }
695
  close_thread_tables(thd);
unknown's avatar
unknown committed
696 697 698
  DBUG_RETURN(ret);
}

unknown's avatar
unknown committed
699

unknown's avatar
unknown committed
700 701 702 703 704 705 706 707 708 709
struct st_used_field
{
  const char *field_name;
  uint field_length;
  enum enum_field_types field_type;
  Field *field;
};

static struct st_used_field init_fields[]=
{
710
  { "Db",       NAME_LEN, MYSQL_TYPE_STRING,    0},
unknown's avatar
unknown committed
711 712
  { "Name",     NAME_LEN, MYSQL_TYPE_STRING,    0},
  { "Type",            9, MYSQL_TYPE_STRING,    0},
713
  { "Definer",        77, MYSQL_TYPE_STRING,    0},
unknown's avatar
unknown committed
714 715
  { "Modified",        0, MYSQL_TYPE_TIMESTAMP, 0},
  { "Created",         0, MYSQL_TYPE_TIMESTAMP, 0},
716
  { "Security_type",   1, MYSQL_TYPE_STRING,    0},
unknown's avatar
unknown committed
717 718 719 720
  { "Comment",  NAME_LEN, MYSQL_TYPE_STRING,    0},
  { 0,                 0, MYSQL_TYPE_STRING,    0}
};

unknown's avatar
unknown committed
721

722 723 724 725
static int
print_field_values(THD *thd, TABLE *table,
		   struct st_used_field *used_fields,
		   int type, const char *wild)
unknown's avatar
unknown committed
726 727 728 729 730
{
  Protocol *protocol= thd->protocol;

  if (table->field[MYSQL_PROC_FIELD_TYPE]->val_int() == type)
  {
731 732
    String db_string;
    String name_string;
unknown's avatar
unknown committed
733
    struct st_used_field *used_field= used_fields;
734

unknown's avatar
unknown committed
735
    if (get_field(thd->mem_root, used_field->field, &db_string))
736 737
      db_string.set_ascii("", 0);
    used_field+= 1;
unknown's avatar
unknown committed
738
    get_field(thd->mem_root, used_field->field, &name_string);
739 740

    if (!wild || !wild[0] || !wild_compare(name_string.ptr(), wild, 0))
unknown's avatar
unknown committed
741 742
    {
      protocol->prepare_for_resend();
743 744
      protocol->store(&db_string);
      protocol->store(&name_string);
unknown's avatar
unknown committed
745 746 747 748 749 750
      for (used_field++;
	   used_field->field_name;
	   used_field++)
      {
	switch (used_field->field_type) {
	case MYSQL_TYPE_TIMESTAMP:
751 752
	  {
	    TIME tmp_time;
753 754

	    bzero((char *)&tmp_time, sizeof(tmp_time));
755 756 757 758
	    ((Field_timestamp *) used_field->field)->get_time(&tmp_time);
	    protocol->store(&tmp_time);
	  }
	  break;
unknown's avatar
unknown committed
759
	default:
760
	  {
761
	    String tmp_string;
762

unknown's avatar
unknown committed
763
	    get_field(thd->mem_root, used_field->field, &tmp_string);
764
	    protocol->store(&tmp_string);
765 766
	  }
	  break;
unknown's avatar
unknown committed
767 768 769
	}
      }
      if (protocol->write())
770
	return SP_INTERNAL_ERROR;
unknown's avatar
unknown committed
771 772
    }
  }
773
  return SP_OK;
unknown's avatar
unknown committed
774 775
}

unknown's avatar
unknown committed
776

777
static int
unknown's avatar
unknown committed
778 779 780 781
db_show_routine_status(THD *thd, int type, const char *wild)
{
  TABLE *table;
  TABLE_LIST tables;
782
  int res;
unknown's avatar
unknown committed
783
  DBUG_ENTER("db_show_routine_status");
unknown's avatar
unknown committed
784 785 786

  memset(&tables, 0, sizeof(tables));
  tables.db= (char*)"mysql";
787
  tables.table_name= tables.alias= (char*)"proc";
unknown's avatar
unknown committed
788 789 790

  if (! (table= open_ltable(thd, &tables, TL_READ)))
  {
791 792
    res= SP_OPEN_TABLE_FAILED;
    goto done;
unknown's avatar
unknown committed
793 794 795 796 797 798
  }
  else
  {
    Item *item;
    List<Item> field_list;
    struct st_used_field *used_field;
799
    TABLE_LIST *leaves= 0;
unknown's avatar
unknown committed
800
    st_used_field used_fields[array_elements(init_fields)];
801

unknown's avatar
unknown committed
802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819
    memcpy((char*) used_fields, (char*) init_fields, sizeof(used_fields));
    /* Init header */
    for (used_field= &used_fields[0];
	 used_field->field_name;
	 used_field++)
    {
      switch (used_field->field_type) {
      case MYSQL_TYPE_TIMESTAMP:
	field_list.push_back(item=new Item_datetime(used_field->field_name));
	break;
      default:
	field_list.push_back(item=new Item_empty_string(used_field->field_name,
							used_field->
							field_length));
	break;
      }
    }
    /* Print header */
820 821
    if (thd->protocol->send_fields(&field_list, Protocol::SEND_NUM_ROWS |
                                                Protocol::SEND_EOF))
822 823
    {
      res= SP_INTERNAL_ERROR;
unknown's avatar
unknown committed
824
      goto err_case;
825
    }
unknown's avatar
unknown committed
826

unknown's avatar
VIEW  
unknown committed
827 828 829 830 831
    /*
      Init fields

      tables is not VIEW for sure => we can pass 0 as condition
    */
832 833
    thd->lex->select_lex.context.resolve_in_table_list_only(&tables);
    setup_tables(thd, &thd->lex->select_lex.context,
unknown's avatar
unknown committed
834
                 &thd->lex->select_lex.top_join_list,
835
                 &tables, 0, &leaves, FALSE);
unknown's avatar
unknown committed
836 837 838 839
    for (used_field= &used_fields[0];
	 used_field->field_name;
	 used_field++)
    {
840 841
      Item_field *field= new Item_field(&thd->lex->select_lex.context,
                                        "mysql", "proc",
unknown's avatar
unknown committed
842
					used_field->field_name);
843
      if (!field ||
unknown's avatar
unknown committed
844
          !(used_field->field= find_field_in_tables(thd, field, &tables, NULL,
845 846
						    0, REPORT_ALL_ERRORS, 1,
                                                    TRUE)))
847 848
      {
	res= SP_INTERNAL_ERROR;
unknown's avatar
unknown committed
849
	goto err_case1;
850
      }
unknown's avatar
unknown committed
851 852
    }

853
    table->file->ha_index_init(0, 1);
854 855
    if ((res= table->file->index_first(table->record[0])))
    {
unknown's avatar
unknown committed
856
      res= (res == HA_ERR_END_OF_FILE) ? 0 : SP_INTERNAL_ERROR;
857 858 859
      goto err_case1;
    }
    if ((res= print_field_values(thd, table, used_fields, type, wild)))
unknown's avatar
unknown committed
860 861 862
      goto err_case1;
    while (!table->file->index_next(table->record[0]))
    {
863
      if ((res= print_field_values(thd, table, used_fields, type, wild)))
unknown's avatar
unknown committed
864 865
	goto err_case1;
    }
866
    res= SP_OK;
unknown's avatar
unknown committed
867
  }
868

unknown's avatar
unknown committed
869
err_case1:
unknown's avatar
unknown committed
870
  send_eof(thd);
unknown's avatar
unknown committed
871
err_case:
unknown's avatar
unknown committed
872
  table->file->ha_index_end();
unknown's avatar
unknown committed
873
  close_thread_tables(thd);
unknown's avatar
unknown committed
874
done:
875
  DBUG_RETURN(res);
unknown's avatar
unknown committed
876 877
}

878

879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897
/* Drop all routines in database 'db' */
int
sp_drop_db_routines(THD *thd, char *db)
{
  TABLE *table;
  byte key[64];			// db
  uint keylen;
  int ret;
  DBUG_ENTER("sp_drop_db_routines");
  DBUG_PRINT("enter", ("db: %s", db));

  // Put the key used to read the row together
  keylen= strlen(db);
  if (keylen > 64)
    keylen= 64;
  memcpy(key, db, keylen);
  memset(key+keylen, (int)' ', 64-keylen); // Pad with space
  keylen= sizeof(key);

898 899 900
  ret= SP_OPEN_TABLE_FAILED;
  if (!(table= open_proc_table_for_update(thd)))
    goto err;
901 902

  ret= SP_OK;
903
  table->file->ha_index_init(0, 1);
904 905 906 907 908 909
  if (! table->file->index_read(table->record[0],
				key, keylen, HA_READ_KEY_EXACT))
  {
    int nxtres;
    bool deleted= FALSE;

910 911
    do
    {
912
      if (! table->file->ha_delete_row(table->record[0]))
913 914 915 916
	deleted= TRUE;		/* We deleted something */
      else
      {
	ret= SP_DELETE_ROW_FAILED;
917
	nxtres= 0;
918 919 920 921 922 923 924 925 926
	break;
      }
    } while (! (nxtres= table->file->index_next_same(table->record[0],
						     key, keylen)));
    if (nxtres != HA_ERR_END_OF_FILE)
      ret= SP_KEY_NOT_FOUND;
    if (deleted)
      sp_cache_invalidate();
  }
unknown's avatar
unknown committed
927
  table->file->ha_index_end();
928 929 930

  close_thread_tables(thd);

931
err:
932 933 934 935
  DBUG_RETURN(ret);
}


unknown's avatar
unknown committed
936 937 938
/*****************************************************************************
  PROCEDURE
******************************************************************************/
939

940
/*
941
  Obtain object representing stored procedure/function by its name from
942 943 944
  stored procedures cache and looking into mysql.proc if needed.

  SYNOPSIS
945
    sp_find_routine()
946
      thd        - thread context
947
      type       - type of object (TYPE_ENUM_FUNCTION or TYPE_ENUM_PROCEDURE)
948
      name       - name of procedure
949
      cp         - hash to look routine in
950 951 952 953 954 955 956 957
      cache_only - if true perform cache-only lookup
                   (Don't look in mysql.proc).

  RETURN VALUE
    Non-0 pointer to sp_head object for the procedure, or
    0 - in case of error.
*/

958
sp_head *
959 960
sp_find_routine(THD *thd, int type, sp_name *name, sp_cache **cp,
                bool cache_only)
961 962
{
  sp_head *sp;
963 964 965 966 967 968 969 970
  ulong depth= (type == TYPE_ENUM_PROCEDURE ?
                thd->variables.max_sp_recursion_depth :
                0);
  DBUG_ENTER("sp_find_routine");
  DBUG_PRINT("enter", ("name:  %.*s.%.*s, type: %d, cache only %d",
                       name->m_db.length, name->m_db.str,
                       name->m_name.length, name->m_name.str,
                       type, cache_only));
971

972
  if ((sp= sp_cache_lookup(cp, name)))
973
  {
974
    ulong level;
unknown's avatar
unknown committed
975 976
    sp_head *new_sp;
    const char *returns= "";
977
    char definer[USER_HOST_BUFF_SIZE];
unknown's avatar
unknown committed
978 979
    String retstr(64);

980 981 982 983 984 985 986 987 988 989
    DBUG_PRINT("info", ("found: 0x%lx", (ulong)sp));
    if (sp->m_first_free_instance)
    {
      DBUG_PRINT("info", ("first free: 0x%lx, level: %lu, flags %x",
                          (ulong)sp->m_first_free_instance,
                          sp->m_first_free_instance->m_recursion_level,
                          sp->m_first_free_instance->m_flags));
      DBUG_ASSERT(!(sp->m_first_free_instance->m_flags & sp_head::IS_INVOKED));
      if (sp->m_first_free_instance->m_recursion_level > depth)
      {
unknown's avatar
unknown committed
990
        sp->recursion_level_error(thd);
991 992 993 994 995 996 997
        DBUG_RETURN(0);
      }
      DBUG_RETURN(sp->m_first_free_instance);
    }
    level= sp->m_last_cached_sp->m_recursion_level + 1;
    if (level > depth)
    {
unknown's avatar
unknown committed
998
      sp->recursion_level_error(thd);
999 1000
      DBUG_RETURN(0);
    }
unknown's avatar
unknown committed
1001 1002 1003 1004

    strxmov(definer, sp->m_definer_user.str, "@",
            sp->m_definer_host.str, NullS);
    if (type == TYPE_ENUM_FUNCTION)
1005
    {
unknown's avatar
unknown committed
1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018
      sp_returns_type(thd, retstr, sp);
      returns= retstr.ptr();
    }
    if (db_load_routine(thd, type, name, &new_sp,
                        sp->m_sql_mode, sp->m_params.str, returns,
                        sp->m_body.str, *sp->m_chistics, definer,
                        sp->m_created, sp->m_modified) == SP_OK)
    {
      sp->m_last_cached_sp->m_next_cached_sp= new_sp;
      new_sp->m_recursion_level= level;
      new_sp->m_first_instance= sp;
      sp->m_last_cached_sp= sp->m_first_free_instance= new_sp;
      DBUG_PRINT("info", ("added level: 0x%lx, level: %lu, flags %x",
1019 1020
                          (ulong)new_sp, new_sp->m_recursion_level,
                          new_sp->m_flags));
unknown's avatar
unknown committed
1021
      DBUG_RETURN(new_sp);
1022
    }
unknown's avatar
unknown committed
1023
    DBUG_RETURN(0);
1024 1025
  }
  if (!cache_only)
1026
  {
1027 1028 1029 1030 1031 1032 1033
    if (db_find_routine(thd, type, name, &sp) == SP_OK)
    {
      sp_cache_insert(cp, sp);
      DBUG_PRINT("info", ("added new: 0x%lx, level: %lu, flags %x",
                          (ulong)sp, sp->m_recursion_level,
                          sp->m_flags));
    }
1034
  }
1035 1036 1037
  DBUG_RETURN(sp);
}

unknown's avatar
unknown committed
1038

1039 1040 1041 1042
/*
  This is used by sql_acl.cc:mysql_routine_grant() and is used to find
  the routines in 'routines'.
*/
1043

1044
int
1045
sp_exist_routines(THD *thd, TABLE_LIST *routines, bool any, bool no_error)
1046
{
1047
  TABLE_LIST *routine;
1048
  bool result= 0;
1049
  bool sp_object_found;
1050
  DBUG_ENTER("sp_exists_routine");
1051
  for (routine= routines; routine; routine= routine->next_global)
1052 1053 1054 1055
  {
    sp_name *name;
    LEX_STRING lex_db;
    LEX_STRING lex_name;
1056 1057 1058 1059
    lex_db.length= strlen(routine->db);
    lex_name.length= strlen(routine->table_name);
    lex_db.str= thd->strmake(routine->db, lex_db.length);
    lex_name.str= thd->strmake(routine->table_name, lex_name.length);
1060 1061
    name= new sp_name(lex_db, lex_name);
    name->init_qname(thd);
1062 1063 1064 1065 1066 1067
    sp_object_found= sp_find_routine(thd, TYPE_ENUM_PROCEDURE, name,
                                     &thd->sp_proc_cache, FALSE) != NULL ||
                     sp_find_routine(thd, TYPE_ENUM_FUNCTION, name,
                                     &thd->sp_func_cache, FALSE) != NULL;
    mysql_reset_errors(thd, TRUE);
    if (sp_object_found)
1068 1069 1070 1071 1072 1073 1074 1075 1076 1077
    {
      if (any)
        DBUG_RETURN(1);
      result= 1;
    }
    else if (!any)
    {
      if (!no_error)
      {
	my_error(ER_SP_DOES_NOT_EXIST, MYF(0), "FUNCTION or PROCEDURE", 
1078
		 routine->table_name);
1079 1080 1081 1082 1083 1084 1085 1086 1087
	DBUG_RETURN(-1);
      }
      DBUG_RETURN(0);
    }
  }
  DBUG_RETURN(result);
}


1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112
/*
  Check if a routine exists in the mysql.proc table, without actually
  parsing the definition. (Used for dropping)

  SYNOPSIS
    sp_routine_exists_in_table()
      thd        - thread context
      name       - name of procedure

  RETURN VALUE
    0     - Success
    non-0 - Error;  SP_OPEN_TABLE_FAILED or SP_KEY_NOT_FOUND
*/

int
sp_routine_exists_in_table(THD *thd, int type, sp_name *name)
{
  TABLE *table;
  int ret;
  Open_tables_state open_tables_state_backup;

  if (!(table= open_proc_table_for_read(thd, &open_tables_state_backup)))
    ret= SP_OPEN_TABLE_FAILED;
  else
  {
1113
    if ((ret= db_find_routine_aux(thd, type, name, table)) != SP_OK)
1114 1115 1116 1117 1118 1119 1120
      ret= SP_KEY_NOT_FOUND;
    close_proc_table(thd, &open_tables_state_backup);
  }
  return ret;
}


1121
int
1122
sp_create_procedure(THD *thd, sp_head *sp)
1123
{
1124
  int ret;
1125
  DBUG_ENTER("sp_create_procedure");
1126
  DBUG_PRINT("enter", ("name: %.*s", sp->m_name.length, sp->m_name.str));
1127 1128 1129

  ret= db_create_routine(thd, TYPE_ENUM_PROCEDURE, sp);
  DBUG_RETURN(ret);
1130 1131
}

unknown's avatar
unknown committed
1132

1133
int
1134
sp_drop_procedure(THD *thd, sp_name *name)
1135
{
1136
  int ret;
1137
  DBUG_ENTER("sp_drop_procedure");
1138
  DBUG_PRINT("enter", ("name: %.*s", name->m_name.length, name->m_name.str));
1139

1140
  ret= db_drop_routine(thd, TYPE_ENUM_PROCEDURE, name);
unknown's avatar
unknown committed
1141
  if (!ret)
1142
    sp_cache_invalidate();
1143
  DBUG_RETURN(ret);
1144
}
1145

unknown's avatar
unknown committed
1146

unknown's avatar
unknown committed
1147
int
1148
sp_update_procedure(THD *thd, sp_name *name, st_sp_chistics *chistics)
unknown's avatar
unknown committed
1149
{
1150
  int ret;
unknown's avatar
unknown committed
1151
  DBUG_ENTER("sp_update_procedure");
1152
  DBUG_PRINT("enter", ("name: %.*s", name->m_name.length, name->m_name.str));
unknown's avatar
unknown committed
1153

1154
  ret= db_update_routine(thd, TYPE_ENUM_PROCEDURE, name, chistics);
unknown's avatar
unknown committed
1155
  if (!ret)
1156
    sp_cache_invalidate();
1157
  DBUG_RETURN(ret);
unknown's avatar
unknown committed
1158 1159
}

unknown's avatar
unknown committed
1160

unknown's avatar
unknown committed
1161
int
1162
sp_show_create_procedure(THD *thd, sp_name *name)
unknown's avatar
unknown committed
1163
{
unknown's avatar
unknown committed
1164
  sp_head *sp;
unknown's avatar
unknown committed
1165
  DBUG_ENTER("sp_show_create_procedure");
1166
  DBUG_PRINT("enter", ("name: %.*s", name->m_name.length, name->m_name.str));
unknown's avatar
unknown committed
1167

1168 1169
  if ((sp= sp_find_routine(thd, TYPE_ENUM_PROCEDURE, name,
                           &thd->sp_proc_cache, FALSE)))
1170 1171 1172 1173 1174
  {
    int ret= sp->show_create_procedure(thd);

    DBUG_RETURN(ret);
  }
unknown's avatar
unknown committed
1175

1176
  DBUG_RETURN(SP_KEY_NOT_FOUND);
unknown's avatar
unknown committed
1177 1178
}

unknown's avatar
unknown committed
1179

unknown's avatar
unknown committed
1180
int
1181
sp_show_status_procedure(THD *thd, const char *wild)
unknown's avatar
unknown committed
1182
{
1183
  int ret;
1184
  DBUG_ENTER("sp_show_status_procedure");
1185 1186 1187

  ret= db_show_routine_status(thd, TYPE_ENUM_PROCEDURE, wild);
  DBUG_RETURN(ret);
unknown's avatar
unknown committed
1188
}
1189

unknown's avatar
unknown committed
1190 1191 1192 1193

/*****************************************************************************
  FUNCTION
******************************************************************************/
1194 1195

int
1196
sp_create_function(THD *thd, sp_head *sp)
1197
{
1198
  int ret;
1199
  DBUG_ENTER("sp_create_function");
1200
  DBUG_PRINT("enter", ("name: %.*s", sp->m_name.length, sp->m_name.str));
1201

1202 1203
  ret= db_create_routine(thd, TYPE_ENUM_FUNCTION, sp);
  DBUG_RETURN(ret);
1204 1205
}

unknown's avatar
unknown committed
1206

1207
int
1208
sp_drop_function(THD *thd, sp_name *name)
1209
{
1210
  int ret;
1211
  DBUG_ENTER("sp_drop_function");
1212
  DBUG_PRINT("enter", ("name: %.*s", name->m_name.length, name->m_name.str));
1213

1214
  ret= db_drop_routine(thd, TYPE_ENUM_FUNCTION, name);
unknown's avatar
unknown committed
1215
  if (!ret)
1216
    sp_cache_invalidate();
1217
  DBUG_RETURN(ret);
1218
}
1219

unknown's avatar
unknown committed
1220

unknown's avatar
unknown committed
1221
int
1222
sp_update_function(THD *thd, sp_name *name, st_sp_chistics *chistics)
unknown's avatar
unknown committed
1223
{
1224
  int ret;
unknown's avatar
unknown committed
1225
  DBUG_ENTER("sp_update_procedure");
1226
  DBUG_PRINT("enter", ("name: %.*s", name->m_name.length, name->m_name.str));
unknown's avatar
unknown committed
1227

1228
  ret= db_update_routine(thd, TYPE_ENUM_FUNCTION, name, chistics);
unknown's avatar
unknown committed
1229
  if (!ret)
1230
    sp_cache_invalidate();
1231
  DBUG_RETURN(ret);
unknown's avatar
unknown committed
1232 1233
}

unknown's avatar
unknown committed
1234

unknown's avatar
unknown committed
1235
int
1236
sp_show_create_function(THD *thd, sp_name *name)
unknown's avatar
unknown committed
1237
{
unknown's avatar
unknown committed
1238
  sp_head *sp;
unknown's avatar
unknown committed
1239
  DBUG_ENTER("sp_show_create_function");
1240
  DBUG_PRINT("enter", ("name: %.*s", name->m_name.length, name->m_name.str));
unknown's avatar
unknown committed
1241

1242 1243
  if ((sp= sp_find_routine(thd, TYPE_ENUM_FUNCTION, name,
                           &thd->sp_func_cache, FALSE)))
1244 1245 1246 1247 1248
  {
    int ret= sp->show_create_function(thd);

    DBUG_RETURN(ret);
  }
1249
  DBUG_RETURN(SP_KEY_NOT_FOUND);
unknown's avatar
unknown committed
1250 1251
}

unknown's avatar
unknown committed
1252

unknown's avatar
unknown committed
1253
int
1254
sp_show_status_function(THD *thd, const char *wild)
unknown's avatar
unknown committed
1255
{
1256
  int ret;
1257
  DBUG_ENTER("sp_show_status_function");
1258 1259
  ret= db_show_routine_status(thd, TYPE_ENUM_FUNCTION, wild);
  DBUG_RETURN(ret);
unknown's avatar
unknown committed
1260 1261
}

unknown's avatar
unknown committed
1262

1263 1264 1265 1266 1267 1268 1269
/*
  Structure that represents element in the set of stored routines
  used by statement or routine.
*/
struct Sroutine_hash_entry;

struct Sroutine_hash_entry
1270
{
1271 1272 1273 1274 1275 1276 1277
  /* Set key consisting of one-byte routine type and quoted routine name. */
  LEX_STRING key;
  /*
    Next element in list linking all routines in set. See also comments
    for LEX::sroutine/sroutine_list and sp_head::m_sroutines.
  */
  Sroutine_hash_entry *next;
1278 1279 1280 1281 1282 1283
  /*
    Uppermost view which directly or indirectly uses this routine.
    0 if routine is not used in view. Note that it also can be 0 if
    statement uses routine both via view and directly.
  */
  TABLE_LIST *belong_to_view;
1284 1285 1286 1287 1288 1289 1290 1291
};


extern "C" byte* sp_sroutine_key(const byte *ptr, uint *plen, my_bool first)
{
  Sroutine_hash_entry *rn= (Sroutine_hash_entry *)ptr;
  *plen= rn->key.length;
  return (byte *)rn->key.str;
1292 1293
}

unknown's avatar
unknown committed
1294

1295
/*
1296 1297 1298 1299
  Check if
   - current statement (the one in thd->lex) needs table prelocking
   - first routine in thd->lex->sroutines_list needs to execute its body in
     prelocked mode.
1300 1301

  SYNOPSIS
1302 1303 1304 1305 1306 1307 1308 1309 1310 1311
    sp_get_prelocking_info()
      thd                  Current thread, thd->lex is the statement to be
                           checked.
      need_prelocking      OUT TRUE  - prelocked mode should be activated
                                       before executing the statement
                               FALSE - Don't activate prelocking 
      first_no_prelocking  OUT TRUE  - Tables used by first routine in
                                       thd->lex->sroutines_list should be
                                       prelocked.
                               FALSE - Otherwise.
1312 1313 1314 1315 1316 1317
  NOTES 
    This function assumes that for any "CALL proc(...)" statement routines_list 
    will have 'proc' as first element (it may have several, consider e.g.
    "proc(sp_func(...)))". This property is currently guaranted by the parser.
*/

1318 1319
void sp_get_prelocking_info(THD *thd, bool *need_prelocking, 
                            bool *first_no_prelocking)
1320 1321
{
  Sroutine_hash_entry *routine;
1322
  routine= (Sroutine_hash_entry*)thd->lex->sroutines_list.first;
1323

1324 1325
  DBUG_ASSERT(routine);
  bool first_is_procedure= (routine->key.str[0] == TYPE_ENUM_PROCEDURE);
1326

1327 1328
  *first_no_prelocking= first_is_procedure;
  *need_prelocking= !first_is_procedure || test(routine->next);
1329 1330 1331
}


1332 1333 1334 1335 1336 1337
/*
  Auxilary function that adds new element to the set of stored routines
  used by statement.

  SYNOPSIS
    add_used_routine()
1338 1339 1340 1341 1342
      lex             LEX representing statement
      arena           Arena in which memory for new element will be allocated
      key             Key for the hash representing set
      belong_to_view  Uppermost view which uses this routine
                      (0 if routine is not used by view)
1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363

  NOTES
    Will also add element to end of 'LEX::sroutines_list' list.

    In case when statement uses stored routines but does not need
    prelocking (i.e. it does not use any tables) we will access the
    elements of LEX::sroutines set on prepared statement re-execution.
    Because of this we have to allocate memory for both hash element
    and copy of its key in persistent arena.

  TODO
    When we will got rid of these accesses on re-executions we will be
    able to allocate memory for hash elements in non-persitent arena
    and directly use key values from sp_head::m_sroutines sets instead
    of making their copies.

  RETURN VALUE
    TRUE  - new element was added.
    FALSE - element was not added (because it is already present in the set).
*/

1364
static bool add_used_routine(LEX *lex, Query_arena *arena,
1365 1366
                             const LEX_STRING *key,
                             TABLE_LIST *belong_to_view)
1367
{
1368
  if (!hash_search(&lex->sroutines, (byte *)key->str, key->length))
1369
  {
1370 1371 1372 1373 1374 1375 1376 1377 1378 1379
    Sroutine_hash_entry *rn=
      (Sroutine_hash_entry *)arena->alloc(sizeof(Sroutine_hash_entry) +
                                          key->length);
    if (!rn)              // OOM. Error will be reported using fatal_error().
      return FALSE;
    rn->key.length= key->length;
    rn->key.str= (char *)rn + sizeof(Sroutine_hash_entry);
    memcpy(rn->key.str, key->str, key->length);
    my_hash_insert(&lex->sroutines, (byte *)rn);
    lex->sroutines_list.link_in_list((byte *)rn, (byte **)&rn->next);
1380
    rn->belong_to_view= belong_to_view;
1381
    return TRUE;
1382
  }
1383
  return FALSE;
1384 1385
}

unknown's avatar
unknown committed
1386

1387
/*
1388 1389
  Add routine which is explicitly used by statement to the set of stored
  routines used by this statement.
1390 1391

  SYNOPSIS
1392 1393 1394 1395 1396 1397 1398 1399
    sp_add_used_routine()
      lex     - LEX representing statement
      arena   - arena in which memory for new element of the set
                will be allocated
      rt      - routine name
      rt_type - routine type (one of TYPE_ENUM_PROCEDURE/...)

  NOTES
1400 1401
    Will also add element to end of 'LEX::sroutines_list' list (and will
    take into account that this is explicitly used routine).
1402 1403 1404 1405 1406

    To be friendly towards prepared statements one should pass
    persistent arena as second argument.
*/

1407
void sp_add_used_routine(LEX *lex, Query_arena *arena,
1408 1409 1410
                         sp_name *rt, char rt_type)
{
  rt->set_routine_type(rt_type);
1411
  (void)add_used_routine(lex, arena, &rt->m_sroutines_key, 0);
1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442
  lex->sroutines_list_own_last= lex->sroutines_list.next;
  lex->sroutines_list_own_elements= lex->sroutines_list.elements;
}


/*
  Remove routines which are only indirectly used by statement from
  the set of routines used by this statement.

  SYNOPSIS
    sp_remove_not_own_routines()
      lex  LEX representing statement
*/

void sp_remove_not_own_routines(LEX *lex)
{
  Sroutine_hash_entry *not_own_rt, *next_rt;
  for (not_own_rt= *(Sroutine_hash_entry **)lex->sroutines_list_own_last;
       not_own_rt; not_own_rt= next_rt)
  {
    /*
      It is safe to obtain not_own_rt->next after calling hash_delete() now
      but we want to be more future-proof.
    */
    next_rt= not_own_rt->next;
    hash_delete(&lex->sroutines, (byte *)not_own_rt);
  }

  *(Sroutine_hash_entry **)lex->sroutines_list_own_last= NULL;
  lex->sroutines_list.next= lex->sroutines_list_own_last;
  lex->sroutines_list.elements= lex->sroutines_list_own_elements;
1443 1444 1445 1446 1447 1448 1449 1450 1451
}


/*
  Merge contents of two hashes representing sets of routines used
  by statements or by other routines.

  SYNOPSIS
    sp_update_sp_used_routines()
1452 1453 1454
      dst - hash to which elements should be added
      src - hash from which elements merged

1455 1456 1457 1458 1459 1460 1461
  NOTE
    This procedure won't create new Sroutine_hash_entry objects,
    instead it will simply add elements from source to destination
    hash. Thus time of life of elements in destination hash becomes
    dependant on time of life of elements from source hash. It also
    won't touch lists linking elements in source and destination
    hashes.
1462 1463
*/

1464
void sp_update_sp_used_routines(HASH *dst, HASH *src)
1465
{
1466
  for (uint i=0 ; i < src->records ; i++)
1467
  {
1468 1469 1470
    Sroutine_hash_entry *rt= (Sroutine_hash_entry *)hash_element(src, i);
    if (!hash_search(dst, (byte *)rt->key.str, rt->key.length))
      my_hash_insert(dst, (byte *)rt);
1471 1472 1473
  }
}

unknown's avatar
unknown committed
1474

1475
/*
1476 1477
  Add contents of hash representing set of routines to the set of
  routines used by statement.
1478 1479

  SYNOPSIS
1480
    sp_update_stmt_used_routines()
1481 1482 1483 1484
      thd             Thread context
      lex             LEX representing statement
      src             Hash representing set from which routines will be added
      belong_to_view  Uppermost view which uses these routines, 0 if none
1485 1486 1487 1488 1489

  NOTE
    It will also add elements to end of 'LEX::sroutines_list' list.
*/

1490 1491 1492
static void
sp_update_stmt_used_routines(THD *thd, LEX *lex, HASH *src,
                             TABLE_LIST *belong_to_view)
1493 1494 1495 1496
{
  for (uint i=0 ; i < src->records ; i++)
  {
    Sroutine_hash_entry *rt= (Sroutine_hash_entry *)hash_element(src, i);
1497
    (void)add_used_routine(lex, thd->stmt_arena, &rt->key, belong_to_view);
1498 1499 1500 1501
  }
}


1502 1503 1504 1505 1506 1507
/*
  Add contents of list representing set of routines to the set of
  routines used by statement.

  SYNOPSIS
    sp_update_stmt_used_routines()
1508 1509 1510 1511
      thd             Thread context
      lex             LEX representing statement
      src             List representing set from which routines will be added
      belong_to_view  Uppermost view which uses these routines, 0 if none
1512 1513 1514 1515 1516

  NOTE
    It will also add elements to end of 'LEX::sroutines_list' list.
*/

1517 1518
static void sp_update_stmt_used_routines(THD *thd, LEX *lex, SQL_LIST *src,
                                         TABLE_LIST *belong_to_view)
1519 1520 1521
{
  for (Sroutine_hash_entry *rt= (Sroutine_hash_entry *)src->first;
       rt; rt= rt->next)
1522
    (void)add_used_routine(lex, thd->stmt_arena, &rt->key, belong_to_view);
1523 1524 1525
}


1526 1527 1528 1529 1530 1531 1532
/*
  Cache sub-set of routines used by statement, add tables used by these
  routines to statement table list. Do the same for all routines used
  by these routines.

  SYNOPSIS
    sp_cache_routines_and_add_tables_aux()
1533 1534 1535 1536 1537 1538 1539
      thd              - thread context
      lex              - LEX representing statement
      start            - first routine from the list of routines to be cached
                         (this list defines mentioned sub-set).
      first_no_prelock - If true, don't add tables or cache routines used by
                         the body of the first routine (i.e. *start)
                         will be executed in non-prelocked mode.
1540
      tabs_changed     - Set to TRUE some tables were added, FALSE otherwise
1541 1542 1543 1544
  NOTE
    If some function is missing this won't be reported here.
    Instead this fact will be discovered during query execution.

1545
  RETURN VALUE
1546 1547
     0     - success
     non-0 - failure
1548 1549
*/

1550
static int
1551
sp_cache_routines_and_add_tables_aux(THD *thd, LEX *lex,
1552
                                     Sroutine_hash_entry *start, 
1553
                                     bool first_no_prelock, bool *tabs_changed)
1554
{
1555
  int ret= 0;
1556
  bool tabschnd= 0;             /* Set if tables changed */
1557
  bool first= TRUE;
1558
  DBUG_ENTER("sp_cache_routines_and_add_tables_aux");
1559

1560
  for (Sroutine_hash_entry *rt= start; rt; rt= rt->next)
1561
  {
1562 1563 1564
    sp_name name(rt->key.str, rt->key.length);
    int type= rt->key.str[0];
    sp_head *sp;
1565

1566 1567 1568
    if (!(sp= sp_cache_lookup((type == TYPE_ENUM_FUNCTION ?
                              &thd->sp_func_cache : &thd->sp_proc_cache),
                              &name)))
1569
    {
1570 1571 1572 1573 1574 1575 1576
      name.m_name.str= strchr(name.m_qname.str, '.');
      name.m_db.length= name.m_name.str - name.m_qname.str;
      name.m_db.str= strmake_root(thd->mem_root, name.m_qname.str,
                                  name.m_db.length);
      name.m_name.str+= 1;
      name.m_name.length= name.m_qname.length - name.m_db.length - 1;

1577
      switch ((ret= db_find_routine(thd, type, &name, &sp)))
1578
      {
1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599
      case SP_OK:
        {
          if (type == TYPE_ENUM_FUNCTION)
            sp_cache_insert(&thd->sp_func_cache, sp);
          else
            sp_cache_insert(&thd->sp_proc_cache, sp);
        }
        break;
      case SP_KEY_NOT_FOUND:
        ret= SP_OK;
        break;
      case SP_OPEN_TABLE_FAILED:
        /*
          Force it to attempt opening it again on subsequent calls;
          otherwise we will get one error message the first time, and
          then ER_SP_PROC_TABLE_CORRUPT (below) on subsequent tries.
        */
        mysql_proc_table_exists= 1;
        /* Fall through */
      default:
        /*
1600 1601 1602 1603 1604 1605
          Any error when loading an existing routine is either some problem
          with the mysql.proc table, or a parse error because the contents
          has been tampered with (in which case we clear that error).
        */
        if (ret == SP_PARSE_ERROR)
          thd->clear_error();
1606 1607 1608 1609 1610
        /*
          If we cleared the parse error, or when db_find_routine() flagged
          an error with it's return value without calling my_error(), we
          set the generic "mysql.proc table corrupt" error here.
         */
1611 1612 1613 1614 1615 1616 1617 1618 1619
        if (!thd->net.report_error)
        {
          char n[NAME_LEN*2+2];

          /* m_qname.str is not always \0 terminated */
          memcpy(n, name.m_qname.str, name.m_qname.length);
          n[name.m_qname.length]= '\0';
          my_error(ER_SP_PROC_TABLE_CORRUPT, MYF(0), n, ret);
        }
1620
        break;
1621 1622 1623 1624
      }
    }
    if (sp)
    {
1625 1626
      if (!(first && first_no_prelock))
      {
1627 1628
        sp_update_stmt_used_routines(thd, lex, &sp->m_sroutines,
                                     rt->belong_to_view);
1629
        tabschnd|=
1630 1631
          sp->add_used_tables_to_table_list(thd, &lex->query_tables_last,
                                            rt->belong_to_view);
1632
      }
1633
    }
1634
    first= FALSE;
1635
  }
1636 1637
  if (tabs_changed)             /* it can be NULL  */
    *tabs_changed= tabschnd;
1638
  DBUG_RETURN(ret);
1639 1640 1641 1642 1643 1644 1645 1646 1647 1648
}


/*
  Cache all routines from the set of used by statement, add tables used
  by those routines to statement table list. Do the same for all routines
  used by those routines.

  SYNOPSIS
    sp_cache_routines_and_add_tables()
1649 1650 1651 1652
      thd              - thread context
      lex              - LEX representing statement
      first_no_prelock - If true, don't add tables or cache routines used by
                         the body of the first routine (i.e. *start)
1653
      tabs_changed     - Set to TRUE some tables were added, FALSE otherwise
1654
                         
1655
  RETURN VALUE
1656 1657
     0     - success
     non-0 - failure
1658 1659
*/

1660 1661 1662
int
sp_cache_routines_and_add_tables(THD *thd, LEX *lex, bool first_no_prelock,
                                 bool *tabs_changed)
1663 1664
{
  return sp_cache_routines_and_add_tables_aux(thd, lex,
1665
           (Sroutine_hash_entry *)lex->sroutines_list.first,
1666
           first_no_prelock, tabs_changed);
1667 1668 1669 1670 1671 1672 1673 1674 1675 1676
}


/*
  Add all routines used by view to the set of routines used by statement.
  Add tables used by those routines to statement table list. Do the same
  for all routines used by these routines.

  SYNOPSIS
    sp_cache_routines_and_add_tables_for_view()
1677 1678 1679
      thd   Thread context
      lex   LEX representing statement
      view  Table list element representing view
1680

1681
  RETURN VALUE
1682 1683
     0     - success
     non-0 - failure
1684 1685
*/

1686
int
1687
sp_cache_routines_and_add_tables_for_view(THD *thd, LEX *lex, TABLE_LIST *view)
1688 1689 1690
{
  Sroutine_hash_entry **last_cached_routine_ptr=
                          (Sroutine_hash_entry **)lex->sroutines_list.next;
1691 1692
  sp_update_stmt_used_routines(thd, lex, &view->view->sroutines_list,
                               view->top_table());
1693 1694 1695
  return sp_cache_routines_and_add_tables_aux(thd, lex, 
                                              *last_cached_routine_ptr, FALSE,
                                              NULL);
1696 1697 1698 1699 1700 1701 1702 1703 1704 1705
}


/*
  Add triggers for table to the set of routines used by statement.
  Add tables used by them to statement table list. Do the same for
  all implicitly used routines.

  SYNOPSIS
    sp_cache_routines_and_add_tables_for_triggers()
1706 1707 1708
      thd    thread context
      lex    LEX respresenting statement
      table  Table list element for table with trigger
1709 1710

  RETURN VALUE
1711 1712
     0     - success
     non-0 - failure
1713 1714
*/

1715
int
1716
sp_cache_routines_and_add_tables_for_triggers(THD *thd, LEX *lex,
1717
                                              TABLE_LIST *table)
1718
{
1719
  int ret= 0;
1720 1721 1722
  Table_triggers_list *triggers= table->table->triggers;
  if (add_used_routine(lex, thd->stmt_arena, &triggers->sroutines_key,
                       table->belong_to_view))
1723 1724 1725
  {
    Sroutine_hash_entry **last_cached_routine_ptr=
                            (Sroutine_hash_entry **)lex->sroutines_list.next;
1726
    for (int i= 0; i < (int)TRG_EVENT_MAX; i++)
unknown's avatar
unknown committed
1727
    {
1728
      for (int j= 0; j < (int)TRG_ACTION_MAX; j++)
unknown's avatar
unknown committed
1729
      {
1730
        if (triggers->bodies[i][j])
1731
        {
1732 1733 1734
          (void)triggers->bodies[i][j]->
                add_used_tables_to_table_list(thd, &lex->query_tables_last,
                                              table->belong_to_view);
1735
          sp_update_stmt_used_routines(thd, lex,
1736 1737
                                       &triggers->bodies[i][j]->m_sroutines,
                                       table->belong_to_view);
1738
        }
unknown's avatar
unknown committed
1739 1740
      }
    }
1741 1742 1743
    ret= sp_cache_routines_and_add_tables_aux(thd, lex,
                                              *last_cached_routine_ptr, 
                                              FALSE, NULL);
1744
  }
1745
  return ret;
1746
}
1747

1748

1749 1750 1751 1752 1753 1754
/*
 * Generates the CREATE... string from the table information.
 * Returns TRUE on success, FALSE on (alloc) failure.
 */
static bool
create_string(THD *thd, String *buf,
1755
	      int type,
1756
	      sp_name *name,
1757 1758 1759
	      const char *params, ulong paramslen,
	      const char *returns, ulong returnslen,
	      const char *body, ulong bodylen,
1760 1761 1762
	      st_sp_chistics *chistics,
              const LEX_STRING *definer_user,
              const LEX_STRING *definer_host)
1763
{
1764 1765
  /* Make some room to begin with */
  if (buf->alloc(100 + name->m_qname.length + paramslen + returnslen + bodylen +
1766 1767
		 chistics->comment.length + 10 /* length of " DEFINER= "*/ +
                 USER_HOST_BUFF_SIZE))
1768
    return FALSE;
unknown's avatar
unknown committed
1769

unknown's avatar
merge  
unknown committed
1770
  buf->append(STRING_WITH_LEN("CREATE "));
1771
  append_definer(thd, buf, definer_user, definer_host);
1772
  if (type == TYPE_ENUM_FUNCTION)
unknown's avatar
merge  
unknown committed
1773
    buf->append(STRING_WITH_LEN("FUNCTION "));
1774
  else
unknown's avatar
merge  
unknown committed
1775
    buf->append(STRING_WITH_LEN("PROCEDURE "));
1776 1777 1778 1779 1780 1781
  append_identifier(thd, buf, name->m_name.str, name->m_name.length);
  buf->append('(');
  buf->append(params, paramslen);
  buf->append(')');
  if (type == TYPE_ENUM_FUNCTION)
  {
unknown's avatar
merge  
unknown committed
1782
    buf->append(STRING_WITH_LEN(" RETURNS "));
1783 1784 1785
    buf->append(returns, returnslen);
  }
  buf->append('\n');
1786 1787
  switch (chistics->daccess) {
  case SP_NO_SQL:
unknown's avatar
merge  
unknown committed
1788
    buf->append(STRING_WITH_LEN("    NO SQL\n"));
1789 1790
    break;
  case SP_READS_SQL_DATA:
unknown's avatar
merge  
unknown committed
1791
    buf->append(STRING_WITH_LEN("    READS SQL DATA\n"));
1792 1793
    break;
  case SP_MODIFIES_SQL_DATA:
unknown's avatar
merge  
unknown committed
1794
    buf->append(STRING_WITH_LEN("    MODIFIES SQL DATA\n"));
1795
    break;
unknown's avatar
unknown committed
1796 1797 1798 1799
  case SP_DEFAULT_ACCESS:
  case SP_CONTAINS_SQL:
    /* Do nothing */
    break;
1800
  }
1801
  if (chistics->detistic)
unknown's avatar
merge  
unknown committed
1802
    buf->append(STRING_WITH_LEN("    DETERMINISTIC\n"));
1803
  if (chistics->suid == SP_IS_NOT_SUID)
unknown's avatar
merge  
unknown committed
1804
    buf->append(STRING_WITH_LEN("    SQL SECURITY INVOKER\n"));
1805
  if (chistics->comment.length)
unknown's avatar
unknown committed
1806
  {
unknown's avatar
merge  
unknown committed
1807
    buf->append(STRING_WITH_LEN("    COMMENT "));
1808 1809
    append_unescaped(buf, chistics->comment.str, chistics->comment.length);
    buf->append('\n');
unknown's avatar
unknown committed
1810
  }
1811 1812
  buf->append(body, bodylen);
  return TRUE;
1813
}
1814 1815 1816 1817 1818 1819 1820 1821


//
// Utilities...
//

int
sp_use_new_db(THD *thd, char *newdb, char *olddb, uint olddblen,
1822
	      bool no_access_check, bool *dbchangedp)
1823 1824 1825 1826 1827
{
  bool changeit;
  DBUG_ENTER("sp_use_new_db");
  DBUG_PRINT("enter", ("newdb: %s", newdb));

1828 1829
  if (! newdb)
    newdb= (char *)"";
1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849
  if (thd->db && thd->db[0])
  {
    if (my_strcasecmp(system_charset_info, thd->db, newdb) == 0)
      changeit= 0;
    else
    {
      changeit= 1;
      strnmov(olddb, thd->db, olddblen);
    }
  }
  else
  {				// thd->db empty
    if (newdb[0])
      changeit= 1;
    else
      changeit= 0;
    olddb[0] = '\0';
  }
  if (!changeit)
  {
1850
    *dbchangedp= FALSE;
1851 1852 1853 1854
    DBUG_RETURN(0);
  }
  else
  {
1855
    int ret= mysql_change_db(thd, newdb, no_access_check);
1856

1857 1858
    if (! ret)
      *dbchangedp= TRUE;
1859 1860 1861
    DBUG_RETURN(ret);
  }
}