sql_class.cc 25.9 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 25 26 27 28 29 30 31 32
   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
**
*****************************************************************************/

#ifdef __GNUC__
#pragma implementation				// gcc: Class implementation
#endif

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

40

unknown's avatar
unknown committed
41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
/*****************************************************************************
** Instansiate templates
*****************************************************************************/

#ifdef __GNUC__
/* 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
****************************************************************************/

61 62
extern "C" byte *get_var_key(user_var_entry *entry, uint *length,
			     my_bool not_used __attribute__((unused)))
unknown's avatar
unknown committed
63 64 65 66 67
{
  *length=(uint) entry->name.length;
  return (byte*) entry->name.str;
}

68
extern "C" void free_user_var(user_var_entry *entry)
unknown's avatar
unknown committed
69 70 71 72 73 74 75 76 77 78 79 80
{
  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));
}


/****************************************************************************
** Thread specific functions
****************************************************************************/

81 82
THD::THD():user_time(0), fatal_error(0),
	   last_insert_id_used(0),
unknown's avatar
unknown committed
83
	   insert_id_used(0), rand_used(0), in_lock_tables(0),
unknown's avatar
unknown committed
84
	   global_read_lock(0), bootstrap(0)
unknown's avatar
unknown committed
85
{
86
  host=user=priv_user=db=query=ip=0;
87
  host_or_ip="unknown ip";
unknown's avatar
unknown committed
88
  locked=killed=count_cuted_fields=some_tables_deleted=no_errors=password=
89
    query_start_used=prepare_command=0;
unknown's avatar
unknown committed
90
  db_length=query_length=col_access=0;
unknown's avatar
unknown committed
91 92
  query_error=0;
  next_insert_id=last_insert_id=0;
unknown's avatar
unknown committed
93
  open_tables=temporary_tables=handler_tables=0;
94
  current_tablenr=0;
unknown's avatar
unknown committed
95
  handler_items=0;
unknown's avatar
unknown committed
96 97
  tmp_table=0;
  lock=locked_tables=0;
98
  used_tables=0;
99
  cuted_fields= sent_row_count= current_stmt_id= 0L;
unknown's avatar
unknown committed
100
  start_time=(time_t) 0;
unknown's avatar
unknown committed
101
  current_linfo =  0;
102
  slave_thread = 0;
103
  slave_proxy_id = 0;
104
  file_id = 0;
unknown's avatar
unknown committed
105
  cond_count=0;
106
  warn_id= 0;
107
  db_charset=default_charset_info;
unknown's avatar
unknown committed
108
  mysys_var=0;
109 110 111
#ifndef DBUG_OFF
  dbug_sentry=THD_SENTRY_MAGIC;
#endif  
unknown's avatar
unknown committed
112
  net.vio=0;
113
  net.last_error[0]=0;				// If error on boot
unknown's avatar
unknown committed
114
  ull=0;
unknown's avatar
unknown committed
115
  system_thread=cleanup_done=0;
116
  transaction.changed_tables = 0;
unknown's avatar
unknown committed
117 118 119 120 121 122
#ifdef	__WIN__
  real_id = 0;
#endif
#ifdef SIGNAL_WITH_VIO_CLOSE
  active_vio = 0;
#endif  
123
  pthread_mutex_init(&LOCK_delete, MY_MUTEX_INIT_FAST);
unknown's avatar
unknown committed
124 125 126 127 128

  /* Variables with default values */
  proc_info="login";
  where="field list";
  server_id = ::server_id;
129
  slave_net = 0;
130
  log_pos = 0;
unknown's avatar
unknown committed
131 132 133
  command=COM_CONNECT;
  set_query_id=1;
  db_access=NO_ACCESS;
134
  version=refresh_version;			// For boot
unknown's avatar
unknown committed
135

unknown's avatar
unknown committed
136
  init();
unknown's avatar
unknown committed
137 138
  /* Initialize sub structures */
  bzero((char*) &mem_root,sizeof(mem_root));
139
  bzero((char*) &transaction.mem_root,sizeof(transaction.mem_root));
unknown's avatar
unknown committed
140
  bzero((char*) &con_root,sizeof(con_root));
141 142
  bzero((char*) &warn_root,sizeof(warn_root));
  init_alloc_root(&warn_root, 1024, 0);
143
  user_connect=(USER_CONN *)0;
unknown's avatar
unknown committed
144
  hash_init(&user_vars, system_charset_info, USER_VARS_HASH_SIZE, 0, 0,
unknown's avatar
unknown committed
145
	    (hash_get_key) get_var_key,
146
	    (hash_free_key) free_user_var,0);
147 148 149 150 151 152 153

  /* Prepared statements */
  last_prepared_stmt= 0;
  init_tree(&prepared_statements, 0, 0, sizeof(PREP_STMT),
	    (qsort_cmp2) compare_prep_stmt, 1,
	    (tree_element_free) free_prep_stmt, 0);

154 155 156 157 158
  /* Protocol */
  protocol= &protocol_simple;			// Default protocol
  protocol_simple.init(this);
  protocol_prep.init(this);

159
#ifdef USING_TRANSACTIONS
unknown's avatar
unknown committed
160
  bzero((char*) &transaction,sizeof(transaction));
161 162 163 164 165 166 167 168
  if (opt_using_transactions)
  {
    if (open_cached_file(&transaction.trans_log,
			 mysql_tmpdir, LOG_PREFIX, binlog_cache_size,
			 MYF(MY_WME)))
      killed=1;
    transaction.trans_log.end_of_file= max_binlog_cache_size;
  }
169
#endif
170 171 172 173 174 175 176 177 178

  /*
    We need good random number initialization for new thread
    Just coping global one will not work
  */
  {
    pthread_mutex_lock(&LOCK_thread_count);
    ulong tmp=(ulong) (rnd(&sql_rand) * 3000000);
    pthread_mutex_unlock(&LOCK_thread_count);
179
    randominit(&rand, tmp + (ulong) &rand, tmp + (ulong) ::query_id);
180
  }
unknown's avatar
unknown committed
181 182
}

