sql_class.cc 53.4 KB
Newer Older
unknown's avatar
unknown committed
1
/* Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
unknown's avatar
unknown committed
2

unknown's avatar
unknown committed
3 4 5 6
   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.
unknown's avatar
unknown committed
7

unknown's avatar
unknown committed
8 9 10 11
   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.
unknown's avatar
unknown committed
12

unknown's avatar
unknown committed
13 14 15 16 17 18 19 20 21 22 23 24
   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 */


/*****************************************************************************
**
** This file implements classes defined in sql_class.h
** Especially the classes to handle a result from a select
**
*****************************************************************************/

25
#ifdef USE_PRAGMA_IMPLEMENTATION
unknown's avatar
unknown committed
26 27 28 29 30 31
#pragma implementation				// gcc: Class implementation
#endif

#include "mysql_priv.h"
#include <m_ctype.h>
#include <sys/stat.h>
32
#include <thr_alarm.h>
unknown's avatar
unknown committed
33 34 35
#ifdef	__WIN__
#include <io.h>
#endif
36
#include <mysys_err.h>
unknown's avatar
unknown committed
37

unknown's avatar
unknown committed
38 39
#include "sp_rcontext.h"
#include "sp_cache.h"
40

41 42 43 44 45 46
/*
  The following is used to initialise Table_ident with a internal
  table name
*/
char internal_table_name[2]= "*";

47

unknown's avatar
unknown committed
48 49 50 51
/*****************************************************************************
** Instansiate templates
*****************************************************************************/

52
#ifdef HAVE_EXPLICIT_TEMPLATE_INSTANTIATION
unknown's avatar
unknown committed
53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
/* Used templates */
template class List<Key>;
template class List_iterator<Key>;
template class List<key_part_spec>;
template class List_iterator<key_part_spec>;
template class List<Alter_drop>;
template class List_iterator<Alter_drop>;
template class List<Alter_column>;
template class List_iterator<Alter_column>;
#endif

/****************************************************************************
** User variables
****************************************************************************/

68 69
extern "C" byte *get_var_key(user_var_entry *entry, uint *length,
			     my_bool not_used __attribute__((unused)))
unknown's avatar
unknown committed
70 71 72 73 74
{
  *length=(uint) entry->name.length;
  return (byte*) entry->name.str;
}

75
extern "C" void free_user_var(user_var_entry *entry)
unknown's avatar
unknown committed
76 77 78 79 80 81 82
{
  char *pos= (char*) entry+ALIGN_SIZE(sizeof(*entry));
  if (entry->value && entry->value != pos)
    my_free(entry->value, MYF(0));
  my_free((char*) entry,MYF(0));
}

83 84 85 86 87
bool key_part_spec::operator==(const key_part_spec& other) const
{
  return length == other.length && !strcmp(field_name, other.field_name);
}

88 89

/*
90
  Test if a foreign key (= generated key) is a prefix of the given key
91 92 93 94 95 96 97 98 99 100 101 102 103 104
  (ignoring key name, key type and order of columns)

  NOTES:
    This is only used to test if an index for a FOREIGN KEY exists

  IMPLEMENTATION
    We only compare field names

  RETURN
    0	Generated key is a prefix of other key
    1	Not equal
*/

bool foreign_key_prefix(Key *a, Key *b)
105
{
106 107 108 109
  /* Ensure that 'a' is the generated key */
  if (a->generated)
  {
    if (b->generated && a->columns.elements > b->columns.elements)
110
      swap_variables(Key*, a, b);               // Put shorter key in 'a'
111 112
  }
  else
113
  {
114 115
    if (!b->generated)
      return TRUE;                              // No foreign key
116
    swap_variables(Key*, a, b);                 // Put generated key in 'a'
117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132
  }

  /* Test if 'a' is a prefix of 'b' */
  if (a->columns.elements > b->columns.elements)
    return TRUE;                                // Can't be prefix

  List_iterator<key_part_spec> col_it1(a->columns);
  List_iterator<key_part_spec> col_it2(b->columns);
  const key_part_spec *col1, *col2;

#ifdef ENABLE_WHEN_INNODB_CAN_HANDLE_SWAPED_FOREIGN_KEY_COLUMNS
  while ((col1= col_it1++))
  {
    bool found= 0;
    col_it2.rewind();
    while ((col2= col_it2++))
133
    {
134 135 136 137 138
      if (*col1 == *col2)
      {
        found= TRUE;
	break;
      }
139
    }
140 141 142 143 144 145 146 147 148 149
    if (!found)
      return TRUE;                              // Error
  }
  return FALSE;                                 // Is prefix
#else
  while ((col1= col_it1++))
  {
    col2= col_it2++;
    if (!(*col1 == *col2))
      return TRUE;
150
  }
151 152
  return FALSE;                                 // Is prefix
#endif
153 154 155
}


unknown's avatar
unknown committed
156 157 158
/****************************************************************************
** Thread specific functions
****************************************************************************/
159

160 161
Open_tables_state::Open_tables_state(ulong version_arg)
  :version(version_arg)
162 163 164 165 166
{
  reset_open_tables_state();
}


unknown's avatar
unknown committed
167 168 169 170 171
/*
  Pass nominal parameters to Statement constructor only to ensure that
  the destructor works OK in case of error. The main_mem_root will be
  re-initialized in init().
*/
unknown's avatar
unknown committed
172

173
THD::THD()
unknown's avatar
unknown committed
174
  :Statement(CONVENTIONAL_EXECUTION, 0, ALLOC_ROOT_MIN_BLOCK_SIZE, 0),
175
   Open_tables_state(refresh_version),
176
   lock_id(&main_lock_id),
177
   user_time(0), in_sub_stmt(0), global_read_lock(0), is_fatal_error(0),
178 179
   rand_used(0), time_zone_used(0),
   last_insert_id_used(0), insert_id_used(0), clear_next_insert_id(0),
180
   in_lock_tables(0), bootstrap(0), derived_tables_processing(FALSE),
181
   spcont(NULL)
unknown's avatar
unknown committed
182
{
unknown's avatar
unknown committed
183
  stmt_arena= this;
184
  db= 0;
185
  catalog= (char*)"std"; // the only catalog we have for now
186 187
  main_security_ctx.init();
  security_ctx= &main_security_ctx;
unknown's avatar
unknown committed
188
  locked=some_tables_deleted=no_errors=password= 0;
unknown's avatar
unknown committed
189
  query_start_used= 0;
190
  count_cuted_fields= CHECK_FIELD_IGNORE;
unknown's avatar
SCRUM  
unknown committed
191
  killed= NOT_KILLED;
192
  db_length= col_access=0;
unknown's avatar
unknown committed
193
  query_error= tmp_table_used= 0;
unknown's avatar
unknown committed
194
  next_insert_id=last_insert_id=0;
195
  hash_clear(&handler_tables_hash);
unknown's avatar
unknown committed
196
  tmp_table=0;
197
  used_tables=0;
198
  cuted_fields= sent_row_count= 0L;
199
  limit_found_rows= 0;
200
  statement_id_counter= 0UL;
201
  // Must be reset to handle error with THD's created for init of mysqld
unknown's avatar
unknown committed
202
  lex->current_select= 0;
unknown's avatar
unknown committed
203
  start_time=(time_t) 0;
unknown's avatar
unknown committed
204
  current_linfo =  0;
205
  slave_thread = 0;
unknown's avatar
unknown committed
206
  variables.pseudo_thread_id= 0;
207
  one_shot_set= 0;
208
  file_id = 0;
209
  query_id= 0;
210
  warn_id= 0;
211
  db_charset= global_system_variables.collation_database;
212
  bzero(ha_data, sizeof(ha_data));
unknown's avatar
unknown committed
213
  mysys_var=0;
214
  binlog_evt_union.do_union= FALSE;
215 216
#ifndef DBUG_OFF
  dbug_sentry=THD_SENTRY_MAGIC;
217
#endif
218
#ifndef EMBEDDED_LIBRARY
unknown's avatar
unknown committed
219
  net.vio=0;
220
#endif
221
  client_capabilities= 0;                       // minimalistic client
222 223
  net.last_error[0]=0;                          // If error on boot
  net.query_cache_query=0;                      // If error on boot
unknown's avatar
unknown committed
224
  ull=0;
225
  system_thread= cleanup_done= abort_on_warning= no_warnings_for_error= 0;
226
  peer_port= 0;					// For SHOW PROCESSLIST
unknown's avatar
unknown committed
227 228 229 230 231
#ifdef	__WIN__
  real_id = 0;
#endif
#ifdef SIGNAL_WITH_VIO_CLOSE
  active_vio = 0;
232
#endif
233
  pthread_mutex_init(&LOCK_delete, MY_MUTEX_INIT_FAST);
unknown's avatar
unknown committed
234 235 236 237 238

  /* Variables with default values */
  proc_info="login";
  where="field list";
  server_id = ::server_id;
239
  slave_net = 0;
unknown's avatar
unknown committed
240
  command=COM_CONNECT;
unknown's avatar
unknown committed
241
  *scramble= '\0';
unknown's avatar
unknown committed
242

unknown's avatar
unknown committed
243
  init();
unknown's avatar
unknown committed
244
  /* Initialize sub structures */
245
  init_sql_alloc(&warn_root, WARN_ALLOC_BLOCK_SIZE, WARN_ALLOC_PREALLOC_SIZE);
246
  user_connect=(USER_CONN *)0;
247
  hash_init(&user_vars, system_charset_info, USER_VARS_HASH_SIZE, 0, 0,
unknown's avatar
unknown committed
248
	    (hash_get_key) get_var_key,
249
	    (hash_free_key) free_user_var, 0);
250

251 252
  sp_proc_cache= NULL;
  sp_func_cache= NULL;
253

unknown's avatar
unknown committed
254 255 256
  /* For user vars replication*/
  if (opt_bin_log)
    my_init_dynamic_array(&user_var_events,
257
			  sizeof(BINLOG_USER_VAR_EVENT *), 16, 16);
unknown's avatar
unknown committed
258 259 260
  else
    bzero((char*) &user_var_events, sizeof(user_var_events));

261 262 263 264 265
  /* Protocol */
  protocol= &protocol_simple;			// Default protocol
  protocol_simple.init(this);
  protocol_prep.init(this);

unknown's avatar
unknown committed
266
  tablespace_op=FALSE;
267 268
  ulong tmp=sql_rnd_with_mutex();
  randominit(&rand, tmp + (ulong) &rand, tmp + (ulong) ::query_id);
269 270
  thr_lock_info_init(&lock_info); /* safety: will be reset after start */
  thr_lock_owner_init(&main_lock_id, &lock_info);
unknown's avatar
unknown committed
271 272
}

