sql_insert.cc 44.6 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 63 64 65
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;
    }
    if (grant_option &&
	check_grant_all_columns(thd,INSERT_ACL,table))
      return -1;
66
    table->time_stamp=0;			// This is saved by caller
bk@work.mysql.com's avatar
bk@work.mysql.com committed
67 68 69 70 71 72 73 74 75 76 77 78
  }
  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));
79
    table_list.db=  table->table_cache_key;
80
    table_list.real_name= table_list.alias= table->table_name;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
81 82 83 84
    table_list.table=table;
    table_list.grant=table->grant;

    thd->dupp_field=0;
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
85
    if (setup_tables(&table_list) ||
86
	setup_fields(thd, 0, &table_list,fields,1,0,0))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
87 88 89 90 91 92
      return -1;
    if (thd->dupp_field)
    {
      my_error(ER_FIELD_SPECIFIED_TWICE,MYF(0), thd->dupp_field->field_name);
      return -1;
    }
93
    table->time_stamp=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
94
    if (table->timestamp_field &&	// Don't set timestamp if used
95 96
	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
97
  }
98
  // For the values we need select_priv
bk@work.mysql.com's avatar
bk@work.mysql.com committed
99 100 101 102 103
  table->grant.want_privilege=(SELECT_ACL & ~table->grant.privilege);
  return 0;
}


104 105 106 107 108 109
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
110 111
{
  int error;
112 113 114 115 116 117 118
  /*
    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 ;

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

133 134 135
  if (thd->master_access & SUPER_ACL)
  {
    if (!(thd->options & OPTION_UPDATE_LOG))
136
      log_on&= ~(int) DELAYED_LOG_UPDATE;
137
    if (!(thd->options & OPTION_BIN_LOG))
138
      log_on&= ~(int) DELAYED_LOG_BIN;
139 140
  }

141 142 143 144 145
  /*
    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
   */
146 147
  if ((lock_type == TL_WRITE_DELAYED &&
       ((specialflag & (SPECIAL_NO_NEW_FUNC | SPECIAL_SAFE_MODE)) ||
148
	thd->slave_thread || !max_insert_delayed_threads)) ||
149 150
      (lock_type == TL_WRITE_CONCURRENT_INSERT && duplic == DUP_REPLACE) ||
      (duplic == DUP_UPDATE))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
151
    lock_type=TL_WRITE;
152
  table_list->lock_type= lock_type;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
153

154
  int res;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
155 156 157 158 159 160 161 162 163 164 165 166 167 168
  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);
      }
    }
169
    if ((table= delayed_get_table(thd,table_list)) && !thd->is_fatal_error)
170 171 172 173 174 175
      if (table_list->next && table)
	res= open_and_lock_tables(thd, table_list->next);
      else
	res= (table == 0);
    else
      res= open_and_lock_tables(thd, table_list);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
176 177
  }
  else
178 179
    res= open_and_lock_tables(thd, table_list);
  if (res)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
180
    DBUG_RETURN(-1);
181
  fix_tables_pointers(thd->lex.all_selects_list);
182 183

  table= table_list->table;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
184
  thd->proc_info="init";
185
  thd->used_tables=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
186
  values= its++;
187 188 189 190

  if (duplic == DUP_UPDATE && !table->insert_values)
  {
    /* it should be allocated before Item::fix_fields() */
191
    table->insert_values=(byte *)alloc_root(&table->mem_root, table->rec_buff_length);
192 193 194 195
    if (!table->insert_values)
      goto abort;
  }

