sql_insert.cc 46.7 KB
Newer Older
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1
/* Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2

bk@work.mysql.com's avatar
bk@work.mysql.com 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.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
7

bk@work.mysql.com's avatar
bk@work.mysql.com 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.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
12

bk@work.mysql.com's avatar
bk@work.mysql.com committed
13 14 15 16 17 18 19 20 21 22 23 24 25
   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 */


/* Insert of records */

#include "mysql_priv.h"
#include "sql_acl.h"

static int check_null_fields(THD *thd,TABLE *entry);
static TABLE *delayed_get_table(THD *thd,TABLE_LIST *table_list);
static int write_delayed(THD *thd,TABLE *table, enum_duplicates dup,
26
			 char *query, uint query_length, int log_on);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
27
static void end_delayed_insert(THD *thd);
28
extern "C" pthread_handler_decl(handle_delayed_insert,arg);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
29 30 31 32 33 34 35 36 37 38 39 40
static void unlink_blobs(register TABLE *table);

/* Define to force use of my_malloc() if the allocated memory block is big */

#ifndef HAVE_ALLOCA
#define my_safe_alloca(size, min_length) my_alloca(size)
#define my_safe_afree(ptr, size, min_length) my_afree(ptr)
#else
#define my_safe_alloca(size, min_length) ((size <= min_length) ? my_alloca(size) : my_malloc(size,MYF(0)))
#define my_safe_afree(ptr, size, min_length) if (size > min_length) my_free(ptr,MYF(0))
#endif

41 42
#define DELAYED_LOG_UPDATE 1
#define DELAYED_LOG_BIN    2
bk@work.mysql.com's avatar
bk@work.mysql.com committed
43 44 45

/*
  Check if insert fields are correct
46 47
  Updates table->time_stamp to point to timestamp field or 0, depending on
  if timestamp should be updated or not.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
48 49
*/

50
int
bk@work.mysql.com's avatar
bk@work.mysql.com committed
51 52 53 54 55 56 57 58 59 60 61 62
check_insert_fields(THD *thd,TABLE *table,List<Item> &fields,
		    List<Item> &values, ulong counter)
{
  if (fields.elements == 0 && values.elements != 0)
  {
    if (values.elements != table->fields)
    {
      my_printf_error(ER_WRONG_VALUE_COUNT_ON_ROW,
		      ER(ER_WRONG_VALUE_COUNT_ON_ROW),
		      MYF(0),counter);
      return -1;
    }
hf@deer.(none)'s avatar
hf@deer.(none) committed
63
#ifndef NO_EMBEDDED_ACCESS_CHECKS
bk@work.mysql.com's avatar
bk@work.mysql.com committed
64 65 66
    if (grant_option &&
	check_grant_all_columns(thd,INSERT_ACL,table))
      return -1;
hf@deer.(none)'s avatar
hf@deer.(none) committed
67
#endif
68
    table->time_stamp=0;			// This is saved by caller
bk@work.mysql.com's avatar
bk@work.mysql.com committed
69 70 71 72 73 74 75 76 77 78 79 80
  }
  else
  {						// Part field list
    if (fields.elements != values.elements)
    {
      my_printf_error(ER_WRONG_VALUE_COUNT_ON_ROW,
		      ER(ER_WRONG_VALUE_COUNT_ON_ROW),
		      MYF(0),counter);
      return -1;
    }
    TABLE_LIST table_list;
    bzero((char*) &table_list,sizeof(table_list));
81
    table_list.db=  table->table_cache_key;
82
    table_list.real_name= table_list.alias= table->table_name;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
83 84 85 86
    table_list.table=table;
    table_list.grant=table->grant;

    thd->dupp_field=0;
87
    if (setup_tables(&table_list) ||
88
	setup_fields(thd, 0, &table_list,fields,1,0,0))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
89 90 91 92 93 94
      return -1;
    if (thd->dupp_field)
    {
      my_error(ER_FIELD_SPECIFIED_TWICE,MYF(0), thd->dupp_field->field_name);
      return -1;
    }
95
    table->time_stamp=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
96
    if (table->timestamp_field &&	// Don't set timestamp if used
97 98
	table->timestamp_field->query_id != thd->query_id)
      table->time_stamp= table->timestamp_field->offset()+1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
99
  }
100
  // For the values we need select_priv
hf@deer.(none)'s avatar
hf@deer.(none) committed
101
#ifndef NO_EMBEDDED_ACCESS_CHECKS
bk@work.mysql.com's avatar
bk@work.mysql.com committed
102
  table->grant.want_privilege=(SELECT_ACL & ~table->grant.privilege);
hf@deer.(none)'s avatar
hf@deer.(none) committed
103
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
104 105 106 107
  return 0;
}


108 109 110 111 112 113
int mysql_insert(THD *thd,TABLE_LIST *table_list,
                 List<Item> &fields,
                 List<List_item> &values_list,
                 List<Item> &update_fields,
                 List<Item> &update_values,
                 enum_duplicates duplic)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