unknown's avatar
unknown committed
273 274 275 276 277 278 279

/*
  Init common variables that has to be reset on start and on change_user
*/

void THD::init(void)
{
280 281
  pthread_mutex_lock(&LOCK_global_system_variables);
  variables= global_system_variables;
282 283 284 285 286 287
  variables.time_format= date_time_format_copy((THD*) 0,
					       variables.time_format);
  variables.date_format= date_time_format_copy((THD*) 0,
					       variables.date_format);
  variables.datetime_format= date_time_format_copy((THD*) 0,
						   variables.datetime_format);
288 289 290
#ifdef HAVE_NDBCLUSTER_DB
  variables.ndb_use_transactions= 1;
#endif
291
  pthread_mutex_unlock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
292
  server_status= SERVER_STATUS_AUTOCOMMIT;
293 294
  if (variables.sql_mode & MODE_NO_BACKSLASH_ESCAPES)
    server_status|= SERVER_STATUS_NO_BACKSLASH_ESCAPES;
unknown's avatar
unknown committed
295 296
  options= thd_startup_options;
  open_options=ha_open_options;
297 298 299
  update_lock_default= (variables.low_priority_updates ?
			TL_WRITE_LOW_PRIORITY :
			TL_WRITE);
unknown's avatar
unknown committed
300
  session_tx_isolation= (enum_tx_isolation) variables.tx_isolation;
301 302 303
  warn_list.empty();
  bzero((char*) warn_count, sizeof(warn_count));
  total_warn_count= 0;
304
  update_charset();
305
  bzero((char *) &status_var, sizeof(status_var));
unknown's avatar
unknown committed
306 307
}

308

309 310 311 312 313 314 315 316
/*
  Init THD for query processing.
  This has to be called once before we call mysql_parse.
  See also comments in sql_class.h.
*/

void THD::init_for_queries()
{
317
  ha_enable_transaction(this,TRUE);
318

unknown's avatar
unknown committed
319
  reset_root_defaults(mem_root, variables.query_alloc_block_size,
320
                      variables.query_prealloc_size);
321
#ifdef USING_TRANSACTIONS
322 323 324
  reset_root_defaults(&transaction.mem_root,
                      variables.trans_alloc_block_size,
                      variables.trans_prealloc_size);
325
#endif
326 327
  transaction.xid_state.xid.null();
  transaction.xid_state.in_thd=1;
328 329 330
}


unknown's avatar
unknown committed
331 332 333 334 335 336 337 338 339 340 341 342 343 344
/*
  Do what's needed when one invokes change user

  SYNOPSIS
    change_user()

  IMPLEMENTATION
    Reset all resources that are connection specific
*/


void THD::change_user(void)
{
  cleanup();
unknown's avatar
unknown committed
345
  cleanup_done= 0;
unknown's avatar
unknown committed
346
  init();
347
  stmt_map.reset();
348
  hash_init(&user_vars, system_charset_info, USER_VARS_HASH_SIZE, 0, 0,
unknown's avatar
unknown committed
349
	    (hash_get_key) get_var_key,
unknown's avatar
unknown committed
350
	    (hash_free_key) free_user_var, 0);
351 352
  sp_cache_clear(&sp_proc_cache);
  sp_cache_clear(&sp_func_cache);
unknown's avatar
unknown committed
353 354 355
}


unknown's avatar
unknown committed
356 357 358
/* Do operations that may take a long time */

void THD::cleanup(void)
unknown's avatar
unknown committed
359
{
unknown's avatar
unknown committed
360
  DBUG_ENTER("THD::cleanup");
unknown's avatar
unknown committed
361
#ifdef ENABLE_WHEN_BINLOG_WILL_BE_ABLE_TO_PREPARE
362 363 364 365
  if (transaction.xid_state.xa_state == XA_PREPARED)
  {
#error xid_state in the cache should be replaced by the allocated value
  }
unknown's avatar
unknown committed
366
#endif
367
  {
unknown's avatar
unknown committed
368
    ha_rollback(this);
369 370
    xid_cache_delete(&transaction.xid_state);
  }
unknown's avatar
unknown committed
371 372 373 374 375
  if (locked_tables)
  {
    lock=locked_tables; locked_tables=0;
    close_thread_tables(this);
  }
376 377 378
  mysql_ha_flush(this, (TABLE_LIST*) 0,
                 MYSQL_HA_CLOSE_FINAL | MYSQL_HA_FLUSH_ALL);
  hash_free(&handler_tables_hash);
379 380
  delete_dynamic(&user_var_events);
  hash_free(&user_vars);
unknown's avatar
unknown committed
381
  close_temporary_tables(this);
382 383 384
  my_free((char*) variables.time_format, MYF(MY_ALLOW_ZERO_PTR));
  my_free((char*) variables.date_format, MYF(MY_ALLOW_ZERO_PTR));
  my_free((char*) variables.datetime_format, MYF(MY_ALLOW_ZERO_PTR));
385
  
386
  sp_cache_clear(&sp_proc_cache);
387 388
  sp_cache_clear(&sp_func_cache);

unknown's avatar
unknown committed
389 390 391
  if (global_read_lock)
    unlock_global_read_lock(this);
  if (ull)
392
  {
unknown's avatar
unknown committed
393 394 395 396
    pthread_mutex_lock(&LOCK_user_locks);
    item_user_lock_release(ull);
    pthread_mutex_unlock(&LOCK_user_locks);
    ull= 0;
397
  }
398

unknown's avatar
unknown committed
399 400 401 402
  cleanup_done=1;
  DBUG_VOID_RETURN;
}

unknown's avatar
unknown committed
403

unknown's avatar
unknown committed
404 405
THD::~THD()
{
406
  THD_CHECK_SENTRY(this);
unknown's avatar
unknown committed
407
  DBUG_ENTER("~THD()");
408 409 410
  /* Ensure that no one is using THD */
  pthread_mutex_lock(&LOCK_delete);
  pthread_mutex_unlock(&LOCK_delete);
411
  add_to_status(&global_status_var, &status_var);
412

unknown's avatar
unknown committed
413
  /* Close connection */
unknown's avatar
unknown committed
414
#ifndef EMBEDDED_LIBRARY
unknown's avatar
unknown committed
415 416 417
  if (net.vio)
  {
    vio_delete(net.vio);
unknown's avatar
unknown committed
418
    net_end(&net);
unknown's avatar
unknown committed
419
  }
420
#endif
421 422
  stmt_map.destroy();                     /* close all prepared statements */
  DBUG_ASSERT(lock_info.n_cursors == 0);
unknown's avatar
unknown committed
423 424
  if (!cleanup_done)
    cleanup();
425

unknown's avatar
unknown committed
426
  ha_close_connection(this);
unknown's avatar
unknown committed
427

428 429
  DBUG_PRINT("info", ("freeing security context"));
  main_security_ctx.destroy();
430
  safeFree(db);
431
  free_root(&warn_root,MYF(0));
432
#ifdef USING_TRANSACTIONS
433
  free_root(&transaction.mem_root,MYF(0));
434
#endif
unknown's avatar
unknown committed
435
  mysys_var=0;					// Safety (shouldn't be needed)
436
  pthread_mutex_destroy(&LOCK_delete);
437
#ifndef DBUG_OFF
unknown's avatar
unknown committed
438
  dbug_sentry= THD_SENTRY_GONE;
439
#endif  
unknown's avatar
unknown committed
440 441 442
  DBUG_VOID_RETURN;
}

443

444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461
/*
  Add to one status variable another status variable

  NOTES
    This function assumes that all variables are long/ulong.
    If this assumption will change, then we have to explictely add
    the other variables after the while loop
*/

void add_to_status(STATUS_VAR *to_var, STATUS_VAR *from_var)
{
  ulong *end= (ulong*) ((byte*) to_var + offsetof(STATUS_VAR,
						  last_system_status_var) +
			sizeof(ulong));
  ulong *to= (ulong*) to_var, *from= (ulong*) from_var;

  while (to != end)
    *(to++)+= *(from++);
462
  /* it doesn't make sense to add last_query_cost values */
463 464 465
}