bk@work.mysql.com's avatar
bk@work.mysql.com committed
196
  if (check_insert_fields(thd,table,fields,*values,1) ||
197
      setup_tables(insert_table_list) ||
198
      setup_fields(thd, 0, insert_table_list, *values, 0, 0, 0) ||
199
      (duplic == DUP_UPDATE &&
200 201
       (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
202
    goto abort;
203 204 205
  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
206
    my_error(ER_UPDATE_TABLE_USED, MYF(0), table_list->real_name);
207 208 209
    goto abort;
  }

bk@work.mysql.com's avatar
bk@work.mysql.com committed
210
  value_count= values->elements;
211
  while ((values= its++))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
212 213 214 215 216 217 218 219 220
  {
    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;
    }
221
    if (setup_fields(thd, 0, insert_table_list, *values, 0, 0, 0))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
222 223 224 225
      goto abort;
  }
  its.rewind ();
  /*
226
    Fill in the given fields and dump it to the table file
bk@work.mysql.com's avatar
bk@work.mysql.com committed
227 228 229 230
  */

  info.records=info.deleted=info.copied=0;
  info.handle_duplicates=duplic;
231 232
  info.update_fields=&update_fields;
  info.update_values=&update_values;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
233 234 235 236 237 238 239 240 241
  // Don't count warnings for simple inserts
  if (values_list.elements > 1 || (thd->options & OPTION_WARNINGS))
    thd->count_cuted_fields = 1;
  thd->cuted_fields = 0L;
  table->next_number_field=table->found_next_number_field;

  error=0;
  id=0;
  thd->proc_info="update";
242
  if (duplic != DUP_ERROR)
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
243
    table->file->extra(HA_EXTRA_IGNORE_DUP_KEY);
244 245
  if ((lock_type != TL_WRITE_DELAYED && !(specialflag & SPECIAL_SAFE_MODE)) &&
      values_list.elements >= MIN_ROWS_TO_USE_BULK_INSERT)
246
  {
247
    table->file->extra_opt(HA_EXTRA_WRITE_CACHE,
248 249
			   min(thd->variables.read_buff_size,
			       table->avg_row_length*values_list.elements));
250 251
    table->file->deactivate_non_unique_index(values_list.elements);
    bulk_insert=1;
252
  }
253 254
  else
    bulk_insert=0;
255

256
  while ((values= its++))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
257 258 259
  {
    if (fields.elements || !value_count)
    {
260
      restore_record(table,default_values);	// Get empty record
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
261
      if (fill_record(fields, *values, 0)|| thd->net.report_error ||
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
262
	  check_null_fields(thd,table))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
263
      {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
264
	if (values_list.elements != 1 && !thd->net.report_error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
265 266 267 268 269 270 271 272 273 274
	{
	  info.records++;
	  continue;
	}
	error=1;
	break;
      }
    }
    else
    {
275
      if (thd->used_tables)			// Column used in values()
276
	restore_record(table,default_values);	// Get empty record
277
      else
278
	table->record[0][0]=table->default_values[0]; // Fix delete marker
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
279
      if (fill_record(table->field,*values, 0) || thd->net.report_error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
280
      {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
281
	if (values_list.elements != 1 && ! thd->net.report_error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
282 283 284 285 286 287 288 289
	{
	  info.records++;
	  continue;
	}
	error=1;
	break;
      }
    }
290
    if (lock_type == TL_WRITE_DELAYED)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308
    {
      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;
    }
309
    thd->row_count++;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
310 311 312
  }
  if (lock_type == TL_WRITE_DELAYED)
  {
313 314 315 316 317 318
    if (!error)
    {
      id=0;					// No auto_increment id
      info.copied=values_list.elements;
      end_delayed_insert(thd);
    }
319
    query_cache_invalidate3(thd, table_list, 1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
320 321 322
  }
  else
  {
323 324 325 326 327 328 329 330 331 332
    if (bulk_insert)
    {
      if (table->file->extra(HA_EXTRA_NO_CACHE))
      {
	if (!error)
	{
	  table->file->print_error(my_errno,MYF(0));
	  error=1;
	}
      }
333
      if (table->file->activate_all_index(thd))
334 335 336 337 338 339 340 341
      {
	if (!error)
	{
	  table->file->print_error(my_errno,MYF(0));
	  error=1;
	}
      }
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
342 343 344 345
    if (id && values_list.elements != 1)
      thd->insert_id(id);			// For update log
    else if (table->next_number_field)
      id=table->next_number_field->val_int();	// Return auto_increment value
346

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
347 348 349 350 351 352 353 354
    /*
      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_...
    */
    if (info.copied || info.deleted)
      query_cache_invalidate3(thd, table_list, 1);

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

357 358
    log_delayed= (transactional_table || table->tmp_table);
    if ((info.copied || info.deleted) && (error <= 0 || !transactional_table))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
359
    {
360 361 362
      mysql_update_log.write(thd, thd->query, thd->query_length);
      if (mysql_bin_log.is_open())
      {
363
	Query_log_event qinfo(thd, thd->query, thd->query_length,
364 365
			      log_delayed);
	if (mysql_bin_log.write(&qinfo) && transactional_table)
366
	  error=1;
367
      }
368
      if (!log_delayed)
369
	thd->options|=OPTION_STATUS_NO_TRANS_UPDATE;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
370
    }
371
    if (transactional_table)
372
      error=ha_autocommit_or_rollback(thd,error);
373

bk@work.mysql.com's avatar
bk@work.mysql.com committed
374 375 376 377 378 379 380 381 382 383
    if (thd->lock)
    {
      mysql_unlock_tables(thd, thd->lock);
      thd->lock=0;
    }
  }
  thd->proc_info="end";
  table->next_number_field=0;
  thd->count_cuted_fields=0;
  thd->next_insert_id=0;			// Reset this if wrongly used
384
  if (duplic != DUP_ERROR)
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
385
    table->file->extra(HA_EXTRA_NO_IGNORE_DUP_KEY);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
386 387 388 389 390
  if (error)
    goto abort;

  if (values_list.elements == 1 && (!(thd->options & OPTION_WARNINGS) ||
				    !thd->cuted_fields))
391
    send_ok(thd,info.copied+info.deleted,id);
392 393
  else
  {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
394 395
    char buff[160];
    if (duplic == DUP_IGNORE)
396
      sprintf(buff,ER(ER_INSERT_INFO),info.records,
397
	      (lock_type == TL_WRITE_DELAYED) ? 0 :
398
	      info.records-info.copied,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
399 400 401 402
	      thd->cuted_fields);
    else
      sprintf(buff,ER(ER_INSERT_INFO),info.records,info.deleted,
	      thd->cuted_fields);
403
    ::send_ok(thd,info.copied+info.deleted,(ulonglong)id,buff);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
404
  }
405
  free_underlaid_joins(thd, &thd->lex.select_lex);
406
  table->insert_values=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
407 408 409 410 411
  DBUG_RETURN(0);

abort:
  if (lock_type == TL_WRITE_DELAYED)
    end_delayed_insert(thd);
412
  free_underlaid_joins(thd, &thd->lex.select_lex);
413
  table->insert_values=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429
  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;
}


/*
430
  Write a record to table with optional deleting of conflicting records
bk@work.mysql.com's avatar
bk@work.mysql.com committed
431 432 433 434 435 436 437
*/


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

bk@work.mysql.com's avatar
bk@work.mysql.com committed
439
  info->records++;
440 441
  if (info->handle_duplicates == DUP_REPLACE ||
      info->handle_duplicates == DUP_UPDATE)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
442 443 444
  {
    while ((error=table->file->write_row(table->record[0])))
    {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
445
      if (error != HA_WRITE_SKIP)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
446 447 448 449
	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
450
	error=HA_WRITE_SKIP;			/* Database can't find key */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
451 452
	goto err;
      }
453 454 455 456 457
      /*
	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.
      */
458 459 460
      if (info->handle_duplicates == DUP_REPLACE &&
          table->next_number_field &&
          key_nr == table->next_number_index &&
461 462
	  table->file->auto_increment_column_changed)
	goto err;
463
      if (table->file->table_flags() & HA_DUPP_POS)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
464 465 466 467 468 469
      {
	if (table->file->rnd_pos(table->record[1],table->file->dupp_ref))
	  goto err;
      }
      else
      {
470
	if (table->file->extra(HA_EXTRA_FLUSH_CACHE)) /* Not needed with NISAM */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
471 472 473 474
	{
	  error=my_errno;
	  goto err;
	}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
475

bk@work.mysql.com's avatar
bk@work.mysql.com committed
476 477 478 479 480 481 482 483 484 485 486
	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,
487
						(byte*) key,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
488 489
						table->key_info[key_nr].
						key_length,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
490 491 492
						HA_READ_KEY_EXACT))))
	  goto err;
      }
493
      if (info->handle_duplicates == DUP_UPDATE)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
494
      {
495 496 497 498
        /* 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
        */
499 500
        store_record(table,insert_values);
        restore_record(table,record[1]);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
501
        if (fill_record(*info->update_fields, *info->update_values, 0))
502 503 504 505 506 507 508 509 510 511
          goto err;
        if ((error=table->file->update_row(table->record[1],table->record[0])))
          goto err;
        info->deleted++;
        break;
      }
      else /* DUP_REPLACE */
      {
        if (last_uniq_key(table,key_nr))
        {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
512 513
          if ((error=table->file->update_row(table->record[1],
					     table->record[0])))
514 515
            goto err;
          info->deleted++;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
516
          break;				/* Update logfile and count */
517 518 519 520
        }
        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
521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539
      }
    }
    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);