unknown's avatar
unknown committed
183 184 185 186 187 188 189

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

void THD::init(void)
{
190 191
  pthread_mutex_lock(&LOCK_global_system_variables);
  variables= global_system_variables;
192
  variables.thd_charset=default_charset_info;
193
  pthread_mutex_unlock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
194 195 196 197
  server_status= SERVER_STATUS_AUTOCOMMIT;
  options= thd_startup_options;
  sql_mode=(uint) opt_sql_mode;
  open_options=ha_open_options;
198 199 200
  update_lock_default= (variables.low_priority_updates ?
			TL_WRITE_LOW_PRIORITY :
			TL_WRITE);
unknown's avatar
unknown committed
201
  session_tx_isolation= (enum_tx_isolation) variables.tx_isolation;
202 203 204
  warn_list.empty();
  bzero((char*) warn_count, sizeof(warn_count));
  total_warn_count= 0;
unknown's avatar
unknown committed
205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220
}

/*
  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
221
  cleanup_done= 0;
unknown's avatar
unknown committed
222
  init();
unknown's avatar
unknown committed
223
  hash_init(&user_vars, system_charset_info, USER_VARS_HASH_SIZE, 0, 0,
unknown's avatar
unknown committed
224
	    (hash_get_key) get_var_key,
unknown's avatar
unknown committed
225
	    (hash_free_key) free_user_var, 0);
unknown's avatar
unknown committed
226 227 228
}


unknown's avatar
unknown committed
229 230 231
/* Do operations that may take a long time */

void THD::cleanup(void)
unknown's avatar
unknown committed
232
{
unknown's avatar
unknown committed
233
  DBUG_ENTER("THD::cleanup");
unknown's avatar
unknown committed
234
  ha_rollback(this);
235
  delete_tree(&prepared_statements);
unknown's avatar
unknown committed
236 237 238 239 240
  if (locked_tables)
  {
    lock=locked_tables; locked_tables=0;
    close_thread_tables(this);
  }
unknown's avatar
unknown committed
241 242 243
  if (handler_tables)
  {
    open_tables=handler_tables; handler_tables=0;
unknown's avatar
unknown committed
244 245 246
    close_thread_tables(this);
  }
  close_temporary_tables(this);
unknown's avatar
unknown committed
247 248 249 250
  hash_free(&user_vars);
  if (global_read_lock)
    unlock_global_read_lock(this);
  if (ull)
251
  {
unknown's avatar
unknown committed
252 253 254 255
    pthread_mutex_lock(&LOCK_user_locks);
    item_user_lock_release(ull);
    pthread_mutex_unlock(&LOCK_user_locks);
    ull= 0;
256
  }
unknown's avatar
unknown committed
257 258 259 260
  cleanup_done=1;
  DBUG_VOID_RETURN;
}