unknown's avatar
SCRUM  
unknown committed
466
void THD::awake(THD::killed_state state_to_set)
467
{
468
  THD_CHECK_SENTRY(this);
469 470
  safe_mutex_assert_owner(&LOCK_delete); 

unknown's avatar
SCRUM  
unknown committed
471 472 473
  killed= state_to_set;
  if (state_to_set != THD::KILL_QUERY)
    thr_alarm_kill(real_id);
474 475 476 477
#ifdef SIGNAL_WITH_VIO_CLOSE
  close_active_vio();
#endif    
  if (mysys_var)
unknown's avatar
unknown committed
478 479 480 481 482 483 484 485 486
  {
    pthread_mutex_lock(&mysys_var->mutex);
    if (!system_thread)		// Don't abort locks
      mysys_var->abort=1;
    /*
      This broadcast could be up in the air if the victim thread
      exits the cond in the time between read and broadcast, but that is
      ok since all we want to do is to make the victim thread get out
      of waiting on current_cond.
487 488 489 490 491
      If we see a non-zero current_cond: it cannot be an old value (because
      then exit_cond() should have run and it can't because we have mutex); so
      it is the true value but maybe current_mutex is not yet non-zero (we're
      in the middle of enter_cond() and there is a "memory order
      inversion"). So we test the mutex too to not lock 0.
492

493
      Note that there is a small chance we fail to kill. If victim has locked
494 495 496 497 498
      current_mutex, but hasn't yet entered enter_cond() (which means that
      current_cond and current_mutex are 0), then the victim will not get
      a signal and it may wait "forever" on the cond (until
      we issue a second KILL or the status it's waiting for happens).
      It's true that we have set its thd->killed but it may not
499
      see it immediately and so may have time to reach the cond_wait().
unknown's avatar
unknown committed
500
    */
501
    if (mysys_var->current_cond && mysys_var->current_mutex)
502
    {
unknown's avatar
unknown committed
503 504 505
      pthread_mutex_lock(mysys_var->current_mutex);
      pthread_cond_broadcast(mysys_var->current_cond);
      pthread_mutex_unlock(mysys_var->current_mutex);
506
    }
unknown's avatar
unknown committed
507 508
    pthread_mutex_unlock(&mysys_var->mutex);
  }
509 510
}

unknown's avatar
unknown committed
511 512 513 514
/*
  Remember the location of thread info, the structure needed for
  sql_alloc() and the structure for the net buffer
*/
unknown's avatar
unknown committed
515 516 517

bool THD::store_globals()
{
518
  if (my_pthread_setspecific_ptr(THR_THD,  this) ||
unknown's avatar
unknown committed
519
      my_pthread_setspecific_ptr(THR_MALLOC, &mem_root))
520 521 522
    return 1;
  mysys_var=my_thread_var;
  dbug_thread_id=my_thread_id();
unknown's avatar
unknown committed
523 524 525 526
  /*
    By default 'slave_proxy_id' is 'thread_id'. They may later become different
    if this is the slave SQL thread.
  */
527
  variables.pseudo_thread_id= thread_id;
528 529 530 531
  /*
    We have to call thr_lock_info_init() again here as THD may have been
    created in another thread
  */
532
  thr_lock_info_init(&lock_info);
533
  return 0;
unknown's avatar
unknown committed
534 535
}

unknown's avatar
unknown committed
536

537 538 539 540 541 542 543 544 545 546
/* Cleanup after a query */

void THD::cleanup_after_query()
{
  if (clear_next_insert_id)
  {
    clear_next_insert_id= 0;
    next_insert_id= 0;
  }
  /* Free Items that were created during this execution */
547
  free_items();
548 549
}

unknown's avatar
unknown committed
550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575
/*
  Convert a string to another character set

  SYNOPSIS
    convert_string()
    to				Store new allocated string here
    to_cs			New character set for allocated string
    from			String to convert
    from_length			Length of string to convert
    from_cs			Original character set

  NOTES
    to will be 0-terminated to make it easy to pass to system funcs

  RETURN
    0	ok
    1	End of memory.
        In this case to->str will point to 0 and to->length will be 0.
*/

bool THD::convert_string(LEX_STRING *to, CHARSET_INFO *to_cs,
			 const char *from, uint from_length,
			 CHARSET_INFO *from_cs)
{
  DBUG_ENTER("convert_string");
  size_s new_length= to_cs->mbmaxlen * from_length;
576
  uint dummy_errors;
unknown's avatar
unknown committed
577 578 579 580 581 582
  if (!(to->str= alloc(new_length+1)))
  {
    to->length= 0;				// Safety fix
    DBUG_RETURN(1);				// EOM
  }
  to->length= copy_and_convert((char*) to->str, new_length, to_cs,
583
			       from, from_length, from_cs, &dummy_errors);
unknown's avatar
unknown committed
584 585 586 587 588
  to->str[to->length]=0;			// Safety
  DBUG_RETURN(0);
}


589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605
/*
  Convert string from source character set to target character set inplace.

  SYNOPSIS
    THD::convert_string

  DESCRIPTION
    Convert string using convert_buffer - buffer for character set 
    conversion shared between all protocols.

  RETURN
    0   ok
   !0   out of memory
*/

bool THD::convert_string(String *s, CHARSET_INFO *from_cs, CHARSET_INFO *to_cs)
{
606 607
  uint dummy_errors;
  if (convert_buffer.copy(s->ptr(), s->length(), from_cs, to_cs, &dummy_errors))
608 609 610 611 612 613 614 615 616 617 618
    return TRUE;
  /* If convert_buffer >> s copying is more efficient long term */
  if (convert_buffer.alloced_length() >= convert_buffer.length() * 2 ||
      !s->is_alloced())
  {
    return s->copy(convert_buffer);
  }
  s->swap(convert_buffer);
  return FALSE;
}

619

unknown's avatar
unknown committed
620 621 622 623 624 625
/*
  Update some cache variables when character set changes
*/

void THD::update_charset()
{
626 627 628 629 630 631 632
  uint32 not_used;
  charset_is_system_charset= !String::needs_conversion(0,charset(),
                                                       system_charset_info,
                                                       &not_used);
  charset_is_collation_connection= 
    !String::needs_conversion(0,charset(),variables.collation_connection,
                              &not_used);
unknown's avatar
unknown committed
633 634 635
}


636 637 638 639 640 641 642 643 644 645 646 647 648 649
/* routings to adding tables to list of changed in transaction tables */

inline static void list_include(CHANGED_TABLE_LIST** prev,
				CHANGED_TABLE_LIST* curr,
				CHANGED_TABLE_LIST* new_table)
{
  if (new_table)
  {
    *prev = new_table;
    (*prev)->next = curr;
  }
}

/* add table to list of changed in transaction tables */
650

651 652
void THD::add_changed_table(TABLE *table)
{
653
  DBUG_ENTER("THD::add_changed_table(table)");
654

unknown's avatar
unknown committed
655
  DBUG_ASSERT((options & (OPTION_NOT_AUTOCOMMIT | OPTION_BEGIN)) &&
656
	      table->file->has_transactions());
657
  add_changed_table(table->s->table_cache_key, table->s->key_length);
unknown's avatar
unknown committed
658
  DBUG_VOID_RETURN;
unknown's avatar
unknown committed
659
}
660

661

unknown's avatar
unknown committed
662 663 664
void THD::add_changed_table(const char *key, long key_length)
{
  DBUG_ENTER("THD::add_changed_table(key)");
665 666
  CHANGED_TABLE_LIST **prev_changed = &transaction.changed_tables;
  CHANGED_TABLE_LIST *curr = transaction.changed_tables;
667

668
  for (; curr; prev_changed = &(curr->next), curr = curr->next)
669
  {
unknown's avatar
unknown committed
670
    int cmp =  (long)curr->key_length - (long)key_length;
671 672
    if (cmp < 0)
    {
673
      list_include(prev_changed, curr, changed_table_dup(key, key_length));
674
      DBUG_PRINT("info", 
675
		 ("key_length %u %u", key_length, (*prev_changed)->key_length));
676 677 678 679
      DBUG_VOID_RETURN;
    }
    else if (cmp == 0)
    {
unknown's avatar
unknown committed
680
      cmp = memcmp(curr->key, key, curr->key_length);
681 682
      if (cmp < 0)
      {
683
	list_include(prev_changed, curr, changed_table_dup(key, key_length));
684
	DBUG_PRINT("info", 
unknown's avatar
unknown committed
685
		   ("key_length %u %u", key_length,
686
		    (*prev_changed)->key_length));
687 688 689 690 691 692 693 694 695
	DBUG_VOID_RETURN;
      }
      else if (cmp == 0)
      {
	DBUG_PRINT("info", ("already in list"));
	DBUG_VOID_RETURN;
      }
    }
  }
696
  *prev_changed = changed_table_dup(key, key_length);
unknown's avatar
unknown committed
697
  DBUG_PRINT("info", ("key_length %u %u", key_length,
698
		      (*prev_changed)->key_length));
699 700 701
  DBUG_VOID_RETURN;
}

702

unknown's avatar
unknown committed
703
CHANGED_TABLE_LIST* THD::changed_table_dup(const char *key, long key_length)
704 705 706
{
  CHANGED_TABLE_LIST* new_table = 
    (CHANGED_TABLE_LIST*) trans_alloc(ALIGN_SIZE(sizeof(CHANGED_TABLE_LIST))+
unknown's avatar
unknown committed
707
				      key_length + 1);
708 709
  if (!new_table)
  {
710 711
    my_error(EE_OUTOFMEMORY, MYF(ME_BELL),
             ALIGN_SIZE(sizeof(TABLE_LIST)) + key_length + 1);
unknown's avatar
SCRUM  
unknown committed
712
    killed= KILL_CONNECTION;
713 714 715 716 717 718
    return 0;
  }

  new_table->key = (char *) (((byte*)new_table)+
			     ALIGN_SIZE(sizeof(CHANGED_TABLE_LIST)));
  new_table->next = 0;
unknown's avatar
unknown committed
719 720
  new_table->key_length = key_length;
  ::memcpy(new_table->key, key, key_length);
721 722 723
  return new_table;
}

724

