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

unknown's avatar
unknown committed
3 4 5 6
   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.
unknown's avatar
unknown committed
7

unknown's avatar
unknown committed
8 9 10 11
   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.
unknown's avatar
unknown committed
12

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


/* Handler-calling-functions */

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

#include "mysql_priv.h"
#include "ha_heap.h"
#include "ha_myisam.h"
#include "ha_myisammrg.h"
28
#ifdef HAVE_ISAM
unknown's avatar
unknown committed
29 30 31 32 33 34
#include "ha_isam.h"
#include "ha_isammrg.h"
#endif
#ifdef HAVE_BERKELEY_DB
#include "ha_berkeley.h"
#endif
35
#ifdef HAVE_INNOBASE_DB
36
#include "ha_innodb.h"
37
#endif
unknown's avatar
unknown committed
38 39 40 41 42 43 44 45 46 47
#include <myisampack.h>
#include <errno.h>

	/* static functions defined in this file */

static int NEAR_F delete_file(const char *name,const char *ext,int extflag);

ulong ha_read_count, ha_write_count, ha_delete_count, ha_update_count,
      ha_read_key_count, ha_read_next_count, ha_read_prev_count,
      ha_read_first_count, ha_read_last_count,
48
      ha_commit_count, ha_rollback_count,
unknown's avatar
unknown committed
49 50 51 52
      ha_read_rnd_count, ha_read_rnd_next_count;

const char *ha_table_type[] = {
  "", "DIAB_ISAM","HASH","MISAM","PISAM","RMS_ISAM","HEAP", "ISAM",
53
  "MRG_ISAM","MYISAM", "MRG_MYISAM", "BDB", "INNODB", "GEMINI", "?", "?",NullS
unknown's avatar
unknown committed
54 55
};

56 57 58
TYPELIB ha_table_typelib= {array_elements(ha_table_type)-4,"",
			   ha_table_type+1};

unknown's avatar
unknown committed
59 60 61 62
const char *ha_row_type[] = {
  "", "FIXED", "DYNAMIC", "COMPRESSED","?","?","?"
};

unknown's avatar
unknown committed
63
const char *tx_isolation_names[] =
64 65 66
{ "READ-UNCOMMITTED", "READ-COMMITTED", "REPEATABLE-READ", "SERIALIZABLE",
  NullS};
TYPELIB tx_isolation_typelib= {array_elements(tx_isolation_names)-1,"",
unknown's avatar
unknown committed
67
			       tx_isolation_names};
unknown's avatar
unknown committed
68 69 70 71 72 73 74 75 76 77

	/* Use other database handler if databasehandler is not incompiled */

enum db_type ha_checktype(enum db_type database_type)
{
  switch (database_type) {
#ifdef HAVE_BERKELEY_DB
  case DB_TYPE_BERKELEY_DB:
    return(berkeley_skip ? DB_TYPE_MYISAM : database_type);
#endif
78
#ifdef HAVE_INNOBASE_DB
79
  case DB_TYPE_INNODB:
unknown's avatar
unknown committed
80
    return(innodb_skip ? DB_TYPE_MYISAM : database_type);
81
#endif
unknown's avatar
unknown committed
82 83 84
#ifndef NO_HASH
  case DB_TYPE_HASH:
#endif
85
#ifdef HAVE_ISAM
unknown's avatar
unknown committed
86
  case DB_TYPE_ISAM:
87
  case DB_TYPE_MRG_ISAM:
unknown's avatar
unknown committed
88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105
#endif
  case DB_TYPE_HEAP:
  case DB_TYPE_MYISAM:
  case DB_TYPE_MRG_MYISAM:
    return (database_type);			/* Database exists on system */
  default:
    break;
  }
  return(DB_TYPE_MYISAM);			/* Use this as default */
} /* ha_checktype */


