sql_class.cc 52.1 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
  host= user= priv_user= db= ip= 0;
185
  catalog= (char*)"std"; // the only catalog we have for now
186
  host_or_ip= "connecting host";
unknown's avatar
unknown committed
187
  locked=some_tables_deleted=no_errors=password= 0;
unknown's avatar
unknown committed
188
  query_start_used= 0;
189
  count_cuted_fields= CHECK_FIELD_IGNORE;
unknown's avatar
SCRUM  
unknown committed
190
  killed= NOT_KILLED;
191
  db_length= col_access=0;
unknown's avatar
unknown committed
192
  query_error= tmp_table_used= 0;
unknown's avatar
unknown committed
193
  next_insert_id=last_insert_id=0;
194
  hash_clear(&handler_tables_hash);
unknown's avatar
unknown committed
195
  tmp_table=0;
196
  used_tables=0;
197
  cuted_fields= sent_row_count= 0L;
198
  limit_found_rows= 0;
199
  statement_id_counter= 0UL;
200
  // Must be reset to handle error with THD's created for init of mysqld
unknown's avatar
unknown committed
201
  lex->current_select= 0;
unknown's avatar
unknown committed
202
  start_time=(time_t) 0;
unknown's avatar
unknown committed
203
  current_linfo =  0;
204
  slave_thread = 0;
unknown's avatar
unknown committed
205
  variables.pseudo_thread_id= 0;
206
  one_shot_set= 0;
207
  file_id = 0;
208
  query_id= 0;
209
  warn_id= 0;
210
  db_charset= global_system_variables.collation_database;
211
  bzero(ha_data, sizeof(ha_data));
unknown's avatar
unknown committed
212
  mysys_var=0;
213
  binlog_evt_union.do_union= FALSE;
214 215
#ifndef DBUG_OFF
  dbug_sentry=THD_SENTRY_MAGIC;
216
#endif
217
#ifndef EMBEDDED_LIBRARY
unknown's avatar
unknown committed
218
  net.vio=0;
219
#endif
220 221
  net.last_error[0]=0;                          // If error on boot
  net.query_cache_query=0;                      // If error on boot
unknown's avatar
unknown committed
222
  ull=0;
223
  system_thread= cleanup_done= abort_on_warning= no_warnings_for_error= 0;
224
  peer_port= 0;					// For SHOW PROCESSLIST
unknown's avatar
unknown committed
225 226 227 228 229
#ifdef	__WIN__
  real_id = 0;
#endif
#ifdef SIGNAL_WITH_VIO_CLOSE
  active_vio = 0;
230
#endif
231
  pthread_mutex_init(&LOCK_delete, MY_MUTEX_INIT_FAST);
unknown's avatar
unknown committed
232 233 234 235 236

  /* Variables with default values */
  proc_info="login";
  where="field list";
  server_id = ::server_id;
237
  slave_net = 0;
unknown's avatar
unknown committed
238
  command=COM_CONNECT;
unknown's avatar
unknown committed
239
#ifndef NO_EMBEDDED_ACCESS_CHECKS
unknown's avatar
unknown committed
240
  db_access=NO_ACCESS;
unknown's avatar
unknown committed
241
#endif
unknown's avatar
unknown committed
242
  *scramble= '\0';
unknown's avatar
unknown committed
243

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

252 253
  sp_proc_cache= NULL;
  sp_func_cache= NULL;
254

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

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

unknown's avatar
unknown committed
267
  tablespace_op=FALSE;
268 269
  ulong tmp=sql_rnd_with_mutex();
  randominit(&rand, tmp + (ulong) &rand, tmp + (ulong) ::query_id);
270 271
  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
272 273
}

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

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

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

309