unknown's avatar
unknown committed
725 726 727 728
int THD::send_explain_fields(select_result *result)
{
  List<Item> field_list;
  Item *item;
729
  CHARSET_INFO *cs= system_charset_info;
730
  field_list.push_back(new Item_return_int("id",3, MYSQL_TYPE_LONGLONG));
731
  field_list.push_back(new Item_empty_string("select_type", 19, cs));
unknown's avatar
unknown committed
732 733 734 735
  field_list.push_back(item= new Item_empty_string("table", NAME_LEN, cs));
  item->maybe_null= 1;
  field_list.push_back(item= new Item_empty_string("type", 10, cs));
  item->maybe_null= 1;
unknown's avatar
unknown committed
736
  field_list.push_back(item=new Item_empty_string("possible_keys",
737
						  NAME_LEN*MAX_KEY, cs));
unknown's avatar
unknown committed
738
  item->maybe_null=1;
739
  field_list.push_back(item=new Item_empty_string("key", NAME_LEN, cs));
unknown's avatar
unknown committed
740
  item->maybe_null=1;
unknown's avatar
unknown committed
741 742
  field_list.push_back(item=new Item_empty_string("key_len",
						  NAME_LEN*MAX_KEY));
unknown's avatar
unknown committed
743 744
  item->maybe_null=1;
  field_list.push_back(item=new Item_empty_string("ref",
745
						  NAME_LEN*MAX_REF_PARTS, cs));
unknown's avatar
unknown committed
746
  item->maybe_null=1;
unknown's avatar
unknown committed
747 748 749
  field_list.push_back(item= new Item_return_int("rows", 10,
                                                 MYSQL_TYPE_LONGLONG));
  item->maybe_null= 1;
750
  field_list.push_back(new Item_empty_string("Extra", 255, cs));
751 752
  return (result->send_fields(field_list,
                              Protocol::SEND_NUM_ROWS | Protocol::SEND_EOF));
unknown's avatar
unknown committed
753
}
754

unknown's avatar
unknown committed
755 756 757
#ifdef SIGNAL_WITH_VIO_CLOSE
void THD::close_active_vio()
{
unknown's avatar
unknown committed
758
  DBUG_ENTER("close_active_vio");
unknown's avatar
unknown committed
759
  safe_mutex_assert_owner(&LOCK_delete); 
unknown's avatar
unknown committed
760
#ifndef EMBEDDED_LIBRARY
unknown's avatar
unknown committed
761 762 763 764 765
  if (active_vio)
  {
    vio_close(active_vio);
    active_vio = 0;
  }
unknown's avatar
unknown committed
766
#endif
767
  DBUG_VOID_RETURN;
unknown's avatar
unknown committed
768 769 770
}
#endif

771

772 773 774 775 776
struct Item_change_record: public ilink
{
  Item **place;
  Item *old_value;
  /* Placement new was hidden by `new' in ilink (TODO: check): */
777
  static void *operator new(size_t size, void *mem) { return mem; }
778 779
  static void operator delete(void *ptr, size_t size) {}
  static void operator delete(void *ptr, void *mem) { /* never called */ }
780 781 782 783 784 785
};


/*
  Register an item tree tree transformation, performed by the query
  optimizer. We need a pointer to runtime_memroot because it may be !=
unknown's avatar
unknown committed
786
  thd->mem_root (due to possible set_n_backup_active_arena called for thd).
787 788 789 790 791 792 793 794 795 796 797 798 799 800
*/

void THD::nocheck_register_item_tree_change(Item **place, Item *old_value,
                                            MEM_ROOT *runtime_memroot)
{
  Item_change_record *change;
  /*
    Now we use one node per change, which adds some memory overhead,
    but still is rather fast as we use alloc_root for allocations.
    A list of item tree changes of an average query should be short.
  */
  void *change_mem= alloc_root(runtime_memroot, sizeof(*change));
  if (change_mem == 0)
  {
801 802 803 804
    /*
      OOM, thd->fatal_error() is called by the error handler of the
      memroot. Just return.
    */
805 806 807 808 809
    return;
  }
  change= new (change_mem) Item_change_record;
  change->place= place;
  change->old_value= old_value;
810
  change_list.append(change);
811 812 813 814 815 816 817
}


void THD::rollback_item_tree_changes()
{
  I_List_iterator<Item_change_record> it(change_list);
  Item_change_record *change;
unknown's avatar
unknown committed
818 819
  DBUG_ENTER("rollback_item_tree_changes");

820 821 822 823
  while ((change= it++))
    *change->place= change->old_value;
  /* We can forget about changes memory: it's allocated in runtime memroot */
  change_list.empty();
unknown's avatar
unknown committed
824
  DBUG_VOID_RETURN;
825 826 827
}


unknown's avatar
unknown committed
828 829 830 831 832 833 834 835 836
/*****************************************************************************
** Functions to provide a interface to select results
*****************************************************************************/

select_result::select_result()
{
  thd=current_thd;
}

837 838
void select_result::send_error(uint errcode,const char *err)
{
unknown's avatar
unknown committed
839
  my_message(errcode, err, MYF(0));
840 841
}

842 843 844 845 846 847

void select_result::cleanup()
{
  /* do nothing */
}

848 849 850
static String default_line_term("\n",default_charset_info);
static String default_escaped("\\",default_charset_info);
static String default_field_term("\t",default_charset_info);
unknown's avatar
unknown committed
851 852 853 854 855

sql_exchange::sql_exchange(char *name,bool flag)
  :file_name(name), opt_enclosed(0), dumpfile(flag), skip_lines(0)
{
  field_term= &default_field_term;
unknown's avatar
SCRUM  
unknown committed
856
  enclosed=   line_start= &my_empty_string;
unknown's avatar
unknown committed
857 858 859 860
  line_term=  &default_line_term;
  escaped=    &default_escaped;
}

861
bool select_send::send_fields(List<Item> &list, uint flags)
unknown's avatar
unknown committed
862
{
863 864 865 866
  bool res;
  if (!(res= thd->protocol->send_fields(&list, flags)))
    status= 1;
  return res;
unknown's avatar
unknown committed
867 868
}

869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890
void select_send::abort()
{
  DBUG_ENTER("select_send::abort");
  if (status && thd->spcont &&
      thd->spcont->find_handler(thd->net.last_errno,
                                MYSQL_ERROR::WARN_LEVEL_ERROR))
  {
    /*
      Executing stored procedure without a handler.
      Here we should actually send an error to the client,
      but as an error will break a multiple result set, the only thing we
      can do for now is to nicely end the current data set and remembering
      the error so that the calling routine will abort
    */
    thd->net.report_error= 0;
    send_eof();
    thd->net.report_error= 1; // Abort SP
  }
  DBUG_VOID_RETURN;
}


unknown's avatar
unknown committed
891 892 893 894
/* Send data to client. Returns 0 if ok */

bool select_send::send_data(List<Item> &items)
{
895
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
896
  {						// using limit offset,count
897
    unit->offset_limit_cnt--;
898
    return 0;
unknown's avatar
unknown committed
899
  }
900

901
#ifdef HAVE_INNOBASE_DB
unknown's avatar
unknown committed
902 903 904 905 906
  /*
    We may be passing the control from mysqld to the client: release the
    InnoDB adaptive hash S-latch to avoid thread deadlocks if it was reserved
    by thd
  */
907 908 909
    ha_release_temporary_latches(thd);
#endif

910 911 912
  List_iterator_fast<Item> li(items);
  Protocol *protocol= thd->protocol;
  char buff[MAX_FIELD_WIDTH];
unknown's avatar
unknown committed
913
  String buffer(buff, sizeof(buff), &my_charset_bin);
914 915 916
  DBUG_ENTER("send_data");

  protocol->prepare_for_resend();
unknown's avatar
unknown committed
917 918 919
  Item *item;
  while ((item=li++))
  {
920
    if (item->send(protocol, &buffer))
unknown's avatar
unknown committed
921
    {
922
      protocol->free();				// Free used buffer
unknown's avatar
unknown committed
923
      my_message(ER_OUT_OF_RESOURCES, ER(ER_OUT_OF_RESOURCES), MYF(0));
924
      break;
unknown's avatar
unknown committed
925 926
    }
  }
927
  thd->sent_row_count++;
928
  if (!thd->vio_ok())
929
    DBUG_RETURN(0);
unknown's avatar
unknown committed
930
  if (!thd->net.report_error)
931 932
    DBUG_RETURN(protocol->write());
  DBUG_RETURN(1);
unknown's avatar
unknown committed
933 934 935 936
}

bool select_send::send_eof()
{
937 938 939 940 941 942 943
#ifdef HAVE_INNOBASE_DB
  /* We may be passing the control from mysqld to the client: release the
     InnoDB adaptive hash S-latch to avoid thread deadlocks if it was reserved
     by thd */
    ha_release_temporary_latches(thd);
#endif

unknown's avatar
unknown committed
944 945 946
  /* Unlock tables before sending packet to gain some speed */
  if (thd->lock)
  {
947 948
    mysql_unlock_tables(thd, thd->lock);
    thd->lock=0;
unknown's avatar
unknown committed
949
  }
unknown's avatar
unknown committed
950 951
  if (!thd->net.report_error)
  {
unknown's avatar
unknown committed
952
    ::send_eof(thd);
953
    status= 0;
unknown's avatar
unknown committed
954 955 956 957
    return 0;
  }
  else
    return 1;
unknown's avatar
unknown committed
958 959 960
}


961 962 963
/************************************************************************
  Handling writing to file
************************************************************************/
unknown's avatar
unknown committed
964

965 966
void select_to_file::send_error(uint errcode,const char *err)
{
unknown's avatar
unknown committed
967
  my_message(errcode, err, MYF(0));
968 969 970 971 972 973 974 975
  if (file > 0)
  {
    (void) end_io_cache(&cache);
    (void) my_close(file,MYF(0));
    (void) my_delete(path,MYF(0));		// Delete file on error
    file= -1;
  }
}
unknown's avatar
unknown committed
976 977


978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003
bool select_to_file::send_eof()
{
  int error= test(end_io_cache(&cache));
  if (my_close(file,MYF(MY_WME)))
    error= 1;
  if (!error)
    ::send_ok(thd,row_count);
  file= -1;
  return error;
}


void select_to_file::cleanup()
{
  /* In case of error send_eof() may be not called: close the file here. */
  if (file >= 0)
  {
    (void) end_io_cache(&cache);
    (void) my_close(file,MYF(0));
    file= -1;
  }
  path[0]= '\0';
  row_count= 0;
}