handler *get_new_handler(TABLE *table, enum db_type db_type)
{
  switch (db_type) {
#ifndef NO_HASH
  return new ha_hash(table);
#endif
106
#ifdef HAVE_ISAM
unknown's avatar
unknown committed
107 108 109 110 111 112 113 114
  case DB_TYPE_MRG_ISAM:
    return new ha_isammrg(table);
  case DB_TYPE_ISAM:
    return new ha_isam(table);
#endif
#ifdef HAVE_BERKELEY_DB
  case DB_TYPE_BERKELEY_DB:
    return new ha_berkeley(table);
115 116
#endif
#ifdef HAVE_INNOBASE_DB
117
  case DB_TYPE_INNODB:
118
    return new ha_innobase(table);
unknown's avatar
unknown committed
119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137
#endif
  case DB_TYPE_HEAP:
    return new ha_heap(table);
  case DB_TYPE_MYISAM:
  default:					// should never happen
    return new ha_myisam(table);
  case DB_TYPE_MRG_MYISAM:
    return new ha_myisammrg(table);
  }
}

int ha_init()
{
#ifdef HAVE_BERKELEY_DB
  if (!berkeley_skip)
  {
    int error;
    if ((error=berkeley_init()))
      return error;
138 139
    if (!berkeley_skip)				// If we couldn't use handler
      opt_using_transactions=1;
140 141
    else
      have_berkeley_db=SHOW_OPTION_DISABLED;
unknown's avatar
unknown committed
142
  }
143 144
#endif
#ifdef HAVE_INNOBASE_DB
unknown's avatar
unknown committed
145
  if (!innodb_skip)
146
  {
unknown's avatar
unknown committed
147 148
    if (innobase_init())
      return -1;
unknown's avatar
unknown committed
149
    if (!innodb_skip)				// If we couldn't use handler
150
      opt_using_transactions=1;
151
    else
unknown's avatar
unknown committed
152
      have_innodb=SHOW_OPTION_DISABLED;
153
  }
unknown's avatar
unknown committed
154 155 156 157 158 159 160 161 162 163 164 165 166
#endif
  return 0;
}

	/* close, flush or restart databases */
	/* Ignore this for other databases than ours */

int ha_panic(enum ha_panic_function flag)
{
  int error=0;
#ifndef NO_HASH
  error|=h_panic(flag);			/* fix hash */
#endif
167 168
#ifdef HAVE_ISAM
  error|=mrg_panic(flag);
unknown's avatar
unknown committed
169
  error|=nisam_panic(flag);
170 171
#endif
  error|=heap_panic(flag);
unknown's avatar
unknown committed
172 173 174 175 176
  error|=mi_panic(flag);
  error|=myrg_panic(flag);
#ifdef HAVE_BERKELEY_DB
  if (!berkeley_skip)
    error|=berkeley_end();
177 178
#endif
#ifdef HAVE_INNOBASE_DB
unknown's avatar
unknown committed
179
  if (!innodb_skip)
180
    error|=innobase_end();
unknown's avatar
unknown committed
181 182 183 184
#endif
  return error;
} /* ha_panic */

185 186 187 188 189 190 191
void ha_drop_database(char* path)
{
#ifdef HAVE_INNOBASE_DB
  if (!innodb_skip)
    innobase_drop_database(path);
#endif
}
unknown's avatar
unknown committed
192

193 194 195
void ha_close_connection(THD* thd)
{
#ifdef HAVE_INNOBASE_DB
unknown's avatar
unknown committed
196
  if (!innodb_skip)
unknown's avatar
unknown committed
197
    innobase_close_connection(thd);
198 199 200
#endif
}

201 202 203 204 205
/*
  This is used to commit or rollback a single statement depending
  on the value of error
*/

unknown's avatar
unknown committed
206 207 208
int ha_autocommit_or_rollback(THD *thd, int error)
{
  DBUG_ENTER("ha_autocommit_or_rollback");
209
#ifdef USING_TRANSACTIONS
210
  if (opt_using_transactions)
unknown's avatar
unknown committed
211
  {
212 213 214 215 216 217 218
    if (!error)
    {
      if (ha_commit_stmt(thd))
	error=1;
    }
    else
      (void) ha_rollback_stmt(thd);
unknown's avatar
unknown committed
219
    thd->tx_isolation=thd->session_tx_isolation;
unknown's avatar
unknown committed
220 221 222 223 224
  }
#endif
  DBUG_RETURN(error);
}