310 311 312 313 314 315 316 317
/*
  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()
{
318
  ha_enable_transaction(this,TRUE);
319

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


unknown's avatar
unknown committed
332 333 334 335 336 337 338 339 340 341 342 343 344 345
/*
  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
346
  cleanup_done= 0;
unknown's avatar
unknown committed
347
  init();
348
  stmt_map.reset();
349
  hash_init(&user_vars, system_charset_info, USER_VARS_HASH_SIZE, 0, 0,
unknown's avatar
unknown committed
350
	    (hash_get_key) get_var_key,
unknown's avatar
unknown committed
351
	    (hash_free_key) free_user_var, 0);
352 353
  sp_cache_clear(&sp_proc_cache);
  sp_cache_clear(&sp_func_cache);
unknown's avatar
unknown committed
354 355 356
}


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

void THD::cleanup(void)
unknown's avatar
unknown committed
360
{
unknown's avatar
unknown committed
361
  DBUG_ENTER("THD::cleanup");
unknown's avatar
unknown committed
362
#ifdef ENABLE_WHEN_BINLOG_WILL_BE_ABLE_TO_PREPARE
363 364 365 366
  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
367
#endif
368
  {
unknown's avatar
unknown committed
369
    ha_rollback(this);
370 371
    xid_cache_delete(&transaction.xid_state);
  }
unknown's avatar
unknown committed
372 373 374 375 376
  if (locked_tables)
  {
    lock=locked_tables; locked_tables=0;
    close_thread_tables(this);
  }
377 378 379
  mysql_ha_flush(this, (TABLE_LIST*) 0,
                 MYSQL_HA_CLOSE_FINAL | MYSQL_HA_FLUSH_ALL);
  hash_free(&handler_tables_hash);
380 381
  delete_dynamic(&user_var_events);
  hash_free(&user_vars);
unknown's avatar
unknown committed
382
  close_temporary_tables(this);
383 384 385
  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));
386
  
387
  sp_cache_clear(&sp_proc_cache);
388 389
  sp_cache_clear(&sp_func_cache);

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

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

unknown's avatar
unknown committed
404

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

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

unknown's avatar
unknown committed
427
  ha_close_connection(this);
unknown's avatar
unknown committed
428 429

  DBUG_PRINT("info", ("freeing host"));
unknown's avatar
unknown committed
430
  if (host != my_localhost)			// If not pointer to constant
431
    safeFree(host);
432 433
  if (user != delayed_user)
    safeFree(user);
unknown's avatar
unknown committed
434
  safeFree(ip);
435
  safeFree(db);
436
  free_root(&warn_root,MYF(0));
437
#ifdef USING_TRANSACTIONS
438
  free_root(&transaction.mem_root,MYF(0));
439
#endif
unknown's avatar
unknown committed
440
  mysys_var=0;					// Safety (shouldn't be needed)
441
  pthread_mutex_destroy(&LOCK_delete);
442
#ifndef DBUG_OFF
unknown's avatar
unknown committed
443
  dbug_sentry= THD_SENTRY_GONE;
444
#endif  
unknown's avatar
unknown committed
445 446 447
  DBUG_VOID_RETURN;
}

448

449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466
/*
  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++);
467
  /* it doesn't make sense to add last_query_cost values */
468 469 470
}


unknown's avatar
SCRUM  
unknown committed
471
void THD::awake(THD::killed_state state_to_set)
472
{
473
  THD_CHECK_SENTRY(this);
474 475
  safe_mutex_assert_owner(&LOCK_delete); 

unknown's avatar
SCRUM  
unknown committed
476 477 478
  killed= state_to_set;
  if (state_to_set != THD::KILL_QUERY)
    thr_alarm_kill(real_id);
479 480 481 482
#ifdef SIGNAL_WITH_VIO_CLOSE
  close_active_vio();
#endif    
  if (mysys_var)
unknown's avatar
unknown committed
483 484 485 486 487 488 489 490 491
  {
    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.
492 493 494 495 496
      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.
497

498
      Note that there is a small chance we fail to kill. If victim has locked
499 500 501 502 503
      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
504
      see it immediately and so may have time to reach the cond_wait().
unknown's avatar
unknown committed
505
    */
506
    if (mysys_var->current_cond && mysys_var->current_mutex)
507
    {
unknown's avatar
unknown committed
508 509 510
      pthread_mutex_lock(mysys_var->current_mutex);
      pthread_cond_broadcast(mysys_var->current_cond);
      pthread_mutex_unlock(mysys_var->current_mutex);
511
    }
unknown's avatar
unknown committed
512 513
    pthread_mutex_unlock(&mysys_var->mutex);
  }
514 515
}

unknown's avatar
unknown committed
516 517 518 519
/*
  Remember the location of thread info, the structure needed for
  sql_alloc() and the structure for the net buffer
*/
unknown's avatar
unknown committed
520 521 522

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

unknown's avatar
unknown committed
541

542 543 544 545 546 547 548 549 550 551
/* 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 */
552
  free_items();
553 554
}

unknown's avatar
unknown committed
555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580
/*
  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;
581
  uint dummy_errors;
unknown's avatar
unknown committed
582 583 584 585 586 587
  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,
588
			       from, from_length, from_cs, &dummy_errors);
unknown's avatar
unknown committed
589 590 591 592 593
  to->str[to->length]=0;			// Safety
  DBUG_RETURN(0);
}


594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610
/*
  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)
{
611 612
  uint dummy_errors;
  if (convert_buffer.copy(s->ptr(), s->length(), from_cs, to_cs, &dummy_errors))
613 614 615 616 617 618 619 620 621 622 623
    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;
}

624

unknown's avatar
unknown committed
625 626 627 628 629 630
/*
  Update some cache variables when character set changes
*/

void THD::update_charset()
{
631 632 633 634 635 636 637
  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
638 639 640
}


641 642 643 644 645 646 647 648 649 650 651 652 653 654
/* 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 */
655