1004
select_to_file::~select_to_file()
unknown's avatar
unknown committed
1005 1006 1007 1008 1009 1010 1011
{
  if (file >= 0)
  {					// This only happens in case of error
    (void) end_io_cache(&cache);
    (void) my_close(file,MYF(0));
    file= -1;
  }
1012 1013 1014 1015 1016 1017 1018 1019
}

/***************************************************************************
** Export of select to textfile
***************************************************************************/

select_export::~select_export()
{
1020
  thd->sent_row_count=row_count;
unknown's avatar
unknown committed
1021 1022
}

1023

1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041
/*
  Create file with IO cache

  SYNOPSIS
    create_file()
    thd			Thread handle
    path		File name
    exchange		Excange class
    cache		IO cache

  RETURN
    >= 0 	File handle
   -1		Error
*/


static File create_file(THD *thd, char *path, sql_exchange *exchange,
			IO_CACHE *cache)
unknown's avatar
unknown committed
1042
{
1043 1044
  File file;
  uint option= MY_UNPACK_FILENAME;
1045

unknown's avatar
unknown committed
1046
#ifdef DONT_ALLOW_FULL_LOAD_DATA_PATHS
1047
  option|= MY_REPLACE_DIR;			// Force use of db directory
unknown's avatar
unknown committed
1048
#endif
1049

unknown's avatar
unknown committed
1050
  if (!dirname_length(exchange->file_name))
1051 1052 1053 1054 1055 1056 1057
  {
    strxnmov(path, FN_REFLEN, mysql_real_data_home, thd->db ? thd->db : "", NullS);
    (void) fn_format(path, exchange->file_name, path, "", option);
  }
  else
    (void) fn_format(path, exchange->file_name, mysql_real_data_home, "", option);
    
1058
  if (!access(path, F_OK))
unknown's avatar
unknown committed
1059
  {
1060
    my_error(ER_FILE_EXISTS_ERROR, MYF(0), exchange->file_name);
unknown's avatar
unknown committed
1061
    return -1;
unknown's avatar
unknown committed
1062 1063
  }
  /* Create the file world readable */
unknown's avatar
unknown committed
1064
  if ((file= my_create(path, 0666, O_WRONLY|O_EXCL, MYF(MY_WME))) < 0)
1065
    return file;
unknown's avatar
unknown committed
1066
#ifdef HAVE_FCHMOD
1067
  (void) fchmod(file, 0666);			// Because of umask()
unknown's avatar
unknown committed
1068
#else
1069
  (void) chmod(path, 0666);
unknown's avatar
unknown committed
1070
#endif
1071
  if (init_io_cache(cache, file, 0L, WRITE_CACHE, 0L, 1, MYF(MY_WME)))
unknown's avatar
unknown committed
1072
  {
1073
    my_close(file, MYF(0));
1074
    my_delete(path, MYF(0));  // Delete file on error, it was just created 
1075
    return -1;
unknown's avatar
unknown committed
1076
  }
1077
  return file;
1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088
}


int
select_export::prepare(List<Item> &list, SELECT_LEX_UNIT *u)
{
  bool blob_flag=0;
  unit= u;
  if ((uint) strlen(exchange->file_name) + NAME_LEN >= FN_REFLEN)
    strmake(path,exchange->file_name,FN_REFLEN-1);

1089
  if ((file= create_file(thd, path, exchange, &cache)) < 0)
1090
    return 1;
unknown's avatar
unknown committed
1091 1092
  /* Check if there is any blobs in data */
  {
unknown's avatar
unknown committed
1093
    List_iterator_fast<Item> li(list);
unknown's avatar
unknown committed
1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127
    Item *item;
    while ((item=li++))
    {
      if (item->max_length >= MAX_BLOB_WIDTH)
      {
	blob_flag=1;
	break;
      }
    }
  }
  field_term_length=exchange->field_term->length();
  if (!exchange->line_term->length())
    exchange->line_term=exchange->field_term;	// Use this if it exists
  field_sep_char= (exchange->enclosed->length() ? (*exchange->enclosed)[0] :
		   field_term_length ? (*exchange->field_term)[0] : INT_MAX);
  escape_char=	(exchange->escaped->length() ? (*exchange->escaped)[0] : -1);
  line_sep_char= (exchange->line_term->length() ?
		  (*exchange->line_term)[0] : INT_MAX);
  if (!field_term_length)
    exchange->opt_enclosed=0;
  if (!exchange->enclosed->length())
    exchange->opt_enclosed=1;			// A little quicker loop
  fixed_row_size= (!field_term_length && !exchange->enclosed->length() &&
		   !blob_flag);
  return 0;
}


bool select_export::send_data(List<Item> &items)
{

  DBUG_ENTER("send_data");
  char buff[MAX_FIELD_WIDTH],null_buff[2],space[MAX_FIELD_WIDTH];
  bool space_inited=0;
unknown's avatar
unknown committed
1128
  String tmp(buff,sizeof(buff),&my_charset_bin),*res;
unknown's avatar
unknown committed
1129 1130
  tmp.length(0);

1131
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
1132
  {						// using limit offset,count
1133
    unit->offset_limit_cnt--;
unknown's avatar
unknown committed
1134 1135 1136 1137 1138 1139
    DBUG_RETURN(0);
  }
  row_count++;
  Item *item;
  char *buff_ptr=buff;
  uint used_length=0,items_left=items.elements;
unknown's avatar
unknown committed
1140
  List_iterator_fast<Item> li(items);
unknown's avatar
unknown committed
1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188

  if (my_b_write(&cache,(byte*) exchange->line_start->ptr(),
		 exchange->line_start->length()))
    goto err;
  while ((item=li++))
  {
    Item_result result_type=item->result_type();
    res=item->str_result(&tmp);
    if (res && (!exchange->opt_enclosed || result_type == STRING_RESULT))
    {
      if (my_b_write(&cache,(byte*) exchange->enclosed->ptr(),
		     exchange->enclosed->length()))
	goto err;
    }
    if (!res)
    {						// NULL
      if (!fixed_row_size)
      {
	if (escape_char != -1)			// Use \N syntax
	{
	  null_buff[0]=escape_char;
	  null_buff[1]='N';
	  if (my_b_write(&cache,(byte*) null_buff,2))
	    goto err;
	}
	else if (my_b_write(&cache,(byte*) "NULL",4))
	  goto err;
      }
      else
      {
	used_length=0;				// Fill with space
      }
    }
    else
    {
      if (fixed_row_size)
	used_length=min(res->length(),item->max_length);
      else
	used_length=res->length();
      if (result_type == STRING_RESULT && escape_char != -1)
      {
	char *pos,*start,*end;

	for (start=pos=(char*) res->ptr(),end=pos+used_length ;
	     pos != end ;
	     pos++)
	{
#ifdef USE_MB
unknown's avatar
unknown committed
1189 1190
          CHARSET_INFO *res_charset=res->charset();
	  if (use_mb(res_charset))
unknown's avatar
unknown committed
1191 1192
	  {
	    int l;
unknown's avatar
unknown committed
1193
	    if ((l=my_ismbchar(res_charset, pos, end)))
unknown's avatar
unknown committed
1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228
	    {
	      pos += l-1;
	      continue;
	    }
	  }
#endif
	  if ((int) *pos == escape_char || (int) *pos == field_sep_char ||
	      (int) *pos == line_sep_char || !*pos)
	  {
	    char tmp_buff[2];
	    tmp_buff[0]= escape_char;
	    tmp_buff[1]= *pos ? *pos : '0';
	    if (my_b_write(&cache,(byte*) start,(uint) (pos-start)) ||
		my_b_write(&cache,(byte*) tmp_buff,2))
	      goto err;
	    start=pos+1;
	  }
	}
	if (my_b_write(&cache,(byte*) start,(uint) (pos-start)))
	  goto err;
      }
      else if (my_b_write(&cache,(byte*) res->ptr(),used_length))
	goto err;
    }
    if (fixed_row_size)
    {						// Fill with space
      if (item->max_length > used_length)
      {
	/* QQ:  Fix by adding a my_b_fill() function */
	if (!space_inited)
	{
	  space_inited=1;
	  bfill(space,sizeof(space),' ');
	}
	uint length=item->max_length-used_length;
1229
	for (; length > sizeof(space) ; length-=sizeof(space))
unknown's avatar
unknown committed
1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266
	{
	  if (my_b_write(&cache,(byte*) space,sizeof(space)))
	    goto err;
	}
	if (my_b_write(&cache,(byte*) space,length))
	  goto err;
      }
    }
    buff_ptr=buff;				// Place separators here
    if (res && (!exchange->opt_enclosed || result_type == STRING_RESULT))
    {
      memcpy(buff_ptr,exchange->enclosed->ptr(),exchange->enclosed->length());
      buff_ptr+=exchange->enclosed->length();
    }
    if (--items_left)
    {
      memcpy(buff_ptr,exchange->field_term->ptr(),field_term_length);
      buff_ptr+=field_term_length;
    }
    if (my_b_write(&cache,(byte*) buff,(uint) (buff_ptr-buff)))
      goto err;
  }
  if (my_b_write(&cache,(byte*) exchange->line_term->ptr(),
		 exchange->line_term->length()))
    goto err;
  DBUG_RETURN(0);
err:
  DBUG_RETURN(1);
}


/***************************************************************************
** Dump  of select to a binary file
***************************************************************************/


int
1267 1268
select_dump::prepare(List<Item> &list __attribute__((unused)),
		     SELECT_LEX_UNIT *u)
unknown's avatar
unknown committed
1269
{
1270
  unit= u;
1271
  return (int) ((file= create_file(thd, path, exchange, &cache)) < 0);
unknown's avatar
unknown committed
1272 1273 1274 1275 1276
}