225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262
/* This function is called when MySQL writes the log segment of a transaction
to the binlog. It is called when the LOCK_log mutex is reserved. Here we
communicate to transactional table handlers whta binlog position corresponds
to the current transaction. The handler can store it and in recovery print
to the user, so that the user knows from what position in the binlog to
start possible roll-forward, for example, if the crashed server was a slave
in replication. This function also calls the commit of the table handler,
because the order of trasnactions in the log of the table handler must be
the same as in the binlog. */

int ha_report_binlog_offset_and_commit(
       THD      *thd,           /* in: user thread */
       char     *log_file_name, /* in: latest binlog file name */
       my_off_t  end_offset)    /* in: the offset in the binlog file
				   up to which we wrote */
{
  THD_TRANS *trans;
  int        error  = 0;

  trans = &thd->transaction.all;

#ifdef HAVE_INNOBASE_DB
  if (trans->innobase_tid)
  {
    if ((error=innobase_report_binlog_offset_and_commit(thd,
							trans->innobase_tid,
							log_file_name,
							end_offset)))
    {
      my_error(ER_ERROR_DURING_COMMIT, MYF(0), error);
      error=1;
    }
    trans->innodb_active_trans=0;
  }
#endif

  return error;
}
263 264

int ha_commit_trans(THD *thd, THD_TRANS* trans)
unknown's avatar
unknown committed
265 266
{
  int error=0;
267
  DBUG_ENTER("ha_commit");
268
#ifdef USING_TRANSACTIONS
269
  if (opt_using_transactions)
270
  {
271
    bool operation_done=0;
272 273 274 275
    /* Update the binary log if we have cached some queries */
    if (trans == &thd->transaction.all && mysql_bin_log.is_open() &&
	my_b_tell(&thd->transaction.trans_log))
    {
276
      mysql_bin_log.write(thd, &thd->transaction.trans_log);
277 278 279 280
      reinit_io_cache(&thd->transaction.trans_log,
		      WRITE_CACHE, (my_off_t) 0, 0, 1);
      thd->transaction.trans_log.end_of_file= max_binlog_cache_size;
    }
unknown's avatar
unknown committed
281
#ifdef HAVE_BERKELEY_DB
282
    if (trans->bdb_tid)
unknown's avatar
unknown committed
283
    {
284 285 286 287 288 289
      if ((error=berkeley_commit(thd,trans->bdb_tid)))
      {
	my_error(ER_ERROR_DURING_COMMIT, MYF(0), error);
	error=1;
      }
      trans->bdb_tid=0;
unknown's avatar
unknown committed
290
    }
291 292
#endif
#ifdef HAVE_INNOBASE_DB
293
    if (trans->innobase_tid)
294
    {
295 296 297 298 299
      if ((error=innobase_commit(thd,trans->innobase_tid)))
      {
	my_error(ER_ERROR_DURING_COMMIT, MYF(0), error);
	error=1;
      }
unknown's avatar
unknown committed
300
      trans->innodb_active_trans=0;
unknown's avatar
unknown committed
301
      if (trans == &thd->transaction.all)
302
      {
unknown's avatar
unknown committed
303
	query_cache.invalidate(Query_cache_table::INNODB);
304 305
	operation_done=1;
      }
306
    }
307
#endif
308 309
    if (error && trans == &thd->transaction.all && mysql_bin_log.is_open())
      sql_print_error("Error: Got error during commit;  Binlog is not up to date!");
unknown's avatar
unknown committed
310
    thd->tx_isolation=thd->session_tx_isolation;
311 312
    if (operation_done)
      statistic_increment(ha_commit_count,&LOCK_status);
313
  }
314
#endif // using transactions
unknown's avatar
unknown committed
315 316 317
  DBUG_RETURN(error);
}

318