656 657
void THD::add_changed_table(TABLE *table)
{
658
  DBUG_ENTER("THD::add_changed_table(table)");
659

unknown's avatar
unknown committed
660
  DBUG_ASSERT((options & (OPTION_NOT_AUTOCOMMIT | OPTION_BEGIN)) &&
661
	      table->file->has_transactions());
662
  add_changed_table(table->s->table_cache_key, table->s->key_length);
unknown's avatar
unknown committed
663
  DBUG_VOID_RETURN;
unknown's avatar
unknown committed
664
}
665

666

unknown's avatar
unknown committed
667 668 669
void THD::add_changed_table(const char *key, long key_length)
{
  DBUG_ENTER("THD::add_changed_table(key)");
670 671
  CHANGED_TABLE_LIST **prev_changed = &transaction.changed_tables;
  CHANGED_TABLE_LIST *curr = transaction.changed_tables;
672

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

707

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

  new_table->key = (char *) (((byte*)new_table)+
			     ALIGN_SIZE(sizeof(CHANGED_TABLE_LIST)));
  new_table->next = 0;
unknown's avatar
unknown committed
724 725
  new_table->key_length = key_length;
  ::memcpy(new_table->key, key, key_length);
726 727 728
  return new_table;
}

729

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

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

776

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


/*
  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
791
  thd->mem_root (due to possible set_n_backup_active_arena called for thd).
792 793 794 795 796 797 798 799 800 801 802 803 804 805
*/

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)
  {
806 807 808 809
    /*
      OOM, thd->fatal_error() is called by the error handler of the
      memroot. Just return.
    */
810 811 812 813 814
    return;
  }
  change= new (change_mem) Item_change_record;
  change->place= place;
  change->old_value= old_value;
815
  change_list.append(change);
816 817 818 819 820 821 822
}


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

825 826 827 828
  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
829
  DBUG_VOID_RETURN;
830 831 832
}


unknown's avatar
unknown committed
833 834 835 836 837 838 839 840 841
/*****************************************************************************
** Functions to provide a interface to select results
*****************************************************************************/

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

842 843
void select_result::send_error(uint errcode,const char *err)
{
unknown's avatar
unknown committed
844
  my_message(errcode, err, MYF(0));
845 846
}

847 848 849 850 851 852

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

853 854 855
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
856 857 858 859 860

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
861
  enclosed=   line_start= &my_empty_string;
unknown's avatar
unknown committed
862 863 864 865
  line_term=  &default_line_term;
  escaped=    &default_escaped;
}

866
bool select_send::send_fields(List<Item> &list, uint flags)
unknown's avatar
unknown committed
867
{
868
  return thd->protocol->send_fields(&list, flags);
unknown's avatar
unknown committed
869 870 871 872 873 874
}

/* Send data to client. Returns 0 if ok */

bool select_send::send_data(List<Item> &items)
{
875
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
876
  {						// using limit offset,count
877
    unit->offset_limit_cnt--;
878
    return 0;
unknown's avatar
unknown committed
879
  }
880

881
#ifdef HAVE_INNOBASE_DB
unknown's avatar
unknown committed
882 883 884 885 886
  /*
    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
  */
887 888 889
    ha_release_temporary_latches(thd);
#endif

890 891 892
  List_iterator_fast<Item> li(items);
  Protocol *protocol= thd->protocol;
  char buff[MAX_FIELD_WIDTH];
unknown's avatar
unknown committed
893
  String buffer(buff, sizeof(buff), &my_charset_bin);
894 895 896
  DBUG_ENTER("send_data");

  protocol->prepare_for_resend();
unknown's avatar
unknown committed
897 898 899
  Item *item;
  while ((item=li++))
  {
900
    if (item->send(protocol, &buffer))
unknown's avatar
unknown committed
901
    {
902
      protocol->free();				// Free used buffer
unknown's avatar
unknown committed
903
      my_message(ER_OUT_OF_RESOURCES, ER(ER_OUT_OF_RESOURCES), MYF(0));
904
      break;
unknown's avatar
unknown committed
905 906
    }
  }
907
  thd->sent_row_count++;
908
  if (!thd->vio_ok())
909
    DBUG_RETURN(0);
unknown's avatar
unknown committed
910
  if (!thd->net.report_error)
911 912
    DBUG_RETURN(protocol->write());
  DBUG_RETURN(1);
unknown's avatar
unknown committed
913 914 915 916
}

bool select_send::send_eof()
{
917 918 919 920 921 922 923
#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
924 925 926
  /* Unlock tables before sending packet to gain some speed */
  if (thd->lock)
  {
927 928
    mysql_unlock_tables(thd, thd->lock);
    thd->lock=0;
unknown's avatar
unknown committed
929
  }
unknown's avatar
unknown committed
930 931
  if (!thd->net.report_error)
  {
unknown's avatar
unknown committed
932
    ::send_eof(thd);
unknown's avatar
unknown committed
933 934 935 936
    return 0;
  }
  else
    return 1;
unknown's avatar
unknown committed
937 938 939
}