bool select_dump::send_data(List<Item> &items)
{
unknown's avatar
unknown committed
1277
  List_iterator_fast<Item> li(items);
unknown's avatar
unknown committed
1278
  char buff[MAX_FIELD_WIDTH];
unknown's avatar
unknown committed
1279
  String tmp(buff,sizeof(buff),&my_charset_bin),*res;
unknown's avatar
unknown committed
1280 1281 1282 1283
  tmp.length(0);
  Item *item;
  DBUG_ENTER("send_data");

1284
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
1285
  {						// using limit offset,count
1286
    unit->offset_limit_cnt--;
unknown's avatar
unknown committed
1287 1288 1289 1290
    DBUG_RETURN(0);
  }
  if (row_count++ > 1) 
  {
unknown's avatar
unknown committed
1291
    my_message(ER_TOO_MANY_ROWS, ER(ER_TOO_MANY_ROWS), MYF(0));
unknown's avatar
unknown committed
1292 1293 1294 1295 1296
    goto err;
  }
  while ((item=li++))
  {
    res=item->str_result(&tmp);
1297
    if (!res)					// If NULL
unknown's avatar
unknown committed
1298
    {
1299 1300
      if (my_b_write(&cache,(byte*) "",1))
	goto err;
unknown's avatar
unknown committed
1301 1302 1303
    }
    else if (my_b_write(&cache,(byte*) res->ptr(),res->length()))
    {
1304
      my_error(ER_ERROR_ON_WRITE, MYF(0), path, my_errno);
unknown's avatar
unknown committed
1305 1306 1307 1308 1309 1310 1311 1312 1313
      goto err;
    }
  }
  DBUG_RETURN(0);
err:
  DBUG_RETURN(1);
}


1314
select_subselect::select_subselect(Item_subselect *item_arg)
1315
{
1316
  item= item_arg;
1317 1318
}

1319

unknown's avatar
unknown committed
1320
bool select_singlerow_subselect::send_data(List<Item> &items)
1321
{
unknown's avatar
unknown committed
1322 1323
  DBUG_ENTER("select_singlerow_subselect::send_data");
  Item_singlerow_subselect *it= (Item_singlerow_subselect *)item;
unknown's avatar
unknown committed
1324 1325
  if (it->assigned())
  {
1326
    my_message(ER_SUBQUERY_NO_1_ROW, ER(ER_SUBQUERY_NO_1_ROW), MYF(0));
unknown's avatar
unknown committed
1327 1328 1329
    DBUG_RETURN(1);
  }
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
1330
  {				          // Using limit offset,count
unknown's avatar
unknown committed
1331 1332
    unit->offset_limit_cnt--;
    DBUG_RETURN(0);
1333
  }
unknown's avatar
unknown committed
1334
  List_iterator_fast<Item> li(items);
1335 1336 1337
  Item *val_item;
  for (uint i= 0; (val_item= li++); i++)
    it->store(i, val_item);
unknown's avatar
unknown committed
1338
  it->assigned(1);
unknown's avatar
unknown committed
1339
  DBUG_RETURN(0);
1340
}
unknown's avatar
unknown committed
1341

1342

1343 1344 1345 1346 1347 1348 1349 1350
void select_max_min_finder_subselect::cleanup()
{
  DBUG_ENTER("select_max_min_finder_subselect::cleanup");
  cache= 0;
  DBUG_VOID_RETURN;
}


1351 1352 1353
bool select_max_min_finder_subselect::send_data(List<Item> &items)
{
  DBUG_ENTER("select_max_min_finder_subselect::send_data");
1354
  Item_maxmin_subselect *it= (Item_maxmin_subselect *)item;
1355 1356
  List_iterator_fast<Item> li(items);
  Item *val_item= li++;
1357
  it->register_value();
1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379
  if (it->assigned())
  {
    cache->store(val_item);
    if ((this->*op)())
      it->store(0, cache);
  }
  else
  {
    if (!cache)
    {
      cache= Item_cache::get_cache(val_item->result_type());
      switch (val_item->result_type())
      {
      case REAL_RESULT:
	op= &select_max_min_finder_subselect::cmp_real;
	break;
      case INT_RESULT:
	op= &select_max_min_finder_subselect::cmp_int;
	break;
      case STRING_RESULT:
	op= &select_max_min_finder_subselect::cmp_str;
	break;
unknown's avatar
unknown committed
1380 1381 1382
      case DECIMAL_RESULT:
        op= &select_max_min_finder_subselect::cmp_decimal;
        break;
1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398
      case ROW_RESULT:
        // This case should never be choosen
	DBUG_ASSERT(0);
	op= 0;
      }
    }
    cache->store(val_item);
    it->store(0, cache);
  }
  it->assigned(1);
  DBUG_RETURN(0);
}

bool select_max_min_finder_subselect::cmp_real()
{
  Item *maxmin= ((Item_singlerow_subselect *)item)->el(0);
1399
  double val1= cache->val_real(), val2= maxmin->val_real();
1400 1401 1402 1403
  if (fmax)
    return (cache->null_value && !maxmin->null_value) ||
      (!cache->null_value && !maxmin->null_value &&
       val1 > val2);
1404 1405 1406
  return (maxmin->null_value && !cache->null_value) ||
    (!cache->null_value && !maxmin->null_value &&
     val1 < val2);
1407 1408 1409 1410 1411 1412 1413 1414 1415 1416
}

bool select_max_min_finder_subselect::cmp_int()
{
  Item *maxmin= ((Item_singlerow_subselect *)item)->el(0);
  longlong val1= cache->val_int(), val2= maxmin->val_int();
  if (fmax)
    return (cache->null_value && !maxmin->null_value) ||
      (!cache->null_value && !maxmin->null_value &&
       val1 > val2);
1417 1418 1419
  return (maxmin->null_value && !cache->null_value) ||
    (!cache->null_value && !maxmin->null_value &&
     val1 < val2);
1420 1421
}

unknown's avatar
unknown committed
1422 1423 1424 1425 1426 1427 1428 1429 1430
bool select_max_min_finder_subselect::cmp_decimal()
{
  Item *maxmin= ((Item_singlerow_subselect *)item)->el(0);
  my_decimal cval, *cvalue= cache->val_decimal(&cval);
  my_decimal mval, *mvalue= maxmin->val_decimal(&mval);
  if (fmax)
    return (cache->null_value && !maxmin->null_value) ||
      (!cache->null_value && !maxmin->null_value &&
       my_decimal_cmp(cvalue, mvalue) > 0) ;
1431 1432 1433
  return (maxmin->null_value && !cache->null_value) ||
    (!cache->null_value && !maxmin->null_value &&
     my_decimal_cmp(cvalue,mvalue) < 0);
unknown's avatar
unknown committed
1434 1435
}

1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449
bool select_max_min_finder_subselect::cmp_str()
{
  String *val1, *val2, buf1, buf2;
  Item *maxmin= ((Item_singlerow_subselect *)item)->el(0);
  /*
    as far as both operand is Item_cache buf1 & buf2 will not be used,
    but added for safety
  */
  val1= cache->val_str(&buf1);
  val2= maxmin->val_str(&buf1);
  if (fmax)
    return (cache->null_value && !maxmin->null_value) ||
      (!cache->null_value && !maxmin->null_value &&
       sortcmp(val1, val2, cache->collation.collation) > 0) ;
1450 1451 1452
  return (maxmin->null_value && !cache->null_value) ||
    (!cache->null_value && !maxmin->null_value &&
     sortcmp(val1, val2, cache->collation.collation) < 0);
1453 1454
}

unknown's avatar
unknown committed
1455 1456 1457 1458 1459 1460 1461 1462 1463 1464
bool select_exists_subselect::send_data(List<Item> &items)
{
  DBUG_ENTER("select_exists_subselect::send_data");
  Item_exists_subselect *it= (Item_exists_subselect *)item;
  if (unit->offset_limit_cnt)
  {				          // Using limit offset,count
    unit->offset_limit_cnt--;
    DBUG_RETURN(0);
  }
  it->value= 1;
unknown's avatar
unknown committed
1465
  it->assigned(1);
unknown's avatar
unknown committed
1466 1467 1468
  DBUG_RETURN(0);
}

unknown's avatar
unknown committed
1469 1470

/***************************************************************************
1471
  Dump of select to variables
unknown's avatar
unknown committed
1472
***************************************************************************/
1473

1474
int select_dumpvar::prepare(List<Item> &list, SELECT_LEX_UNIT *u)
unknown's avatar
unknown committed
1475
{
1476
  List_iterator_fast<Item> li(list);
unknown's avatar
unknown committed
1477
  List_iterator_fast<my_var> gl(var_list);
unknown's avatar
unknown committed
1478
  Item *item;
1479

1480 1481
  local_vars.empty();				// Clear list if SP
  unit= u;
1482
  row_count= 0;
1483

1484
  if (var_list.elements != list.elements)
unknown's avatar
unknown committed
1485
  {
unknown's avatar
unknown committed
1486 1487
    my_message(ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT,
               ER(ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT), MYF(0));
1488
    return 1;
unknown's avatar
unknown committed
1489
  }
1490
  while ((item=li++))
unknown's avatar
unknown committed
1491
  {
1492
    my_var *mv= gl++;
unknown's avatar
unknown committed
1493
    if (mv->local)
unknown's avatar
unknown committed
1494
      (void)local_vars.push_back(new Item_splocal(mv->s, mv->offset));
unknown's avatar
unknown committed
1495 1496
    else
    {
1497
      Item_func_set_user_var *var= new Item_func_set_user_var(mv->s, item);
unknown's avatar
unknown committed
1498 1499 1500
      /*
        Item_func_set_user_var can't substitute something else on its place =>
        0 can be passed as last argument (reference on item)
unknown's avatar
unknown committed
1501
        Item_func_set_user_var can't be fixed after creation, so we do not
1502
        check var->fixed
unknown's avatar
unknown committed
1503
      */
1504 1505 1506
      var->fix_fields(thd, 0);
      var->fix_length_and_dec();
      vars.push_back(var);
unknown's avatar
unknown committed
1507
    }
unknown's avatar
unknown committed
1508
  }
1509 1510
  return 0;
}
1511