319
int ha_rollback_trans(THD *thd, THD_TRANS *trans)
unknown's avatar
unknown committed
320 321
{
  int error=0;
322
  DBUG_ENTER("ha_rollback");
323 324
#ifdef USING_TRANSACTIONS
  if (opt_using_transactions)
unknown's avatar
unknown committed
325
  {
326
    bool operation_done=0;
327 328
#ifdef HAVE_BERKELEY_DB
    if (trans->bdb_tid)
unknown's avatar
unknown committed
329
    {
330 331 332 333 334 335
      if ((error=berkeley_rollback(thd, trans->bdb_tid)))
      {
	my_error(ER_ERROR_DURING_ROLLBACK, MYF(0), error);
	error=1;
      }
      trans->bdb_tid=0;
336
      operation_done=1;
unknown's avatar
unknown committed
337
    }
338 339
#endif
#ifdef HAVE_INNOBASE_DB
340
    if (trans->innobase_tid)
341
    {
342 343 344 345 346
      if ((error=innobase_rollback(thd, trans->innobase_tid)))
      {
	my_error(ER_ERROR_DURING_ROLLBACK, MYF(0), error);
	error=1;
      }
unknown's avatar
unknown committed
347
      trans->innodb_active_trans=0;
348
      operation_done=1;
349
    }
unknown's avatar
unknown committed
350
#endif
351 352 353 354
    if (trans == &thd->transaction.all)
      reinit_io_cache(&thd->transaction.trans_log,
		      WRITE_CACHE, (my_off_t) 0, 0, 1);
    thd->transaction.trans_log.end_of_file= max_binlog_cache_size;
unknown's avatar
unknown committed
355
    thd->tx_isolation=thd->session_tx_isolation;
356 357
    if (operation_done)
      statistic_increment(ha_rollback_count,&LOCK_status);
358 359
  }
#endif /* USING_TRANSACTIONS */
unknown's avatar
unknown committed
360 361 362 363 364 365 366 367 368
  DBUG_RETURN(error);
}

bool ha_flush_logs()
{
  bool result=0;
#ifdef HAVE_BERKELEY_DB
  if (!berkeley_skip && berkeley_flush_logs())
    result=1;
369 370
#endif
#ifdef HAVE_INNOBASE_DB
unknown's avatar
unknown committed
371
  if (!innodb_skip && innobase_flush_logs())
372
    result=1;
unknown's avatar
unknown committed
373 374 375 376
#endif
  return result;
}

unknown's avatar
unknown committed
377 378 379 380
/*
  This should return ENOENT if the file doesn't exists.
  The .frm file will be deleted only if we return 0 or ENOENT
*/
unknown's avatar
unknown committed
381 382 383 384 385

int ha_delete_table(enum db_type table_type, const char *path)
{
  handler *file=get_new_handler((TABLE*) 0, table_type);
  if (!file)
unknown's avatar
unknown committed
386
    return ENOENT;
unknown's avatar
unknown committed
387 388 389 390
  int error=file->delete_table(path);
  delete file;
  return error;
}
unknown's avatar
unknown committed
391

unknown's avatar
unknown committed
392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456
void ha_store_ptr(byte *buff, uint pack_length, my_off_t pos)
{
  switch (pack_length) {
#if SIZEOF_OFF_T > 4
  case 8: mi_int8store(buff,pos); break;
  case 7: mi_int7store(buff,pos); break;
  case 6: mi_int6store(buff,pos); break;
  case 5: mi_int5store(buff,pos); break;
#endif
  case 4: mi_int4store(buff,pos); break;
  case 3: mi_int3store(buff,pos); break;
  case 2: mi_int2store(buff,(uint) pos); break;
  case 1: buff[0]= (uchar) pos; break;
  }
  return;
}