540
  info->last_errno= error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
541 542 543 544 545 546
  table->file->print_error(error,MYF(0));
  return 1;
}


/******************************************************************************
547 548 549
  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
550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571
******************************************************************************/

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

/*****************************************************************************
572 573
  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
574 575 576 577 578 579 580
*****************************************************************************/

class delayed_row :public ilink {
public:
  char *record,*query;
  enum_duplicates dup;
  time_t start_time;
581 582
  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
583 584 585 586
  ulonglong last_insert_id;
  ulong time_stamp;
  uint query_length;

587
  delayed_row(enum_duplicates dup_arg, int log_query_arg)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607
    :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;
608
  TABLE_LIST table_list;			// Argument
bk@work.mysql.com's avatar
bk@work.mysql.com committed
609 610 611 612 613 614

  delayed_insert()
    :locks_in_memory(0),
     table(0),tables_in_use(0),stacked_inserts(0), status(0), dead(0),
     group_count(0)
  {
615 616
    thd.user=thd.priv_user=(char*) delayed_user;
    thd.host=(char*) localhost;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
617 618 619 620 621 622
    thd.current_tablenr=0;
    thd.version=refresh_version;
    thd.command=COM_DELAYED_INSERT;

    bzero((char*) &thd.net,sizeof(thd.net));	// Safety
    thd.system_thread=1;
623
    thd.host_or_ip= "";
bk@work.mysql.com's avatar
bk@work.mysql.com committed
624
    bzero((char*) &info,sizeof(info));
625
    pthread_mutex_init(&mutex,MY_MUTEX_INIT_FAST);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
626 627 628 629 630 631 632 633
    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()
  {
634
    /* The following is not really needed, but just for safety */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
635 636 637 638 639 640
    delayed_row *row;
    while ((row=rows.get()))
      delete row;
    if (table)
      close_thread_tables(&thd);
    VOID(pthread_mutex_lock(&LOCK_thread_count));
641 642 643
    pthread_mutex_destroy(&mutex);
    pthread_cond_destroy(&cond);
    pthread_cond_destroy(&cond_client);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
644 645 646 647 648 649
    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));
650
    VOID(pthread_cond_broadcast(&COND_thread_count)); /* Tell main we are ready */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
651 652 653 654 655 656 657 658 659 660 661 662 663 664 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 713 714
  }

  /* 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)))
  {
715 716 717
    /* 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
718 719 720 721 722 723
    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()))
      {
724
	thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
725 726 727 728
	my_error(ER_OUTOFMEMORY,MYF(0),sizeof(delayed_insert));
	pthread_mutex_unlock(&LOCK_delayed_create);
	DBUG_RETURN(0);
      }
729 730 731
      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
732
      if (!(tmp->thd.db=my_strdup(table_list->db,MYF(MY_WME))) ||
733
	  !(tmp->thd.query=my_strdup(table_list->real_name,MYF(MY_WME))))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
734 735
      {
	delete tmp;
736
	thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
737 738 739 740
	my_error(ER_OUT_OF_RESOURCES,MYF(0));
	pthread_mutex_unlock(&LOCK_delayed_create);
	DBUG_RETURN(0);
      }
741 742
      tmp->table_list= *table_list;			// Needed to open table
      tmp->table_list.db= tmp->thd.db;
743
      tmp->table_list.alias= tmp->table_list.real_name=tmp->thd.query;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
744 745 746 747 748 749 750 751 752 753 754
      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;
755
	thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
756
	pthread_mutex_unlock(&LOCK_delayed_create);
757
	net_printf(thd,ER_CANT_CREATE_THREAD,error);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
758 759 760 761 762 763 764 765 766 767 768 769 770
	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)
      {
771
	if (tmp->thd.is_fatal_error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
772 773
	{
	  /* Copy error message and abort */