1512

1513 1514 1515 1516 1517 1518 1519
void select_dumpvar::cleanup()
{
  vars.empty();
  row_count=0;
}


unknown's avatar
unknown committed
1520
Query_arena::Type Query_arena::type() const
1521
{
unknown's avatar
unknown committed
1522
  DBUG_ASSERT(0); /* Should never be called */
1523
  return STATEMENT;
1524 1525 1526
}


1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541
void Query_arena::free_items()
{
  Item *next;
  DBUG_ENTER("Query_arena::free_items");
  /* This works because items are allocated with sql_alloc() */
  for (; free_list; free_list= next)
  {
    next= free_list->next;
    free_list->delete_self();
  }
  /* Postcondition: free_list is 0 */
  DBUG_VOID_RETURN;
}


1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554
void Query_arena::set_query_arena(Query_arena *set)
{
  mem_root=  set->mem_root;
  free_list= set->free_list;
  state= set->state;
}


void Query_arena::cleanup_stmt()
{
  DBUG_ASSERT("Query_arena::cleanup_stmt()" == "not implemented");
}

1555 1556 1557 1558
/*
  Statement functions 
*/

unknown's avatar
unknown committed
1559 1560 1561 1562
Statement::Statement(enum enum_state state_arg, ulong id_arg,
                     ulong alloc_block_size, ulong prealloc_size)
  :Query_arena(&main_mem_root, state_arg),
  id(id_arg),
1563 1564 1565 1566
  set_query_id(1),
  allow_sum_func(0),
  lex(&main_lex),
  query(0),
1567 1568
  query_length(0),
  cursor(0)
1569
{
1570
  name.str= NULL;
unknown's avatar
unknown committed
1571
  init_sql_alloc(&main_mem_root, alloc_block_size, prealloc_size);
1572 1573 1574
}


unknown's avatar
unknown committed
1575
Query_arena::Type Statement::type() const
1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588
{
  return STATEMENT;
}


void Statement::set_statement(Statement *stmt)
{
  id=             stmt->id;
  set_query_id=   stmt->set_query_id;
  allow_sum_func= stmt->allow_sum_func;
  lex=            stmt->lex;
  query=          stmt->query;
  query_length=   stmt->query_length;
1589
  cursor=         stmt->cursor;
1590 1591 1592
}


1593 1594 1595
void
Statement::set_n_backup_statement(Statement *stmt, Statement *backup)
{
1596
  DBUG_ENTER("Statement::set_n_backup_statement");
1597 1598
  backup->set_statement(this);
  set_statement(stmt);
1599
  DBUG_VOID_RETURN;
1600 1601 1602 1603 1604
}


void Statement::restore_backup_statement(Statement *stmt, Statement *backup)
{
1605
  DBUG_ENTER("Statement::restore_backup_statement");
1606 1607
  stmt->set_statement(this);
  set_statement(backup);
1608
  DBUG_VOID_RETURN;
1609 1610 1611
}


1612
void THD::end_statement()
1613 1614 1615 1616 1617
{
  /* Cleanup SQL processing state to resuse this statement in next query. */
  lex_end(lex);
  delete lex->result;
  lex->result= 0;
1618 1619
  /* Note that free_list is freed in cleanup_after_query() */

1620 1621 1622 1623 1624 1625 1626
  /*
    Don't free mem_root, as mem_root is freed in the end of dispatch_command
    (once for any command).
  */
}


unknown's avatar
unknown committed
1627
void THD::set_n_backup_active_arena(Query_arena *set, Query_arena *backup)
unknown's avatar
unknown committed
1628
{
unknown's avatar
unknown committed
1629
  DBUG_ENTER("THD::set_n_backup_active_arena");
1630
  DBUG_ASSERT(backup->is_backup_arena == FALSE);
1631

unknown's avatar
unknown committed
1632 1633
  backup->set_query_arena(this);
  set_query_arena(set);
unknown's avatar
unknown committed
1634
#ifndef DBUG_OFF
1635
  backup->is_backup_arena= TRUE;
unknown's avatar
unknown committed
1636
#endif
1637
  DBUG_VOID_RETURN;
unknown's avatar
unknown committed
1638 1639 1640
}


unknown's avatar
unknown committed
1641
void THD::restore_active_arena(Query_arena *set, Query_arena *backup)
1642
{
unknown's avatar
unknown committed
1643
  DBUG_ENTER("THD::restore_active_arena");
1644
  DBUG_ASSERT(backup->is_backup_arena);
unknown's avatar
unknown committed
1645 1646
  set->set_query_arena(this);
  set_query_arena(backup);
unknown's avatar
unknown committed
1647
#ifndef DBUG_OFF
1648
  backup->is_backup_arena= FALSE;
1649
#endif
unknown's avatar
unknown committed
1650
  DBUG_VOID_RETURN;
1651 1652
}

1653 1654
Statement::~Statement()
{
1655 1656 1657 1658 1659
  /*
    We must free `main_mem_root', not `mem_root' (pointer), to work
    correctly if this statement is used as a backup statement,
    for which `mem_root' may point to some other statement.
  */
unknown's avatar
unknown committed
1660
  free_root(&main_mem_root, MYF(0));
1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678
}

C_MODE_START

static byte *
get_statement_id_as_hash_key(const byte *record, uint *key_length,
                             my_bool not_used __attribute__((unused)))
{
  const Statement *statement= (const Statement *) record; 
  *key_length= sizeof(statement->id);
  return (byte *) &((const Statement *) statement)->id;
}

static void delete_statement_as_hash_key(void *key)
{
  delete (Statement *) key;
}

1679 1680
static byte *get_stmt_name_hash_key(Statement *entry, uint *length,
                                    my_bool not_used __attribute__((unused)))
1681 1682 1683 1684 1685
{
  *length=(uint) entry->name.length;
  return (byte*) entry->name.str;
}

1686 1687 1688 1689 1690
C_MODE_END

Statement_map::Statement_map() :
  last_found_statement(0)
{
1691 1692 1693 1694 1695
  enum
  {
    START_STMT_HASH_SIZE = 16,
    START_NAME_HASH_SIZE = 16
  };
1696
  hash_init(&st_hash, &my_charset_bin, START_STMT_HASH_SIZE, 0, 0,
1697 1698
            get_statement_id_as_hash_key,
            delete_statement_as_hash_key, MYF(0));
1699
  hash_init(&names_hash, system_charset_info, START_NAME_HASH_SIZE, 0, 0,
1700 1701
            (hash_get_key) get_stmt_name_hash_key,
            NULL,MYF(0));
1702 1703
}

1704

1705 1706
int Statement_map::insert(Statement *statement)
{
1707 1708 1709
  int res= my_hash_insert(&st_hash, (byte *) statement);
  if (res)
    return res;
1710 1711
  if (statement->name.str)
  {
1712 1713
    if ((res= my_hash_insert(&names_hash, (byte*)statement)))
    {
1714
      hash_delete(&st_hash, (byte*)statement);
1715 1716
      return res;
    }
1717
  }
1718 1719
  last_found_statement= statement;
  return res;
1720 1721
}

1722

1723 1724
void Statement_map::close_transient_cursors()
{
1725
#ifdef TO_BE_IMPLEMENTED
1726 1727 1728
  Statement *stmt;
  while ((stmt= transient_cursor_list.head()))
    stmt->close_cursor();                 /* deletes itself from the list */
1729
#endif
1730 1731 1732
}


1733 1734 1735
bool select_dumpvar::send_data(List<Item> &items)
{
  List_iterator_fast<Item_func_set_user_var> li(vars);
unknown's avatar
unknown committed
1736 1737
  List_iterator_fast<Item_splocal> var_li(local_vars);
  List_iterator_fast<my_var> my_li(var_list);
1738
  List_iterator<Item> it(items);
1739
  Item_func_set_user_var *xx;
unknown's avatar
unknown committed
1740 1741
  Item_splocal *yy;
  my_var *zz;
1742
  DBUG_ENTER("send_data");
unknown's avatar
unknown committed
1743 1744 1745 1746 1747
  if (unit->offset_limit_cnt)
  {						// using limit offset,count
    unit->offset_limit_cnt--;
    DBUG_RETURN(0);
  }
1748

1749 1750 1751 1752 1753
  if (unit->offset_limit_cnt)
  {				          // Using limit offset,count
    unit->offset_limit_cnt--;
    DBUG_RETURN(0);
  }
1754 1755
  if (row_count++) 
  {
unknown's avatar
unknown committed
1756
    my_message(ER_TOO_MANY_ROWS, ER(ER_TOO_MANY_ROWS), MYF(0));
1757 1758
    DBUG_RETURN(1);
  }
1759
  while ((zz=my_li++) && (it++))
unknown's avatar
unknown committed
1760
  {
unknown's avatar
unknown committed
1761 1762 1763 1764
    if (zz->local)
    {
      if ((yy=var_li++)) 
      {
1765 1766
	if (thd->spcont->set_item_eval(current_thd,
				       yy->get_offset(), it.ref(), zz->type))
1767
	  DBUG_RETURN(1);
unknown's avatar
unknown committed
1768 1769 1770 1771 1772
      }
    }
    else
    {
      if ((xx=li++))
unknown's avatar
unknown committed
1773 1774
      {
        xx->check();
unknown's avatar
unknown committed
1775
	xx->update();
unknown's avatar
unknown committed
1776
      }
unknown's avatar
unknown committed
1777
    }
unknown's avatar
unknown committed
1778
  }
unknown's avatar
unknown committed
1779 1780 1781 1782 1783
  DBUG_RETURN(0);
}