my_off_t ha_get_ptr(byte *ptr, uint pack_length)
{
  my_off_t pos;
  switch (pack_length) {
#if SIZEOF_OFF_T > 4
  case 8:
    pos= (my_off_t) mi_uint8korr(ptr);
    break;
  case 7:
    pos= (my_off_t) mi_uint7korr(ptr);
    break;
  case 6:
    pos= (my_off_t) mi_uint6korr(ptr);
    break;
  case 5:
    pos= (my_off_t) mi_uint5korr(ptr);
    break;
#endif
  case 4:
    pos= (my_off_t) mi_uint4korr(ptr);
    break;
  case 3:
    pos= (my_off_t) mi_uint3korr(ptr);
    break;
  case 2:
    pos= (my_off_t) mi_uint2korr(ptr);
    break;
  case 1:
    pos= (my_off_t) mi_uint2korr(ptr);
    break;
  default:
    pos=0;					// Impossible
    break;
  }
 return pos;
}

/****************************************************************************
** General handler functions
****************************************************************************/

	/* Open database-handler. Try O_RDONLY if can't open as O_RDWR */
	/* Don't wait for locks if not HA_OPEN_WAIT_IF_LOCKED is set */

int handler::ha_open(const char *name, int mode, int test_if_locked)
{
  int error;
  DBUG_ENTER("handler::open");
457 458
  DBUG_PRINT("enter",("name: %s  db_type: %d  db_stat: %d  mode: %d  lock_test: %d",
		      name, table->db_type, table->db_stat, mode, test_if_locked));
unknown's avatar
unknown committed
459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477

  if ((error=open(name,mode,test_if_locked)))
  {
    if ((error == EACCES || error == EROFS) && mode == O_RDWR &&
	(table->db_stat & HA_TRY_READ_ONLY))
    {
      table->db_stat|=HA_READ_ONLY;
      error=open(name,O_RDONLY,test_if_locked);
    }
  }
  if (error)
  {
    my_errno=error;			/* Safeguard */
    DBUG_PRINT("error",("error: %d  errno: %d",error,errno));
  }
  else
  {
    if (table->db_options_in_use & HA_OPTION_READ_ONLY_DATA)
      table->db_stat|=HA_READ_ONLY;
478 479
    (void) extra(HA_EXTRA_NO_READCHECK);	// Not needed in SQL

unknown's avatar
unknown committed
480
    if (!alloc_root_inited(&table->mem_root))	// If temporary table
481
      ref=(byte*) sql_alloc(ALIGN_SIZE(ref_length)*2);
unknown's avatar
unknown committed
482 483 484
    else
      ref=(byte*) alloc_root(&table->mem_root, ALIGN_SIZE(ref_length)*2);
    if (!ref)
unknown's avatar
unknown committed
485 486 487 488 489 490 491 492 493 494 495 496
    {
      close();
      error=HA_ERR_OUT_OF_MEM;
    }
    else
      dupp_ref=ref+ALIGN_SIZE(ref_length);
  }
  DBUG_RETURN(error);
}

int handler::check(THD* thd, HA_CHECK_OPT* check_opt)
{
497
  return HA_ADMIN_NOT_IMPLEMENTED;
unknown's avatar
unknown committed
498 499
}

unknown's avatar
unknown committed
500 501 502 503 504 505 506 507 508 509
int handler::backup(THD* thd, HA_CHECK_OPT* check_opt)
{
  return HA_ADMIN_NOT_IMPLEMENTED;
}

int handler::restore(THD* thd, HA_CHECK_OPT* check_opt)
{
  return HA_ADMIN_NOT_IMPLEMENTED;
}

unknown's avatar
unknown committed
510 511
int handler::repair(THD* thd, HA_CHECK_OPT* check_opt)
{
512
  return HA_ADMIN_NOT_IMPLEMENTED;
unknown's avatar
unknown committed
513 514
}

515
int handler::optimize(THD* thd, HA_CHECK_OPT* check_opt)
unknown's avatar
unknown committed
516
{
517
  return HA_ADMIN_NOT_IMPLEMENTED;
unknown's avatar
unknown committed
518 519
}

520
int handler::analyze(THD* thd, HA_CHECK_OPT* check_opt)
unknown's avatar
unknown committed
521
{
522
  return HA_ADMIN_NOT_IMPLEMENTED;
unknown's avatar
unknown committed
523 524
}