114 115
{
  int error;
116 117 118 119 120 121 122
  /*
    log_on is about delayed inserts only.
    By default, both logs are enabled (this won't cause problems if the server
    runs without --log-update or --log-bin).
  */
  int log_on= DELAYED_LOG_UPDATE | DELAYED_LOG_BIN ;

123
  bool transactional_table, log_delayed, bulk_insert;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
124 125 126 127 128
  uint value_count;
  ulong counter = 1;
  ulonglong id;
  COPY_INFO info;
  TABLE *table;
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
129
  List_iterator_fast<List_item> its(values_list);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
130 131
  List_item *values;
  char *query=thd->query;
132
  thr_lock_type lock_type = table_list->lock_type;
133
  TABLE_LIST *insert_table_list= (TABLE_LIST*)
134
    thd->lex->select_lex.table_list.first;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
135 136
  DBUG_ENTER("mysql_insert");

hf@deer.(none)'s avatar
hf@deer.(none) committed
137
#ifndef NO_EMBEDDED_ACCESS_CHECKS
138
  if (thd->master_access & SUPER_ACL)
hf@deer.(none)'s avatar
hf@deer.(none) committed
139
#endif
140 141
  {
    if (!(thd->options & OPTION_UPDATE_LOG))
142
      log_on&= ~(int) DELAYED_LOG_UPDATE;
143
    if (!(thd->options & OPTION_BIN_LOG))
144
      log_on&= ~(int) DELAYED_LOG_BIN;
145
  }
146 147 148 149 150
  /*
    in safe mode or with skip-new change delayed insert to be regular
    if we are told to replace duplicates, the insert cannot be concurrent
    delayed insert changed to regular in slave thread
   */
151 152
  if ((lock_type == TL_WRITE_DELAYED &&
       ((specialflag & (SPECIAL_NO_NEW_FUNC | SPECIAL_SAFE_MODE)) ||
153
	thd->slave_thread || !max_insert_delayed_threads)) ||
154 155
      (lock_type == TL_WRITE_CONCURRENT_INSERT && duplic == DUP_REPLACE) ||
      (duplic == DUP_UPDATE))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
156
    lock_type=TL_WRITE;
157
  table_list->lock_type= lock_type;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
158

159
  int res;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
160 161 162 163 164 165 166 167 168 169 170 171 172 173
  if (lock_type == TL_WRITE_DELAYED)
  {
    if (thd->locked_tables)
    {
      if (find_locked_table(thd,
			    table_list->db ? table_list->db : thd->db,
			    table_list->real_name))
      {
	my_printf_error(ER_DELAYED_INSERT_TABLE_LOCKED,
			ER(ER_DELAYED_INSERT_TABLE_LOCKED),
			MYF(0), table_list->real_name);
	DBUG_RETURN(-1);
      }
    }
174
    if ((table= delayed_get_table(thd,table_list)) && !thd->is_fatal_error)
175 176 177
    {
      res= 0;
      if (table_list->next)			/* if sub select */
178
	res= open_and_lock_tables(thd, table_list->next);
179
    }
180
    else
181
    {
182 183
      /* Too many delayed insert threads;  Use a normal insert */
      table_list->lock_type= lock_type= TL_WRITE;
184
      res= open_and_lock_tables(thd, table_list);
185
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
186 187
  }
  else
188 189
    res= open_and_lock_tables(thd, table_list);
  if (res)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
190
    DBUG_RETURN(-1);
191 192

  table= table_list->table;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
193
  thd->proc_info="init";
194
  thd->used_tables=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
195
  values= its++;
196 197 198 199

  if (duplic == DUP_UPDATE && !table->insert_values)
  {
    /* it should be allocated before Item::fix_fields() */
200 201
    table->insert_values= 
      (byte *)alloc_root(&thd->mem_root, table->rec_buff_length);
202 203 204 205
    if (!table->insert_values)
      goto abort;
  }

bk@work.mysql.com's avatar
bk@work.mysql.com committed
206
  if (check_insert_fields(thd,table,fields,*values,1) ||
207
      setup_tables(insert_table_list) ||
208
      setup_fields(thd, 0, insert_table_list, *values, 0, 0, 0) ||
209
      (duplic == DUP_UPDATE &&
210 211
       (setup_fields(thd, 0, insert_table_list, update_fields, 0, 0, 0) ||
        setup_fields(thd, 0, insert_table_list, update_values, 0, 0, 0))))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
212
    goto abort;
213 214 215
  if (find_real_table_in_list(table_list->next, 
			      table_list->db, table_list->real_name))
  {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
216
    my_error(ER_UPDATE_TABLE_USED, MYF(0), table_list->real_name);
217 218 219
    goto abort;
  }

bk@work.mysql.com's avatar
bk@work.mysql.com committed
220
  value_count= values->elements;
221
  while ((values= its++))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
222 223 224 225 226 227 228 229 230
  {
    counter++;
    if (values->elements != value_count)
    {
      my_printf_error(ER_WRONG_VALUE_COUNT_ON_ROW,
		      ER(ER_WRONG_VALUE_COUNT_ON_ROW),
		      MYF(0),counter);
      goto abort;
    }
231
    if (setup_fields(thd, 0, insert_table_list, *values, 0, 0, 0))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
232 233 234 235
      goto abort;
  }
  its.rewind ();
  /*
236
    Fill in the given fields and dump it to the table file
bk@work.mysql.com's avatar
bk@work.mysql.com committed
237 238
  */

vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
239
  info.records= info.deleted= info.copied= info.updated= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
240
  info.handle_duplicates=duplic;
241 242
  info.update_fields=&update_fields;
  info.update_values=&update_values;
243 244 245 246 247 248 249 250
  /*
    Count warnings for all inserts.
    For single line insert, generate an error if try to set a NOT NULL field
    to NULL
  */
  thd->count_cuted_fields= ((values_list.elements == 1) ?
			    CHECK_FIELD_ERROR_FOR_NULL :
			    CHECK_FIELD_WARN);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
251 252 253 254 255 256
  thd->cuted_fields = 0L;
  table->next_number_field=table->found_next_number_field;

  error=0;
  id=0;
  thd->proc_info="update";
257
  if (duplic != DUP_ERROR)
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
258
    table->file->extra(HA_EXTRA_IGNORE_DUP_KEY);
259 260
  if ((lock_type != TL_WRITE_DELAYED && !(specialflag & SPECIAL_SAFE_MODE)) &&
      values_list.elements >= MIN_ROWS_TO_USE_BULK_INSERT)
261
  {
262
    table->file->extra_opt(HA_EXTRA_WRITE_CACHE,
263 264
			   min(thd->variables.read_buff_size,
			       table->avg_row_length*values_list.elements));
265 266
    table->file->deactivate_non_unique_index(values_list.elements);
    bulk_insert=1;
267
  }
268 269
  else
    bulk_insert=0;
270

271
  while ((values= its++))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
272 273 274
  {
    if (fields.elements || !value_count)
    {
275
      restore_record(table,default_values);	// Get empty record
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
276
      if (fill_record(fields, *values, 0)|| thd->net.report_error ||
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
277
	  check_null_fields(thd,table))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
278
      {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
279
	if (values_list.elements != 1 && !thd->net.report_error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
280 281 282 283 284 285 286 287 288 289
	{
	  info.records++;
	  continue;
	}
	error=1;
	break;
      }
    }
    else
    {
290
      if (thd->used_tables)			// Column used in values()
291
	restore_record(table,default_values);	// Get empty record
292
      else
293
	table->record[0][0]=table->default_values[0]; // Fix delete marker
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
294
      if (fill_record(table->field,*values, 0) || thd->net.report_error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
295
      {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
296
	if (values_list.elements != 1 && ! thd->net.report_error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
297 298 299 300 301 302 303 304
	{
	  info.records++;
	  continue;
	}
	error=1;
	break;
      }
    }
305
    if (lock_type == TL_WRITE_DELAYED)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323
    {
      error=write_delayed(thd,table,duplic,query, thd->query_length, log_on);
      query=0;
    }
    else
      error=write_record(table,&info);
    if (error)
      break;
    /*
      If auto_increment values are used, save the first one
       for LAST_INSERT_ID() and for the update log.
       We can't use insert_id() as we don't want to touch the
       last_insert_id_used flag.
    */
    if (! id && thd->insert_id_used)
    {						// Get auto increment value
      id= thd->last_insert_id;
    }
324
    thd->row_count++;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
325
  }
326 327 328 329 330

  /*
    Now all rows are inserted.  Time to update logs and sends response to
    user
  */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
331 332
  if (lock_type == TL_WRITE_DELAYED)
  {
333 334 335 336 337 338
    if (!error)
    {
      id=0;					// No auto_increment id
      info.copied=values_list.elements;
      end_delayed_insert(thd);
    }
339
    query_cache_invalidate3(thd, table_list, 1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
340 341 342
  }
  else
  {
343 344 345 346 347 348 349 350 351 352
    if (bulk_insert)
    {
      if (table->file->extra(HA_EXTRA_NO_CACHE))
      {
	if (!error)
	{
	  table->file->print_error(my_errno,MYF(0));
	  error=1;
	}
      }
353
      if (table->file->activate_all_index(thd))
354 355 356 357 358 359 360 361
      {
	if (!error)
	{
	  table->file->print_error(my_errno,MYF(0));
	  error=1;
	}
      }
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
362 363
    if (id && values_list.elements != 1)
      thd->insert_id(id);			// For update log
364
    else if (table->next_number_field && info.copied)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
365
      id=table->next_number_field->val_int();	// Return auto_increment value
366

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
367 368 369 370 371
    /*
      Invalidate the table in the query cache if something changed.
      For the transactional algorithm to work the invalidation must be
      before binlog writing and ha_autocommit_...
    */
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
372
    if (info.copied || info.deleted || info.updated)
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
373 374
      query_cache_invalidate3(thd, table_list, 1);

375
    transactional_table= table->file->has_transactions();
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
376

377
    log_delayed= (transactional_table || table->tmp_table);
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
378 379
    if ((info.copied || info.deleted || info.updated) && 
	(error <= 0 || !transactional_table))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
380
    {
381 382 383
      mysql_update_log.write(thd, thd->query, thd->query_length);
      if (mysql_bin_log.is_open())
      {
guilhem@mysql.com's avatar
guilhem@mysql.com committed
384 385
        if (error <= 0)
          thd->clear_error();
386
	Query_log_event qinfo(thd, thd->query, thd->query_length,
387 388
			      log_delayed);
	if (mysql_bin_log.write(&qinfo) && transactional_table)
389
	  error=1;
390
      }
391
      if (!log_delayed)
392
	thd->options|=OPTION_STATUS_NO_TRANS_UPDATE;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
393
    }
394
    if (transactional_table)
395
      error=ha_autocommit_or_rollback(thd,error);
396

bk@work.mysql.com's avatar
bk@work.mysql.com committed
397 398 399 400 401 402 403 404
    if (thd->lock)
    {
      mysql_unlock_tables(thd, thd->lock);
      thd->lock=0;
    }
  }
  thd->proc_info="end";
  table->next_number_field=0;
405
  thd->count_cuted_fields= CHECK_FIELD_IGNORE;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
406
  thd->next_insert_id=0;			// Reset this if wrongly used
407
  if (duplic != DUP_ERROR)
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
408
    table->file->extra(HA_EXTRA_NO_IGNORE_DUP_KEY);
409 410 411 412 413 414 415

  /* Reset value of LAST_INSERT_ID if no rows where inserted */
  if (!info.copied && thd->insert_id_used)
  {
    thd->insert_id(0);
    id=0;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
416 417 418 419
  if (error)
    goto abort;
  if (values_list.elements == 1 && (!(thd->options & OPTION_WARNINGS) ||
				    !thd->cuted_fields))
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
420
    send_ok(thd,info.copied+info.deleted+info.updated,id);
421 422
  else
  {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
423 424
    char buff[160];
    if (duplic == DUP_IGNORE)
425 426 427
      sprintf(buff, ER(ER_INSERT_INFO), (ulong) info.records,
	      (lock_type == TL_WRITE_DELAYED) ? (ulong) 0 :
	      (ulong) (info.records - info.copied), (ulong) thd->cuted_fields);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
428
    else
429
      sprintf(buff, ER(ER_INSERT_INFO), (ulong) info.records,
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
430 431
	      (ulong) info.deleted+info.updated, (ulong) thd->cuted_fields);
    ::send_ok(thd,info.copied+info.deleted+info.updated,(ulonglong)id,buff);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
432
  }
433
  free_underlaid_joins(thd, &thd->lex->select_lex);
434
  table->insert_values=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
435 436 437 438 439
  DBUG_RETURN(0);

abort:
  if (lock_type == TL_WRITE_DELAYED)
    end_delayed_insert(thd);
440
  free_underlaid_joins(thd, &thd->lex->select_lex);
441
  table->insert_values=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457
  DBUG_RETURN(-1);
}


	/* Check if there is more uniq keys after field */

static int last_uniq_key(TABLE *table,uint keynr)
{
  while (++keynr < table->keys)
    if (table->key_info[keynr].flags & HA_NOSAME)
      return 0;
  return 1;
}


/*
458
  Write a record to table with optional deleting of conflicting records
bk@work.mysql.com's avatar
bk@work.mysql.com committed
459 460 461 462 463 464 465
*/


int write_record(TABLE *table,COPY_INFO *info)
{
  int error;
  char *key=0;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
466

bk@work.mysql.com's avatar
bk@work.mysql.com committed
467
  info->records++;
468 469
  if (info->handle_duplicates == DUP_REPLACE ||
      info->handle_duplicates == DUP_UPDATE)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
470 471 472
  {
    while ((error=table->file->write_row(table->record[0])))
    {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
473
      if (error != HA_WRITE_SKIP)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
474 475 476 477
	goto err;
      uint key_nr;
      if ((int) (key_nr = table->file->get_dup_key(error)) < 0)
      {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
478
	error=HA_WRITE_SKIP;			/* Database can't find key */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
479 480
	goto err;
      }
481 482 483 484 485
      /*
	Don't allow REPLACE to replace a row when a auto_increment column
	was used.  This ensures that we don't get a problem when the
	whole range of the key has been used.
      */
486 487 488
      if (info->handle_duplicates == DUP_REPLACE &&
          table->next_number_field &&
          key_nr == table->next_number_index &&
489 490
	  table->file->auto_increment_column_changed)
	goto err;
491
      if (table->file->table_flags() & HA_DUPP_POS)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
492 493 494 495 496 497
      {
	if (table->file->rnd_pos(table->record[1],table->file->dupp_ref))
	  goto err;
      }
      else
      {
498
	if (table->file->extra(HA_EXTRA_FLUSH_CACHE)) /* Not needed with NISAM */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
499 500 501 502
	{
	  error=my_errno;
	  goto err;
	}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
503

bk@work.mysql.com's avatar
bk@work.mysql.com committed
504 505 506 507 508 509 510 511 512 513 514
	if (!key)
	{
	  if (!(key=(char*) my_safe_alloca(table->max_unique_length,
					   MAX_KEY_LENGTH)))
	  {
	    error=ENOMEM;
	    goto err;
	  }
	}
	key_copy((byte*) key,table,key_nr,0);
	if ((error=(table->file->index_read_idx(table->record[1],key_nr,
515
						(byte*) key,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
516 517
						table->key_info[key_nr].
						key_length,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
518 519 520
						HA_READ_KEY_EXACT))))
	  goto err;
      }
521
      if (info->handle_duplicates == DUP_UPDATE)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
522
      {
523 524 525 526
        /* we don't check for other UNIQUE keys - the first row
           that matches, is updated. If update causes a conflict again,
           an error is returned
        */
527 528
        store_record(table,insert_values);
        restore_record(table,record[1]);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
529
        if (fill_record(*info->update_fields, *info->update_values, 0))
530 531 532
          goto err;
        if ((error=table->file->update_row(table->record[1],table->record[0])))
          goto err;
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
533
        info->updated++;
534 535 536 537
        break;
      }
      else /* DUP_REPLACE */
      {
monty@mysql.com's avatar
monty@mysql.com committed
538 539 540 541 542 543 544 545
	/*
	  The manual defines the REPLACE semantics that it is either
	  an INSERT or DELETE(s) + INSERT; FOREIGN KEY checks in
	  InnoDB do not function in the defined way if we allow MySQL
	  to convert the latter operation internally to an UPDATE.
	*/
	if (last_uniq_key(table,key_nr) &&
	    !table->file->referenced_by_foreign_key())
546
        {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
547 548
          if ((error=table->file->update_row(table->record[1],
					     table->record[0])))
549 550
            goto err;
          info->deleted++;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
551
          break;				/* Update logfile and count */
552 553 554 555
        }
        else if ((error=table->file->delete_row(table->record[1])))
          goto err;
        info->deleted++;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574
      }
    }
    info->copied++;
  }
  else if ((error=table->file->write_row(table->record[0])))
  {
    if (info->handle_duplicates != DUP_IGNORE ||
	(error != HA_ERR_FOUND_DUPP_KEY && error != HA_ERR_FOUND_DUPP_UNIQUE))
      goto err;
  }
  else
    info->copied++;
  if (key)
    my_safe_afree(key,table->max_unique_length,MAX_KEY_LENGTH);
  return 0;

err:
  if (key)
    my_afree(key);
575
  info->last_errno= error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
576 577 578 579 580 581
  table->file->print_error(error,MYF(0));
  return 1;
}


/******************************************************************************
582 583 584
  Check that all fields with arn't null_fields are used
  If DONT_USE_DEFAULT_FIELDS isn't defined use default value for not set
  fields.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606
******************************************************************************/

static int check_null_fields(THD *thd __attribute__((unused)),
			     TABLE *entry __attribute__((unused)))
{
#ifdef DONT_USE_DEFAULT_FIELDS
  for (Field **field=entry->field ; *field ; field++)
  {
    if ((*field)->query_id != thd->query_id && !(*field)->maybe_null() &&
	*field != entry->timestamp_field &&
	*field != entry->next_number_field)
    {
      my_printf_error(ER_BAD_NULL_ERROR, ER(ER_BAD_NULL_ERROR),MYF(0),
		      (*field)->field_name);
      return 1;
    }
  }
#endif
  return 0;
}

/*****************************************************************************
607 608
  Handling of delayed inserts
  A thread is created for each table that one uses with the DELAYED attribute.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
609 610 611 612 613 614 615
*****************************************************************************/

class delayed_row :public ilink {
public:
  char *record,*query;
  enum_duplicates dup;
  time_t start_time;
616 617
  bool query_start_used,last_insert_id_used,insert_id_used;
  int log_query;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
618 619 620 621
  ulonglong last_insert_id;
  ulong time_stamp;
  uint query_length;

622
  delayed_row(enum_duplicates dup_arg, int log_query_arg)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642
    :record(0),query(0),dup(dup_arg),log_query(log_query_arg) {}
  ~delayed_row()
  {
    x_free(record);
  }
};


class delayed_insert :public ilink {
  uint locks_in_memory;
public:
  THD thd;
  TABLE *table;
  pthread_mutex_t mutex;
  pthread_cond_t cond,cond_client;
  volatile uint tables_in_use,stacked_inserts;
  volatile bool status,dead;
  COPY_INFO info;
  I_List<delayed_row> rows;
  uint group_count;
643
  TABLE_LIST table_list;			// Argument
bk@work.mysql.com's avatar
bk@work.mysql.com committed
644 645 646 647 648 649

  delayed_insert()
    :locks_in_memory(0),
     table(0),tables_in_use(0),stacked_inserts(0), status(0), dead(0),
     group_count(0)
  {
650
    thd.user=thd.priv_user=(char*) delayed_user;
hf@deer.(none)'s avatar
hf@deer.(none) committed
651
    thd.host=(char*) my_localhost;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
652 653 654
    thd.current_tablenr=0;
    thd.version=refresh_version;
    thd.command=COM_DELAYED_INSERT;
655
    thd.lex->current_select= 0; /* for my_message_sql */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
656

657 658
    bzero((char*) &thd.net, sizeof(thd.net));		// Safety
    bzero((char*) &table_list, sizeof(table_list));	// Safety
659
    thd.system_thread= SYSTEM_THREAD_DELAYED_INSERT;
660
    thd.host_or_ip= "";
bk@work.mysql.com's avatar
bk@work.mysql.com committed
661
    bzero((char*) &info,sizeof(info));
662
    pthread_mutex_init(&mutex,MY_MUTEX_INIT_FAST);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
663 664 665 666 667 668 669 670
    pthread_cond_init(&cond,NULL);
    pthread_cond_init(&cond_client,NULL);
    VOID(pthread_mutex_lock(&LOCK_thread_count));
    delayed_insert_threads++;
    VOID(pthread_mutex_unlock(&LOCK_thread_count));
  }
  ~delayed_insert()
  {
671
    /* The following is not really needed, but just for safety */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
672 673 674 675 676 677
    delayed_row *row;
    while ((row=rows.get()))
      delete row;
    if (table)
      close_thread_tables(&thd);
    VOID(pthread_mutex_lock(&LOCK_thread_count));
678 679 680
    pthread_mutex_destroy(&mutex);
    pthread_cond_destroy(&cond);
    pthread_cond_destroy(&cond_client);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
681 682 683 684 685 686
    thd.unlink();				// Must be unlinked under lock
    x_free(thd.query);
    thd.user=thd.host=0;
    thread_count--;
    delayed_insert_threads--;
    VOID(pthread_mutex_unlock(&LOCK_thread_count));
687
    VOID(pthread_cond_broadcast(&COND_thread_count)); /* Tell main we are ready */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
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 713 714 715 716 717 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
  }

  /* The following is for checking when we can delete ourselves */
  inline void lock()
  {
    locks_in_memory++;				// Assume LOCK_delay_insert
  }
  void unlock()
  {
    pthread_mutex_lock(&LOCK_delayed_insert);
    if (!--locks_in_memory)
    {
      pthread_mutex_lock(&mutex);
      if (thd.killed && ! stacked_inserts && ! tables_in_use)
      {
	pthread_cond_signal(&cond);
	status=1;
      }
      pthread_mutex_unlock(&mutex);
    }
    pthread_mutex_unlock(&LOCK_delayed_insert);
  }
  inline uint lock_count() { return locks_in_memory; }

  TABLE* get_local_table(THD* client_thd);
  bool handle_inserts(void);
};


I_List<delayed_insert> delayed_threads;


delayed_insert *find_handler(THD *thd, TABLE_LIST *table_list)
{
  thd->proc_info="waiting for delay_list";
  pthread_mutex_lock(&LOCK_delayed_insert);	// Protect master list
  I_List_iterator<delayed_insert> it(delayed_threads);
  delayed_insert *tmp;
  while ((tmp=it++))
  {
    if (!strcmp(tmp->thd.db,table_list->db) &&
	!strcmp(table_list->real_name,tmp->table->real_name))
    {
      tmp->lock();
      break;
    }
  }
  pthread_mutex_unlock(&LOCK_delayed_insert); // For unlink from list
  return tmp;
}


static TABLE *delayed_get_table(THD *thd,TABLE_LIST *table_list)
{
  int error;
  delayed_insert *tmp;
  DBUG_ENTER("delayed_get_table");

  if (!table_list->db)
    table_list->db=thd->db;

  /* no match; create a new thread to handle the table */
  if (!(tmp=find_handler(thd,table_list)))
  {
752 753 754
    /* Don't create more than max_insert_delayed_threads */
    if (delayed_insert_threads >= max_insert_delayed_threads)
      DBUG_RETURN(0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
755 756 757 758 759 760
    thd->proc_info="Creating delayed handler";
    pthread_mutex_lock(&LOCK_delayed_create);
    if (!(tmp=find_handler(thd,table_list)))	// Was just created
    {
      if (!(tmp=new delayed_insert()))
      {
761
	thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
762 763 764 765
	my_error(ER_OUTOFMEMORY,MYF(0),sizeof(delayed_insert));
	pthread_mutex_unlock(&LOCK_delayed_create);
	DBUG_RETURN(0);
      }
766 767 768
      pthread_mutex_lock(&LOCK_thread_count);
      thread_count++;
      pthread_mutex_unlock(&LOCK_thread_count);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
769
      if (!(tmp->thd.db=my_strdup(table_list->db,MYF(MY_WME))) ||
770
	  !(tmp->thd.query=my_strdup(table_list->real_name,MYF(MY_WME))))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
771 772
      {
	delete tmp;
773
	thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
774 775 776 777
	my_error(ER_OUT_OF_RESOURCES,MYF(0));
	pthread_mutex_unlock(&LOCK_delayed_create);
	DBUG_RETURN(0);
      }
778 779
      tmp->table_list= *table_list;			// Needed to open table
      tmp->table_list.db= tmp->thd.db;
780
      tmp->table_list.alias= tmp->table_list.real_name=tmp->thd.query;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
781 782 783 784 785 786 787 788 789 790 791
      tmp->lock();
      pthread_mutex_lock(&tmp->mutex);
      if ((error=pthread_create(&tmp->thd.real_id,&connection_attrib,
				handle_delayed_insert,(void*) tmp)))
      {
	DBUG_PRINT("error",
		   ("Can't create thread to handle delayed insert (error %d)",
		    error));
	pthread_mutex_unlock(&tmp->mutex);
	tmp->unlock();
	delete tmp;
792
	thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
793
	pthread_mutex_unlock(&LOCK_delayed_create);
794
	net_printf(thd,ER_CANT_CREATE_THREAD,error);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
795 796 797 798 799 800 801 802 803 804 805 806 807
	DBUG_RETURN(0);
      }

      /* Wait until table is open */
      thd->proc_info="waiting for handler open";
      while (!tmp->thd.killed && !tmp->table && !thd->killed)
      {
	pthread_cond_wait(&tmp->cond_client,&tmp->mutex);
      }
      pthread_mutex_unlock(&tmp->mutex);
      thd->proc_info="got old table";
      if (tmp->thd.killed)
      {
808
	if (tmp->thd.is_fatal_error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
809 810
	{
	  /* Copy error message and abort */
811
	  thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
812
	  strmov(thd->net.last_error,tmp->thd.net.last_error);
813
	  thd->net.last_errno=tmp->thd.net.last_errno;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834
	}
	tmp->unlock();
	pthread_mutex_unlock(&LOCK_delayed_create);
	DBUG_RETURN(0);				// Continue with normal insert
      }
      if (thd->killed)
      {
	tmp->unlock();
	pthread_mutex_unlock(&LOCK_delayed_create);
	DBUG_RETURN(0);
      }
    }
    pthread_mutex_unlock(&LOCK_delayed_create);
  }

  pthread_mutex_lock(&tmp->mutex);
  TABLE *table=tmp->get_local_table(thd);
  pthread_mutex_unlock(&tmp->mutex);
  tmp->unlock();
  if (table)
    thd->di=tmp;
835 836
  else if (tmp->thd.is_fatal_error)
    thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
837 838 839 840 841 842 843 844 845 846 847 848 849 850
  DBUG_RETURN((table_list->table=table));
}


/*
  As we can't let many threads modify the same TABLE structure, we create
  an own structure for each tread.  This includes a row buffer to save the
  column values and new fields that points to the new row buffer.
  The memory is allocated in the client thread and is freed automaticly.
*/

TABLE *delayed_insert::get_local_table(THD* client_thd)
{
  my_ptrdiff_t adjust_ptrs;
851
  Field **field,**org_field, *found_next_number_field;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876
  TABLE *copy;

  /* First request insert thread to get a lock */
  status=1;
  tables_in_use++;
  if (!thd.lock)				// Table is not locked
  {
    client_thd->proc_info="waiting for handler lock";
    pthread_cond_signal(&cond);			// Tell handler to lock table
    while (!dead && !thd.lock && ! client_thd->killed)
    {
      pthread_cond_wait(&cond_client,&mutex);
    }
    client_thd->proc_info="got handler lock";
    if (client_thd->killed)
      goto error;
    if (dead)
    {
      strmov(client_thd->net.last_error,thd.net.last_error);
      client_thd->net.last_errno=thd.net.last_errno;
      goto error;
    }
  }

  client_thd->proc_info="allocating local table";
877 878 879
  copy= (TABLE*) client_thd->alloc(sizeof(*copy)+
				   (table->fields+1)*sizeof(Field**)+
				   table->reclength);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
880 881 882 883 884 885 886 887 888 889 890 891 892 893
  if (!copy)
    goto error;
  *copy= *table;
  bzero((char*) &copy->name_hash,sizeof(copy->name_hash)); // No name hashing
  /* We don't need to change the file handler here */

  field=copy->field=(Field**) (copy+1);
  copy->record[0]=(byte*) (field+table->fields+1);
  memcpy((char*) copy->record[0],(char*) table->record[0],table->reclength);

  /* Make a copy of all fields */

  adjust_ptrs=PTR_BYTE_DIFF(copy->record[0],table->record[0]);

894
  found_next_number_field=table->found_next_number_field;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
895 896
  for (org_field=table->field ; *org_field ; org_field++,field++)
  {
897
    if (!(*field= (*org_field)->new_field(&client_thd->mem_root,copy)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
898 899
      return 0;
    (*field)->move_field(adjust_ptrs);		// Point at copy->record[0]
900 901
    if (*org_field == found_next_number_field)
      (*field)->table->found_next_number_field= *field;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929
  }
  *field=0;

  /* Adjust timestamp */
  if (table->timestamp_field)
  {
    /* Restore offset as this may have been reset in handle_inserts */
    copy->time_stamp=table->timestamp_field->offset()+1;
    copy->timestamp_field=
      (Field_timestamp*) copy->field[table->timestamp_field_offset];
  }

  /* _rowid is not used with delayed insert */
  copy->rowid_field=0;
  return copy;

  /* Got fatal error */
 error:
  tables_in_use--;
  status=1;
  pthread_cond_signal(&cond);			// Inform thread about abort
  return 0;
}


/* Put a question in queue */

static int write_delayed(THD *thd,TABLE *table,enum_duplicates duplic,
930
			 char *query, uint query_length, int log_on)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 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 983
{
  delayed_row *row=0;
  delayed_insert *di=thd->di;
  DBUG_ENTER("write_delayed");

  thd->proc_info="waiting for handler insert";
  pthread_mutex_lock(&di->mutex);
  while (di->stacked_inserts >= delayed_queue_size && !thd->killed)
    pthread_cond_wait(&di->cond_client,&di->mutex);
  thd->proc_info="storing row into queue";

  if (thd->killed || !(row= new delayed_row(duplic, log_on)))
    goto err;

  if (!query)
    query_length=0;
  if (!(row->record= (char*) my_malloc(table->reclength+query_length+1,
				       MYF(MY_WME))))
    goto err;
  memcpy(row->record,table->record[0],table->reclength);
  if (query_length)
  {
    row->query=row->record+table->reclength;
    memcpy(row->query,query,query_length+1);
  }
  row->query_length=		query_length;
  row->start_time=		thd->start_time;
  row->query_start_used=	thd->query_start_used;
  row->last_insert_id_used=	thd->last_insert_id_used;
  row->insert_id_used=		thd->insert_id_used;
  row->last_insert_id=		thd->last_insert_id;
  row->time_stamp=		table->time_stamp;

  di->rows.push_back(row);
  di->stacked_inserts++;
  di->status=1;
  if (table->blob_fields)
    unlink_blobs(table);
  pthread_cond_signal(&di->cond);

  thread_safe_increment(delayed_rows_in_use,&LOCK_delayed_status);
  pthread_mutex_unlock(&di->mutex);
  DBUG_RETURN(0);

 err:
  delete row;
  pthread_mutex_unlock(&di->mutex);
  DBUG_RETURN(1);
}


static void end_delayed_insert(THD *thd)
{
984
  DBUG_ENTER("end_delayed_insert");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
985 986
  delayed_insert *di=thd->di;
  pthread_mutex_lock(&di->mutex);
987
  DBUG_PRINT("info",("tables in use: %d",di->tables_in_use));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
988 989 990 991 992 993
  if (!--di->tables_in_use || di->thd.killed)
  {						// Unlock table
    di->status=1;
    pthread_cond_signal(&di->cond);
  }
  pthread_mutex_unlock(&di->mutex);
994
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007
}


/* We kill all delayed threads when doing flush-tables */

void kill_delayed_threads(void)
{
  VOID(pthread_mutex_lock(&LOCK_delayed_insert)); // For unlink from list

  I_List_iterator<delayed_insert> it(delayed_threads);
  delayed_insert *tmp;
  while ((tmp=it++))
  {
1008
    /* Ensure that the thread doesn't kill itself while we are looking at it */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1009 1010 1011 1012 1013
    pthread_mutex_lock(&tmp->mutex);
    tmp->thd.killed=1;
    if (tmp->thd.mysys_var)
    {
      pthread_mutex_lock(&tmp->thd.mysys_var->mutex);
1014
      if (tmp->thd.mysys_var->current_cond)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1015
      {
1016 1017 1018 1019 1020 1021
	/*
	  We need the following test because the main mutex may be locked
	  in handle_delayed_insert()
	*/
	if (&tmp->mutex != tmp->thd.mysys_var->current_mutex)
	  pthread_mutex_lock(tmp->thd.mysys_var->current_mutex);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1022
	pthread_cond_broadcast(tmp->thd.mysys_var->current_cond);
1023 1024
	if (&tmp->mutex != tmp->thd.mysys_var->current_mutex)
	  pthread_mutex_unlock(tmp->thd.mysys_var->current_mutex);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037
      }
      pthread_mutex_unlock(&tmp->thd.mysys_var->mutex);
    }
    pthread_mutex_unlock(&tmp->mutex);
  }
  VOID(pthread_mutex_unlock(&LOCK_delayed_insert)); // For unlink from list
}


/*
 * Create a new delayed insert thread
*/

1038
extern "C" pthread_handler_decl(handle_delayed_insert,arg)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1039 1040 1041 1042 1043 1044 1045 1046
{
  delayed_insert *di=(delayed_insert*) arg;
  THD *thd= &di->thd;

  pthread_detach_this_thread();
  /* Add thread to THD list so that's it's visible in 'show processlist' */
  pthread_mutex_lock(&LOCK_thread_count);
  thd->thread_id=thread_id++;
1047
  thd->end_time();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1048
  threads.append(thd);
1049
  thd->killed=abort_loop;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1050 1051 1052
  pthread_mutex_unlock(&LOCK_thread_count);

  pthread_mutex_lock(&di->mutex);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1053
#if !defined( __WIN__) && !defined(OS2)	/* Win32 calls this in pthread_create */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1054 1055 1056 1057 1058 1059 1060 1061
  if (my_thread_init())
  {
    strmov(thd->net.last_error,ER(thd->net.last_errno=ER_OUT_OF_RESOURCES));
    goto end;
  }
#endif

  DBUG_ENTER("handle_delayed_insert");
1062
  if (init_thr_lock() || thd->store_globals())
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1063
  {
1064
    thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1065 1066 1067
    strmov(thd->net.last_error,ER(thd->net.last_errno=ER_OUT_OF_RESOURCES));
    goto end;
  }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1068
#if !defined(__WIN__) && !defined(OS2) && !defined(__NETWARE__)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1069 1070 1071 1072 1073 1074 1075
  sigset_t set;
  VOID(sigemptyset(&set));			// Get mask in use
  VOID(pthread_sigmask(SIG_UNBLOCK,&set,&thd->block_signals));
#endif

  /* open table */

1076
  if (!(di->table=open_ltable(thd,&di->table_list,TL_WRITE_DELAYED)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1077
  {
1078
    thd->fatal_error();				// Abort waiting inserts
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1079 1080
    goto end;
  }
1081 1082
  if (di->table->file->has_transactions())
  {
1083
    thd->fatal_error();
1084
    my_error(ER_ILLEGAL_HA, MYF(0), di->table_list.real_name);
1085 1086
    goto end;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121
  di->table->copy_blobs=1;

  /* One can now use this */
  pthread_mutex_lock(&LOCK_delayed_insert);
  delayed_threads.append(di);
  pthread_mutex_unlock(&LOCK_delayed_insert);

  /* Tell client that the thread is initialized */
  pthread_cond_signal(&di->cond_client);

  /* Now wait until we get an insert or lock to handle */
  /* We will not abort as long as a client thread uses this thread */

  for (;;)
  {
    if (thd->killed)
    {
      uint lock_count;
      /*
	Remove this from delay insert list so that no one can request a
	table from this
      */
      pthread_mutex_unlock(&di->mutex);
      pthread_mutex_lock(&LOCK_delayed_insert);
      di->unlink();
      lock_count=di->lock_count();
      pthread_mutex_unlock(&LOCK_delayed_insert);
      pthread_mutex_lock(&di->mutex);
      if (!lock_count && !di->tables_in_use && !di->stacked_inserts)
	break;					// Time to die
    }

    if (!di->status && !di->stacked_inserts)
    {
      struct timespec abstime;
1122
      set_timespec(abstime, delayed_insert_timeout);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1123 1124 1125 1126

      /* Information for pthread_kill */
      di->thd.mysys_var->current_mutex= &di->mutex;
      di->thd.mysys_var->current_cond= &di->cond;
1127
      di->thd.proc_info="Waiting for INSERT";
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1128

1129
      DBUG_PRINT("info",("Waiting for someone to insert rows"));
1130
      while (!thd->killed)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1131 1132
      {
	int error;
1133
#if defined(HAVE_BROKEN_COND_TIMEDWAIT)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1134 1135 1136 1137
	error=pthread_cond_wait(&di->cond,&di->mutex);
#else
	error=pthread_cond_timedwait(&di->cond,&di->mutex,&abstime);
#ifdef EXTRA_DEBUG
1138
	if (error && error != EINTR && error != ETIMEDOUT)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153
	{
	  fprintf(stderr, "Got error %d from pthread_cond_timedwait\n",error);
	  DBUG_PRINT("error",("Got error %d from pthread_cond_timedwait",
			      error));
	}
#endif
#endif
	if (thd->killed || di->status)
	  break;
	if (error == ETIME || error == ETIMEDOUT)
	{
	  thd->killed=1;
	  break;
	}
      }
1154 1155
      /* We can't lock di->mutex and mysys_var->mutex at the same time */
      pthread_mutex_unlock(&di->mutex);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1156 1157 1158 1159
      pthread_mutex_lock(&di->thd.mysys_var->mutex);
      di->thd.mysys_var->current_mutex= 0;
      di->thd.mysys_var->current_cond= 0;
      pthread_mutex_unlock(&di->thd.mysys_var->mutex);
1160
      pthread_mutex_lock(&di->mutex);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1161
    }
1162
    di->thd.proc_info=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251

    if (di->tables_in_use && ! thd->lock)
    {
      /* request for new delayed insert */
      if (!(thd->lock=mysql_lock_tables(thd,&di->table,1)))
      {
	di->dead=thd->killed=1;			// Fatal error
      }
      pthread_cond_broadcast(&di->cond_client);
    }
    if (di->stacked_inserts)
    {
      if (di->handle_inserts())
      {
	di->dead=thd->killed=1;			// Some fatal error
      }
    }
    di->status=0;
    if (!di->stacked_inserts && !di->tables_in_use && thd->lock)
    {
      /* No one is doing a insert delayed;
	 Unlock it so that other threads can use it */
      MYSQL_LOCK *lock=thd->lock;
      thd->lock=0;
      pthread_mutex_unlock(&di->mutex);
      mysql_unlock_tables(thd, lock);
      di->group_count=0;
      pthread_mutex_lock(&di->mutex);
    }
    if (di->tables_in_use)
      pthread_cond_broadcast(&di->cond_client); // If waiting clients
  }

end:
  /*
    di should be unlinked from the thread handler list and have no active
    clients
  */

  close_thread_tables(thd);			// Free the table
  di->table=0;
  di->dead=thd->killed=1;			// If error
  pthread_cond_broadcast(&di->cond_client);	// Safety
  pthread_mutex_unlock(&di->mutex);

  pthread_mutex_lock(&LOCK_delayed_create);	// Because of delayed_get_table
  pthread_mutex_lock(&LOCK_delayed_insert);	
  delete di;
  pthread_mutex_unlock(&LOCK_delayed_insert);
  pthread_mutex_unlock(&LOCK_delayed_create);  

  my_thread_end();
  pthread_exit(0);
  DBUG_RETURN(0);
}


/* Remove pointers from temporary fields to allocated values */

static void unlink_blobs(register TABLE *table)
{
  for (Field **ptr=table->field ; *ptr ; ptr++)
  {
    if ((*ptr)->flags & BLOB_FLAG)
      ((Field_blob *) (*ptr))->clear_temporary();
  }
}

/* Free blobs stored in current row */

static void free_delayed_insert_blobs(register TABLE *table)
{
  for (Field **ptr=table->field ; *ptr ; ptr++)
  {
    if ((*ptr)->flags & BLOB_FLAG)
    {
      char *str;
      ((Field_blob *) (*ptr))->get_ptr(&str);
      my_free(str,MYF(MY_ALLOW_ZERO_PTR));
      ((Field_blob *) (*ptr))->reset();
    }
  }
}


bool delayed_insert::handle_inserts(void)
{
  int error;
  uint max_rows;
1252
  bool using_ignore=0, using_bin_log=mysql_bin_log.is_open();
1253
  delayed_row *row;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276
  DBUG_ENTER("handle_inserts");

  /* Allow client to insert new rows */
  pthread_mutex_unlock(&mutex);

  table->next_number_field=table->found_next_number_field;

  thd.proc_info="upgrading lock";
  if (thr_upgrade_write_delay_lock(*thd.lock->locks))
  {
    /* This can only happen if thread is killed by shutdown */
    sql_print_error(ER(ER_DELAYED_CANT_CHANGE_LOCK),table->real_name);
    goto err;
  }

  thd.proc_info="insert";
  max_rows=delayed_insert_limit;
  if (thd.killed || table->version != refresh_version)
  {
    thd.killed=1;
    max_rows= ~0;				// Do as much as possible
  }

1277 1278 1279 1280 1281 1282 1283
  /*
    We can't use row caching when using the binary log because if
    we get a crash, then binary log will contain rows that are not yet
    written to disk, which will cause problems in replication.
  */
  if (!using_bin_log)
    table->file->extra(HA_EXTRA_WRITE_CACHE);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298
  pthread_mutex_lock(&mutex);
  while ((row=rows.get()))
  {
    stacked_inserts--;
    pthread_mutex_unlock(&mutex);
    memcpy(table->record[0],row->record,table->reclength);

    thd.start_time=row->start_time;
    thd.query_start_used=row->query_start_used;
    thd.last_insert_id=row->last_insert_id;
    thd.last_insert_id_used=row->last_insert_id_used;
    thd.insert_id_used=row->insert_id_used;
    table->time_stamp=row->time_stamp;

    info.handle_duplicates= row->dup;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1299 1300 1301 1302 1303 1304
    if (info.handle_duplicates == DUP_IGNORE ||
	info.handle_duplicates == DUP_REPLACE)
    {
      table->file->extra(HA_EXTRA_IGNORE_DUP_KEY);
      using_ignore=1;
    }
1305
    thd.clear_error(); // reset error for binlog
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1306 1307
    if (write_record(table,&info))
    {
1308
      info.error_count++;				// Ignore errors
1309
      thread_safe_increment(delayed_insert_errors,&LOCK_delayed_status);
sasha@laptop.slkc.uswest.net's avatar
sasha@laptop.slkc.uswest.net committed
1310
      row->log_query = 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1311
    }
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1312 1313 1314 1315 1316
    if (using_ignore)
    {
      using_ignore=0;
      table->file->extra(HA_EXTRA_NO_IGNORE_DUP_KEY);
    }
1317
    if (row->query)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1318
    {
1319 1320 1321
      if (row->log_query & DELAYED_LOG_UPDATE)
        mysql_update_log.write(&thd,row->query, row->query_length);
      if (row->log_query & DELAYED_LOG_BIN && using_bin_log)
1322
      {
1323 1324
        Query_log_event qinfo(&thd, row->query, row->query_length,0);
        mysql_bin_log.write(&qinfo);
1325
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350
    }
    if (table->blob_fields)
      free_delayed_insert_blobs(table);
    thread_safe_sub(delayed_rows_in_use,1,&LOCK_delayed_status);
    thread_safe_increment(delayed_insert_writes,&LOCK_delayed_status);
    pthread_mutex_lock(&mutex);

    delete row;
    /* Let READ clients do something once in a while */
    if (group_count++ == max_rows)
    {
      group_count=0;
      if (stacked_inserts || tables_in_use)	// Let these wait a while
      {
	if (tables_in_use)
	  pthread_cond_broadcast(&cond_client); // If waiting clients
	thd.proc_info="reschedule";
	pthread_mutex_unlock(&mutex);
	if ((error=table->file->extra(HA_EXTRA_NO_CACHE)))
	{
	  /* This should never happen */
	  table->file->print_error(error,MYF(0));
	  sql_print_error("%s",thd.net.last_error);
	  goto err;
	}
1351
	query_cache_invalidate3(&thd, table, 1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1352 1353 1354 1355 1356
	if (thr_reschedule_write_lock(*thd.lock->locks))
	{
	  /* This should never happen */
	  sql_print_error(ER(ER_DELAYED_CANT_CHANGE_LOCK),table->real_name);
	}
1357 1358
	if (!using_bin_log)
	  table->file->extra(HA_EXTRA_WRITE_CACHE);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375
	pthread_mutex_lock(&mutex);
	thd.proc_info="insert";
      }
      if (tables_in_use)
	pthread_cond_broadcast(&cond_client);	// If waiting clients
    }
  }

  thd.proc_info=0;
  table->next_number_field=0;
  pthread_mutex_unlock(&mutex);
  if ((error=table->file->extra(HA_EXTRA_NO_CACHE)))
  {						// This shouldn't happen
    table->file->print_error(error,MYF(0));
    sql_print_error("%s",thd.net.last_error);
    goto err;
  }
1376
  query_cache_invalidate3(&thd, table, 1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1377 1378 1379 1380
  pthread_mutex_lock(&mutex);
  DBUG_RETURN(0);

 err:
1381 1382 1383 1384 1385 1386 1387
  /* Remove all not used rows */
  while ((row=rows.get()))
  {
    delete row;
    thread_safe_increment(delayed_insert_errors,&LOCK_delayed_status);
    stacked_inserts--;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1388 1389 1390 1391 1392 1393 1394 1395
  thread_safe_increment(delayed_insert_errors, &LOCK_delayed_status);
  pthread_mutex_lock(&mutex);
  DBUG_RETURN(1);
}



/***************************************************************************
1396
  Store records in INSERT ... SELECT *
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1397 1398 1399
***************************************************************************/

int
1400
select_insert::prepare(List<Item> &values, SELECT_LEX_UNIT *u)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1401 1402 1403
{
  DBUG_ENTER("select_insert::prepare");

1404
  unit= u;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1405 1406 1407
  if (check_insert_fields(thd,table,*fields,values,1))
    DBUG_RETURN(1);

1408
  restore_record(table,default_values);			// Get empty record
1409
  table->next_number_field=table->found_next_number_field;
1410
  thd->count_cuted_fields= CHECK_FIELD_WARN;		// calc cuted fields
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1411
  thd->cuted_fields=0;
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
1412 1413 1414 1415 1416 1417
  if (info.handle_duplicates != DUP_REPLACE)
    table->file->extra(HA_EXTRA_WRITE_CACHE);
  if (info.handle_duplicates == DUP_IGNORE ||
      info.handle_duplicates == DUP_REPLACE)
    table->file->extra(HA_EXTRA_IGNORE_DUP_KEY);
  table->file->deactivate_non_unique_index((ha_rows) 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1418 1419 1420 1421 1422 1423 1424 1425
  DBUG_RETURN(0);
}

select_insert::~select_insert()
{
  if (table)
  {
    table->next_number_field=0;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1426
    table->file->extra(HA_EXTRA_RESET);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1427
  }
1428
  thd->count_cuted_fields= CHECK_FIELD_IGNORE;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1429 1430 1431 1432 1433
}


bool select_insert::send_data(List<Item> &values)
{
1434
  if (unit->offset_limit_cnt)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1435
  {						// using limit offset,count
1436
    unit->offset_limit_cnt--;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1437 1438 1439
    return 0;
  }
  if (fields->elements)
1440
    fill_record(*fields, values, 1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1441
  else
1442
    fill_record(table->field, values, 1);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
1443
  if (thd->net.report_error || write_record(table,&info))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456
    return 1;
  if (table->next_number_field)		// Clear for next record
  {
    table->next_number_field->reset();
    if (! last_insert_id && thd->insert_id_used)
      last_insert_id=thd->insert_id();
  }
  return 0;
}


void select_insert::send_error(uint errcode,const char *err)
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1457 1458
  DBUG_ENTER("select_insert::send_error");

1459
  /* TODO error should be sent at the query processing end */
1460
  ::send_error(thd,errcode,err);
1461 1462 1463 1464 1465 1466 1467 1468 1469

  if (!table)
  {
    /*
      This can only happen when using CREATE ... SELECT and the table was not
      created becasue of an syntax error
    */
    DBUG_VOID_RETURN;
  }
1470 1471
  table->file->extra(HA_EXTRA_NO_CACHE);
  table->file->activate_all_index(thd);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1472 1473 1474 1475 1476
  /*
    If at least one row has been inserted/modified and will stay in the table
    (the table doesn't have transactions) (example: we got a duplicate key
    error while inserting into a MyISAM table) we must write to the binlog (and
    the error code will make the slave stop).
1477
  */
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
1478 1479
  if ((info.copied || info.deleted || info.updated) && 
      !table->file->has_transactions())
1480 1481 1482 1483 1484 1485 1486 1487 1488 1489
  {
    if (last_insert_id)
      thd->insert_id(last_insert_id);		// For binary log
    mysql_update_log.write(thd,thd->query,thd->query_length);
    if (mysql_bin_log.is_open())
    {
      Query_log_event qinfo(thd, thd->query, thd->query_length,
                            table->file->has_transactions());
      mysql_bin_log.write(&qinfo);
    }
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1490 1491
    if (!table->tmp_table)
      thd->options|=OPTION_STATUS_NO_TRANS_UPDATE;    
1492
  }
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
1493
  if (info.copied || info.deleted || info.updated)
1494
    query_cache_invalidate3(thd, table, 1);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1495
  ha_rollback_stmt(thd);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1496
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1497 1498 1499 1500 1501
}


bool select_insert::send_eof()
{
1502
  int error,error2;
1503 1504
  DBUG_ENTER("select_insert::send_eof");

1505 1506
  if (!(error=table->file->extra(HA_EXTRA_NO_CACHE)))
    error=table->file->activate_all_index(thd);
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1507
  table->file->extra(HA_EXTRA_NO_IGNORE_DUP_KEY);
1508

1509 1510 1511 1512
  /*
    We must invalidate the table in the query cache before binlog writing
    and ha_autocommit_...
  */
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1513

vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
1514
  if (info.copied || info.deleted || info.updated)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1515
  {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1516
    query_cache_invalidate3(thd, table, 1);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1517 1518 1519
    if (!(table->file->has_transactions() || table->tmp_table))
      thd->options|=OPTION_STATUS_NO_TRANS_UPDATE;
  }
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1520

1521 1522
  if (last_insert_id)
    thd->insert_id(last_insert_id);		// For binary log
1523
  /* Write to binlog before commiting transaction */
1524
  mysql_update_log.write(thd,thd->query,thd->query_length);
1525 1526
  if (mysql_bin_log.is_open())
  {
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1527 1528
    if (!error)
      thd->clear_error();
1529 1530 1531 1532
    Query_log_event qinfo(thd, thd->query, thd->query_length,
			  table->file->has_transactions());
    mysql_bin_log.write(&qinfo);
  }
1533 1534 1535
  if ((error2=ha_autocommit_or_rollback(thd,error)) && ! error)
    error=error2;
  if (error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1536 1537
  {
    table->file->print_error(error,MYF(0));
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
1538
    //TODO error should be sent at the query processing end
1539
    ::send_error(thd);
1540
    DBUG_RETURN(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1541
  }
1542 1543 1544 1545
  char buff[160];
  if (info.handle_duplicates == DUP_IGNORE)
    sprintf(buff, ER(ER_INSERT_INFO), (ulong) info.records,
	    (ulong) (info.records - info.copied), (ulong) thd->cuted_fields);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1546
  else
1547
    sprintf(buff, ER(ER_INSERT_INFO), (ulong) info.records,
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
1548 1549
	    (ulong) info.deleted+info.updated, (ulong) thd->cuted_fields);
  ::send_ok(thd,info.copied+info.deleted+info.updated,last_insert_id,buff);
1550
  DBUG_RETURN(0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1551 1552 1553 1554
}


/***************************************************************************
1555
  CREATE TABLE (SELECT) ...
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1556 1557 1558
***************************************************************************/

int
1559
select_create::prepare(List<Item> &values, SELECT_LEX_UNIT *u)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1560 1561 1562
{
  DBUG_ENTER("select_create::prepare");

1563
  unit= u;
1564 1565
  table= create_table_from_items(thd, create_info, db, name,
				 extra_fields, keys, &values, &lock);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1566 1567 1568
  if (!table)
    DBUG_RETURN(-1);				// abort() deletes table

1569 1570 1571 1572 1573 1574 1575 1576
  if (table->fields < values.elements)
  {
    my_printf_error(ER_WRONG_VALUE_COUNT_ON_ROW,
                    ER(ER_WRONG_VALUE_COUNT_ON_ROW),
		    MYF(0),1);
    DBUG_RETURN(-1);
  }

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1577 1578 1579 1580 1581 1582 1583 1584 1585 1586
  /* First field to copy */
  field=table->field+table->fields - values.elements;

  if (table->timestamp_field)			// Don't set timestamp if used
  {
    table->timestamp_field->set_time();
    table->time_stamp=0;			// This should be saved
  }
  table->next_number_field=table->found_next_number_field;

1587
  restore_record(table,default_values);			// Get empty record
1588
  thd->count_cuted_fields= CHECK_FIELD_WARN;		// count warnings
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1589
  thd->cuted_fields=0;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1590 1591 1592
  if (info.handle_duplicates == DUP_IGNORE ||
      info.handle_duplicates == DUP_REPLACE)
    table->file->extra(HA_EXTRA_IGNORE_DUP_KEY);
1593
  table->file->deactivate_non_unique_index((ha_rows) 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1594 1595 1596 1597 1598 1599
  DBUG_RETURN(0);
}


bool select_create::send_data(List<Item> &values)
{
1600
  if (unit->offset_limit_cnt)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1601
  {						// using limit offset,count
1602
    unit->offset_limit_cnt--;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1603 1604
    return 0;
  }
1605
  fill_record(field, values, 1);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
1606
  if (thd->net.report_error ||write_record(table,&info))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1607 1608 1609 1610 1611 1612 1613 1614 1615 1616
    return 1;
  if (table->next_number_field)		// Clear for next record
  {
    table->next_number_field->reset();
    if (! last_insert_id && thd->insert_id_used)
      last_insert_id=thd->insert_id();
  }
  return 0;
}

monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
1617

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1618 1619 1620 1621 1622 1623 1624
bool select_create::send_eof()
{
  bool tmp=select_insert::send_eof();
  if (tmp)
    abort();
  else
  {
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1625
    table->file->extra(HA_EXTRA_NO_IGNORE_DUP_KEY);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1626 1627
    VOID(pthread_mutex_lock(&LOCK_open));
    mysql_unlock_tables(thd, lock);
1628 1629 1630 1631 1632
    /*
      TODO:
      Check if we can remove the following two rows.
      We should be able to just keep the table in the table cache.
    */
1633 1634
    if (!table->tmp_table)
      hash_delete(&open_cache,(byte*) table);
1635
    lock=0;
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
1636
    table=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651
    VOID(pthread_mutex_unlock(&LOCK_open));
  }
  return tmp;
}

void select_create::abort()
{
  VOID(pthread_mutex_lock(&LOCK_open));
  if (lock)
  {
    mysql_unlock_tables(thd, lock);
    lock=0;
  }
  if (table)
  {
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1652
    table->file->extra(HA_EXTRA_NO_IGNORE_DUP_KEY);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1653
    enum db_type table_type=table->db_type;
1654 1655
    if (!table->tmp_table)
      hash_delete(&open_cache,(byte*) table);
1656
    if (!create_info->table_existed)
1657
      quick_rm_table(table_type,db,name);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1658 1659 1660 1661 1662 1663 1664
    table=0;
  }
  VOID(pthread_mutex_unlock(&LOCK_open));
}


/*****************************************************************************
1665
  Instansiate templates
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1666 1667 1668
*****************************************************************************/

#ifdef __GNUC__
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
1669
template class List_iterator_fast<List_item>;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1670 1671 1672 1673
template class I_List<delayed_insert>;
template class I_List_iterator<delayed_insert>;
template class I_List<delayed_row>;
#endif