bool select_dumpvar::send_eof()
{
1784
  if (! row_count)
unknown's avatar
unknown committed
1785 1786
    push_warning(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
                 ER_SP_FETCH_NO_DATA, ER(ER_SP_FETCH_NO_DATA));
1787 1788
  ::send_ok(thd,row_count);
  return 0;
unknown's avatar
unknown committed
1789
}
1790 1791 1792 1793 1794 1795 1796 1797 1798 1799

/****************************************************************************
  TMP_TABLE_PARAM
****************************************************************************/

void TMP_TABLE_PARAM::init()
{
  field_count= sum_func_count= func_count= hidden_field_count= 0;
  group_parts= group_length= group_null_parts= 0;
  quick_group= 1;
unknown's avatar
unknown committed
1800
  table_charset= 0;
1801
}
1802 1803 1804 1805


void thd_increment_bytes_sent(ulong length)
{
unknown's avatar
unknown committed
1806
  THD *thd=current_thd;
unknown's avatar
unknown committed
1807
  if (likely(thd != 0))
unknown's avatar
unknown committed
1808 1809 1810
  { /* current_thd==0 when close_connection() calls net_send_error() */
    thd->status_var.bytes_sent+= length;
  }
1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829
}


void thd_increment_bytes_received(ulong length)
{
  current_thd->status_var.bytes_received+= length;
}


void thd_increment_net_big_packet_count(ulong length)
{
  current_thd->status_var.net_big_packet_count+= length;
}


void THD::set_status_var_init()
{
  bzero((char*) &status_var, sizeof(status_var));
}
1830

1831

1832
void Security_context::init()
1833 1834 1835 1836 1837 1838 1839 1840 1841
{
  host= user= priv_user= ip= 0;
  host_or_ip= "connecting host";
#ifndef NO_EMBEDDED_ACCESS_CHECKS
  db_access= NO_ACCESS;
#endif
}


1842
void Security_context::destroy()
1843 1844 1845 1846 1847 1848 1849 1850 1851 1852
{
  // If not pointer to constant
  if (host != my_localhost)
    safeFree(host);
  if (user != delayed_user)
    safeFree(user);
  safeFree(ip);
}


1853
void Security_context::skip_grants()
1854 1855 1856 1857 1858 1859 1860 1861 1862
{
  /* privileges for the user are unknown everything is allowed */
  host_or_ip= (char *)"";
  master_access= ~NO_ACCESS;
  priv_user= (char *)"";
  *priv_host= '\0';
}


1863 1864 1865 1866 1867 1868 1869 1870
/****************************************************************************
  Handling of open and locked tables states.

  This is used when we want to open/lock (and then close) some tables when
  we already have a set of tables open and locked. We use these methods for
  access to mysql.proc table to find definitions of stored routines.
****************************************************************************/

1871
void THD::reset_n_backup_open_tables_state(Open_tables_state *backup)
1872
{
1873 1874
  DBUG_ENTER("reset_n_backup_open_tables_state");
  backup->set_open_tables_state(this);
1875
  reset_open_tables_state();
1876
  DBUG_VOID_RETURN;
1877 1878 1879
}


1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891
void THD::restore_backup_open_tables_state(Open_tables_state *backup)
{
  DBUG_ENTER("restore_backup_open_tables_state");
  /*
    Before we will throw away current open tables state we want
    to be sure that it was properly cleaned up.
  */
  DBUG_ASSERT(open_tables == 0 && temporary_tables == 0 &&
              handler_tables == 0 && derived_tables == 0 &&
              lock == 0 && locked_tables == 0 &&
              prelocked_mode == NON_PRELOCKED);
  set_open_tables_state(backup);
1892 1893
  DBUG_VOID_RETURN;
}
1894 1895


1896

1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938
/****************************************************************************
  Handling of statement states in functions and triggers.

  This is used to ensure that the function/trigger gets a clean state
  to work with and does not cause any side effects of the calling statement.

  It also allows most stored functions and triggers to replicate even
  if they are used items that would normally be stored in the binary
  replication (like last_insert_id() etc...)

  The following things is done
  - Disable binary logging for the duration of the statement
  - Disable multi-result-sets for the duration of the statement
  - Value of last_insert_id() is reset and restored
  - Value set by 'SET INSERT_ID=#' is reset and restored
  - Value for found_rows() is reset and restored
  - examined_row_count is added to the total
  - cuted_fields is added to the total

  NOTES:
    Seed for random() is saved for the first! usage of RAND()
    We reset examined_row_count and cuted_fields and add these to the
    result to ensure that if we have a bug that would reset these within
    a function, we are not loosing any rows from the main statement.
****************************************************************************/

void THD::reset_sub_statement_state(Sub_statement_state *backup,
                                    uint new_state)
{
  backup->options=         options;
  backup->in_sub_stmt=     in_sub_stmt;
  backup->no_send_ok=      net.no_send_ok;
  backup->enable_slow_log= enable_slow_log;
  backup->last_insert_id=  last_insert_id;
  backup->next_insert_id=  next_insert_id;
  backup->insert_id_used=  insert_id_used;
  backup->limit_found_rows= limit_found_rows;
  backup->examined_row_count= examined_row_count;
  backup->sent_row_count=   sent_row_count;
  backup->cuted_fields=     cuted_fields;
  backup->client_capabilities= client_capabilities;

1939 1940
  if (!lex->requires_prelocking() || is_update_query(lex->sql_command))
    options&= ~OPTION_BIN_LOG;
1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977
  /* Disable result sets */
  client_capabilities &= ~CLIENT_MULTI_RESULTS;
  in_sub_stmt|= new_state;
  last_insert_id= 0;
  next_insert_id= 0;
  insert_id_used= 0;
  examined_row_count= 0;
  sent_row_count= 0;
  cuted_fields= 0;

#ifndef EMBEDDED_LIBRARY
  /* Surpress OK packets in case if we will execute statements */
  net.no_send_ok= TRUE;
#endif
}


void THD::restore_sub_statement_state(Sub_statement_state *backup)
{
  options=          backup->options;
  in_sub_stmt=      backup->in_sub_stmt;
  net.no_send_ok=   backup->no_send_ok;
  enable_slow_log=  backup->enable_slow_log;
  last_insert_id=   backup->last_insert_id;
  next_insert_id=   backup->next_insert_id;
  insert_id_used=   backup->insert_id_used;
  limit_found_rows= backup->limit_found_rows;
  sent_row_count=   backup->sent_row_count;
  client_capabilities= backup->client_capabilities;

  /*
    The following is added to the old values as we are interested in the
    total complexity of the query
  */
  examined_row_count+= backup->examined_row_count;
  cuted_fields+=       backup->cuted_fields;
}
1978 1979 1980 1981 1982 1983


/***************************************************************************
  Handling of XA id cacheing
***************************************************************************/

1984 1985 1986 1987 1988 1989
pthread_mutex_t LOCK_xid_cache;
HASH xid_cache;

static byte *xid_get_hash_key(const byte *ptr,uint *length,
                                  my_bool not_used __attribute__((unused)))
{
1990 1991
  *length=((XID_STATE*)ptr)->xid.key_length();
  return ((XID_STATE*)ptr)->xid.key();
1992 1993 1994 1995 1996
}

static void xid_free_hash (void *ptr)
{
  if (!((XID_STATE*)ptr)->in_thd)
unknown's avatar
unknown committed
1997
    my_free((gptr)ptr, MYF(0));
1998 1999 2000 2001 2002
}

bool xid_cache_init()
{
  pthread_mutex_init(&LOCK_xid_cache, MY_MUTEX_INIT_FAST);
unknown's avatar
unknown committed
2003 2004
  return hash_init(&xid_cache, &my_charset_bin, 100, 0, 0,
                   xid_get_hash_key, xid_free_hash, 0) != 0;
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018
}

void xid_cache_free()
{
  if (hash_inited(&xid_cache))
  {
    hash_free(&xid_cache);
    pthread_mutex_destroy(&LOCK_xid_cache);
  }
}

XID_STATE *xid_cache_search(XID *xid)
{
  pthread_mutex_lock(&LOCK_xid_cache);
2019
  XID_STATE *res=(XID_STATE *)hash_search(&xid_cache, xid->key(), xid->key_length());
2020 2021 2022 2023
  pthread_mutex_unlock(&LOCK_xid_cache);
  return res;
}

2024

2025 2026 2027 2028 2029
bool xid_cache_insert(XID *xid, enum xa_states xa_state)
{
  XID_STATE *xs;
  my_bool res;
  pthread_mutex_lock(&LOCK_xid_cache);
2030
  if (hash_search(&xid_cache, xid->key(), xid->key_length()))
2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044
    res=0;
  else if (!(xs=(XID_STATE *)my_malloc(sizeof(*xs), MYF(MY_WME))))
    res=1;
  else
  {
    xs->xa_state=xa_state;
    xs->xid.set(xid);
    xs->in_thd=0;
    res=my_hash_insert(&xid_cache, (byte*)xs);
  }
  pthread_mutex_unlock(&LOCK_xid_cache);
  return res;
}

2045

2046 2047 2048
bool xid_cache_insert(XID_STATE *xid_state)
{
  pthread_mutex_lock(&LOCK_xid_cache);
2049 2050
  DBUG_ASSERT(hash_search(&xid_cache, xid_state->xid.key(),
                          xid_state->xid.key_length())==0);
2051 2052 2053 2054 2055
  my_bool res=my_hash_insert(&xid_cache, (byte*)xid_state);
  pthread_mutex_unlock(&LOCK_xid_cache);
  return res;
}

2056

2057 2058 2059 2060 2061 2062 2063
void xid_cache_delete(XID_STATE *xid_state)
{
  pthread_mutex_lock(&LOCK_xid_cache);
  hash_delete(&xid_cache, (byte *)xid_state);
  pthread_mutex_unlock(&LOCK_xid_cache);
}