unknown's avatar
unknown committed
261

unknown's avatar
unknown committed
262 263
THD::~THD()
{
264
  THD_CHECK_SENTRY(this);
unknown's avatar
unknown committed
265
  DBUG_ENTER("~THD()");
266 267 268 269
  /* Ensure that no one is using THD */
  pthread_mutex_lock(&LOCK_delete);
  pthread_mutex_unlock(&LOCK_delete);

unknown's avatar
unknown committed
270 271 272 273 274 275 276 277
  /* Close connection */
  if (net.vio)
  {
    vio_delete(net.vio);
    net_end(&net); 
  }
  if (!cleanup_done)
    cleanup();
unknown's avatar
unknown committed
278 279
#ifdef USING_TRANSACTIONS
  if (opt_using_transactions)
unknown's avatar
unknown committed
280
  {
unknown's avatar
unknown committed
281 282
    close_cached_file(&transaction.trans_log);
    ha_close_connection(this);
unknown's avatar
unknown committed
283
  }
unknown's avatar
unknown committed
284
#endif
unknown's avatar
unknown committed
285 286

  DBUG_PRINT("info", ("freeing host"));
287 288
  if (host != localhost)			// If not pointer to constant
    safeFree(host);
289 290
  if (user != delayed_user)
    safeFree(user);
unknown's avatar
unknown committed
291 292
  safeFree(db);
  safeFree(ip);
293
  free_root(&mem_root,MYF(0));
unknown's avatar
unknown committed
294
  free_root(&con_root,MYF(0));
295
  free_root(&warn_root,MYF(0));
296
  free_root(&transaction.mem_root,MYF(0));
unknown's avatar
unknown committed
297
  mysys_var=0;					// Safety (shouldn't be needed)
298
  pthread_mutex_destroy(&LOCK_delete);
299 300
#ifndef DBUG_OFF
  dbug_sentry = THD_SENTRY_GONE;
301
#endif  
unknown's avatar
unknown committed
302 303 304
  DBUG_VOID_RETURN;
}

305

306
void THD::awake(bool prepare_to_die)
307
{
308
  THD_CHECK_SENTRY(this);
309 310
  safe_mutex_assert_owner(&LOCK_delete); 

311 312
  if (prepare_to_die)
    killed = 1;
313 314 315 316 317
  thr_alarm_kill(real_id);
#ifdef SIGNAL_WITH_VIO_CLOSE
  close_active_vio();
#endif    
  if (mysys_var)
unknown's avatar
unknown committed
318 319 320 321 322 323 324 325 326 327 328
  {
    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.
    */
    if (mysys_var->current_cond)
329
    {
unknown's avatar
unknown committed
330 331 332
      pthread_mutex_lock(mysys_var->current_mutex);
      pthread_cond_broadcast(mysys_var->current_cond);
      pthread_mutex_unlock(mysys_var->current_mutex);
333
    }
unknown's avatar
unknown committed
334 335
    pthread_mutex_unlock(&mysys_var->mutex);
  }
336 337
}

unknown's avatar
unknown committed
338 339 340 341
/*
  Remember the location of thread info, the structure needed for
  sql_alloc() and the structure for the net buffer
*/
unknown's avatar
unknown committed
342 343 344

bool THD::store_globals()
{
345
  if (my_pthread_setspecific_ptr(THR_THD,  this) ||
unknown's avatar
unknown committed
346
      my_pthread_setspecific_ptr(THR_MALLOC, &mem_root))
347 348 349 350
    return 1;
  mysys_var=my_thread_var;
  dbug_thread_id=my_thread_id();
  return 0;
unknown's avatar
unknown committed
351 352
}