940 941 942
/************************************************************************
  Handling writing to file
************************************************************************/
unknown's avatar
unknown committed
943

944 945
void select_to_file::send_error(uint errcode,const char *err)
{
unknown's avatar
unknown committed
946
  my_message(errcode, err, MYF(0));
947 948 949 950 951 952 953 954
  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
955 956


957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982
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;
}


983
select_to_file::~select_to_file()
unknown's avatar
unknown committed
984 985 986 987 988 989 990
{
  if (file >= 0)
  {					// This only happens in case of error
    (void) end_io_cache(&cache);
    (void) my_close(file,MYF(0));
    file= -1;
  }
991 992 993 994 995 996 997 998
}

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

select_export::~select_export()
{
999
  thd->sent_row_count=row_count;
unknown's avatar
unknown committed
1000 1001
}

1002

1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020
/*
  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
1021
{
1022 1023
  File file;
  uint option= MY_UNPACK_FILENAME;
1024

unknown's avatar
unknown committed
1025
#ifdef DONT_ALLOW_FULL_LOAD_DATA_PATHS
1026
  option|= MY_REPLACE_DIR;			// Force use of db directory
unknown's avatar
unknown committed
1027
#endif
1028

unknown's avatar
unknown committed
1029
  if (!dirname_length(exchange->file_name))
1030 1031 1032 1033 1034 1035 1036
  {
    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);
    
1037
  if (!access(path, F_OK))
unknown's avatar
unknown committed
1038
  {
1039
    my_error(ER_FILE_EXISTS_ERROR, MYF(0), exchange->file_name);
unknown's avatar
unknown committed
1040
    return -1;
unknown's avatar
unknown committed
1041 1042
  }
  /* Create the file world readable */
unknown's avatar
unknown committed
1043
  if ((file= my_create(path, 0666, O_WRONLY|O_EXCL, MYF(MY_WME))) < 0)
1044
    return file;
unknown's avatar
unknown committed
1045
#ifdef HAVE_FCHMOD
1046
  (void) fchmod(file, 0666);			// Because of umask()
unknown's avatar
unknown committed
1047
#else
1048
  (void) chmod(path, 0666);
unknown's avatar
unknown committed
1049
#endif
1050
  if (init_io_cache(cache, file, 0L, WRITE_CACHE, 0L, 1, MYF(MY_WME)))
unknown's avatar
unknown committed
1051
  {
1052
    my_close(file, MYF(0));
1053
    my_delete(path, MYF(0));  // Delete file on error, it was just created 
1054
    return -1;
unknown's avatar
unknown committed
1055
  }
1056
  return file;
1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067
}


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);

1068
  if ((file= create_file(thd, path, exchange, &cache)) < 0)
1069
    return 1;