774
	  thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
775
	  strmov(thd->net.last_error,tmp->thd.net.last_error);
776
	  thd->net.last_errno=tmp->thd.net.last_errno;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797
	}
	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;
798 799
  else if (tmp->thd.is_fatal_error)
    thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
800 801 802 803 804 805 806 807 808 809 810 811 812 813
  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;
814
  Field **field,**org_field, *found_next_number_field;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839
  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";
840 841 842
  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
843 844 845 846 847 848 849 850 851 852 853 854 855 856
  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]);

857
  found_next_number_field=table->found_next_number_field;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
858 859
  for (org_field=table->field ; *org_field ; org_field++,field++)
  {
860
    if (!(*field= (*org_field)->new_field(&client_thd->mem_root,copy)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
861 862
      return 0;
    (*field)->move_field(adjust_ptrs);		// Point at copy->record[0]
863 864
    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
865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892
  }
  *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,
893
			 char *query, uint query_length, int log_on)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
894 895 896 897 898 899 900 901 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 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946
{
  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)
{
947
  DBUG_ENTER("end_delayed_insert");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
948 949
  delayed_insert *di=thd->di;
  pthread_mutex_lock(&di->mutex);
950
  DBUG_PRINT("info",("tables in use: %d",di->tables_in_use));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
951 952 953 954 955 956
  if (!--di->tables_in_use || di->thd.killed)
  {						// Unlock table
    di->status=1;
    pthread_cond_signal(&di->cond);
  }
  pthread_mutex_unlock(&di->mutex);
957
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
958 959 960 961 962 963 964 965 966 967 968 969 970
}


/* 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++))
  {
971
    /* 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
972 973 974 975 976
    pthread_mutex_lock(&tmp->mutex);
    tmp->thd.killed=1;
    if (tmp->thd.mysys_var)
    {
      pthread_mutex_lock(&tmp->thd.mysys_var->mutex);
977
      if (tmp->thd.mysys_var->current_cond)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
978
      {
979 980 981 982 983 984
	/*
	  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
985
	pthread_cond_broadcast(tmp->thd.mysys_var->current_cond);
986 987
	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
988 989 990 991 992 993 994 995 996 997 998 999 1000
      }
      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
*/

1001
extern "C" pthread_handler_decl(handle_delayed_insert,arg)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1002 1003 1004 1005 1006 1007 1008 1009
{
  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++;
1010
  thd->end_time();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1011
  threads.append(thd);
1012
  thd->killed=abort_loop;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1013 1014 1015
  pthread_mutex_unlock(&LOCK_thread_count);

  pthread_mutex_lock(&di->mutex);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1016
#if !defined( __WIN__) && !defined(OS2)	/* Win32 calls this in pthread_create */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1017 1018 1019 1020 1021 1022 1023 1024
  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");
1025
  if (init_thr_lock() || thd->store_globals())
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1026
  {
1027
    thd->fatal_error();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1028 1029 1030
    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
1031
#if !defined(__WIN__) && !defined(OS2) && !defined(__NETWARE__)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1032 1033 1034 1035 1036 1037 1038
  sigset_t set;
  VOID(sigemptyset(&set));			// Get mask in use
  VOID(pthread_sigmask(SIG_UNBLOCK,&set,&thd->block_signals));
#endif

  /* open table */

1039
  if (!(di->table=open_ltable(thd,&di->table_list,TL_WRITE_DELAYED)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1040
  {
1041
    thd->fatal_error();				// Abort waiting inserts
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1042 1043
    goto end;
  }
1044 1045
  if (di->table->file->has_transactions())
  {
1046
    thd->fatal_error();
1047
    my_error(ER_ILLEGAL_HA, MYF(0), di->table_list.real_name);
1048 1049
    goto end;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084
  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;
1085
      set_timespec(abstime, delayed_insert_timeout);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1086 1087 1088 1089

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

1092
      DBUG_PRINT("info",("Waiting for someone to insert rows"));
1093
      while (!thd->killed)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1094 1095
      {
	int error;
1096
#if defined(HAVE_BROKEN_COND_TIMEDWAIT)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1097 1098 1099 1100
	error=pthread_cond_wait(&di->cond,&di->mutex);
#else
	error=pthread_cond_timedwait(&di->cond,&di->mutex,&abstime);
#ifdef EXTRA_DEBUG
1101
	if (error && error != EINTR && error != ETIMEDOUT)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116
	{
	  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;
	}
      }
1117 1118
      /* 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
1119 1120 1121 1122
      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);
1123
      pthread_mutex_lock(&di->mutex);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1124
    }
1125
    di->thd.proc_info=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 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

    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;
1215
  bool using_ignore=0, using_bin_log=mysql_bin_log.is_open();
1216
  delayed_row *row;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239
  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
  }

1240 1241 1242 1243 1244 1245 1246
  /*
    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
1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261
  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
1262 1263 1264 1265 1266 1267
    if (info.handle_duplicates == DUP_IGNORE ||
	info.handle_duplicates == DUP_REPLACE)
    {
      table->file->extra(HA_EXTRA_IGNORE_DUP_KEY);
      using_ignore=1;
    }
1268
    thd.clear_error(); // reset error for binlog
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1269 1270
    if (write_record(table,&info))
    {
1271
      info.error_count++;				// Ignore errors
1272
      thread_safe_increment(delayed_insert_errors,&LOCK_delayed_status);
sasha@laptop.slkc.uswest.net's avatar
sasha@laptop.slkc.uswest.net committed
1273
      row->log_query = 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1274
    }
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1275 1276 1277 1278 1279
    if (using_ignore)
    {
      using_ignore=0;
      table->file->extra(HA_EXTRA_NO_IGNORE_DUP_KEY);
    }
1280
    if (row->query)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1281
    {
1282 1283 1284
      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)
1285
      {
1286 1287
        Query_log_event qinfo(&thd, row->query, row->query_length,0);
        mysql_bin_log.write(&qinfo);
1288
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313
    }
    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;
	}
1314
	query_cache_invalidate3(&thd, table, 1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1315 1316 1317 1318 1319
	if (thr_reschedule_write_lock(*thd.lock->locks))
	{
	  /* This should never happen */
	  sql_print_error(ER(ER_DELAYED_CANT_CHANGE_LOCK),table->real_name);
	}
1320 1321
	if (!using_bin_log)
	  table->file->extra(HA_EXTRA_WRITE_CACHE);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338
	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;
  }
1339
  query_cache_invalidate3(&thd, table, 1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1340 1341 1342 1343
  pthread_mutex_lock(&mutex);
  DBUG_RETURN(0);

 err:
1344 1345 1346 1347 1348 1349 1350
  /* 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
1351 1352 1353 1354 1355 1356 1357 1358
  thread_safe_increment(delayed_insert_errors, &LOCK_delayed_status);
  pthread_mutex_lock(&mutex);
  DBUG_RETURN(1);
}



/***************************************************************************
1359
  Store records in INSERT ... SELECT *
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1360 1361 1362
***************************************************************************/

int
1363
select_insert::prepare(List<Item> &values, SELECT_LEX_UNIT *u)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1364 1365 1366
{
  DBUG_ENTER("select_insert::prepare");

1367
  unit= u;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1368 1369 1370
  if (check_insert_fields(thd,table,*fields,values,1))
    DBUG_RETURN(1);

1371
  restore_record(table,default_values);			// Get empty record
1372
  table->next_number_field=table->found_next_number_field;
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
1373
  thd->count_cuted_fields=1;			// calc cuted fields
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1374
  thd->cuted_fields=0;
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
1375 1376 1377 1378 1379 1380
  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
1381 1382 1383 1384 1385 1386 1387 1388
  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
1389
    table->file->extra(HA_EXTRA_RESET);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1390 1391 1392 1393 1394 1395 1396
  }
  thd->count_cuted_fields=0;
}


bool select_insert::send_data(List<Item> &values)
{
1397
  if (unit->offset_limit_cnt)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1398
  {						// using limit offset,count
1399
    unit->offset_limit_cnt--;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1400 1401 1402
    return 0;
  }
  if (fields->elements)
1403
    fill_record(*fields, values, 1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1404
  else
1405
    fill_record(table->field, values, 1);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
1406
  if (thd->net.report_error || write_record(table,&info))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419
    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)
{
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
1420
  //TODO error should be sent at the query processing end
1421
  ::send_error(thd,errcode,err);
1422 1423
  table->file->extra(HA_EXTRA_NO_CACHE);
  table->file->activate_all_index(thd);
1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441
  /* 
     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).
  */
  if ((info.copied || info.deleted) && !table->file->has_transactions())
  {
    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);
    }
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1442
  if (info.copied || info.deleted)
1443
    query_cache_invalidate3(thd, table, 1);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1444
  ha_rollback_stmt(thd);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1445 1446 1447 1448 1449
}


bool select_insert::send_eof()
{
1450 1451 1452
  int error,error2;
  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
1453
  table->file->extra(HA_EXTRA_NO_IGNORE_DUP_KEY);
1454

1455 1456 1457 1458
  /*
    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
1459 1460 1461 1462

  if (info.copied || info.deleted)
    query_cache_invalidate3(thd, table, 1);

1463 1464
  if (last_insert_id)
    thd->insert_id(last_insert_id);		// For binary log
1465
  /* Write to binlog before commiting transaction */
1466
  mysql_update_log.write(thd,thd->query,thd->query_length);
1467 1468 1469 1470 1471 1472
  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);
  }
1473 1474 1475
  if ((error2=ha_autocommit_or_rollback(thd,error)) && ! error)
    error=error2;
  if (error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1476 1477
  {
    table->file->print_error(error,MYF(0));
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
1478
    //TODO error should be sent at the query processing end
1479
    ::send_error(thd);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490
    return 1;
  }
  else
  {
    char buff[160];
    if (info.handle_duplicates == DUP_IGNORE)
      sprintf(buff,ER(ER_INSERT_INFO),info.records,info.records-info.copied,
	      thd->cuted_fields);
    else
      sprintf(buff,ER(ER_INSERT_INFO),info.records,info.deleted,
	      thd->cuted_fields);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1491
    ::send_ok(thd,info.copied+info.deleted,last_insert_id,buff);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1492 1493 1494 1495 1496 1497
    return 0;
  }
}


/***************************************************************************
1498
  CREATE TABLE (SELECT) ...
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1499 1500 1501
***************************************************************************/

int
1502
select_create::prepare(List<Item> &values, SELECT_LEX_UNIT *u)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1503 1504 1505
{
  DBUG_ENTER("select_create::prepare");

1506
  unit= u;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521
  table=create_table_from_items(thd, create_info, db, name,
				extra_fields, keys, &values, &lock);
  if (!table)
    DBUG_RETURN(-1);				// abort() deletes table

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

1522
  restore_record(table,default_values);			// Get empty record
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1523 1524
  thd->count_cuted_fields=1;			// count warnings
  thd->cuted_fields=0;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1525 1526 1527
  if (info.handle_duplicates == DUP_IGNORE ||
      info.handle_duplicates == DUP_REPLACE)
    table->file->extra(HA_EXTRA_IGNORE_DUP_KEY);
1528
  table->file->deactivate_non_unique_index((ha_rows) 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1529 1530 1531 1532 1533 1534
  DBUG_RETURN(0);
}


bool select_create::send_data(List<Item> &values)
{
1535
  if (unit->offset_limit_cnt)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1536
  {						// using limit offset,count
1537
    unit->offset_limit_cnt--;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1538 1539
    return 0;
  }
1540
  fill_record(field, values, 1);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
1541
  if (thd->net.report_error ||write_record(table,&info))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553
    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;
}

extern HASH open_cache;

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

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1555 1556 1557 1558 1559 1560 1561
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
1562
    table->file->extra(HA_EXTRA_NO_IGNORE_DUP_KEY);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1563 1564
    VOID(pthread_mutex_lock(&LOCK_open));
    mysql_unlock_tables(thd, lock);
1565 1566 1567 1568 1569
    /*
      TODO:
      Check if we can remove the following two rows.
      We should be able to just keep the table in the table cache.
    */
1570 1571
    if (!table->tmp_table)
      hash_delete(&open_cache,(byte*) table);
1572
    lock=0; 
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
1573
    table=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588
    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
1589
    table->file->extra(HA_EXTRA_NO_IGNORE_DUP_KEY);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1590
    enum db_type table_type=table->db_type;
1591 1592
    if (!table->tmp_table)
      hash_delete(&open_cache,(byte*) table);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1593 1594 1595 1596 1597 1598 1599 1600
    quick_rm_table(table_type,db,name);
    table=0;
  }
  VOID(pthread_mutex_unlock(&LOCK_open));
}


/*****************************************************************************
1601
  Instansiate templates
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1602 1603 1604
*****************************************************************************/

#ifdef __GNUC__
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
1605
template class List_iterator_fast<List_item>;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1606 1607 1608 1609
template class I_List<delayed_insert>;
template class I_List_iterator<delayed_insert>;
template class I_List<delayed_row>;
#endif