unknown's avatar
unknown committed
353

354 355 356 357 358 359 360 361 362 363 364 365 366 367
/* 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 */
368

369 370
void THD::add_changed_table(TABLE *table)
{
371
  DBUG_ENTER("THD::add_changed_table(table)");
372

unknown's avatar
unknown committed
373
  DBUG_ASSERT((options & (OPTION_NOT_AUTOCOMMIT | OPTION_BEGIN)) &&
374
	      table->file->has_transactions());
unknown's avatar
unknown committed
375 376
  add_changed_table(table->table_cache_key, table->key_length);
  DBUG_VOID_RETURN;
unknown's avatar
unknown committed
377
}
378

379

unknown's avatar
unknown committed
380 381 382
void THD::add_changed_table(const char *key, long key_length)
{
  DBUG_ENTER("THD::add_changed_table(key)");
383 384
  CHANGED_TABLE_LIST **prev_changed = &transaction.changed_tables;
  CHANGED_TABLE_LIST *curr = transaction.changed_tables;
385

386
  for (; curr; prev_changed = &(curr->next), curr = curr->next)
387
  {
unknown's avatar
unknown committed
388
    int cmp =  (long)curr->key_length - (long)key_length;
389 390
    if (cmp < 0)
    {
391
      list_include(prev_changed, curr, changed_table_dup(key, key_length));
392
      DBUG_PRINT("info", 
393
		 ("key_length %u %u", key_length, (*prev_changed)->key_length));
394 395 396 397
      DBUG_VOID_RETURN;
    }
    else if (cmp == 0)
    {
unknown's avatar
unknown committed
398
      cmp = memcmp(curr->key, key, curr->key_length);
399 400
      if (cmp < 0)
      {
401
	list_include(prev_changed, curr, changed_table_dup(key, key_length));
402
	DBUG_PRINT("info", 
unknown's avatar
unknown committed
403
		   ("key_length %u %u", key_length,
404
		    (*prev_changed)->key_length));
405 406 407 408 409 410 411 412 413
	DBUG_VOID_RETURN;
      }
      else if (cmp == 0)
      {
	DBUG_PRINT("info", ("already in list"));
	DBUG_VOID_RETURN;
      }
    }
  }
414
  *prev_changed = changed_table_dup(key, key_length);
unknown's avatar
unknown committed
415
  DBUG_PRINT("info", ("key_length %u %u", key_length,
416
		      (*prev_changed)->key_length));
417 418 419
  DBUG_VOID_RETURN;
}

420

unknown's avatar
unknown committed
421
CHANGED_TABLE_LIST* THD::changed_table_dup(const char *key, long key_length)
422 423 424
{
  CHANGED_TABLE_LIST* new_table = 
    (CHANGED_TABLE_LIST*) trans_alloc(ALIGN_SIZE(sizeof(CHANGED_TABLE_LIST))+
unknown's avatar
unknown committed
425
				      key_length + 1);
426 427 428
  if (!new_table)
  {
    my_error(EE_OUTOFMEMORY, MYF(ME_BELL),
unknown's avatar
unknown committed
429
	     ALIGN_SIZE(sizeof(TABLE_LIST)) + key_length + 1);
430 431 432 433 434 435 436
    killed= 1;
    return 0;
  }

  new_table->key = (char *) (((byte*)new_table)+
			     ALIGN_SIZE(sizeof(CHANGED_TABLE_LIST)));
  new_table->next = 0;
unknown's avatar
unknown committed
437 438
  new_table->key_length = key_length;
  ::memcpy(new_table->key, key, key_length);
439 440 441
  return new_table;
}