525 526 527 528 529
/*
  Read first row (only) from a table
  This is never called for InnoDB or BDB tables, as these table types
  has the HA_NOT_EXACT_COUNT set.
*/
unknown's avatar
unknown committed
530

531
int handler::read_first_row(byte * buf, uint primary_key)
unknown's avatar
unknown committed
532 533
{
  register int error;
534
  DBUG_ENTER("handler::read_first_row");
unknown's avatar
unknown committed
535 536

  statistic_increment(ha_read_first_count,&LOCK_status);
537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554

  /*
    If there is very few deleted rows in the table, find the first row by
    scanning the table.
  */
  if (deleted < 10 || primary_key >= MAX_KEY)
  {
    (void) rnd_init();
    while ((error= rnd_next(buf)) == HA_ERR_RECORD_DELETED) ;
    (void) rnd_end();
  }
  else
  {
    /* Find the first row through the primary key */
    (void) index_init(primary_key);
    error=index_first(buf);
    (void) index_end();
  }
unknown's avatar
unknown committed
555 556 557 558 559 560 561 562 563 564 565 566 567 568 569
  DBUG_RETURN(error);
}


/*
  The following function is only needed for tables that may be temporary tables
  during joins
*/

int handler::restart_rnd_next(byte *buf, byte *pos)
{
  return HA_ERR_WRONG_COMMAND;
}


570
/* Set a timestamp in record */
unknown's avatar
unknown committed
571 572 573 574 575 576 577 578 579 580 581 582 583 584 585

void handler::update_timestamp(byte *record)
{
  long skr= (long) current_thd->query_start();
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int4store(record,skr);
  }
  else
#endif
  longstore(record,skr);
  return;
}

586 587 588 589
/*
  Updates field with field_type NEXT_NUMBER according to following:
  if field = 0 change field to the next free key in database.
*/
unknown's avatar
unknown committed
590 591 592 593 594 595 596

void handler::update_auto_increment()
{
  longlong nr;
  THD *thd;
  DBUG_ENTER("update_auto_increment");
  if (table->next_number_field->val_int() != 0)
597 598
  {
    auto_increment_column_changed=0;
unknown's avatar
unknown committed
599
    DBUG_VOID_RETURN;
600
  }
unknown's avatar
unknown committed
601 602 603 604 605 606 607
  thd=current_thd;
  if ((nr=thd->next_insert_id))
    thd->next_insert_id=0;			// Clear after use
  else
    nr=get_auto_increment();
  thd->insert_id((ulonglong) nr);
  table->next_number_field->store(nr);
608
  auto_increment_column_changed=1;
unknown's avatar
unknown committed
609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661
  DBUG_VOID_RETURN;
}


longlong handler::get_auto_increment()
{
  longlong nr;
  int error;
  (void) extra(HA_EXTRA_KEYREAD);
  index_init(table->next_number_index);
  error=index_last(table->record[1]);
  if (error)
    nr=1;
  else
    nr=(longlong) table->next_number_field->
      val_int_offset(table->rec_buff_length)+1;
  (void) extra(HA_EXTRA_NO_KEYREAD);
  index_end();
  return nr;
}

	/* Print error that we got from handler function */