unknown's avatar
unknown committed
1070 1071
  /* Check if there is any blobs in data */
  {
unknown's avatar
unknown committed
1072
    List_iterator_fast<Item> li(list);
unknown's avatar
unknown committed
1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106
    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
1107
  String tmp(buff,sizeof(buff),&my_charset_bin),*res;
unknown's avatar
unknown committed
1108 1109
  tmp.length(0);

1110
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
1111
  {						// using limit offset,count
1112
    unit->offset_limit_cnt--;
unknown's avatar
unknown committed
1113 1114 1115 1116 1117 1118
    DBUG_RETURN(0);
  }
  row_count++;
  Item *item;
  char *buff_ptr=buff;
  uint used_length=0,items_left=items.elements;
unknown's avatar
unknown committed
1119
  List_iterator_fast<Item> li(items);
unknown's avatar
unknown committed
1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 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

  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
1168 1169
          CHARSET_INFO *res_charset=res->charset();
	  if (use_mb(res_charset))
unknown's avatar
unknown committed
1170 1171
	  {
	    int l;
unknown's avatar
unknown committed
1172
	    if ((l=my_ismbchar(res_charset, pos, end)))
unknown's avatar
unknown committed
1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207
	    {
	      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;
1208
	for (; length > sizeof(space) ; length-=sizeof(space))
unknown's avatar
unknown committed
1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245
	{
	  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
1246 1247
select_dump::prepare(List<Item> &list __attribute__((unused)),
		     SELECT_LEX_UNIT *u)
unknown's avatar
unknown committed
1248
{
1249
  unit= u;
1250
  return (int) ((file= create_file(thd, path, exchange, &cache)) < 0);
unknown's avatar
unknown committed
1251 1252 1253 1254 1255
}


bool select_dump::send_data(List<Item> &items)
{
unknown's avatar
unknown committed
1256
  List_iterator_fast<Item> li(items);
unknown's avatar
unknown committed
1257
  char buff[MAX_FIELD_WIDTH];
unknown's avatar
unknown committed
1258
  String tmp(buff,sizeof(buff),&my_charset_bin),*res;
unknown's avatar
unknown committed
1259 1260 1261 1262
  tmp.length(0);
  Item *item;
  DBUG_ENTER("send_data");

1263
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
1264
  {						// using limit offset,count
1265
    unit->offset_limit_cnt--;
unknown's avatar
unknown committed
1266 1267 1268 1269
    DBUG_RETURN(0);
  }
  if (row_count++ > 1) 
  {
unknown's avatar
unknown committed
1270
    my_message(ER_TOO_MANY_ROWS, ER(ER_TOO_MANY_ROWS), MYF(0));
unknown's avatar
unknown committed
1271 1272 1273 1274 1275
    goto err;
  }
  while ((item=li++))
  {
    res=item->str_result(&tmp);
1276
    if (!res)					// If NULL
unknown's avatar
unknown committed
1277
    {
1278 1279
      if (my_b_write(&cache,(byte*) "",1))
	goto err;
unknown's avatar
unknown committed
1280 1281 1282
    }
    else if (my_b_write(&cache,(byte*) res->ptr(),res->length()))
    {
1283
      my_error(ER_ERROR_ON_WRITE, MYF(0), path, my_errno);
unknown's avatar
unknown committed
1284 1285 1286 1287 1288 1289 1290 1291 1292
      goto err;
    }
  }
  DBUG_RETURN(0);
err:
  DBUG_RETURN(1);
}


1293
select_subselect::select_subselect(Item_subselect *item_arg)
1294
{
1295
  item= item_arg;
1296 1297
}

1298

unknown's avatar
unknown committed
1299
bool select_singlerow_subselect::send_data(List<Item> &items)
1300
{
unknown's avatar
unknown committed
1301 1302
  DBUG_ENTER("select_singlerow_subselect::send_data");
  Item_singlerow_subselect *it= (Item_singlerow_subselect *)item;
unknown's avatar
unknown committed
1303 1304
  if (it->assigned())
  {
1305
    my_message(ER_SUBQUERY_NO_1_ROW, ER(ER_SUBQUERY_NO_1_ROW), MYF(0));
unknown's avatar
unknown committed
1306 1307 1308
    DBUG_RETURN(1);
  }
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
1309
  {				          // Using limit offset,count
unknown's avatar
unknown committed
1310 1311
    unit->offset_limit_cnt--;
    DBUG_RETURN(0);
1312
  }
unknown's avatar
unknown committed
1313
  List_iterator_fast<Item> li(items);
1314 1315 1316
  Item *val_item;
  for (uint i= 0; (val_item= li++); i++)
    it->store(i, val_item);
unknown's avatar
unknown committed
1317
  it->assigned(1);
unknown's avatar
unknown committed
1318
  DBUG_RETURN(0);
1319
}
unknown's avatar
unknown committed
1320

1321

1322 1323 1324 1325 1326 1327 1328 1329
void select_max_min_finder_subselect::cleanup()
{
  DBUG_ENTER("select_max_min_finder_subselect::cleanup");
  cache= 0;
  DBUG_VOID_RETURN;
}


1330 1331 1332
bool select_max_min_finder_subselect::send_data(List<Item> &items)
{
  DBUG_ENTER("select_max_min_finder_subselect::send_data");
1333
  Item_maxmin_subselect *it= (Item_maxmin_subselect *)item;
1334 1335
  List_iterator_fast<Item> li(items);
  Item *val_item= li++;
1336
  it->register_value();
1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358
  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
1359 1360 1361
      case DECIMAL_RESULT:
        op= &select_max_min_finder_subselect::cmp_decimal;
        break;
1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377
      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);
1378
  double val1= cache->val_real(), val2= maxmin->val_real();
1379 1380 1381 1382
  if (fmax)
    return (cache->null_value && !maxmin->null_value) ||
      (!cache->null_value && !maxmin->null_value &&
       val1 > val2);
1383 1384 1385
  return (maxmin->null_value && !cache->null_value) ||
    (!cache->null_value && !maxmin->null_value &&
     val1 < val2);
1386 1387 1388 1389 1390 1391 1392 1393 1394 1395
}

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);
1396 1397 1398
  return (maxmin->null_value && !cache->null_value) ||
    (!cache->null_value && !maxmin->null_value &&
     val1 < val2);
1399 1400
}

unknown's avatar
unknown committed
1401 1402 1403 1404 1405 1406 1407 1408 1409
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) ;
1410 1411 1412
  return (maxmin->null_value && !cache->null_value) ||
    (!cache->null_value && !maxmin->null_value &&
     my_decimal_cmp(cvalue,mvalue) < 0);