unknown's avatar
unknown committed
442 443 444 445
int THD::send_explain_fields(select_result *result)
{
  List<Item> field_list;
  Item *item;
446
  field_list.push_back(new Item_return_int("id",3, MYSQL_TYPE_LONGLONG));
unknown's avatar
unknown committed
447 448 449 450 451 452 453 454
  field_list.push_back(new Item_empty_string("select_type",19));
  field_list.push_back(new Item_empty_string("table",NAME_LEN));
  field_list.push_back(new Item_empty_string("type",10));
  field_list.push_back(item=new Item_empty_string("possible_keys",
						  NAME_LEN*MAX_KEY));
  item->maybe_null=1;
  field_list.push_back(item=new Item_empty_string("key",NAME_LEN));
  item->maybe_null=1;
455 456
  field_list.push_back(item=new Item_return_int("key_len",3,
						MYSQL_TYPE_LONGLONG));
unknown's avatar
unknown committed
457 458 459 460
  item->maybe_null=1;
  field_list.push_back(item=new Item_empty_string("ref",
						  NAME_LEN*MAX_REF_PARTS));
  item->maybe_null=1;
461
  field_list.push_back(new Item_return_int("rows",10, MYSQL_TYPE_LONGLONG));
unknown's avatar
unknown committed
462 463 464
  field_list.push_back(new Item_empty_string("Extra",255));
  return (result->send_fields(field_list,1));
}
465

unknown's avatar
unknown committed
466 467 468 469 470 471 472 473 474 475 476 477
#ifdef SIGNAL_WITH_VIO_CLOSE
void THD::close_active_vio()
{
  safe_mutex_assert_owner(&LOCK_delete); 
  if (active_vio)
  {
    vio_close(active_vio);
    active_vio = 0;
  }
}
#endif

478 479 480 481 482 483 484 485 486
void THD::add_possible_loop (Item *item)
{
  if (!possible_loops)
  {
    possible_loops= new List<Item>;
  }
  possible_loops->push_back(item);
}

unknown's avatar
unknown committed
487 488 489 490 491 492 493 494 495
/*****************************************************************************
** Functions to provide a interface to select results
*****************************************************************************/

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

496 497 498 499
static String
	default_line_term("\n",default_charset_info),
	default_escaped("\\",default_charset_info),
	default_field_term("\t",default_charset_info);
unknown's avatar
unknown committed
500 501 502 503 504 505 506 507 508 509 510 511

sql_exchange::sql_exchange(char *name,bool flag)
  :file_name(name), opt_enclosed(0), dumpfile(flag), skip_lines(0)
{
  field_term= &default_field_term;
  enclosed=   line_start= &empty_string;
  line_term=  &default_line_term;
  escaped=    &default_escaped;
}

bool select_send::send_fields(List<Item> &list,uint flag)
{
512
  return thd->protocol->send_fields(&list,flag);
unknown's avatar
unknown committed
513 514 515 516 517 518 519
}


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

bool select_send::send_data(List<Item> &items)
{
520
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
521
  {						// using limit offset,count
522
    unit->offset_limit_cnt--;
523
    return 0;
unknown's avatar
unknown committed
524
  }
525 526 527 528

  List_iterator_fast<Item> li(items);
  Protocol *protocol= thd->protocol;
  char buff[MAX_FIELD_WIDTH];
unknown's avatar
unknown committed
529
  String buffer(buff, sizeof(buff), NULL);
530 531 532
  DBUG_ENTER("send_data");

  protocol->prepare_for_resend();
unknown's avatar
unknown committed
533 534 535
  Item *item;
  while ((item=li++))
  {
536
    if (item->send(protocol, &buffer))
unknown's avatar
unknown committed
537
    {
538
      protocol->free();				// Free used buffer
unknown's avatar
unknown committed
539
      my_message(ER_OUT_OF_RESOURCES, ER(ER_OUT_OF_RESOURCES), MYF(0));
540
      break;
unknown's avatar
unknown committed
541 542
    }
  }
543
  thd->sent_row_count++;
unknown's avatar
unknown committed
544
  if (!thd->net.report_error)
545 546
    DBUG_RETURN(protocol->write());
  DBUG_RETURN(1);
unknown's avatar
unknown committed
547 548 549 550 551 552 553 554 555
}