void handler::print_error(int error, myf errflag)
{
  DBUG_ENTER("print_error");
  DBUG_PRINT("enter",("error: %d",error));

  int textno=ER_GET_ERRNO;
  switch (error) {
  case EAGAIN:
    textno=ER_FILE_USED;
    break;
  case ENOENT:
    textno=ER_FILE_NOT_FOUND;
    break;
  case HA_ERR_KEY_NOT_FOUND:
  case HA_ERR_NO_ACTIVE_RECORD:
  case HA_ERR_END_OF_FILE:
    textno=ER_KEY_NOT_FOUND;
    break;
  case HA_ERR_WRONG_TABLE_DEF:
    textno=ER_WRONG_MRG_TABLE;
    break;
  case HA_ERR_FOUND_DUPP_KEY:
  {
    uint key_nr=get_dup_key(error);
    if ((int) key_nr >= 0)
    {
      /* Write the dupplicated key in the error message */
      char key[MAX_KEY_LENGTH];
      String str(key,sizeof(key));
      key_unpack(&str,table,(uint) key_nr);
unknown's avatar
unknown committed
662
      uint max_length=MYSQL_ERRMSG_SIZE-(uint) strlen(ER(ER_DUP_ENTRY));
unknown's avatar
unknown committed
663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682
      if (str.length() >= max_length)
      {
	str.length(max_length-4);
	str.append("...");
      }
      my_error(ER_DUP_ENTRY,MYF(0),str.c_ptr(),key_nr+1);
      DBUG_VOID_RETURN;
    }
    textno=ER_DUP_KEY;
    break;
  }
  case HA_ERR_FOUND_DUPP_UNIQUE:
    textno=ER_DUP_UNIQUE;
    break;
  case HA_ERR_RECORD_CHANGED:
    textno=ER_CHECKREAD;
    break;
  case HA_ERR_CRASHED:
    textno=ER_NOT_KEYFILE;
    break;
683 684 685 686 687 688
  case HA_ERR_CRASHED_ON_USAGE:
    textno=ER_CRASHED_ON_USAGE;
    break;
  case HA_ERR_CRASHED_ON_REPAIR:
    textno=ER_CRASHED_ON_REPAIR;
    break;
unknown's avatar
unknown committed
689 690 691 692 693 694 695 696 697 698 699 700 701 702 703
  case HA_ERR_OUT_OF_MEM:
    my_error(ER_OUT_OF_RESOURCES,errflag);
    DBUG_VOID_RETURN;
  case HA_ERR_WRONG_COMMAND:
    textno=ER_ILLEGAL_HA;
    break;
  case HA_ERR_OLD_FILE:
    textno=ER_OLD_KEYFILE;
    break;
  case HA_ERR_UNSUPPORTED:
    textno=ER_UNSUPPORTED_EXTENSION;
    break;
  case HA_ERR_RECORD_FILE_FULL:
    textno=ER_RECORD_FILE_FULL;
    break;
704 705 706 707 708 709
  case HA_ERR_LOCK_WAIT_TIMEOUT:
    textno=ER_LOCK_WAIT_TIMEOUT;
    break;
  case HA_ERR_LOCK_TABLE_FULL:
    textno=ER_LOCK_TABLE_FULL;
    break;
710 711 712
  case HA_ERR_LOCK_DEADLOCK:
    textno=ER_LOCK_DEADLOCK;
    break;
713 714 715
  case HA_ERR_READ_ONLY_TRANSACTION:
    textno=ER_READ_ONLY_TRANSACTION;
    break;
unknown's avatar
Merge  
unknown committed
716 717 718 719 720 721 722 723 724
  case HA_ERR_CANNOT_ADD_FOREIGN:
    textno=ER_CANNOT_ADD_FOREIGN;
    break;
  case HA_ERR_ROW_IS_REFERENCED:
    textno=ER_ROW_IS_REFERENCED;
    break;
  case HA_ERR_NO_REFERENCED_ROW:
    textno=ER_NO_REFERENCED_ROW;
    break;
unknown's avatar
unknown committed
725 726 727 728 729 730 731 732 733 734 735 736 737 738
  default:
    {
      my_error(ER_GET_ERRNO,errflag,error);
      DBUG_VOID_RETURN;
    }
  }
  my_error(textno,errflag,table->table_name,error);
  DBUG_VOID_RETURN;
}

	/* Return key if error because of duplicated keys */

uint handler::get_dup_key(int error)
{
739
  DBUG_ENTER("get_dup_key");
unknown's avatar
unknown committed
740 741 742 743 744 745 746 747
  table->file->errkey  = (uint) -1;
  if (error == HA_ERR_FOUND_DUPP_KEY || error == HA_ERR_FOUND_DUPP_UNIQUE)
    info(HA_STATUS_ERRKEY | HA_STATUS_NO_LOCK);
  DBUG_RETURN(table->file->errkey);
}