unknown's avatar
unknown committed
1413 1414
}

1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428
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) ;
1429 1430 1431
  return (maxmin->null_value && !cache->null_value) ||
    (!cache->null_value && !maxmin->null_value &&
     sortcmp(val1, val2, cache->collation.collation) < 0);
1432 1433
}

unknown's avatar
unknown committed
1434 1435 1436 1437 1438 1439 1440 1441 1442 1443
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
1444
  it->assigned(1);
unknown's avatar
unknown committed
1445 1446 1447
  DBUG_RETURN(0);
}

unknown's avatar
unknown committed
1448 1449

/***************************************************************************
1450
  Dump of select to variables
unknown's avatar
unknown committed
1451
***************************************************************************/
1452

1453
int select_dumpvar::prepare(List<Item> &list, SELECT_LEX_UNIT *u)
unknown's avatar
unknown committed
1454
{
1455
  List_iterator_fast<Item> li(list);
unknown's avatar
unknown committed
1456
  List_iterator_fast<my_var> gl(var_list);
unknown's avatar
unknown committed
1457
  Item *item;
1458

1459 1460
  local_vars.empty();				// Clear list if SP
  unit= u;
1461
  row_count= 0;
1462

1463
  if (var_list.elements != list.elements)
unknown's avatar
unknown committed
1464
  {
unknown's avatar
unknown committed
1465 1466
    my_message(ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT,
               ER(ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT), MYF(0));
1467
    return 1;
unknown's avatar
unknown committed
1468
  }
1469
  while ((item=li++))
unknown's avatar
unknown committed
1470
  {
1471
    my_var *mv= gl++;
unknown's avatar
unknown committed
1472
    if (mv->local)
unknown's avatar
unknown committed
1473
      (void)local_vars.push_back(new Item_splocal(mv->s, mv->offset));
unknown's avatar
unknown committed
1474 1475
    else
    {
1476
      Item_func_set_user_var *var= new Item_func_set_user_var(mv->s, item);
unknown's avatar
unknown committed
1477 1478 1479
      /*
        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
1480
        Item_func_set_user_var can't be fixed after creation, so we do not
1481
        check var->fixed
unknown's avatar
unknown committed
1482
      */
1483 1484 1485
      var->fix_fields(thd, 0);
      var->fix_length_and_dec();
      vars.push_back(var);
unknown's avatar
unknown committed
1486
    }
unknown's avatar
unknown committed
1487
  }
1488 1489
  return 0;
}
1490

1491

1492 1493 1494 1495 1496 1497 1498
void select_dumpvar::cleanup()
{
  vars.empty();
  row_count=0;
}


unknown's avatar
unknown committed
1499
Query_arena::Type Query_arena::type() const
1500
{
unknown's avatar
unknown committed
1501
  DBUG_ASSERT(0); /* Should never be called */
1502
  return STATEMENT;
1503 1504 1505
}


1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520
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;
}


1521 1522 1523 1524
/*
  Statement functions 
*/

unknown's avatar
unknown committed
1525 1526 1527 1528
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),
1529 1530 1531 1532
  set_query_id(1),
  allow_sum_func(0),
  lex(&main_lex),
  query(0),
1533 1534
  query_length(0),
  cursor(0)
1535
{
1536
  name.str= NULL;
unknown's avatar
unknown committed
1537
  init_sql_alloc(&main_mem_root, alloc_block_size, prealloc_size);
1538 1539 1540
}


unknown's avatar
unknown committed
1541
Query_arena::Type Statement::type() const
1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554
{
  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;
1555
  cursor=         stmt->cursor;
1556 1557 1558
}


1559 1560 1561
void
Statement::set_n_backup_statement(Statement *stmt, Statement *backup)
{
1562
  DBUG_ENTER("Statement::set_n_backup_statement");
1563 1564
  backup->set_statement(this);
  set_statement(stmt);
1565
  DBUG_VOID_RETURN;
1566 1567 1568 1569 1570
}


void Statement::restore_backup_statement(Statement *stmt, Statement *backup)
{
1571
  DBUG_ENTER("Statement::restore_backup_statement");
1572 1573
  stmt->set_statement(this);
  set_statement(backup);
1574
  DBUG_VOID_RETURN;
1575 1576 1577
}


1578 1579 1580 1581 1582 1583
void Statement::close_cursor()
{
  DBUG_ASSERT("Statement::close_cursor()" == "not implemented");
}