bool select_send::send_eof()
{
  /* Unlock tables before sending packet to gain some speed */
  if (thd->lock)
  {
    mysql_unlock_tables(thd, thd->lock); thd->lock=0;
  }
unknown's avatar
unknown committed
556 557
  if (!thd->net.report_error)
  {
unknown's avatar
unknown committed
558
    ::send_eof(thd);
unknown's avatar
unknown committed
559 560 561 562
    return 0;
  }
  else
    return 1;
unknown's avatar
unknown committed
563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578
}


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


select_export::~select_export()
{
  if (file >= 0)
  {					// This only happens in case of error
    (void) end_io_cache(&cache);
    (void) my_close(file,MYF(0));
    file= -1;
  }
579
  thd->sent_row_count=row_count;
unknown's avatar
unknown committed
580 581 582
}

int
583
select_export::prepare(List<Item> &list, SELECT_LEX_UNIT *u)
unknown's avatar
unknown committed
584 585 586 587
{
  char path[FN_REFLEN];
  uint option=4;
  bool blob_flag=0;
588
  unit= u;
unknown's avatar
unknown committed
589 590 591
#ifdef DONT_ALLOW_FULL_LOAD_DATA_PATHS
  option|=1;					// Force use of db directory
#endif
unknown's avatar
unknown committed
592
  if ((uint) strlen(exchange->file_name) + NAME_LEN >= FN_REFLEN)
unknown's avatar
unknown committed
593 594 595 596 597
    strmake(path,exchange->file_name,FN_REFLEN-1);
  (void) fn_format(path,exchange->file_name, thd->db ? thd->db : "", "",
		   option);
  if (!access(path,F_OK))
  {
unknown's avatar
unknown committed
598
    my_error(ER_FILE_EXISTS_ERROR, MYF(0), exchange->file_name);
unknown's avatar
unknown committed
599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616
    return 1;
  }
  /* Create the file world readable */
  if ((file=my_create(path, 0666, O_WRONLY, MYF(MY_WME))) < 0)
    return 1;
#ifdef HAVE_FCHMOD
  (void) fchmod(file,0666);			// Because of umask()
#else
  (void) chmod(path,0666);
#endif
  if (init_io_cache(&cache,file,0L,WRITE_CACHE,0L,1,MYF(MY_WME)))
  {
    my_close(file,MYF(0));
    file= -1;
    return 1;
  }
  /* Check if there is any blobs in data */
  {
unknown's avatar
unknown committed
617
    List_iterator_fast<Item> li(list);
unknown's avatar
unknown committed
618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651
    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
652
  String tmp(buff,sizeof(buff),NULL),*res;
unknown's avatar
unknown committed
653 654
  tmp.length(0);

655
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
656
  {						// using limit offset,count
657
    unit->offset_limit_cnt--;
unknown's avatar
unknown committed
658 659 660 661 662 663
    DBUG_RETURN(0);
  }
  row_count++;
  Item *item;
  char *buff_ptr=buff;
  uint used_length=0,items_left=items.elements;
unknown's avatar
unknown committed
664
  List_iterator_fast<Item> li(items);
unknown's avatar
unknown committed
665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712

  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
713 714
          CHARSET_INFO *res_charset=res->charset();
	  if (use_mb(res_charset))
unknown's avatar
unknown committed
715 716
	  {
	    int l;
unknown's avatar
unknown committed
717
	    if ((l=my_ismbchar(res_charset, pos, end)))
unknown's avatar
unknown committed
718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752
	    {
	      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;
753
	for (; length > sizeof(space) ; length-=sizeof(space))
unknown's avatar
unknown committed
754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784
	{
	  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);
}


unknown's avatar
unknown committed
785
void select_export::send_error(uint errcode, const char *err)
unknown's avatar
unknown committed
786
{
unknown's avatar
unknown committed
787
  my_message(errcode, err, MYF(0));;
788 789 790
  (void) end_io_cache(&cache);
  (void) my_close(file,MYF(0));
  file= -1;
unknown's avatar
unknown committed
791 792 793 794 795 796 797 798
}


bool select_export::send_eof()
{
  int error=test(end_io_cache(&cache));
  if (my_close(file,MYF(MY_WME)))
    error=1;
unknown's avatar
unknown committed
799
  if (!error)
800
    ::send_ok(thd,row_count);
unknown's avatar
unknown committed
801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821
  file= -1;
  return error;
}


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


select_dump::~select_dump()
{
  if (file >= 0)
  {					// This only happens in case of error
    (void) end_io_cache(&cache);
    (void) my_close(file,MYF(0));
    file= -1;
  }
}

int
822 823
select_dump::prepare(List<Item> &list __attribute__((unused)),
		     SELECT_LEX_UNIT *u)
unknown's avatar
unknown committed
824 825
{
  uint option=4;
826
  unit= u;
unknown's avatar
unknown committed
827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857
#ifdef DONT_ALLOW_FULL_LOAD_DATA_PATHS
  option|=1;					// Force use of db directory
#endif
  (void) fn_format(path,exchange->file_name, thd->db ? thd->db : "", "",
		   option);
  if (!access(path,F_OK))
  {
    my_error(ER_FILE_EXISTS_ERROR,MYF(0),exchange->file_name);
    return 1;
  }
  /* Create the file world readable */
  if ((file=my_create(path, 0666, O_WRONLY, MYF(MY_WME))) < 0)
    return 1;
#ifdef HAVE_FCHMOD
  (void) fchmod(file,0666);			// Because of umask()
#else
  (void) chmod(path,0666);
#endif
  if (init_io_cache(&cache,file,0L,WRITE_CACHE,0L,1,MYF(MY_WME)))
  {
    my_close(file,MYF(0));
    my_delete(path,MYF(0));
    file= -1;
    return 1;
  }
  return 0;
}


bool select_dump::send_data(List<Item> &items)
{
unknown's avatar
unknown committed
858
  List_iterator_fast<Item> li(items);
unknown's avatar
unknown committed
859
  char buff[MAX_FIELD_WIDTH];
unknown's avatar
unknown committed
860
  String tmp(buff,sizeof(buff),NULL),*res;
unknown's avatar
unknown committed
861 862 863 864
  tmp.length(0);
  Item *item;
  DBUG_ENTER("send_data");

865
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
866
  {						// using limit offset,count
867
    unit->offset_limit_cnt--;
unknown's avatar
unknown committed
868 869 870 871
    DBUG_RETURN(0);
  }
  if (row_count++ > 1) 
  {
unknown's avatar
unknown committed
872
    my_error(ER_TOO_MANY_ROWS, MYF(0));
unknown's avatar
unknown committed
873 874 875 876 877
    goto err;
  }
  while ((item=li++))
  {
    res=item->str_result(&tmp);
878
    if (!res)					// If NULL
unknown's avatar
unknown committed
879
    {
880 881
      if (my_b_write(&cache,(byte*) "",1))
	goto err;
unknown's avatar
unknown committed
882 883 884 885 886 887 888 889 890 891 892 893 894 895 896
    }
    else if (my_b_write(&cache,(byte*) res->ptr(),res->length()))
    {
      my_error(ER_ERROR_ON_WRITE,MYF(0), path, my_errno);
      goto err;
    }
  }
  DBUG_RETURN(0);
err:
  DBUG_RETURN(1);
}


void select_dump::send_error(uint errcode,const char *err)
{
unknown's avatar
unknown committed
897
  my_message(errcode, err, MYF(0));
unknown's avatar
unknown committed
898 899 900 901 902 903 904 905 906 907 908
  (void) end_io_cache(&cache);
  (void) my_close(file,MYF(0));
  (void) my_delete(path,MYF(0));		// Delete file on error
  file= -1;
}

bool select_dump::send_eof()
{
  int error=test(end_io_cache(&cache));
  if (my_close(file,MYF(MY_WME)))
    error=1;
unknown's avatar
unknown committed
909
  if (!error)
910
    ::send_ok(thd,row_count);
unknown's avatar
unknown committed
911 912 913
  file= -1;
  return error;
}
914 915 916 917 918 919

select_subselect::select_subselect(Item_subselect *item)
{
  this->item=item;
}

unknown's avatar
unknown committed
920
bool select_singleval_subselect::send_data(List<Item> &items)
921
{
unknown's avatar
unknown committed
922 923
  DBUG_ENTER("select_singleval_subselect::send_data");
  Item_singleval_subselect *it= (Item_singleval_subselect *)item;
unknown's avatar
unknown committed
924 925
  if (it->assigned())
  {
926
      my_message(ER_SUBSELECT_NO_1_ROW, ER(ER_SUBSELECT_NO_1_ROW), MYF(0));
unknown's avatar
unknown committed
927 928 929
    DBUG_RETURN(1);
  }
  if (unit->offset_limit_cnt)
unknown's avatar
unknown committed
930
  {				          // Using limit offset,count
unknown's avatar
unknown committed
931 932
    unit->offset_limit_cnt--;
    DBUG_RETURN(0);
933
  }
unknown's avatar
unknown committed
934 935 936 937 938 939
  List_iterator_fast<Item> li(items);
  Item *val_item= li++;                   // Only one (single value subselect)
  /*
    Following val() call have to be first, because function AVG() & STD()
    calculate value on it & determinate "is it NULL?".
  */
unknown's avatar
unknown committed
940
  it->real_value= val_item->val_result();
unknown's avatar
unknown committed
941
  if ((it->null_value= val_item->null_value))
942
  {
943
    it->reset();
944 945 946
  } 
  else 
  {
unknown's avatar
unknown committed
947 948
    it->max_length= val_item->max_length;
    it->decimals= val_item->decimals;
949
    it->set_charset(val_item->charset());
unknown's avatar
unknown committed
950 951
    it->int_value= val_item->val_int_result();
    String *s= val_item->str_result(&it->string_value);
952 953 954 955 956 957 958
    if (s != &it->string_value)
    {
      it->string_value.set(*s, 0, s->length());
    }
    // TODO: remove when correct charset handling appeared for Item
    it->str_value.set(*s, 0, s->length()); // store charset

unknown's avatar
unknown committed
959
    it->res_type= val_item->result_type();
960
  }
unknown's avatar
unknown committed
961
  it->assigned(1);
unknown's avatar
unknown committed
962
  DBUG_RETURN(0);
963
}
unknown's avatar
unknown committed
964 965 966 967 968 969 970 971 972 973 974

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
975
  it->assigned(1);
unknown's avatar
unknown committed
976 977 978
  DBUG_RETURN(0);
}

unknown's avatar
unknown committed
979 980 981 982

/***************************************************************************
** Dump  of select to variables
***************************************************************************/
983
int select_dumpvar::prepare(List<Item> &list, SELECT_LEX_UNIT *u)
unknown's avatar
unknown committed
984
{
985 986
  List_iterator_fast<Item> li(list);
  List_iterator_fast<LEX_STRING> gl(var_list);
unknown's avatar
unknown committed
987 988
  Item *item;
  LEX_STRING *ls;
989
  if (var_list.elements != list.elements)
unknown's avatar
unknown committed
990
  {
991 992
    my_error(ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT, MYF(0));
    return 1;
unknown's avatar
unknown committed
993
  }
994
  while ((item=li++))
unknown's avatar
unknown committed
995
  {
996
    ls= gl++;
unknown's avatar
unknown committed
997 998 999
    Item_func_set_user_var *xx = new Item_func_set_user_var(*ls,item);
    xx->fix_fields(current_thd,(TABLE_LIST*) current_thd->lex.select_lex.table_list.first,&item);
    xx->fix_length_and_dec();
1000
    vars.push_back(xx);
unknown's avatar
unknown committed
1001
  }
1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016
  return 0;
}
bool select_dumpvar::send_data(List<Item> &items)
{
  List_iterator_fast<Item_func_set_user_var> li(vars);
  Item_func_set_user_var *xx;
  DBUG_ENTER("send_data");

  if (row_count++) 
  {
    my_error(ER_TOO_MANY_ROWS, MYF(0));
    DBUG_RETURN(1);
  }
  while ((xx=li++))
    xx->update();
unknown's avatar
unknown committed
1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032
  DBUG_RETURN(0);
}

bool select_dumpvar::send_eof()
{
  if (row_count)
  {
    ::send_ok(thd,row_count);
    return 0;
  }
  else
  {
    my_error(ER_EMPTY_QUERY,MYF(0));
    return 1;
  }
}