int handler::delete_table(const char *name)
{
unknown's avatar
unknown committed
748
  int error=0;
unknown's avatar
unknown committed
749 750 751
  for (const char **ext=bas_ext(); *ext ; ext++)
  {
    if (delete_file(name,*ext,2))
unknown's avatar
unknown committed
752 753 754 755
    {
      if ((error=errno) != ENOENT)
	break;
    }
unknown's avatar
unknown committed
756
  }
unknown's avatar
unknown committed
757
  return error;
unknown's avatar
unknown committed
758 759 760 761 762 763 764 765 766 767 768 769 770 771
}


int handler::rename_table(const char * from, const char * to)
{
  DBUG_ENTER("handler::rename_table");
  for (const char **ext=bas_ext(); *ext ; ext++)
  {
    if (rename_file_ext(from,to,*ext))
      DBUG_RETURN(my_errno);
  }
  DBUG_RETURN(0);
}

772 773 774 775 776 777 778 779 780 781 782
/* Tell the handler to turn on or off logging to the handler's
   recovery log
*/
int ha_recovery_logging(THD *thd, bool on)
{
  int error=0;

  DBUG_ENTER("ha_recovery_logging");
  DBUG_RETURN(error);
}

unknown's avatar
unknown committed
783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798
int handler::index_next_same(byte *buf, const byte *key, uint keylen)
{
  int error;
  if (!(error=index_next(buf)))
  {
    if (key_cmp(table, key, active_index, keylen))
    {
      table->status=STATUS_NOT_FOUND;
      error=HA_ERR_END_OF_FILE;
    }
  }
  return error;
}


/*
799 800 801 802
  This is called to delete all rows in a table
  If the handler don't support this, then this function will
  return HA_ERR_WRONG_COMMAND and MySQL will delete the rows one
  by one.
unknown's avatar
unknown committed
803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824
*/

int handler::delete_all_rows()
{
  return (my_errno=HA_ERR_WRONG_COMMAND);
}

/****************************************************************************
** Some general functions that isn't in the handler class
****************************************************************************/

	/* Initiates table-file and calls apropriate database-creator */
	/* Returns 1 if something got wrong */

int ha_create_table(const char *name, HA_CREATE_INFO *create_info,
		    bool update_create_info)

{
  int error;
  TABLE table;
  DBUG_ENTER("ha_create_table");

825
  if (openfrm(name,"",0,(uint) READ_ALL, 0, &table))
unknown's avatar
unknown committed
826 827 828 829 830 831 832 833 834
    DBUG_RETURN(1);
  if (update_create_info)
  {
    update_create_info_from_table(create_info, &table);
    if (table.file->option_flag() & HA_DROP_BEFORE_CREATE)
      table.file->delete_table(name);		// Needed for BDB tables
  }
  error=table.file->create(name,&table,create_info);
  VOID(closefrm(&table));
unknown's avatar
unknown committed
835 836 837 838
  if (error)
  {
    if (table.db_type == DB_TYPE_INNODB)
    {
839 840 841 842
      /* Creation of InnoDB table cannot fail because of an OS error:
	 put error as the number */
      my_error(ER_CANT_CREATE_TABLE,MYF(ME_BELL+ME_WAITTANG),name,error);
    }
unknown's avatar
unknown committed
843 844
    else
      my_error(ER_CANT_CREATE_TABLE,MYF(ME_BELL+ME_WAITTANG),name,my_errno);
845
  }
unknown's avatar
unknown committed
846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861
  DBUG_RETURN(error != 0);
}

	/* Use key cacheing on all databases */

void ha_key_cache(void)
{
  if (keybuff_size)
    (void) init_key_cache(keybuff_size,0);
} /* ha_key_cache */


static int NEAR_F delete_file(const char *name,const char *ext,int extflag)
{
  char buff[FN_REFLEN];
  VOID(fn_format(buff,name,"",ext,extflag | 4));
862
  return(my_delete_with_symlink(buff,MYF(MY_WME)));
unknown's avatar
unknown committed
863
}