1584
void THD::end_statement()
1585 1586 1587 1588 1589
{
  /* Cleanup SQL processing state to resuse this statement in next query. */
  lex_end(lex);
  delete lex->result;
  lex->result= 0;
1590 1591
  /* Note that free_list is freed in cleanup_after_query() */

1592 1593 1594 1595 1596 1597 1598
  /*
    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
1599
void THD::set_n_backup_active_arena(Query_arena *set, Query_arena *backup)
unknown's avatar
unknown committed
1600
{
unknown's avatar
unknown committed
1601
  DBUG_ENTER("THD::set_n_backup_active_arena");
1602
  DBUG_ASSERT(backup->is_backup_arena == FALSE);
1603

unknown's avatar
unknown committed
1604 1605
  backup->set_query_arena(this);
  set_query_arena(set);
unknown's avatar
unknown committed
1606
#ifndef DBUG_OFF
1607
  backup->is_backup_arena= TRUE;
unknown's avatar
unknown committed
1608
#endif
1609
  DBUG_VOID_RETURN;
unknown's avatar
unknown committed
1610 1611 1612
}


unknown's avatar
unknown committed
1613
void THD::restore_active_arena(Query_arena *set, Query_arena *backup)
1614
{
unknown's avatar
unknown committed
1615
  DBUG_ENTER("THD::restore_active_arena");
1616
  DBUG_ASSERT(backup->is_backup_arena);
unknown's avatar
unknown committed
1617 1618
  set->set_query_arena(this);
  set_query_arena(backup);
unknown's avatar
unknown committed
1619
#ifndef DBUG_OFF
1620
  backup->is_backup_arena= FALSE;
1621
#endif
unknown's avatar
unknown committed
1622
  DBUG_VOID_RETURN;
1623 1624
}

unknown's avatar
unknown committed
1625
void Query_arena::set_query_arena(Query_arena *set)
unknown's avatar
unknown committed
1626
{
unknown's avatar
unknown committed
1627
  mem_root=  set->mem_root;
unknown's avatar
unknown committed
1628
  free_list= set->free_list;
1629
  state= set->state;
unknown's avatar
unknown committed
1630 1631
}

1632 1633
Statement::~Statement()
{
1634 1635 1636 1637 1638
  /*
    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
1639
  free_root(&main_mem_root, MYF(0));
1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657
}

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;
}

1658 1659
static byte *get_stmt_name_hash_key(Statement *entry, uint *length,
                                    my_bool not_used __attribute__((unused)))
1660 1661 1662 1663 1664
{
  *length=(uint) entry->name.length;
  return (byte*) entry->name.str;
}

1665 1666 1667 1668 1669
C_MODE_END

Statement_map::Statement_map() :
  last_found_statement(0)
{
1670 1671 1672 1673 1674
  enum
  {
    START_STMT_HASH_SIZE = 16,
    START_NAME_HASH_SIZE = 16
  };
1675
  hash_init(&st_hash, &my_charset_bin, START_STMT_HASH_SIZE, 0, 0,
1676 1677
            get_statement_id_as_hash_key,
            delete_statement_as_hash_key, MYF(0));
1678
  hash_init(&names_hash, system_charset_info, START_NAME_HASH_SIZE, 0, 0,
1679 1680
            (hash_get_key) get_stmt_name_hash_key,
            NULL,MYF(0));
1681 1682
}

1683

1684 1685 1686 1687 1688 1689 1690 1691
int Statement_map::insert(Statement *statement)
{
  int rc= my_hash_insert(&st_hash, (byte *) statement);
  if (statement->name.str)
  {
    if ((rc= my_hash_insert(&names_hash, (byte*)statement)))
      hash_delete(&st_hash, (byte*)statement);
  }
1692 1693
  if (rc == 0)
    last_found_statement= statement;
1694
  return rc;
1695 1696
}

1697

1698 1699 1700 1701 1702 1703 1704 1705
void Statement_map::close_transient_cursors()
{
  Statement *stmt;
  while ((stmt= transient_cursor_list.head()))
    stmt->close_cursor();                 /* deletes itself from the list */
}


1706 1707 1708
bool select_dumpvar::send_data(List<Item> &items)
{
  List_iterator_fast<Item_func_set_user_var> li(vars);
unknown's avatar
unknown committed
1709 1710
  List_iterator_fast<Item_splocal> var_li(local_vars);
  List_iterator_fast<my_var> my_li(var_list);
1711
  List_iterator<Item> it(items);
1712
  Item_func_set_user_var *xx;
unknown's avatar
unknown committed
1713 1714
  Item_splocal *yy;
  my_var *zz;
1715
  DBUG_ENTER("send_data");
unknown's avatar
unknown committed
1716 1717 1718 1719 1720
  if (unit->offset_limit_cnt)
  {						// using limit offset,count
    unit->offset_limit_cnt--;
    DBUG_RETURN(0);
  }
1721

1722 1723 1724 1725 1726
  if (unit->offset_limit_cnt)
  {				          // Using limit offset,count
    unit->offset_limit_cnt--;
    DBUG_RETURN(0);
  }
1727 1728
  if (row_count++) 
  {
unknown's avatar
unknown committed
1729
    my_message(ER_TOO_MANY_ROWS, ER(ER_TOO_MANY_ROWS), MYF(0));
1730 1731
    DBUG_RETURN(1);
  }
1732
  while ((zz=my_li++) && (it++))
unknown's avatar
unknown committed
1733
  {
unknown's avatar
unknown committed
1734 1735 1736 1737
    if (zz->local)
    {
      if ((yy=var_li++)) 
      {
1738 1739
	if (thd->spcont->set_item_eval(current_thd,
				       yy->get_offset(), it.ref(), zz->type))
1740
	  DBUG_RETURN(1);
unknown's avatar
unknown committed
1741 1742 1743 1744 1745
      }
    }
    else
    {
      if ((xx=li++))
unknown's avatar
unknown committed
1746 1747
      {
        xx->check();
unknown's avatar
unknown committed
1748
	xx->update();
unknown's avatar
unknown committed
1749
      }
unknown's avatar
unknown committed
1750
    }
unknown's avatar
unknown committed
1751
  }
unknown's avatar
unknown committed
1752 1753 1754 1755 1756
  DBUG_RETURN(0);
}

bool select_dumpvar::send_eof()
{
1757
  if (! row_count)
unknown's avatar
unknown committed
1758 1759
    push_warning(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
                 ER_SP_FETCH_NO_DATA, ER(ER_SP_FETCH_NO_DATA));
1760 1761
  ::send_ok(thd,row_count);
  return 0;
unknown's avatar
unknown committed
1762
}
1763 1764 1765 1766 1767 1768 1769 1770 1771 1772

/****************************************************************************
  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
1773
  table_charset= 0;
1774
}
1775 1776 1777 1778


void thd_increment_bytes_sent(ulong length)
{
unknown's avatar
unknown committed
1779
  THD *thd=current_thd;
unknown's avatar
unknown committed
1780
  if (likely(thd != 0))
unknown's avatar
unknown committed
1781 1782 1783
  { /* current_thd==0 when close_connection() calls net_send_error() */
    thd->status_var.bytes_sent+= length;
  }
1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802
}


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));
}
1803 1804 1805 1806 1807 1808 1809 1810 1811

/****************************************************************************
  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.
****************************************************************************/

1812
void THD::reset_n_backup_open_tables_state(Open_tables_state *backup)
1813
{
1814 1815
  DBUG_ENTER("reset_n_backup_open_tables_state");
  backup->set_open_tables_state(this);
1816
  reset_open_tables_state();
1817
  DBUG_VOID_RETURN;
1818 1819 1820
}


1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832
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);
1833 1834
  DBUG_VOID_RETURN;
}
1835 1836


1837

1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879
/****************************************************************************
  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;

1880 1881
  if (!lex->requires_prelocking() || is_update_query(lex->sql_command))
    options&= ~OPTION_BIN_LOG;
1882 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 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
  /* 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;
}
1919 1920 1921 1922 1923 1924


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

1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937
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)))
{
  *length=((XID_STATE*)ptr)->xid.length();
  return (byte *)&((XID_STATE*)ptr)->xid;
}

static void xid_free_hash (void *ptr)
{
  if (!((XID_STATE*)ptr)->in_thd)
unknown's avatar
unknown committed
1938
    my_free((gptr)ptr, MYF(0));
1939 1940 1941 1942 1943
}

bool xid_cache_init()
{
  pthread_mutex_init(&LOCK_xid_cache, MY_MUTEX_INIT_FAST);
unknown's avatar
unknown committed
1944 1945
  return hash_init(&xid_cache, &my_charset_bin, 100, 0, 0,
                   xid_get_hash_key, xid_free_hash, 0) != 0;
1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964
}

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);
  XID_STATE *res=(XID_STATE *)hash_search(&xid_cache, (byte *)xid, xid->length());
  pthread_mutex_unlock(&LOCK_xid_cache);
  return res;
}

1965

1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985
bool xid_cache_insert(XID *xid, enum xa_states xa_state)
{
  XID_STATE *xs;
  my_bool res;
  pthread_mutex_lock(&LOCK_xid_cache);
  if (hash_search(&xid_cache, (byte *)xid, xid->length()))
    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;
}

1986

1987 1988 1989 1990 1991 1992 1993 1994 1995 1996
bool xid_cache_insert(XID_STATE *xid_state)
{
  pthread_mutex_lock(&LOCK_xid_cache);
  DBUG_ASSERT(hash_search(&xid_cache, (byte *)&xid_state->xid,
                          xid_state->xid.length())==0);
  my_bool res=my_hash_insert(&xid_cache, (byte*)xid_state);
  pthread_mutex_unlock(&LOCK_xid_cache);
  return res;
}

1997

1998 1999 2000 2001 2002 2003 2004
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);
}