ha_innodb.cc 119 KB
Newer Older
1
/* Copyright (C) 2000 MySQL AB & Innobase Oy
2

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

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.
12

13 14 15 16
   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 */

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
17 18
/* This file defines the InnoDB handler: the interface between MySQL and
InnoDB */
19

20
/* TODO list for the InnoDB handler:
21
  - Ask Monty if strings of different languages can exist in the same
22
    database. Answer: in 4.1 yes.
23
*/
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
24

25 26 27 28 29
#ifdef __GNUC__
#pragma implementation				// gcc: Class implementation
#endif

#include "mysql_priv.h"
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
30
#include "slave.h"
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
31 32
#include "sql_cache.h"

33 34 35 36 37 38
#ifdef HAVE_INNOBASE_DB
#include <m_ctype.h>
#include <assert.h>
#include <hash.h>
#include <myisampack.h>

39 40
#define MAX_ULONG_BIT ((ulong) 1 << (sizeof(ulong)*8-1))

41
#include "ha_innodb.h"
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
42

43 44
pthread_mutex_t innobase_mutex;

45
/* Store MySQL definition of 'byte': in Linux it is char while InnoDB
46 47
uses unsigned char */
typedef byte	mysql_byte;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
48

49 50
#define INSIDE_HA_INNOBASE_CC

51
/* Include necessary InnoDB headers */
52
extern "C" {
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
53
#include "../innobase/include/univ.i"
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
54
#include "../innobase/include/os0file.h"
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
55
#include "../innobase/include/os0thread.h"
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
56 57 58 59
#include "../innobase/include/srv0start.h"
#include "../innobase/include/srv0srv.h"
#include "../innobase/include/trx0roll.h"
#include "../innobase/include/trx0trx.h"
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
60
#include "../innobase/include/trx0sys.h"
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
61 62 63 64 65
#include "../innobase/include/row0ins.h"
#include "../innobase/include/row0mysql.h"
#include "../innobase/include/row0sel.h"
#include "../innobase/include/row0upd.h"
#include "../innobase/include/log0log.h"
66
#include "../innobase/include/lock0lock.h"
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
67 68 69
#include "../innobase/include/dict0crea.h"
#include "../innobase/include/btr0cur.h"
#include "../innobase/include/btr0btr.h"
70
#include "../innobase/include/fsp0fsp.h"
71 72 73 74 75
}

#define HA_INNOBASE_ROWS_IN_TABLE 10000 /* to get optimization right */
#define HA_INNOBASE_RANGE_COUNT	  100

76
bool 	innodb_skip 		= 0;
77 78
uint 	innobase_init_flags 	= 0;
ulong 	innobase_cache_size 	= 0;
79

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
80 81 82
/* The default values for the following, type long, start-up parameters
are declared in mysqld.cc: */

83
long innobase_mirrored_log_groups, innobase_log_files_in_group,
84 85
     innobase_log_file_size, innobase_log_buffer_size,
     innobase_buffer_pool_size, innobase_additional_mem_pool_size,
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
86
     innobase_file_io_threads, innobase_lock_wait_timeout,
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
87 88
     innobase_thread_concurrency, innobase_force_recovery;

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
89 90
/* The default values for the following char* start-up parameters
are determined in innobase_init below: */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
91
  
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
92
char*	innobase_data_home_dir			= NULL;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
93
char*	innobase_data_file_path 		= NULL;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
94 95
char*	innobase_log_group_home_dir		= NULL;
char*	innobase_log_arch_dir			= NULL;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
96 97
/* The following has a misleading name: starting from 4.0.5, this also
affects Windows: */
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
98 99 100 101 102
char*	innobase_unix_file_flush_method		= NULL;

/* Below we have boolean-valued start-up parameters, and their default
values */

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
103
uint	innobase_flush_log_at_trx_commit	= 0;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
104 105 106
my_bool innobase_log_archive			= FALSE;
my_bool	innobase_use_native_aio			= FALSE;
my_bool	innobase_fast_shutdown			= TRUE;
107

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
108
static char *internal_innobase_data_file_path	= NULL;
109

110
/* The following counter is used to convey information to InnoDB
111 112 113 114 115
about server activity: in selects it is not sensible to call
srv_active_wake_master_thread after each fetch or search, we only do
it every INNOBASE_WAKE_INTERVAL'th step. */

#define INNOBASE_WAKE_INTERVAL	32
116
ulong	innobase_active_counter	= 0;
117 118 119

char*	innobase_home 	= NULL;

120 121
char    innodb_dummy_stmt_trx_handle = 'D';

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
122
static HASH 	innobase_open_tables;
123

124
static mysql_byte* innobase_get_key(INNOBASE_SHARE *share,uint *length,
125 126 127 128 129 130 131
			      my_bool not_used __attribute__((unused)));
static INNOBASE_SHARE *get_share(const char *table_name);
static void free_share(INNOBASE_SHARE *share);
static void innobase_print_error(const char* db_errpfx, char* buffer);

/* General functions */

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
132
/**********************************************************************
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
133 134 135
Releases possible search latch and InnoDB thread FIFO ticket. These should
be released at each SQL statement end. It does no harm to release these
also in the middle of an SQL statement. */
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152
static
void
innobase_release_stat_resources(
/*============================*/
	trx_t*	trx)	/* in: transaction object */
{
	if (trx->has_search_latch) {
		trx_search_latch_release_if_reserved(trx);
	}

	if (trx->declared_to_be_inside_innodb) {
		/* Release our possible ticket in the FIFO */

		srv_conc_force_exit_innodb(trx);
	}
}

153 154 155 156 157 158 159 160 161 162 163 164 165
/************************************************************************
Call this function when mysqld passes control to the client. That is to
avoid deadlocks on the adaptive hash S-latch possibly held by thd. For more
documentation, see handler.cc. */

void
innobase_release_temporary_latches(
/*===============================*/
        void*   innobase_tid)
{
        innobase_release_stat_resources((trx_t*)innobase_tid);
}

166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182
/************************************************************************
Increments innobase_active_counter and every INNOBASE_WAKE_INTERVALth
time calls srv_active_wake_master_thread. This function should be used
when a single database operation may introduce a small need for
server utility activity, like checkpointing. */
inline
void
innobase_active_small(void)
/*=======================*/
{
	innobase_active_counter++;

	if ((innobase_active_counter % INNOBASE_WAKE_INTERVAL) == 0) {
		srv_active_wake_master_thread();
	}
}

183
/************************************************************************
184
Converts an InnoDB error code to a MySQL error code. */
185 186 187 188 189
static
int
convert_error_code_to_mysql(
/*========================*/
			/* out: MySQL error code */
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
190 191
	int	error,	/* in: InnoDB error code */
	THD*	thd)	/* in: user thread handle or NULL */
192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209
{
	if (error == DB_SUCCESS) {

		return(0);

  	} else if (error == (int) DB_DUPLICATE_KEY) {

    		return(HA_ERR_FOUND_DUPP_KEY);

 	} else if (error == (int) DB_RECORD_NOT_FOUND) {

    		return(HA_ERR_NO_ACTIVE_RECORD);

 	} else if (error == (int) DB_ERROR) {

    		return(HA_ERR_NO_ACTIVE_RECORD);

 	} else if (error == (int) DB_DEADLOCK) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
210 211 212 213 214 215 216
 		/* Since we roll back the whole transaction, we must
 		tell it also to MySQL so that MySQL knows to empty the
 		cached binlog for this transaction */

 		if (thd) {
 			ha_rollback(thd);
 		}
217

218 219 220 221
    		return(HA_ERR_LOCK_DEADLOCK);

 	} else if (error == (int) DB_LOCK_WAIT_TIMEOUT) {

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
222 223 224 225 226 227 228 229 230
 		/* Since we roll back the whole transaction, we must
 		tell it also to MySQL so that MySQL knows to empty the
 		cached binlog for this transaction */


 		if (thd) {
 			ha_rollback(thd);
 		}

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
231
    		return(HA_ERR_LOCK_WAIT_TIMEOUT);
232 233 234

 	} else if (error == (int) DB_NO_REFERENCED_ROW) {

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
235
    		return(HA_ERR_NO_REFERENCED_ROW);
236 237 238

 	} else if (error == (int) DB_ROW_IS_REFERENCED) {

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
239
    		return(HA_ERR_ROW_IS_REFERENCED);
240

241
        } else if (error == (int) DB_CANNOT_ADD_CONSTRAINT) {
242

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
243
    		return(HA_ERR_CANNOT_ADD_FOREIGN);
244

245 246
        } else if (error == (int) DB_COL_APPEARS_TWICE_IN_INDEX) {

247
    		return(HA_ERR_CRASHED);
248

249 250 251 252 253 254 255 256 257 258 259 260 261 262 263
 	} else if (error == (int) DB_OUT_OF_FILE_SPACE) {

    		return(HA_ERR_RECORD_FILE_FULL);

 	} else if (error == (int) DB_TABLE_IS_BEING_USED) {

    		return(HA_ERR_WRONG_COMMAND);

 	} else if (error == (int) DB_TABLE_NOT_FOUND) {

    		return(HA_ERR_KEY_NOT_FOUND);

  	} else if (error == (int) DB_TOO_BIG_RECORD) {

    		return(HA_ERR_TO_BIG_ROW);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
264 265 266 267

  	} else if (error == (int) DB_CORRUPTION) {

    		return(HA_ERR_CRASHED);
268
    	} else {
269
    		return(-1);			// Unknown error
270 271 272
    	}
}

273 274 275
extern "C" {
/*****************************************************************
Prints info of a THD object (== user session thread) to the
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
276
standard output. NOTE that /mysql/innobase/trx/trx0trx.c must contain
277 278 279 280 281
the prototype for this function! */

void
innobase_mysql_print_thd(
/*=====================*/
282 283 284
	char*   buf,	/* in/out: buffer where to print, must be at least
			400 bytes */
        void*   input_thd)/* in: pointer to a MySQL THD object */
285
{
286 287
  	THD*    thd;
	char*   old_buf = buf;
288

289
        thd = (THD*) input_thd;
290

291 292 293 294 295
	/*  We cannot use the return value of normal sprintf() as this is
	not portable to some old non-Posix Unixes, e.g., some old SCO
	Unixes */

  	buf += my_sprintf(buf,
296 297
			 (buf, "MySQL thread id %lu, query id %lu",
			  thd->thread_id, thd->query_id));
298 299 300 301
    	if (thd->host) {
	        *buf = ' ';
		buf++;
	        buf = strnmov(buf, thd->host, 30);
302 303
  	}

304 305 306 307
  	if (thd->ip) {
	        *buf = ' ';
		buf++;
	        buf=strnmov(buf, thd->ip, 20);
308 309
  	}

310 311 312 313
  	if (thd->user) {
	        *buf = ' ';
		buf++;
	        buf=strnmov(buf, thd->user, 20);
314 315
  	}

316 317 318 319
  	if (thd->proc_info) {
	        *buf = ' ';
		buf++;
	        buf=strnmov(buf, thd->proc_info, 50);
320 321
  	}

322 323 324 325
  	if (thd->query) {
	        *buf = '\n';
		buf++;
	        buf=strnmov(buf, thd->query, 150);
326
  	}  
monty@hundin.mysql.fi's avatar
merge  
monty@hundin.mysql.fi committed
327

328 329 330 331 332 333 334 335
	buf[0] = '\n';
	buf[1] = '\0'; /* Note that we must put a null character here to end
		       the printed string */

	/* We test the printed length did not overrun the buffer length of
	400 bytes */

 	ut_a(strlen(old_buf) < 400);
336 337 338
}
}

339
/*************************************************************************
340 341
Gets the InnoDB transaction handle for a MySQL handler object, creates
an InnoDB transaction struct if the corresponding MySQL thread struct still
342
lacks one. */
343
static
344 345 346
trx_t*
check_trx_exists(
/*=============*/
347
			/* out: InnoDB transaction handle */
348 349 350 351
	THD*	thd)	/* in: user thread handle */
{
	trx_t*	trx;

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
352 353
	ut_a(thd == current_thd);

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
354
	trx = (trx_t*) thd->transaction.all.innobase_tid;
355 356

	if (trx == NULL) {
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
357
	        DBUG_ASSERT(thd != NULL);
358
		trx = trx_allocate_for_mysql();
359

360
		trx->mysql_thd = thd;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
361 362
		trx->mysql_query_str = &((*thd).query);
		
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
363
		thd->transaction.all.innobase_tid = trx;
364

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
365
		/* The execution of a single SQL statement is denoted by
366
		a 'transaction' handle which is a dummy pointer: InnoDB
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
367 368
		remembers internally where the latest SQL statement
		started, and if error handling requires rolling back the
369
		latest statement, InnoDB does a rollback to a savepoint. */
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
370

371 372
		thd->transaction.stmt.innobase_tid =
		                  (void*)&innodb_dummy_stmt_trx_handle;
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
373
	} else {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390
		if (trx->magic_n != TRX_MAGIC_N) {
			mem_analyze_corruption((byte*)trx);

			ut_a(0);
		}
	}

	if (thd->options & OPTION_NO_FOREIGN_KEY_CHECKS) {
		trx->check_foreigns = FALSE;
	} else {
		trx->check_foreigns = TRUE;
	}

	if (thd->options & OPTION_RELAXED_UNIQUE_CHECKS) {
		trx->check_unique_secondary = FALSE;
	} else {
		trx->check_unique_secondary = TRUE;
391 392 393 394 395 396
	}

	return(trx);
}

/*************************************************************************
397
Updates the user_thd field in a handle and also allocates a new InnoDB
398 399
transaction handle if needed, and updates the transaction fields in the
prebuilt struct. */
400
inline
401 402 403 404 405 406
int
ha_innobase::update_thd(
/*====================*/
			/* out: 0 or error code */
	THD*	thd)	/* in: thd to use the handle */
{
407 408
	row_prebuilt_t*	prebuilt = (row_prebuilt_t*) innobase_prebuilt;
	trx_t*		trx;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
409
	
410 411
	trx = check_trx_exists(thd);

412
	if (prebuilt->trx != trx) {
413

414
		row_update_prebuilt_trx(prebuilt, trx);
415 416 417
	}

	user_thd = thd;
418

419 420 421
	return(0);
}

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
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 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579

/*   BACKGROUND INFO: HOW THE MYSQL QUERY CACHE WORKS WITH INNODB
     ------------------------------------------------------------

1) The use of the query cache for TBL is disabled when there is an
uncommitted change to TBL.

2) When a change to TBL commits, InnoDB stores the current value of
its global trx id counter, let us denote it by INV_TRX_ID, to the table object
in the InnoDB data dictionary, and does only allow such transactions whose
id >= INV_TRX_ID to use the query cache.

3) When InnoDB does an INSERT/DELETE/UPDATE to a table TBL, or an implicit
modification because an ON DELETE CASCADE, we invalidate the MySQL query cache
of TBL immediately.

How this is implemented inside InnoDB:

1) Since every modification always sets an IX type table lock on the InnoDB
table, it is easy to check if there can be uncommitted modifications for a
table: just check if there are locks in the lock list of the table.

2) When a transaction inside InnoDB commits, it reads the global trx id
counter and stores the value INV_TRX_ID to the tables on which it had a lock.

3) If there is an implicit table change from ON DELETE CASCADE or SET NULL,
InnoDB calls an invalidate method for the MySQL query cache for that table.

How this is implemented inside sql_cache.cc:

1) The query cache for an InnoDB table TBL is invalidated immediately at an
INSERT/UPDATE/DELETE, just like in the case of MyISAM. No need to delay
invalidation to the transaction commit.

2) To store or retrieve a value from the query cache of an InnoDB table TBL,
any query must first ask InnoDB's permission. We must pass the thd as a
parameter because InnoDB will look at the trx id, if any, associated with
that thd.

3) Use of the query cache for InnoDB tables is now allowed also when
AUTOCOMMIT==0 or we are inside BEGIN ... COMMIT. Thus transactions no longer
put restrictions on the use of the query cache.
*/

/**********************************************************************
The MySQL query cache uses this to check from InnoDB if the query cache at
the moment is allowed to operate on an InnoDB table. The SQL query must
be a non-locking SELECT.

The query cache is allowed to operate on certain query only if this function
returns TRUE for all tables in the query.

If thd is not in the autocommit state, this function also starts a new
transaction for thd if there is no active trx yet, and assigns a consistent
read view to it if there is no read view yet. */

my_bool
innobase_query_caching_of_table_permitted(
/*======================================*/
				/* out: TRUE if permitted, FALSE if not;
				note that the value FALSE does not mean
				we should invalidate the query cache:
				invalidation is called explicitly */
	THD*	thd,		/* in: thd of the user who is trying to
				store a result to the query cache or
				retrieve it */
	char*	full_name,	/* in: concatenation of database name,
				the null character '\0', and the table
				name */
	uint	full_name_len)	/* in: length of the full name, i.e.
				len(dbname) + len(tablename) + 1 */
{
	ibool	is_autocommit;
	trx_t*	trx;
	char*	ptr;
	char	norm_name[1000];

	ut_a(full_name_len < 999);

	if (thd->variables.tx_isolation == ISO_SERIALIZABLE) {
		/* In the SERIALIZABLE mode we add LOCK IN SHARE MODE to every
		plain SELECT */
	
		return((my_bool)FALSE);
	}

	trx = (trx_t*) thd->transaction.all.innobase_tid;

	if (trx == NULL) {
		trx = check_trx_exists(thd);
	}

	innobase_release_stat_resources(trx);

	if (!(thd->options & (OPTION_NOT_AUTOCOMMIT | OPTION_BEGIN))) {

		is_autocommit = TRUE;
	} else {
		is_autocommit = FALSE;

	}

	if (is_autocommit && trx->conc_state == TRX_NOT_STARTED) {
		/* We are going to retrieve the query result from the
		query cache. This cannot be a store operation because then
		we would have started the trx already.

		We can imagine we instantaneously serialize
		this consistent read trx to the current trx id counter.
		If trx2 would have changed the tables of a query
		result stored in the cache, and trx2 would have already
		committed, making the result obsolete, then trx2 would have
		already invalidated the cache. Thus we can trust the result
		in the cache is ok for this query. */

		return((my_bool)TRUE);
	}
	
	/* Normalize the table name to InnoDB format */

	memcpy(norm_name, full_name, full_name_len);

	norm_name[strlen(norm_name)] = '/'; /* InnoDB uses '/' as the
					    separator between db and table */
	norm_name[full_name_len] = '\0';
#ifdef __WIN__
	/* Put to lower case */

	ptr = norm_name;

	while (*ptr != '\0') {
	        *ptr = tolower(*ptr);
	        ptr++;
	}
#endif
	if (row_search_check_if_query_cache_permitted(trx, norm_name)) {

		printf("Query cache for %s permitted\n", norm_name);

		return((my_bool)TRUE);
	}

	printf("Query cache for %s NOT permitted\n", norm_name);

	return((my_bool)FALSE);
}

extern "C" {
/*********************************************************************
Invalidates the MySQL query cache for the table.
NOTE that the exact prototype of this function has to be in
/innobase/row/row0ins.c! */

void
innobase_invalidate_query_cache(
/*============================*/
	trx_t*	trx,		/* in: transaction which modifies the table */
	char*	full_name,	/* in: concatenation of database name, null
580 581 582 583 584
				char '\0', table name, null char'\0';
				NOTE that in Windows this is always
				in LOWER CASE! */
	ulint	full_name_len)	/* in: full name length where also the null
				chars count */
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
585 586
{
	/* Argument TRUE below means we are using transactions */
587
#ifdef HAVE_QUERY_CACHE
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
588 589 590 591
	query_cache.invalidate((THD*)(trx->mysql_thd),
					(const char*)full_name,
					(uint32)full_name_len,
					TRUE);
592
#endif
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
593 594 595
}
}

596 597 598 599 600 601 602 603 604 605 606 607 608 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
/*********************************************************************
Call this when you have opened a new table handle in HANDLER, before you
call index_read_idx() etc. Actually, we can let the cursor stay open even
over a transaction commit! Then you should call this before every operation,
fecth next etc. This function inits the necessary things even after a
transaction commit. */

void
ha_innobase::init_table_handle_for_HANDLER(void)
/*============================================*/
{
        row_prebuilt_t* prebuilt;

        /* If current thd does not yet have a trx struct, create one.
        If the current handle does not yet have a prebuilt struct, create
        one. Update the trx pointers in the prebuilt struct. Normally
        this operation is done in external_lock. */

        update_thd(current_thd);

        /* Initialize the prebuilt struct much like it would be inited in
        external_lock */

        prebuilt = (row_prebuilt_t*)innobase_prebuilt;

        /* If the transaction is not started yet, start it */

        trx_start_if_not_started_noninline(prebuilt->trx);

        /* Assign a read view if the transaction does not have it yet */

        trx_assign_read_view(prebuilt->trx);

        /* We did the necessary inits in this function, no need to repeat them
        in row_search_for_mysql */

        prebuilt->sql_stat_start = FALSE;

        /* We let HANDLER always to do the reads as consistent reads, even
        if the trx isolation level would have been specified as SERIALIZABLE */

        prebuilt->select_lock_type = LOCK_NONE;

        /* Always fetch all columns in the index record */

        prebuilt->hint_no_need_to_fetch_extra_cols = FALSE;

        /* We want always to fetch all columns in the whole row? Or do
	we???? */

        prebuilt->read_just_key = FALSE;
}

649
/*************************************************************************
650
Opens an InnoDB database. */
651

652
bool
653 654
innobase_init(void)
/*===============*/
655
			/* out: TRUE if error */
656
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
657
	static char current_dir[3];		// Set if using current lib
658 659
	int		err;
	bool		ret;
660
	char 	        *default_path;
monty@hundin.mysql.fi's avatar
merge  
monty@hundin.mysql.fi committed
661

662 663
  	DBUG_ENTER("innobase_init");

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
664
  	os_innodb_umask = (ulint)my_umask;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
665

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
666 667 668 669 670 671 672 673 674 675 676 677 678 679
	/* First calculate the default path for innodb_data_home_dir etc.,
	in case the user has not given any value.

	Note that when using the embedded server, the datadirectory is not
	necessarily the current directory of this program. */

	if (mysql_embedded) {
		default_path = mysql_real_data_home;
	} else {
	  	/* It's better to use current lib, to keep paths short */
	  	current_dir[0] = FN_CURLIB;
	  	current_dir[1] = FN_LIBCHAR;
	  	current_dir[2] = 0;
	  	default_path = current_dir;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
680 681
	}

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
682 683
	ut_a(default_path);

684 685 686 687 688 689
	if (specialflag & SPECIAL_NO_PRIOR) {
	        srv_set_thread_priorities = FALSE;
	} else {
	        srv_set_thread_priorities = TRUE;
	        srv_query_thread_priority = QUERY_PRIOR;
	}
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
690 691 692
	
	/* Set InnoDB initialization parameters according to the values
	read from MySQL .cnf file */
693

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
694 695 696
	/*--------------- Data files -------------------------*/

	/* The default dir for data files is the datadir of MySQL */
697 698

	srv_data_home = (innobase_data_home_dir ? innobase_data_home_dir :
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
699
			 default_path);
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
700

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716
	/* Set default InnoDB data file size to 10 MB and let it be
  	auto-extending. Thus users can use InnoDB in >= 4.0 without having
	to specify any startup options. */

	if (!innobase_data_file_path) {
  		innobase_data_file_path = (char*) "ibdata1:10M:autoextend";
	}

	/* Since InnoDB edits the argument in the next call, we make another
	copy of it: */

	internal_innobase_data_file_path = my_strdup(innobase_data_file_path,
						   MYF(MY_WME));

	ret = (bool) srv_parse_data_file_paths_and_sizes(
				internal_innobase_data_file_path,
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
717 718 719 720 721 722
				&srv_data_file_names,
				&srv_data_file_sizes,
				&srv_data_file_is_raw_partition,
				&srv_n_data_files,
				&srv_auto_extend_last_data_file,
				&srv_last_file_size_max);
723
	if (ret == FALSE) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
724 725 726
	  	sql_print_error(
			"InnoDB: syntax error in innodb_data_file_path");
	  	DBUG_RETURN(TRUE);
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
727
	}
728

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
729 730 731 732 733 734 735 736 737 738 739 740 741 742 743
	/* -------------- Log files ---------------------------*/

	/* The default dir for log files is the datadir of MySQL */
	
	if (!innobase_log_group_home_dir) {
	  	innobase_log_group_home_dir = default_path;
	}
	  	
	/* Since innodb_log_arch_dir has no relevance under MySQL,
	starting from 4.0.6 we always set it the same as
	innodb_log_group_home_dir: */

	innobase_log_arch_dir = innobase_log_group_home_dir;

	srv_arch_dir = innobase_log_arch_dir;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
744

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
745 746 747
	ret = (bool)
		srv_parse_log_group_home_dirs(innobase_log_group_home_dir,
						&srv_log_group_home_dirs);
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
748

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
749 750 751 752
	if (ret == FALSE || innobase_mirrored_log_groups != 1) {
		fprintf(stderr,
		"InnoDB: syntax error in innodb_log_group_home_dir\n"
		"InnoDB: or a wrong number of mirrored log groups\n");
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
753

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
754
		DBUG_RETURN(TRUE);
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
755
	}
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
756

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
757 758 759
	/* --------------------------------------------------*/

	srv_file_flush_method_str = innobase_unix_file_flush_method;
760

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
761
	srv_n_log_groups = (ulint) innobase_mirrored_log_groups;
762
	srv_n_log_files = (ulint) innobase_log_files_in_group;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
763 764 765 766
	srv_log_file_size = (ulint) innobase_log_file_size;

	srv_log_archive_on = (ulint) innobase_log_archive;
	srv_log_buffer_size = (ulint) innobase_log_buffer_size;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
767
	srv_flush_log_at_trx_commit = (ulint) innobase_flush_log_at_trx_commit;
768

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
769
	srv_pool_size = (ulint) innobase_buffer_pool_size;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
770

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
771 772 773
	srv_mem_pool_size = (ulint) innobase_additional_mem_pool_size;

	srv_n_file_io_threads = (ulint) innobase_file_io_threads;
774

775
	srv_lock_wait_timeout = (ulint) innobase_lock_wait_timeout;
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
776 777 778 779
	srv_thread_concurrency = (ulint) innobase_thread_concurrency;
	srv_force_recovery = (ulint) innobase_force_recovery;

	srv_fast_shutdown = (ibool) innobase_fast_shutdown;
780

781
	srv_print_verbose_log = mysql_embedded ? 0 : 1;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
782

783
	if (strcmp(default_charset_info->name, "latin1") == 0) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
784

785 786 787 788
		/* Store the character ordering table to InnoDB.
		For non-latin1 charsets we use the MySQL comparison
		functions, and consequently we do not need to know
		the ordering internally in InnoDB. */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
789

790 791 792
		memcpy(srv_latin1_ordering,
				default_charset_info->sort_order, 256);
	}
793

794 795 796 797 798 799 800 801
	/* Since we in this module access directly the fields of a trx
        struct, and due to different headers and flags it might happen that
	mutex_t has a different size in this module and in InnoDB
	modules, we check at run time that the size is the same in
	these compilation modules. */

	srv_sizeof_trx_t_in_ha_innodb_cc = sizeof(trx_t);

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
802
	err = innobase_start_or_create_for_mysql();
803 804 805

	if (err != DB_SUCCESS) {

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
806
		DBUG_RETURN(1);
807
	}
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
808

809
	(void) hash_init(&innobase_open_tables,32,0,0,
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
810
			 		(hash_get_key) innobase_get_key,0,0);
811
	pthread_mutex_init(&innobase_mutex,MY_MUTEX_INIT_FAST);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827

	/* If this is a replication slave and we needed to do a crash recovery,
	set the master binlog position to what InnoDB internally knew about
	how far we got transactions durable inside InnoDB. There is a
	problem here: if the user used also MyISAM tables, InnoDB might not
	know the right position for them.

	THIS DOES NOT WORK CURRENTLY because replication seems to initialize
	glob_mi also after innobase_init. */
	
/*	if (trx_sys_mysql_master_log_pos != -1) {
		ut_memcpy(glob_mi.log_file_name, trx_sys_mysql_master_log_name,
				1 + ut_strlen(trx_sys_mysql_master_log_name));
		glob_mi.pos = trx_sys_mysql_master_log_pos;
	}
*/
828
  	DBUG_RETURN(0);
829 830 831
}

/***********************************************************************
832
Closes an InnoDB database. */
833

834
bool
835 836
innobase_end(void)
/*==============*/
837
				/* out: TRUE if error */
838 839 840 841 842 843
{
	int	err;

	DBUG_ENTER("innobase_end");

	err = innobase_shutdown_for_mysql();
844
	hash_free(&innobase_open_tables);
monty@tik.mysql.fi's avatar
monty@tik.mysql.fi committed
845
	my_free(internal_innobase_data_file_path,MYF(MY_ALLOW_ZERO_PTR));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
846
	pthread_mutex_destroy(&innobase_mutex);
847 848 849

	if (err != DB_SUCCESS) {

850
	  DBUG_RETURN(1);
851
	}
852

853
  	DBUG_RETURN(0);
854 855 856
}

/********************************************************************
857
Flushes InnoDB logs to disk and makes a checkpoint. Really, a commit
858 859
flushes logs, and the name of this function should be innobase_checkpoint. */

860
bool
861 862
innobase_flush_logs(void)
/*=====================*/
863
				/* out: TRUE if error */
864
{
865
  	bool 	result = 0;
866 867 868

  	DBUG_ENTER("innobase_flush_logs");

869
	log_flush_up_to(ut_dulint_max, LOG_WAIT_ONE_GROUP);
870

871 872 873
  	DBUG_RETURN(result);
}

874
/*************************************************************************
875
Gets the free space in an InnoDB database: returned in units of kB. */
876 877 878 879 880 881 882 883 884

uint
innobase_get_free_space(void)
/*=========================*/
			/* out: free space in kB */
{
	return((uint) fsp_get_available_space_in_free_extents(0));
}

885
/*********************************************************************
886
Commits a transaction in an InnoDB database. */
887

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
888 889 890 891 892
void
innobase_commit_low(
/*================*/
	trx_t*	trx)	/* in: transaction handle */
{
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
893 894 895 896
        /* TODO: Guilhem should check if master_log_name, pending
        etc. are right if the master log gets rotated! Possible bug here.
	Comment by Heikki March 4, 2003. */

897 898
        if (current_thd->slave_thread) {
                /* Update the replication position info inside InnoDB */
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
899

900 901 902
                trx->mysql_master_log_file_name
                                        = active_mi->rli.master_log_name;
                trx->mysql_master_log_pos = ((ib_longlong)
903 904 905
					 (active_mi->rli.master_log_pos +
					  active_mi->rli.event_len +
					  active_mi->rli.pending));
906 907
        }
        trx_commit_for_mysql(trx);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
908 909 910 911 912
}

/*********************************************************************
Commits a transaction in an InnoDB database. */

913 914 915 916
int
innobase_commit(
/*============*/
			/* out: 0 or error number */
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
917
	THD*	thd,	/* in: MySQL thread handle of the user for whom
918
			the transaction should be committed */
919 920
	void*	trx_handle)/* in: InnoDB trx handle or
			&innodb_dummy_stmt_trx_handle: the latter means
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
921 922
			that the current SQL statement ended, and we should
			mark the start of a new statement with a savepoint */
923 924
{
	int	error	= 0;
925
	trx_t*	trx;
926 927 928 929

  	DBUG_ENTER("innobase_commit");
  	DBUG_PRINT("trans", ("ending transaction"));

930
	trx = check_trx_exists(thd);
931

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
932 933 934 935 936 937 938 939 940 941
        if (trx->auto_inc_lock) {
		  	
		/* If we had reserved the auto-inc lock for
		some table in this SQL statement, we release it now */
		  	
		srv_conc_enter_innodb(trx);
		row_unlock_table_autoinc_for_mysql(trx);
		srv_conc_exit_innodb(trx);
	}

942
	if (trx_handle != (void*)&innodb_dummy_stmt_trx_handle) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
943
		innobase_commit_low(trx);
944
		thd->transaction.all.innodb_active_trans=0;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
945
	}
946

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
947 948
	/* Release possible statement level resources */
	innobase_release_stat_resources(trx);
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
949 950
	trx_mark_sql_stat_end(trx);

951 952 953 954 955
#ifndef DBUG_OFF
	if (error) {
    		DBUG_PRINT("error", ("error: %d", error));
    	}
#endif
956
	/* Tell InnoDB server that there might be work for
957 958 959 960 961 962 963
	utility threads: */

	srv_active_wake_master_thread();

	DBUG_RETURN(error);
}

964 965 966 967 968 969 970 971 972
/*********************************************************************
This is called when MySQL writes the binlog entry for the current
transaction. Writes to the InnoDB tablespace info which tells where the
MySQL binlog entry for the current transaction ended. Also commits the
transaction inside InnoDB. */

int
innobase_report_binlog_offset_and_commit(
/*=====================================*/
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
973
                                /* out: 0 or error code */
974
        THD*    thd,            /* in: user thread */
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
975
        void*   trx_handle,     /* in: InnoDB trx handle */
976 977
        char*   log_file_name,  /* in: latest binlog file name */
        my_off_t end_offset)    /* in: the offset in the binlog file
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
978
                                   up to which we wrote */
979
{
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
980 981 982
	trx_t*	trx;

	trx = (trx_t*)trx_handle;
983

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
984 985
	ut_a(trx != NULL);

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
986 987 988 989
	trx->mysql_log_file_name = log_file_name;  	
	trx->mysql_log_offset = (ib_longlong)end_offset;
	
  	return(innobase_commit(thd, trx_handle));
990 991
}

992
/*********************************************************************
993
Rolls back a transaction in an InnoDB database. */
994 995 996 997 998

int
innobase_rollback(
/*==============*/
			/* out: 0 or error number */
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
999
	THD*	thd,	/* in: handle to the MySQL thread of the user
1000
			whose transaction should be rolled back */
1001 1002 1003
	void*	trx_handle)/* in: InnoDB trx handle or a dummy stmt handle;
			the latter means we roll back the latest SQL
			statement */
1004 1005
{
	int	error = 0;
1006
	trx_t*	trx;
1007

1008 1009 1010
	DBUG_ENTER("innobase_rollback");
	DBUG_PRINT("trans", ("aborting transaction"));

1011
	trx = check_trx_exists(thd);
1012

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1013 1014 1015 1016 1017 1018 1019 1020 1021 1022
        if (trx->auto_inc_lock) {
		  	
		/* If we had reserved the auto-inc lock for
		some table in this SQL statement, we release it now */
		  	
		srv_conc_enter_innodb(trx);
		row_unlock_table_autoinc_for_mysql(trx);
		srv_conc_exit_innodb(trx);
	}

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1023 1024
	srv_conc_enter_innodb(trx);

1025
	if (trx_handle != (void*)&innodb_dummy_stmt_trx_handle) {
1026
		error = trx_rollback_for_mysql(trx);
1027
		thd->transaction.all.innodb_active_trans=0;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1028
	} else {
1029
		error = trx_rollback_last_sql_stat_for_mysql(trx);
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1030
	}
1031

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
1032 1033 1034 1035
	srv_conc_exit_innodb(trx);

	/* Release possible statement level resources */
	innobase_release_stat_resources(trx);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1036

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1037 1038
	trx_mark_sql_stat_end(trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1039
	DBUG_RETURN(convert_error_code_to_mysql(error, NULL));
1040 1041 1042
}

/*********************************************************************
1043
Frees a possible InnoDB trx object associated with the current
1044 1045 1046 1047 1048 1049 1050 1051 1052
THD. */

int
innobase_close_connection(
/*======================*/
			/* out: 0 or error number */
	THD*	thd)	/* in: handle to the MySQL thread of the user
			whose transaction should be rolled back */
{
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1053
	if (NULL != thd->transaction.all.innobase_tid) {
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
1054

1055 1056
	        trx_rollback_for_mysql((trx_t*)
				(thd->transaction.all.innobase_tid));
1057
		trx_free_for_mysql((trx_t*)
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1058
				(thd->transaction.all.innobase_tid));
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1059
		thd->transaction.all.innobase_tid = NULL;
1060 1061 1062
	}

	return(0);
1063
}
1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078

/**********************************************************************
Prints an error message. */
static
void
innobase_print_error(
/*=================*/
	const char*	db_errpfx,	/* in: error prefix text */
	char*		buffer)		/* in: error text */
{
  	sql_print_error("%s:  %s", db_errpfx, buffer);
}


/*****************************************************************************
1079
** InnoDB database tables
1080 1081 1082
*****************************************************************************/

/********************************************************************
1083 1084 1085
This function is not relevant since we store the tables and indexes
into our own tablespace, not as files, whose extension this function would
give. */
1086 1087 1088 1089

const char**
ha_innobase::bas_ext() const
/*========================*/
1090 1091
				/* out: file extension strings, currently not
				used */
1092
{
1093
	static const char* ext[] = {".InnoDB", NullS};
1094

1095 1096 1097
	return(ext);
}

1098 1099 1100
/*********************************************************************
Normalizes a table name string. A normalized name consists of the
database name catenated to '/' and table name. An example:
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
1101 1102
test/mytable. On Windows normalization puts both the database name and the
table name always to lower case. */
1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116
static
void
normalize_table_name(
/*=================*/
	char*		norm_name,	/* out: normalized name as a
					null-terminated string */
	const char*	name)		/* in: table name string */
{
	char*	name_ptr;
	char*	db_ptr;
	char*	ptr;

	/* Scan name from the end */

1117
	ptr = strend(name)-1;
1118 1119 1120 1121 1122 1123 1124

	while (ptr >= name && *ptr != '\\' && *ptr != '/') {
		ptr--;
	}

	name_ptr = ptr + 1;

monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
1125
	DBUG_ASSERT(ptr > name);
1126 1127

	ptr--;
1128

1129 1130 1131 1132 1133 1134 1135 1136 1137
	while (ptr >= name && *ptr != '\\' && *ptr != '/') {
		ptr--;
	}

	db_ptr = ptr + 1;

	memcpy(norm_name, db_ptr, strlen(name) + 1 - (db_ptr - name));

	norm_name[name_ptr - db_ptr - 1] = '/';
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148

#ifdef __WIN__
	/* Put to lower case */

	ptr = norm_name;

	while (*ptr != '\0') {
	        *ptr = tolower(*ptr);
	        ptr++;
	}
#endif
1149
}
1150

1151
/*********************************************************************
1152
Creates and opens a handle to a table which already exists in an InnoDB
1153 1154 1155 1156 1157 1158 1159 1160
database. */

int
ha_innobase::open(
/*==============*/
					/* out: 1 if error, 0 if success */
	const char*	name,		/* in: table name */
	int 		mode,		/* in: not used */
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1161
	uint 		test_if_locked)	/* in: not used */
1162
{
1163 1164 1165 1166
	dict_table_t*	ib_table;
  	int 		error	= 0;
  	uint		buff_len;
  	char		norm_name[1000];
1167 1168 1169 1170 1171 1172

	DBUG_ENTER("ha_innobase::open");

	UT_NOT_USED(mode);
	UT_NOT_USED(test_if_locked);

1173 1174
	normalize_table_name(norm_name, name);

1175 1176
	user_thd = NULL;

1177 1178
	last_query_id = (ulong)-1;

1179 1180 1181
	if (!(share=get_share(name)))
	  DBUG_RETURN(1);

1182 1183 1184 1185
	/* Create buffers for packing the fields of a record. Why
	table->reclength did not work here? Obviously, because char
	fields when packed actually became 1 byte longer, when we also
	stored the string length as the first byte. */
1186 1187

	buff_len = table->reclength + table->max_key_length
1188
							+ MAX_REF_PARTS * 3;
1189
	if (!(mysql_byte*) my_multi_malloc(MYF(MY_WME),
1190 1191
				     &upd_buff, buff_len,
				     &key_val_buff, buff_len,
1192
				     NullS)) {
1193
	  	free_share(share);
1194
	  	DBUG_RETURN(1);
1195 1196
  	}

1197
	/* Get pointer to a table object in InnoDB dictionary cache */
1198

1199 1200 1201
	ib_table = dict_table_get_and_increment_handle_count(
				      		     norm_name, NULL);
 	if (NULL == ib_table) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1202 1203 1204 1205 1206 1207 1208 1209 1210
	        ut_print_timestamp(stderr);
	        fprintf(stderr, "  InnoDB error:\n"
"Cannot find table %s from the internal data dictionary\n"
"of InnoDB though the .frm file for the table exists. Maybe you\n"
"have deleted and recreated InnoDB data files but have forgotten\n"
"to delete the corresponding .frm files of InnoDB tables, or you\n"
"have moved .frm files to another database?\n"
"Look from section 15.1 of http://www.innodb.com/ibman.html\n"
"how you can resolve the problem.\n",
1211
			  norm_name);
1212

1213
	        free_share(share);
1214
    		my_free((char*) upd_buff, MYF(0));
1215 1216 1217 1218
    		my_errno = ENOENT;
    		DBUG_RETURN(1);
  	}

1219
	innobase_prebuilt = row_create_prebuilt(ib_table);
1220

1221
	((row_prebuilt_t*)innobase_prebuilt)->mysql_row_len = table->reclength;
1222

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1223 1224 1225 1226
	/* Looks like MySQL-3.23 sometimes has primary key number != 0 */

 	primary_key = table->primary_key;
	key_used_on_scan = primary_key;
1227

1228 1229 1230 1231 1232
	/* Allocate a buffer for a 'row reference'. A row reference is
	a string of bytes of length ref_length which uniquely specifies
        a row in our table. Note that MySQL may also compare two row
        references for equality by doing a simple memcmp on the strings
        of length ref_length! */
1233

1234
  	if (!row_table_got_default_clust_index(ib_table)) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1235 1236 1237 1238 1239
	        if (primary_key >= MAX_KEY) {
	                fprintf(stderr,
		    "InnoDB: Error: table %s has a primary key in InnoDB\n"
		    "InnoDB: data dictionary, but not in MySQL!\n", name);
		}
1240 1241 1242

		((row_prebuilt_t*)innobase_prebuilt)
				->clust_index_was_generated = FALSE;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1243
 		/*
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1244 1245 1246 1247 1248
		  MySQL allocates the buffer for ref. key_info->key_length
		  includes space for all key columns + one byte for each column
		  that may be NULL. ref_length must be as exact as possible to
		  save space, because all row reference buffers are allocated
		  based on ref_length.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1249
		*/
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1250
 
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1251
  		ref_length = table->key_info[primary_key].key_length;
1252
	} else {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1253 1254 1255
	        if (primary_key != MAX_KEY) {
	                fprintf(stderr,
		    "InnoDB: Error: table %s has no primary key in InnoDB\n"
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1256 1257 1258 1259 1260 1261 1262 1263
		    "InnoDB: data dictionary, but has one in MySQL!\n"
		    "InnoDB: If you created the table with a MySQL\n"
                    "InnoDB: version < 3.23.54 and did not define a primary\n"
                    "InnoDB: key, but defined a unique key with all non-NULL\n"
                    "InnoDB: columns, then MySQL internally treats that key\n"
                    "InnoDB: as the primary key. You can fix this error by\n"
		    "InnoDB: dump + DROP + CREATE + reimport of the table.\n",
				name);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1264 1265
		}

1266 1267 1268
		((row_prebuilt_t*)innobase_prebuilt)
				->clust_index_was_generated = TRUE;

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1269
  		ref_length = DATA_ROW_ID_LEN;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1270

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1271 1272 1273 1274 1275 1276 1277 1278 1279
		/*
		  If we automatically created the clustered index, then
		  MySQL does not know about it, and MySQL must NOT be aware
		  of the index used on scan, to make it avoid checking if we
		  update the column of the index. That is why we assert below
		  that key_used_on_scan is the undefined value MAX_KEY.
		  The column is the row id in the automatical generation case,
		  and it will never be updated anyway.
		*/
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1280 1281 1282 1283 1284 1285 1286
	       
		if (key_used_on_scan != MAX_KEY) {
	                fprintf(stderr,
"InnoDB: Warning: table %s key_used_on_scan is %lu even though there is no\n"
"InnoDB: primary key inside InnoDB.\n",
				name, (ulint)key_used_on_scan);
		}
1287
	}
1288

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1289 1290
	auto_inc_counter_for_this_stat = 0;

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1291 1292 1293
	block_size = 16 * 1024;	/* Index block size in InnoDB: used by MySQL
				in query optimization */

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1294
	/* Init table lock structure */
1295
	thr_lock_data_init(&share->lock,&lock,(void*) 0);
1296 1297

  	info(HA_STATUS_NO_LOCK | HA_STATUS_VARIABLE | HA_STATUS_CONST);
1298

1299 1300 1301 1302 1303 1304 1305 1306 1307 1308
  	DBUG_RETURN(0);
}

/*********************************************************************
Does nothing. */

void
ha_innobase::initialize(void)
/*=========================*/
{
1309
}
1310 1311

/**********************************************************************
1312
Closes a handle to an InnoDB table. */
1313 1314 1315 1316 1317 1318 1319 1320 1321 1322

int
ha_innobase::close(void)
/*====================*/
				/* out: error number */
{
  	DBUG_ENTER("ha_innobase::close");

	row_prebuilt_free((row_prebuilt_t*) innobase_prebuilt);

1323
    	my_free((char*) upd_buff, MYF(0));
1324 1325
        free_share(share);

1326
	/* Tell InnoDB server that there might be work for
1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342
	utility threads: */

	srv_active_wake_master_thread();

  	DBUG_RETURN(0);
}

/* The following accessor functions should really be inside MySQL code! */

/******************************************************************
Gets field offset for a field in a table. */
inline
uint
get_field_offset(
/*=============*/
			/* out: offset */
1343
	TABLE*	table,	/* in: MySQL table object */
1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356
	Field*	field)	/* in: MySQL field object */
{
	return((uint) (field->ptr - (char*) table->record[0]));
}

/******************************************************************
Checks if a field in a record is SQL NULL. Uses the record format
information in table to track the null bit in record. */
inline
uint
field_in_record_is_null(
/*====================*/
			/* out: 1 if NULL, 0 otherwise */
1357
	TABLE*	table,	/* in: MySQL table object */
1358 1359 1360 1361 1362 1363 1364 1365 1366
	Field*	field,	/* in: MySQL field object */
	char*	record)	/* in: a row in MySQL format */
{
	int	null_offset;

	if (!field->null_ptr) {

		return(0);
	}
1367

1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385
	null_offset = (uint) ((char*) field->null_ptr
					- (char*) table->record[0]);

	if (record[null_offset] & field->null_bit) {

		return(1);
	}

	return(0);
}

/******************************************************************
Sets a field in a record to SQL NULL. Uses the record format
information in table to track the null bit in record. */
inline
void
set_field_in_record_to_null(
/*========================*/
1386
	TABLE*	table,	/* in: MySQL table object */
1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403
	Field*	field,	/* in: MySQL field object */
	char*	record)	/* in: a row in MySQL format */
{
	int	null_offset;

	null_offset = (uint) ((char*) field->null_ptr
					- (char*) table->record[0]);

	record[null_offset] = record[null_offset] | field->null_bit;
}

/******************************************************************
Resets SQL NULL bits in a record to zero. */
inline
void
reset_null_bits(
/*============*/
1404
	TABLE*	table,	/* in: MySQL table object */
1405 1406 1407 1408 1409 1410 1411
	char*	record)	/* in: a row in MySQL format */
{
	bzero(record, table->null_bytes);
}

extern "C" {
/*****************************************************************
1412
InnoDB uses this function is to compare two data fields for which the
1413
data type is such that we must use MySQL code to compare them. NOTE that the
1414
prototype of this function is in rem0cmp.c in InnoDB source code!
1415
If you change this function, remember to update the prototype there! */
1416 1417 1418

int
innobase_mysql_cmp(
1419
/*===============*/
1420 1421
					/* out: 1, 0, -1, if a is greater,
					equal, less than b, respectively */
1422
	int		mysql_type,	/* in: MySQL type */
1423 1424 1425 1426 1427 1428 1429 1430
	unsigned char*	a,		/* in: data field */
	unsigned int	a_length,	/* in: data field length,
					not UNIV_SQL_NULL */
	unsigned char*	b,		/* in: data field */
	unsigned int	b_length)	/* in: data field length,
					not UNIV_SQL_NULL */
{
	enum_field_types	mysql_tp;
1431
	int                     ret;
1432

monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
1433 1434
	DBUG_ASSERT(a_length != UNIV_SQL_NULL);
	DBUG_ASSERT(b_length != UNIV_SQL_NULL);
1435 1436 1437 1438 1439 1440 1441

	mysql_tp = (enum_field_types) mysql_type;

	switch (mysql_tp) {

	case FIELD_TYPE_STRING:
	case FIELD_TYPE_VAR_STRING:
1442 1443 1444
  		ret = my_sortncmp((const char*) a, a_length,
				  (const char*) b, b_length);
		if (ret < 0) {
1445
		        return(-1);
1446
		} else if (ret > 0) {
1447
		        return(1);
1448
		} else {
1449
		        return(0);
1450
	        }
1451 1452 1453 1454 1455 1456 1457 1458 1459
	default:
		assert(0);
	}

	return(0);
}
}

/******************************************************************
1460
Converts a MySQL type to an InnoDB type. */
1461 1462
inline
ulint
1463 1464 1465
get_innobase_type_from_mysql_type(
/*==============================*/
			/* out: DATA_BINARY, DATA_VARCHAR, ... */
1466 1467 1468
	Field*	field)	/* in: MySQL field */
{
	/* The following asserts check that MySQL type code fits in
1469 1470
	8 bits: this is used in ibuf and also when DATA_NOT_NULL is
	ORed to the type */
1471

monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
1472 1473 1474 1475 1476
	DBUG_ASSERT((ulint)FIELD_TYPE_STRING < 256);
	DBUG_ASSERT((ulint)FIELD_TYPE_VAR_STRING < 256);
	DBUG_ASSERT((ulint)FIELD_TYPE_DOUBLE < 256);
	DBUG_ASSERT((ulint)FIELD_TYPE_FLOAT < 256);
	DBUG_ASSERT((ulint)FIELD_TYPE_DECIMAL < 256);
1477 1478

	switch (field->type()) {
1479
		case FIELD_TYPE_VAR_STRING: if (field->flags & BINARY_FLAG) {
1480 1481 1482 1483 1484 1485

						return(DATA_BINARY);
					} else if (strcmp(
						   default_charset_info->name,
							"latin1") == 0) {
						return(DATA_VARCHAR);
1486 1487
					} else {
						return(DATA_VARMYSQL);
1488
					}
1489 1490 1491 1492 1493 1494 1495
		case FIELD_TYPE_STRING: if (field->flags & BINARY_FLAG) {

						return(DATA_FIXBINARY);
					} else if (strcmp(
						   default_charset_info->name,
							"latin1") == 0) {
						return(DATA_CHAR);
1496 1497
					} else {
						return(DATA_MYSQL);
1498
					}
1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509
		case FIELD_TYPE_LONG:
		case FIELD_TYPE_LONGLONG:
		case FIELD_TYPE_TINY:
		case FIELD_TYPE_SHORT:
		case FIELD_TYPE_INT24:
		case FIELD_TYPE_DATE:
		case FIELD_TYPE_DATETIME:
		case FIELD_TYPE_YEAR:
		case FIELD_TYPE_NEWDATE:
		case FIELD_TYPE_ENUM:
		case FIELD_TYPE_SET:
1510 1511 1512
		case FIELD_TYPE_TIME:
		case FIELD_TYPE_TIMESTAMP:
					return(DATA_INT);
1513
		case FIELD_TYPE_FLOAT:
1514
					return(DATA_FLOAT);
1515
		case FIELD_TYPE_DOUBLE:
1516
					return(DATA_DOUBLE);
1517
		case FIELD_TYPE_DECIMAL:
1518 1519 1520 1521 1522 1523
					return(DATA_DECIMAL);
		case FIELD_TYPE_TINY_BLOB:
		case FIELD_TYPE_MEDIUM_BLOB:
		case FIELD_TYPE_BLOB:
		case FIELD_TYPE_LONG_BLOB:
					return(DATA_BLOB);
1524 1525 1526 1527 1528 1529
		default:
					assert(0);
	}

	return(0);
}
1530

1531
/***********************************************************************
1532 1533
Stores a key value for a row to a buffer. This must currently only be used
to store a row reference to the 'ref' buffer of this table handle! */
1534 1535 1536 1537 1538 1539 1540

uint
ha_innobase::store_key_val_for_row(
/*===============================*/
				/* out: key value length as stored in buff */
	uint 		keynr,	/* in: key number */
	char*		buff,	/* in/out: buffer for the key value (in MySQL
1541 1542
				format); currently this MUST be the 'ref'
				buffer! */
1543
	const mysql_byte* record)/* in: row in MySQL format */
1544 1545 1546 1547 1548
{
	KEY*		key_info 	= table->key_info + keynr;
  	KEY_PART_INFO*	key_part	= key_info->key_part;
  	KEY_PART_INFO*	end		= key_part + key_info->key_parts;
	char*		buff_start	= buff;
1549

1550 1551 1552 1553 1554 1555 1556 1557 1558
  	DBUG_ENTER("store_key_val_for_row");

  	for (; key_part != end; key_part++) {

    		if (key_part->null_bit) {
      			/* Store 0 if the key part is a NULL part */

      			if (record[key_part->null_offset]
						& key_part->null_bit) {
1559
				*buff++ = 1;
1560 1561 1562
				continue;
      			}

1563
      			*buff++ = 0;
1564
    		}
1565

1566 1567 1568 1569
		memcpy(buff, record + key_part->offset, key_part->length);
		buff += key_part->length;
  	}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1570
	/*
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1571 1572 1573
	  We have to zero-fill the 'ref' buffer so that MySQL is able to
	  use a simple memcmp to compare two key values to determine if they
	  are equal
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1574 1575
	*/
	bzero(buff, (ref_length- (uint) (buff - buff_start)));
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1576 1577

	DBUG_RETURN((uint)(buff - buff_start));
1578 1579 1580
}

/******************************************************************
1581
Builds a template to the prebuilt struct. */
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1582
static
1583
void
1584 1585 1586 1587 1588 1589 1590 1591 1592
build_template(
/*===========*/
	row_prebuilt_t*	prebuilt,	/* in: prebuilt struct */
	THD*		thd,		/* in: current user thread, used
					only if templ_type is
					ROW_MYSQL_REC_FIELDS */
	TABLE*		table,		/* in: MySQL table */
	ulint		templ_type)	/* in: ROW_MYSQL_WHOLE_ROW or
					ROW_MYSQL_REC_FIELDS */
1593
{
1594 1595
	dict_index_t*	index;
	dict_index_t*	clust_index;
1596
	mysql_row_templ_t* templ;
1597
	Field*		field;
1598 1599
	ulint		n_fields;
	ulint		n_requested_fields	= 0;
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1600
	ibool		fetch_all_in_key	= FALSE;
1601
	ulint		i;
1602

1603
	clust_index = dict_table_get_first_index_noninline(prebuilt->table);
1604

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1605 1606 1607 1608
	if (!prebuilt->hint_no_need_to_fetch_extra_cols) {
		/* We have a hint that we should at least fetch all
		columns in the key, or all columns in the table */

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1609
		if (prebuilt->read_just_key) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1610 1611
			/* MySQL has instructed us that it is enough to
			fetch the columns in the key */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1612

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1613 1614 1615
			fetch_all_in_key = TRUE;
		} else {
			/* We are building a temporary table: fetch all
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1616 1617 1618 1619 1620
 			columns; the reason is that MySQL may use the
			clustered index key to store rows, but the mechanism
			we use below to detect required columns does not
			reveal that. Actually, it might be enough to
			fetch only all in the key also in this case! */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1621

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1622 1623
			templ_type = ROW_MYSQL_WHOLE_ROW;
		}
1624 1625
	}

1626
	if (prebuilt->select_lock_type == LOCK_X) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1627 1628 1629
		/* We always retrieve the whole clustered index record if we
		use exclusive row level locks, for example, if the read is
		done in an UPDATE statement. */
1630 1631 1632 1633

	        templ_type = ROW_MYSQL_WHOLE_ROW;
	}

1634
	if (templ_type == ROW_MYSQL_REC_FIELDS) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1635 1636 1637 1638 1639
		/* In versions < 3.23.50 we always retrieved the clustered
		index record if prebuilt->select_lock_type == LOCK_S,
		but there is really not need for that, and in some cases
		performance could be seriously degraded because the MySQL
		optimizer did not know about our convention! */
1640

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1641
		index = prebuilt->index;
1642 1643
	} else {
		index = clust_index;
1644
	}
1645

1646 1647 1648 1649 1650 1651 1652
	if (index == clust_index) {
		prebuilt->need_to_access_clustered = TRUE;
	} else {
		prebuilt->need_to_access_clustered = FALSE;
		/* Below we check column by column if we need to access
		the clustered index */
	}
1653

1654 1655 1656 1657 1658 1659 1660
	n_fields = (ulint)table->fields;

	if (!prebuilt->mysql_template) {
		prebuilt->mysql_template = (mysql_row_templ_t*)
						mem_alloc_noninline(
					n_fields * sizeof(mysql_row_templ_t));
	}
1661

1662 1663
	prebuilt->template_type = templ_type;
	prebuilt->null_bitmap_len = table->null_bytes;
1664

1665 1666
	prebuilt->templ_contains_blob = FALSE;

1667
	for (i = 0; i < n_fields; i++) {
1668
		templ = prebuilt->mysql_template + n_requested_fields;
1669 1670
		field = table->field[i];

1671
		if (templ_type == ROW_MYSQL_REC_FIELDS
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1672 1673 1674
			&& !(fetch_all_in_key &&
				ULINT_UNDEFINED != dict_index_get_nth_col_pos(
								index, i))
1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685
			&& thd->query_id != field->query_id
			&& thd->query_id != (field->query_id ^ MAX_ULONG_BIT)
			&& thd->query_id !=
				(field->query_id ^ (MAX_ULONG_BIT >> 1))) {

			/* This field is not needed in the query, skip it */

			goto skip_field;
		}

		n_requested_fields++;
1686

1687
		templ->col_no = i;
1688

1689 1690 1691
		if (index == clust_index) {
			templ->rec_field_no = (index->table->cols + i)
								->clust_pos;
1692
		} else {
1693 1694
			templ->rec_field_no = dict_index_get_nth_col_pos(
								index, i);
1695 1696
		}

1697 1698 1699 1700 1701 1702 1703 1704
		if (templ->rec_field_no == ULINT_UNDEFINED) {
			prebuilt->need_to_access_clustered = TRUE;
		}

		if (field->null_ptr) {
			templ->mysql_null_byte_offset =
				(ulint) ((char*) field->null_ptr
					- (char*) table->record[0]);
1705

1706 1707 1708 1709
			templ->mysql_null_bit_mask = (ulint) field->null_bit;
		} else {
			templ->mysql_null_bit_mask = 0;
		}
1710

1711 1712
		templ->mysql_col_offset = (ulint)
					get_field_offset(table, field);
1713

1714 1715 1716
		templ->mysql_col_len = (ulint) field->pack_length();
		templ->type = get_innobase_type_from_mysql_type(field);
		templ->is_unsigned = (ulint) (field->flags & UNSIGNED_FLAG);
1717

1718 1719
		if (templ->type == DATA_BLOB) {
			prebuilt->templ_contains_blob = TRUE;
1720
		}
1721 1722 1723
skip_field:
		;
	}
1724

1725
	prebuilt->n_template = n_requested_fields;
1726

1727 1728 1729 1730 1731
	if (prebuilt->need_to_access_clustered) {
		/* Change rec_field_no's to correspond to the clustered index
		record */
		for (i = 0; i < n_requested_fields; i++) {
			templ = prebuilt->mysql_template + i;
1732

1733 1734 1735
			templ->rec_field_no =
			    (index->table->cols + templ->col_no)->clust_pos;
		}
1736
	}
1737 1738 1739
}

/************************************************************************
1740
Stores a row in an InnoDB database, to the table specified in this
1741 1742 1743 1744 1745
handle. */

int
ha_innobase::write_row(
/*===================*/
1746 1747
				/* out: error code */
	mysql_byte* 	record)	/* in: a row in MySQL format */
1748
{
1749
	row_prebuilt_t* prebuilt = (row_prebuilt_t*)innobase_prebuilt;
1750
  	int 		error;
1751
	longlong	auto_inc;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1752
	longlong	dummy;
1753 1754
	ibool           incremented_auto_inc_for_stat = FALSE;
	ibool           incremented_auto_inc_counter = FALSE;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1755
	ibool           skip_auto_inc_decr;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1756

1757
  	DBUG_ENTER("ha_innobase::write_row");
1758

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1759 1760 1761
	ut_a(prebuilt->trx ==
		(trx_t*) current_thd->transaction.all.innobase_tid);

1762 1763 1764 1765 1766
  	statistic_increment(ha_write_count, &LOCK_status);

  	if (table->time_stamp) {
    		update_timestamp(record + table->time_stamp - 1);
    	}
1767

1768 1769 1770
	if (last_query_id != user_thd->query_id) {
	        prebuilt->sql_stat_start = TRUE;
                last_query_id = user_thd->query_id;
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
1771 1772

		innobase_release_stat_resources(prebuilt->trx);
1773 1774
	}

1775
  	if (table->next_number_field && record == table->record[0]) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1776 1777
		/* This is the case where the table has an
		auto-increment column */
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802

		/* Initialize the auto-inc counter if it has not been
		initialized yet */

		if (0 == dict_table_autoinc_peek(prebuilt->table)) {

			/* This call initializes the counter */
		        error = innobase_read_and_init_auto_inc(&dummy);

			if (error) {
				/* Deadlock or lock wait timeout */

				goto func_exit;
			}

			/* We have to set sql_stat_start to TRUE because
			the above call probably has called a select, and
			has reset that flag; row_insert_for_mysql has to
			know to set the IX intention lock on the table,
			something it only does at the start of each
			statement */

			prebuilt->sql_stat_start = TRUE;
		}

1803 1804
	        /* Fetch the value the user possibly has set in the
	        autoincrement field */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1805

1806 1807
	        auto_inc = table->next_number_field->val_int();

1808 1809 1810
		/* In replication and also otherwise the auto-inc column 
		can be set with SET INSERT_ID. Then we must look at
		user_thd->next_insert_id. If it is nonzero and the user
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1811 1812 1813
		has not supplied a value, we must use it, and use values
		incremented by 1 in all subsequent inserts within the
		same SQL statement! */
1814 1815 1816

		if (auto_inc == 0 && user_thd->next_insert_id != 0) {
		        auto_inc = user_thd->next_insert_id;
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1817
		        auto_inc_counter_for_this_stat = auto_inc;
1818
		}
1819

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1820 1821 1822 1823 1824 1825
		if (auto_inc == 0 && auto_inc_counter_for_this_stat) {
			/* The user set the auto-inc counter for
			this SQL statement with SET INSERT_ID. We must
			assign sequential values from the counter. */

			auto_inc_counter_for_this_stat++;
1826
			incremented_auto_inc_for_stat = TRUE;
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1827 1828 1829 1830 1831 1832 1833

			auto_inc = auto_inc_counter_for_this_stat;

			/* We give MySQL a new value to place in the
			auto-inc column */
			user_thd->next_insert_id = auto_inc;
		}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1834

1835
		if (auto_inc != 0) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1836 1837 1838
			/* This call will calculate the max of the current
			value and the value supplied by the user and
			update the counter accordingly */
1839 1840 1841 1842 1843 1844 1845 1846

			/* We have to use the transactional lock mechanism
			on the auto-inc counter of the table to ensure
			that replication and roll-forward of the binlog
			exactly imitates also the given auto-inc values.
			The lock is released at each SQL statement's
			end. */

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
1847
			srv_conc_enter_innodb(prebuilt->trx);
1848
			error = row_lock_table_autoinc_for_mysql(prebuilt);
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
1849
			srv_conc_exit_innodb(prebuilt->trx);
1850 1851

			if (error != DB_SUCCESS) {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1852

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1853
				error = convert_error_code_to_mysql(error,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1854
								    user_thd);
1855 1856
				goto func_exit;
			}	
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1857

1858 1859
			dict_table_autoinc_update(prebuilt->table, auto_inc);
		} else {
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1860 1861
			srv_conc_enter_innodb(prebuilt->trx);

1862 1863 1864 1865 1866
			if (!prebuilt->trx->auto_inc_lock) {

				error = row_lock_table_autoinc_for_mysql(
								prebuilt);
				if (error != DB_SUCCESS) {
1867
 					srv_conc_exit_innodb(prebuilt->trx);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1868

1869
					error = convert_error_code_to_mysql(
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1870
							error, user_thd);
1871 1872 1873 1874
					goto func_exit;
				}
			}	

1875 1876 1877
			/* The following call gets the value of the auto-inc
			counter of the table and increments it by 1 */

1878
			auto_inc = dict_table_autoinc_get(prebuilt->table);
1879 1880
			incremented_auto_inc_counter = TRUE;

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
1881
			srv_conc_exit_innodb(prebuilt->trx);
1882

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1883 1884
			/* We can give the new value for MySQL to place in
			the field */
1885

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1886
			user_thd->next_insert_id = auto_inc;
1887
		}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1888

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1889 1890 1891
		/* This call of a handler.cc function places
		user_thd->next_insert_id to the column value, if the column
		value was not set by the user */
1892

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1893 1894
    		update_auto_increment();
	}
1895

1896 1897 1898 1899
	if (prebuilt->mysql_template == NULL
			|| prebuilt->template_type != ROW_MYSQL_WHOLE_ROW) {
		/* Build the template used in converting quickly between
		the two database formats */
1900

1901 1902
		build_template(prebuilt, NULL, table, ROW_MYSQL_WHOLE_ROW);
	}
1903

1904 1905 1906 1907 1908 1909 1910
	if (user_thd->lex.sql_command == SQLCOM_INSERT
	    && user_thd->lex.duplicates == DUP_IGNORE) {
	        prebuilt->trx->ignore_duplicates_in_insert = TRUE;
        } else {
	        prebuilt->trx->ignore_duplicates_in_insert = FALSE;
	}

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1911 1912
	srv_conc_enter_innodb(prebuilt->trx);

1913
	error = row_insert_for_mysql((byte*) record, prebuilt);
1914

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
1915
	srv_conc_exit_innodb(prebuilt->trx);
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
1916

1917 1918 1919
	if (error != DB_SUCCESS) {
	        /* If the insert did not succeed we restore the value of
		the auto-inc counter we used; note that this behavior was
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1920 1921 1922
		introduced only in version 4.0.4.
		NOTE that a REPLACE command handles a duplicate key error
		itself, and we must not decrement the autoinc counter
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1923 1924 1925 1926 1927 1928
		if we are performing a REPLACE statement.
		NOTE 2: if there was an error, for example a deadlock,
		which caused InnoDB to roll back the whole transaction
		already in the call of row_insert_for_mysql(), we may no
		longer have the AUTO-INC lock, and cannot decrement
		the counter here. */
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1929 1930

	        skip_auto_inc_decr = FALSE;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1931

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1932 1933 1934 1935
	        if (error == DB_DUPLICATE_KEY
		    && (user_thd->lex.sql_command == SQLCOM_REPLACE
			|| user_thd->lex.sql_command
			                 == SQLCOM_REPLACE_SELECT)) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1936 1937 1938

		        skip_auto_inc_decr= TRUE;
		}
1939

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1940 1941
	        if (!skip_auto_inc_decr && incremented_auto_inc_counter
		    && prebuilt->trx->auto_inc_lock) {
1942
	                dict_table_autoinc_decrement(prebuilt->table);
1943 1944
	        }

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1945 1946
		if (!skip_auto_inc_decr && incremented_auto_inc_for_stat
		    && prebuilt->trx->auto_inc_lock) {
1947 1948 1949 1950
		        auto_inc_counter_for_this_stat--;
		}
	}

1951 1952
	prebuilt->trx->ignore_duplicates_in_insert = FALSE;

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
1953
	error = convert_error_code_to_mysql(error, user_thd);
1954

1955
	/* Tell InnoDB server that there might be work for
1956
	utility threads: */
1957
func_exit:
1958
	innobase_active_small();
1959 1960 1961 1962

  	DBUG_RETURN(error);
}

1963
/******************************************************************
1964
Converts field data for storage in an InnoDB update vector. */
1965 1966 1967 1968 1969 1970 1971 1972 1973 1974
inline
mysql_byte*
innobase_convert_and_store_changed_col(
/*===================================*/
				/* out: pointer to the end of the converted
				data in the buffer */
	upd_field_t*	ufield,	/* in/out: field in the update vector */
	mysql_byte*	buf,	/* in: buffer we can use in conversion */
	mysql_byte*	data,	/* in: column data to store */
	ulint		len,	/* in: data len */
1975
	ulint		col_type,/* in: data type in InnoDB type numbers */
1976
	ulint		is_unsigned)/* in: != 0 if an unsigned integer type */
1977
{
1978 1979 1980 1981
	uint	i;

	if (len == UNIV_SQL_NULL) {
		data = NULL;
1982 1983
	} else if (col_type == DATA_VARCHAR || col_type == DATA_BINARY
		   || col_type == DATA_VARMYSQL) {
1984 1985 1986 1987 1988
	        /* Remove trailing spaces */
        	while (len > 0 && data[len - 1] == ' ') {
	                len--;
	        }

1989
	} else if (col_type == DATA_INT) {
1990
		/* Store integer data in InnoDB in a big-endian
1991
		format, sign bit negated, if signed */
1992

1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003
		for (i = 0; i < len; i++) {
			buf[len - 1 - i] = data[i];
		}

		if (!is_unsigned) {
			buf[0] = buf[0] ^ 128;
		}

		data = buf;

		buf += len;
2004
	}
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024

	ufield->new_val.data = data;
	ufield->new_val.len = len;

	return(buf);
}

/**************************************************************************
Checks which fields have changed in a row and stores information
of them to an update vector. */
static
int
calc_row_difference(
/*================*/
					/* out: error number or 0 */
	upd_t*		uvect,		/* in/out: update vector */
	mysql_byte* 	old_row,	/* in: old row in MySQL format */
	mysql_byte* 	new_row,	/* in: new row in MySQL format */
	struct st_table* table,		/* in: table in MySQL data dictionary */
	mysql_byte*	upd_buff,	/* in: buffer to use */
2025
	row_prebuilt_t*	prebuilt,	/* in: InnoDB prebuilt struct */
2026 2027 2028
	THD*		thd)		/* in: user thread */
{
	Field*		field;
2029 2030 2031
	uint		n_fields;
	ulint		o_len;
	ulint		n_len;
2032 2033 2034
	byte*	        o_ptr;
        byte*	        n_ptr;
        byte*	        buf;
2035
	upd_field_t*	ufield;
2036 2037
	ulint		col_type;
	ulint		is_unsigned;
2038
	ulint		n_changed = 0;
2039
	uint		i;
2040 2041 2042

	n_fields = table->fields;

2043
	/* We use upd_buff to convert changed fields */
2044
	buf = (byte*) upd_buff;
2045

2046 2047 2048
	for (i = 0; i < n_fields; i++) {
		field = table->field[i];

2049
		/* if (thd->query_id != field->query_id) { */
2050 2051
			/* TODO: check that these fields cannot have
			changed! */
2052

2053 2054
		/*	goto skip_field;
		}*/
2055

2056 2057
		o_ptr = (byte*) old_row + get_field_offset(table, field);
		n_ptr = (byte*) new_row + get_field_offset(table, field);
2058 2059 2060
		o_len = field->pack_length();
		n_len = field->pack_length();

2061
		col_type = get_innobase_type_from_mysql_type(field);
2062
		is_unsigned = (ulint) (field->flags & UNSIGNED_FLAG);
2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077

		switch (col_type) {

		case DATA_BLOB:
			o_ptr = row_mysql_read_blob_ref(&o_len, o_ptr, o_len);
			n_ptr = row_mysql_read_blob_ref(&n_len, n_ptr, n_len);
			break;
		case DATA_VARCHAR:
		case DATA_BINARY:
		case DATA_VARMYSQL:
			o_ptr = row_mysql_read_var_ref_noninline(&o_len, o_ptr);
			n_ptr = row_mysql_read_var_ref_noninline(&n_len, n_ptr);
		default:
			;
		}
2078

2079 2080 2081 2082 2083
		if (field->null_ptr) {
			if (field_in_record_is_null(table, field,
							(char*) old_row)) {
				o_len = UNIV_SQL_NULL;
			}
2084

2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096
			if (field_in_record_is_null(table, field,
							(char*) new_row)) {
				n_len = UNIV_SQL_NULL;
			}
		}

		if (o_len != n_len || (o_len != UNIV_SQL_NULL &&
					0 != memcmp(o_ptr, n_ptr, o_len))) {
			/* The field has changed */

			ufield = uvect->fields + n_changed;

2097 2098 2099 2100
			buf = (byte*)
                          innobase_convert_and_store_changed_col(ufield,
					  (mysql_byte*)buf,
					  (mysql_byte*)n_ptr, n_len, col_type,
2101
						is_unsigned);
2102
			ufield->exp = NULL;
2103 2104
			ufield->field_no =
					(prebuilt->table->cols + i)->clust_pos;
2105 2106
			n_changed++;
		}
2107
		;
2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119
	}

	uvect->n_fields = n_changed;
	uvect->info_bits = 0;

	return(0);
}

/**************************************************************************
Updates a row given as a parameter to a new value. Note that we are given
whole rows, not just the fields which are updated: this incurs some
overhead for CPU when we check which fields are actually updated.
2120
TODO: currently InnoDB does not prevent the 'Halloween problem':
2121 2122
in a searched update a single row can get updated several times
if its index columns are updated! */
2123

2124 2125 2126 2127
int
ha_innobase::update_row(
/*====================*/
					/* out: error number or 0 */
2128 2129
	const mysql_byte* 	old_row,/* in: old row in MySQL format */
	mysql_byte* 		new_row)/* in: new row in MySQL format */
2130 2131 2132 2133 2134
{
	row_prebuilt_t*	prebuilt = (row_prebuilt_t*) innobase_prebuilt;
	upd_t*		uvect;
	int		error = 0;

2135
	DBUG_ENTER("ha_innobase::update_row");
2136

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2137 2138 2139
	ut_a(prebuilt->trx ==
		(trx_t*) current_thd->transaction.all.innobase_tid);

2140 2141 2142 2143
        if (table->time_stamp) {
                update_timestamp(new_row + table->time_stamp - 1);
	}

2144 2145 2146
	if (last_query_id != user_thd->query_id) {
	        prebuilt->sql_stat_start = TRUE;
                last_query_id = user_thd->query_id;
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
2147 2148

		innobase_release_stat_resources(prebuilt->trx);
2149 2150
	}

2151 2152 2153 2154 2155
	if (prebuilt->upd_node) {
		uvect = prebuilt->upd_node->update;
	} else {
		uvect = row_get_prebuilt_update_vector(prebuilt);
	}
2156 2157 2158 2159

	/* Build an update vector from the modified fields in the rows
	(uses upd_buff of the handle) */

2160 2161
	calc_row_difference(uvect, (mysql_byte*) old_row, new_row, table,
						upd_buff, prebuilt, user_thd);
2162 2163 2164
	/* This is not a delete */
	prebuilt->upd_node->is_delete = FALSE;

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2165
	assert(prebuilt->template_type == ROW_MYSQL_WHOLE_ROW);
2166

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2167 2168
	srv_conc_enter_innodb(prebuilt->trx);

2169
	error = row_update_for_mysql((byte*) old_row, prebuilt);
2170

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
2171
	srv_conc_exit_innodb(prebuilt->trx);
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2172

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2173
	error = convert_error_code_to_mysql(error, user_thd);
2174

2175
	/* Tell InnoDB server that there might be work for
2176 2177
	utility threads: */

2178
	innobase_active_small();
2179 2180 2181 2182 2183 2184 2185 2186 2187 2188

	DBUG_RETURN(error);
}

/**************************************************************************
Deletes a row given as the parameter. */

int
ha_innobase::delete_row(
/*====================*/
2189 2190
					/* out: error number or 0 */
	const mysql_byte* record)	/* in: a row in MySQL format */
2191 2192 2193 2194
{
	row_prebuilt_t*	prebuilt = (row_prebuilt_t*) innobase_prebuilt;
	int		error = 0;

2195
	DBUG_ENTER("ha_innobase::delete_row");
2196

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2197 2198 2199
	ut_a(prebuilt->trx ==
		(trx_t*) current_thd->transaction.all.innobase_tid);

2200 2201 2202
	if (last_query_id != user_thd->query_id) {
	        prebuilt->sql_stat_start = TRUE;
                last_query_id = user_thd->query_id;
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
2203 2204

		innobase_release_stat_resources(prebuilt->trx);
2205 2206
	}

2207 2208 2209
	if (!prebuilt->upd_node) {
		row_get_prebuilt_update_vector(prebuilt);
	}
2210 2211

	/* This is a delete */
2212

2213
	prebuilt->upd_node->is_delete = TRUE;
2214

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2215 2216
	srv_conc_enter_innodb(prebuilt->trx);

2217
	error = row_update_for_mysql((byte*) record, prebuilt);
2218

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
2219
	srv_conc_exit_innodb(prebuilt->trx);
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2220

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2221
	error = convert_error_code_to_mysql(error, user_thd);
2222

2223
	/* Tell the InnoDB server that there might be work for
2224 2225
	utility threads: */

2226
	innobase_active_small();
2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242

	DBUG_RETURN(error);
}

/**********************************************************************
Initializes a handle to use an index. */

int
ha_innobase::index_init(
/*====================*/
			/* out: 0 or error number */
	uint 	keynr)	/* in: key (index) number */
{
	int 	error	= 0;
  	DBUG_ENTER("index_init");

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2243
	error = change_active_index(keynr);
2244 2245 2246 2247 2248

  	DBUG_RETURN(error);
}

/**********************************************************************
2249
Currently does nothing. */
2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262

int
ha_innobase::index_end(void)
/*========================*/
{
	int 	error	= 0;
  	DBUG_ENTER("index_end");

  	DBUG_RETURN(error);
}

/*************************************************************************
Converts a search mode flag understood by MySQL to a flag understood
2263
by InnoDB. */
2264 2265 2266 2267 2268 2269 2270 2271 2272 2273 2274 2275 2276 2277
inline
ulint
convert_search_mode_to_innobase(
/*============================*/
	enum ha_rkey_function	find_flag)
{
	switch (find_flag) {
  		case HA_READ_KEY_EXACT:		return(PAGE_CUR_GE);
  			/* the above does not require the index to be UNIQUE */
  		case HA_READ_KEY_OR_NEXT:	return(PAGE_CUR_GE);
		case HA_READ_KEY_OR_PREV:	return(PAGE_CUR_LE);
		case HA_READ_AFTER_KEY:		return(PAGE_CUR_G);
		case HA_READ_BEFORE_KEY:	return(PAGE_CUR_L);
		case HA_READ_PREFIX:		return(PAGE_CUR_GE);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2278
	        case HA_READ_PREFIX_LAST:       return(PAGE_CUR_LE);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2279
		  /* In MySQL-4.0 HA_READ_PREFIX and HA_READ_PREFIX_LAST always
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2280
		  pass a complete-field prefix of a key value as the search
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2281 2282 2283 2284 2285
		  tuple. I.e., it is not allowed that the last field would
		  just contain n first bytes of the full field value.
		  MySQL uses a 'padding' trick to convert LIKE 'abc%'
		  type queries so that it can use as a search tuple
		  a complete-field-prefix of a key value. Thus, the InnoDB
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2286 2287 2288 2289 2290 2291 2292
		  search mode PAGE_CUR_LE_OR_EXTENDS is never used.
		  TODO: when/if MySQL starts to use also partial-field
		  prefixes, we have to deal with stripping of spaces
		  and comparison of non-latin1 char type fields in
		  innobase_mysql_cmp() to get PAGE_CUR_LE_OR_EXTENDS to
		  work correctly. */

2293 2294 2295 2296 2297
		default:			assert(0);
	}

	return(0);
}
2298

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2299 2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2326 2327 2328 2329 2330 2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2341 2342 2343 2344 2345 2346 2347
/*
   BACKGROUND INFO: HOW A SELECT SQL QUERY IS EXECUTED
   ---------------------------------------------------
The following does not cover all the details, but explains how we determine
the start of a new SQL statement, and what is associated with it.

For each table in the database the MySQL interpreter may have several
table handle instances in use, also in a single SQL query. For each table
handle instance there is an InnoDB  'prebuilt' struct which contains most
of the InnoDB data associated with this table handle instance.

  A) if the user has not explicitly set any MySQL table level locks:

  1) MySQL calls ::external_lock to set an 'intention' table level lock on
the table of the handle instance. There we set
prebuilt->sql_stat_start = TRUE. The flag sql_stat_start should be set
true if we are taking this table handle instance to use in a new SQL
statement issued by the user. We also increment trx->n_mysql_tables_in_use.

  2) If prebuilt->sql_stat_start == TRUE we 'pre-compile' the MySQL search
instructions to prebuilt->template of the table handle instance in
::index_read. The template is used to save CPU time in large joins.

  3) In row_search_for_mysql, if prebuilt->sql_stat_start is true, we
allocate a new consistent read view for the trx if it does not yet have one,
or in the case of a locking read, set an InnoDB 'intention' table level
lock on the table.

  4) We do the SELECT. MySQL may repeatedly call ::index_read for the
same table handle instance, if it is a join.

  5) When the SELECT ends, MySQL removes its intention table level locks
in ::external_lock. When trx->n_mysql_tables_in_use drops to zero,
 (a) we execute a COMMIT there if the autocommit is on,
 (b) we also release possible 'SQL statement level resources' InnoDB may
have for this SQL statement. The MySQL interpreter does NOT execute
autocommit for pure read transactions, though it should. That is why the
table handler in that case has to execute the COMMIT in ::external_lock.

  B) If the user has explicitly set MySQL table level locks, then MySQL
does NOT call ::external_lock at the start of the statement. To determine
when we are at the start of a new SQL statement we at the start of
::index_read also compare the query id to the latest query id where the
table handle instance was used. If it has changed, we know we are at the
start of a new SQL statement. Since the query id can theoretically
overwrap, we use this test only as a secondary way of determining the
start of a new SQL statement. */


2348 2349 2350 2351 2352 2353 2354 2355 2356
/**************************************************************************
Positions an index cursor to the index specified in the handle. Fetches the
row if any. */

int
ha_innobase::index_read(
/*====================*/
					/* out: 0, HA_ERR_KEY_NOT_FOUND,
					or error number */
2357
	mysql_byte*		buf,	/* in/out: buffer for the returned
2358
					row */
2359
	const mysql_byte* 	key_ptr,/* in: key value; if this is NULL
2360
					we position the cursor at the
2361 2362 2363
					start or end of index; this can
					also contain an InnoDB row id, in
					which case key_len is the InnoDB
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2364 2365 2366 2367
					row id length; the key value can
					also be a prefix of a full key value,
					and the last column can be a prefix
					of a full column */
2368
	uint			key_len,/* in: key value length */
2369 2370 2371 2372 2373 2374 2375 2376 2377 2378
	enum ha_rkey_function find_flag)/* in: search flags from my_base.h */
{
	row_prebuilt_t* prebuilt	= (row_prebuilt_t*) innobase_prebuilt;
	ulint		mode;
	dict_index_t*	index;
	ulint		match_mode 	= 0;
	int 		error;
	ulint		ret;

  	DBUG_ENTER("index_read");
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2379 2380 2381 2382

	ut_a(prebuilt->trx ==
		(trx_t*) current_thd->transaction.all.innobase_tid);

2383
  	statistic_increment(ha_read_key_count, &LOCK_status);
2384

2385 2386 2387
	if (last_query_id != user_thd->query_id) {
	        prebuilt->sql_stat_start = TRUE;
                last_query_id = user_thd->query_id;
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
2388 2389

		innobase_release_stat_resources(prebuilt->trx);
2390 2391
	}

2392
	index = prebuilt->index;
2393

2394 2395
	/* Note that if the index for which the search template is built is not
        necessarily prebuilt->index, but can also be the clustered index */
2396

2397 2398 2399 2400
	if (prebuilt->sql_stat_start) {
		build_template(prebuilt, user_thd, table,
							ROW_MYSQL_REC_FIELDS);
	}
2401 2402

	if (key_ptr) {
2403 2404 2405
	        /* Convert the search key value to InnoDB format into
		prebuilt->search_tuple */

2406 2407 2408 2409 2410
		row_sel_convert_mysql_key_to_innobase(prebuilt->search_tuple,
							(byte*) key_val_buff,
							index,
							(byte*) key_ptr,
							(ulint) key_len);
2411 2412 2413 2414 2415 2416
	} else {
		/* We position the cursor to the last or the first entry
		in the index */

 		dtuple_set_n_fields(prebuilt->search_tuple, 0);
	}
2417

2418 2419 2420 2421 2422 2423 2424 2425 2426 2427 2428 2429 2430 2431
	mode = convert_search_mode_to_innobase(find_flag);

	match_mode = 0;

	if (find_flag == HA_READ_KEY_EXACT) {
		match_mode = ROW_SEL_EXACT;

	} else if (find_flag == HA_READ_PREFIX
				|| find_flag == HA_READ_PREFIX_LAST) {
		match_mode = ROW_SEL_EXACT_PREFIX;
	}

	last_match_mode = match_mode;

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2432 2433
	srv_conc_enter_innodb(prebuilt->trx);

2434
	ret = row_search_for_mysql((byte*) buf, mode, prebuilt, match_mode, 0);
2435

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
2436
	srv_conc_exit_innodb(prebuilt->trx);
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2437

2438 2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449
	if (ret == DB_SUCCESS) {
		error = 0;
		table->status = 0;

	} else if (ret == DB_RECORD_NOT_FOUND) {
		error = HA_ERR_KEY_NOT_FOUND;
		table->status = STATUS_NOT_FOUND;

	} else if (ret == DB_END_OF_INDEX) {
		error = HA_ERR_KEY_NOT_FOUND;
		table->status = STATUS_NOT_FOUND;
	} else {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2450
		error = convert_error_code_to_mysql(ret, user_thd);
2451 2452
		table->status = STATUS_NOT_FOUND;
	}
2453

2454 2455 2456
	DBUG_RETURN(error);
}

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2457 2458 2459
/***********************************************************************
The following functions works like index_read, but it find the last
row with the current key value or prefix. */
2460 2461

int
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2462 2463 2464 2465 2466 2467 2468 2469 2470
ha_innobase::index_read_last(
/*=========================*/
			           /* out: 0, HA_ERR_KEY_NOT_FOUND, or an
				   error code */
        mysql_byte*       buf,     /* out: fetched row */
        const mysql_byte* key_ptr, /* in: key value, or a prefix of a full
				   key value */
	uint              key_len) /* in: length of the key val or prefix
				   in bytes */
2471
{
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2472
        return(index_read(buf, key_ptr, key_len, HA_READ_PREFIX_LAST));
2473 2474
}

2475 2476 2477 2478 2479 2480
/************************************************************************
Changes the active index of a handle. */

int
ha_innobase::change_active_index(
/*=============================*/
2481 2482 2483
			/* out: 0 or error code */
	uint 	keynr)	/* in: use this index; MAX_KEY means always clustered
			index, even if it was internally generated by
2484
			InnoDB */
2485
{
2486
  row_prebuilt_t* prebuilt	= (row_prebuilt_t*) innobase_prebuilt;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2487
  KEY*		key=0;
2488
  statistic_increment(ha_read_key_count, &LOCK_status);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2489
  DBUG_ENTER("change_active_index");
2490

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2491 2492 2493
  ut_a(prebuilt->trx ==
	     (trx_t*) current_thd->transaction.all.innobase_tid);

2494
  active_index = keynr;
2495

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2496
  if (keynr != MAX_KEY && table->keys > 0) {
2497
    key = table->key_info + active_index;
2498

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2499
    prebuilt->index = dict_table_get_index_noninline(
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2500 2501
						     prebuilt->table,
						     key->name);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2502 2503 2504 2505
  } else {
    prebuilt->index = dict_table_get_first_index_noninline(
							   prebuilt->table);
  }
2506

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2507
  if (!prebuilt->index) {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2508 2509
    sql_print_error("Innodb could not find key n:o %u with name %s from dict cache for table %s", keynr, key ? key->name : "NULL", prebuilt->table->name);
    DBUG_RETURN(1);
2510
  }
2511

2512
  assert(prebuilt->search_tuple != 0);
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2513

2514
  dtuple_set_n_fields(prebuilt->search_tuple, prebuilt->index->n_fields);
2515

2516 2517
  dict_index_copy_types(prebuilt->search_tuple, prebuilt->index,
			prebuilt->index->n_fields);
2518

2519 2520
  /* Maybe MySQL changes the active index for a handle also
     during some queries, we do not know: then it is safest to build
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2521
     the template such that all columns will be fetched. */
2522

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2523
  build_template(prebuilt, NULL, table, ROW_MYSQL_WHOLE_ROW);
2524

2525
  DBUG_RETURN(0);
2526 2527 2528 2529 2530 2531 2532 2533 2534 2535 2536
}

/**************************************************************************
Positions an index cursor to the index specified in keynr. Fetches the
row if any. */
/* ??? This is only used to read whole keys ??? */

int
ha_innobase::index_read_idx(
/*========================*/
					/* out: error number or 0 */
2537
	mysql_byte*	buf,		/* in/out: buffer for the returned
2538 2539
					row */
	uint 		keynr,		/* in: use this index */
2540
	const mysql_byte* key,		/* in: key value; if this is NULL
2541 2542 2543 2544 2545
					we position the cursor at the
					start or end of index */
	uint		key_len,	/* in: key value length */
	enum ha_rkey_function find_flag)/* in: search flags from my_base.h */
{
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2546 2547 2548 2549
	if (change_active_index(keynr)) {

		return(1);
	}
2550 2551 2552 2553 2554 2555 2556 2557 2558 2559 2560 2561 2562

	return(index_read(buf, key, key_len, find_flag));
}

/***************************************************************************
Reads the next or previous row from a cursor, which must have previously been
positioned using index_read. */

int
ha_innobase::general_fetch(
/*=======================*/
				/* out: 0, HA_ERR_END_OF_FILE, or error
				number */
2563
	mysql_byte* 	buf,	/* in/out: buffer for next row in MySQL
2564 2565 2566 2567 2568 2569 2570 2571
				format */
	uint 	direction,	/* in: ROW_SEL_NEXT or ROW_SEL_PREV */
	uint	match_mode)	/* in: 0, ROW_SEL_EXACT, or
				ROW_SEL_EXACT_PREFIX */
{
	row_prebuilt_t*	prebuilt = (row_prebuilt_t*) innobase_prebuilt;
	ulint		ret;
	int		error	= 0;
2572

2573
	DBUG_ENTER("general_fetch");
2574

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2575
	ut_a(prebuilt->trx ==
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2576
	     (trx_t*) current_thd->transaction.all.innobase_tid);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2577

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2578
	srv_conc_enter_innodb(prebuilt->trx);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2579

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2580 2581
	ret = row_search_for_mysql((byte*)buf, 0, prebuilt, match_mode,
								direction);
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
2582
	srv_conc_exit_innodb(prebuilt->trx);
2583 2584 2585 2586 2587 2588 2589 2590 2591 2592 2593 2594 2595

	if (ret == DB_SUCCESS) {
		error = 0;
		table->status = 0;

	} else if (ret == DB_RECORD_NOT_FOUND) {
		error = HA_ERR_END_OF_FILE;
		table->status = STATUS_NOT_FOUND;

	} else if (ret == DB_END_OF_INDEX) {
		error = HA_ERR_END_OF_FILE;
		table->status = STATUS_NOT_FOUND;
	} else {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2596
		error = convert_error_code_to_mysql(ret, user_thd);
2597 2598
		table->status = STATUS_NOT_FOUND;
	}
2599

2600 2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611
	DBUG_RETURN(error);
}

/***************************************************************************
Reads the next row from a cursor, which must have previously been
positioned using index_read. */

int
ha_innobase::index_next(
/*====================*/
				/* out: 0, HA_ERR_END_OF_FILE, or error
				number */
2612
	mysql_byte* 	buf)	/* in/out: buffer for next row in MySQL
2613 2614
				format */
{
2615 2616
  	statistic_increment(ha_read_next_count, &LOCK_status);

2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627
	return(general_fetch(buf, ROW_SEL_NEXT, 0));
}

/***********************************************************************
Reads the next row matching to the key value given as the parameter. */

int
ha_innobase::index_next_same(
/*=========================*/
				/* out: 0, HA_ERR_END_OF_FILE, or error
				number */
2628 2629
	mysql_byte* 	buf,	/* in/out: buffer for the row */
	const mysql_byte* key,	/* in: key value */
2630 2631
	uint 		keylen)	/* in: key value length */
{
2632
  	statistic_increment(ha_read_next_count, &LOCK_status);
2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644 2645

	return(general_fetch(buf, ROW_SEL_NEXT, last_match_mode));
}

/***************************************************************************
Reads the previous row from a cursor, which must have previously been
positioned using index_read. */

int
ha_innobase::index_prev(
/*====================*/
				/* out: 0, HA_ERR_END_OF_FILE, or error
				number */
2646
	mysql_byte* 	buf)	/* in/out: buffer for previous row in MySQL
2647 2648 2649 2650 2651 2652 2653 2654 2655 2656 2657 2658
				format */
{
	return(general_fetch(buf, ROW_SEL_PREV, 0));
}

/************************************************************************
Positions a cursor on the first record in an index and reads the
corresponding row to buf. */

int
ha_innobase::index_first(
/*=====================*/
2659
				/* out: 0, HA_ERR_END_OF_FILE,
2660 2661
				or error code */
	mysql_byte*	buf)	/* in/out: buffer for the row */
2662 2663 2664 2665 2666 2667 2668 2669
{
	int	error;

  	DBUG_ENTER("index_first");
  	statistic_increment(ha_read_first_count, &LOCK_status);

  	error = index_read(buf, NULL, 0, HA_READ_AFTER_KEY);

2670 2671 2672 2673 2674 2675
        /* MySQL does not seem to allow this to return HA_ERR_KEY_NOT_FOUND */

  	if (error == HA_ERR_KEY_NOT_FOUND) {
  		error = HA_ERR_END_OF_FILE;
  	}

2676 2677 2678 2679 2680 2681 2682 2683 2684 2685
  	DBUG_RETURN(error);
}

/************************************************************************
Positions a cursor on the last record in an index and reads the
corresponding row to buf. */

int
ha_innobase::index_last(
/*====================*/
2686 2687
				/* out: 0, HA_ERR_END_OF_FILE, or error code */
	mysql_byte*	buf)	/* in/out: buffer for the row */
2688 2689 2690 2691
{
	int	error;

  	DBUG_ENTER("index_first");
2692
  	statistic_increment(ha_read_last_count, &LOCK_status);
2693 2694 2695

  	error = index_read(buf, NULL, 0, HA_READ_BEFORE_KEY);

2696
        /* MySQL does not seem to allow this to return HA_ERR_KEY_NOT_FOUND */
2697 2698 2699 2700 2701 2702 2703 2704 2705 2706 2707 2708 2709 2710 2711

  	if (error == HA_ERR_KEY_NOT_FOUND) {
  		error = HA_ERR_END_OF_FILE;
  	}

  	DBUG_RETURN(error);
}

/********************************************************************
Initialize a table scan. */

int
ha_innobase::rnd_init(
/*==================*/
			/* out: 0 or error number */
2712
	bool	scan)	/* in: ???????? */
2713
{
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2714
	int	err;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2715

2716
	row_prebuilt_t*	prebuilt = (row_prebuilt_t*) innobase_prebuilt;
2717

2718
	if (prebuilt->clust_index_was_generated) {
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2719
		err = change_active_index(MAX_KEY);
2720
	} else {
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2721
		err = change_active_index(primary_key);
2722
	}
2723

2724
  	start_of_scan = 1;
2725

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2726
 	return(err);
2727 2728 2729 2730 2731 2732 2733 2734 2735 2736 2737 2738 2739 2740 2741 2742 2743 2744 2745 2746 2747
}

/*********************************************************************
Ends a table scan ???????????????? */

int
ha_innobase::rnd_end(void)
/*======================*/
				/* out: 0 or error number */
{
  	return(index_end());
}

/*********************************************************************
Reads the next row in a table scan (also used to read the FIRST row
in a table scan). */

int
ha_innobase::rnd_next(
/*==================*/
			/* out: 0, HA_ERR_END_OF_FILE, or error number */
2748
	mysql_byte* buf)/* in/out: returns the row in this buffer,
2749 2750
			in MySQL format */
{
2751
	int	error;
2752 2753 2754 2755

  	DBUG_ENTER("rnd_next");
  	statistic_increment(ha_read_rnd_next_count, &LOCK_status);

2756
  	if (start_of_scan) {
2757 2758 2759 2760
		error = index_first(buf);
		if (error == HA_ERR_KEY_NOT_FOUND) {
			error = HA_ERR_END_OF_FILE;
		}
2761
		start_of_scan = 0;
2762
	} else {
2763
		error = general_fetch(buf, ROW_SEL_NEXT, 0);
2764
	}
2765

2766 2767 2768 2769
  	DBUG_RETURN(error);
}

/**************************************************************************
2770
Fetches a row from the table based on a row reference. */
2771

2772 2773 2774
int
ha_innobase::rnd_pos(
/*=================*/
2775 2776 2777
				/* out: 0, HA_ERR_KEY_NOT_FOUND,
				or error code */
	mysql_byte* 	buf,	/* in/out: buffer for the row */
2778 2779 2780 2781 2782
	mysql_byte*	pos)	/* in: primary key value of the row in the
				MySQL format, or the row id if the clustered
				index was internally generated by InnoDB;
				the length of data in pos has to be
				ref_length */
2783
{
2784 2785 2786
	row_prebuilt_t*	prebuilt = (row_prebuilt_t*) innobase_prebuilt;
	int		error;
	uint		keynr	= active_index;
2787
	DBUG_ENTER("rnd_pos");
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2788
	DBUG_DUMP("key", (char*) pos, ref_length);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2789

2790
	statistic_increment(ha_read_rnd_count, &LOCK_status);
2791

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2792 2793 2794
	ut_a(prebuilt->trx ==
		(trx_t*) current_thd->transaction.all.innobase_tid);

2795 2796 2797 2798
	if (prebuilt->clust_index_was_generated) {
		/* No primary key was defined for the table and we
		generated the clustered index from the row id: the
		row reference is the row id, not any key value
2799
		that MySQL knows of */
2800

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2801
		error = change_active_index(MAX_KEY);
2802
	} else {
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2803
		error = change_active_index(primary_key);
2804
	}
2805

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2806
	if (error) {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2807
	        DBUG_PRINT("error",("Got error: %ld",error));
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
2808 2809
		DBUG_RETURN(error);
	}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2810

2811 2812 2813 2814
	/* Note that we assume the length of the row reference is fixed
        for the table, and it is == ref_length */

	error = index_read(buf, pos, ref_length, HA_READ_KEY_EXACT);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2815 2816 2817 2818
	if (error)
	{
	  DBUG_PRINT("error",("Got error: %ld",error));
	}
2819
	change_active_index(keynr);
2820

2821 2822 2823 2824
  	DBUG_RETURN(error);
}

/*************************************************************************
2825
Stores a reference to the current row to 'ref' field of the handle. Note
2826 2827
that in the case where we have generated the clustered index for the
table, the function parameter is illogical: we MUST ASSUME that 'record'
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2828
is the current 'position' of the handle, because if row ref is actually
2829
the row id internally generated in InnoDB, then 'record' does not contain
2830 2831
it. We just guess that the row id must be for the record where the handle
was positioned the last time. */
2832 2833 2834 2835

void
ha_innobase::position(
/*==================*/
2836
	const mysql_byte*	record)	/* in: row in MySQL format */
2837
{
2838 2839
	row_prebuilt_t*	prebuilt = (row_prebuilt_t*) innobase_prebuilt;
	uint		len;
2840

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2841 2842 2843
	ut_a(prebuilt->trx ==
		(trx_t*) current_thd->transaction.all.innobase_tid);

2844 2845 2846 2847
	if (prebuilt->clust_index_was_generated) {
		/* No primary key was defined for the table and we
		generated the clustered index from row id: the
		row reference will be the row id, not any key value
2848
		that MySQL knows of */
2849 2850 2851 2852 2853 2854 2855

		len = DATA_ROW_ID_LEN;

		memcpy(ref, prebuilt->row_id, len);
	} else {
		len = store_key_val_for_row(primary_key, (char*) ref, record);
	}
2856

2857 2858 2859
	/* Since we do not store len to the buffer 'ref', we must assume
	that len is always fixed for this table. The following assertion
	checks this. */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2860
  
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2861 2862 2863 2864 2865
	if (len != ref_length) {
	        fprintf(stderr,
	 "InnoDB: Error: stored ref len is %lu, but table ref len is %lu\n",
		  (ulint)len, (ulint)ref_length);
	}
2866 2867 2868 2869
}


/*********************************************************************
2870
Creates a table definition to an InnoDB database. */
2871 2872 2873 2874
static
int
create_table_def(
/*=============*/
2875
	trx_t*		trx,		/* in: InnoDB transaction handle */
2876 2877 2878 2879 2880 2881 2882 2883 2884
	TABLE*		form,		/* in: information on table
					columns and indexes */
	const char*	table_name)	/* in: table name */
{
	Field*		field;
	dict_table_t*	table;
	ulint		n_cols;
  	int 		error;
  	ulint		col_type;
2885 2886
  	ulint		nulls_allowed;
	ulint		unsigned_type;
2887
  	ulint		i;
2888

2889 2890 2891 2892 2893 2894 2895 2896 2897
  	DBUG_ENTER("create_table_def");
  	DBUG_PRINT("enter", ("table_name: %s", table_name));

	n_cols = form->fields;

	/* The '0' below specifies that everything is currently
	created in tablespace 0 */

	table = dict_mem_table_create((char*) table_name, 0, n_cols);
2898

2899 2900 2901
	for (i = 0; i < n_cols; i++) {
		field = form->field[i];

2902 2903 2904 2905 2906 2907 2908 2909 2910 2911 2912 2913
		col_type = get_innobase_type_from_mysql_type(field);
		if (field->null_ptr) {
			nulls_allowed = 0;
		} else {
			nulls_allowed = DATA_NOT_NULL;
		}

		if (field->flags & UNSIGNED_FLAG) {
			unsigned_type = DATA_UNSIGNED;
		} else {
			unsigned_type = 0;
		}
2914 2915

		dict_mem_table_add_col(table, (char*) field->field_name,
2916 2917
					col_type, (ulint)field->type()
					| nulls_allowed | unsigned_type,
2918 2919 2920 2921 2922
					field->pack_length(), 0);
	}

	error = row_create_table_for_mysql(table, trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2923
	error = convert_error_code_to_mysql(error, NULL);
2924 2925 2926 2927 2928

	DBUG_RETURN(error);
}

/*********************************************************************
2929
Creates an index in an InnoDB database. */
2930 2931
static
int
2932 2933
create_index(
/*=========*/
2934
	trx_t*		trx,		/* in: InnoDB transaction handle */
2935 2936 2937 2938 2939 2940
	TABLE*		form,		/* in: information on table
					columns and indexes */
	const char*	table_name,	/* in: table name */
	uint		key_num)	/* in: index number */
{
	dict_index_t*	index;
2941
  	int 		error;
2942 2943 2944 2945 2946 2947
	ulint		n_fields;
	KEY*		key;
	KEY_PART_INFO*	key_part;
	ulint		ind_type;
  	ulint		i;

2948
  	DBUG_ENTER("create_index");
2949

2950 2951 2952
	key = form->key_info + key_num;

    	n_fields = key->key_parts;
2953

2954 2955
    	ind_type = 0;

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2956 2957
    	if (key_num == form->primary_key)
	{
2958 2959
		ind_type = ind_type | DICT_CLUSTERED;
	}
2960

2961 2962 2963 2964
	if (key->flags & HA_NOSAME ) {
		ind_type = ind_type | DICT_UNIQUE;
	}

2965
	/* The '0' below specifies that everything in InnoDB is currently
2966 2967 2968 2969 2970 2971 2972 2973 2974 2975 2976 2977 2978 2979 2980
	created in tablespace 0 */

	index = dict_mem_index_create((char*) table_name, key->name, 0,
						ind_type, n_fields);
	for (i = 0; i < n_fields; i++) {
		key_part = key->key_part + i;

		/* We assume all fields should be sorted in ascending
		order, hence the '0': */
		dict_mem_index_add_field(index,
				(char*) key_part->field->field_name, 0);
	}

	error = row_create_index_for_mysql(index, trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
2981
	error = convert_error_code_to_mysql(error, NULL);
2982 2983 2984 2985 2986

	DBUG_RETURN(error);
}

/*********************************************************************
2987
Creates an index to an InnoDB table when the user has defined no
2988
primary index. */
2989 2990
static
int
2991 2992
create_clustered_index_when_no_primary(
/*===================================*/
2993
	trx_t*		trx,		/* in: InnoDB transaction handle */
2994 2995 2996
	const char*	table_name)	/* in: table name */
{
	dict_index_t*	index;
2997 2998
  	int 		error;

2999
	/* The first '0' below specifies that everything in InnoDB is
3000 3001
	currently created in file space 0 */

monty@donna.mysql.fi's avatar
monty@donna.mysql.fi committed
3002 3003 3004
	index = dict_mem_index_create((char*) table_name,
				      (char*) "GEN_CLUST_INDEX",
				      0, DICT_CLUSTERED, 0);
3005 3006
	error = row_create_index_for_mysql(index, trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3007
	error = convert_error_code_to_mysql(error, NULL);
3008

3009
	return(error);
3010 3011 3012
}

/*********************************************************************
3013
Creates a new table to an InnoDB database. */
3014 3015 3016 3017 3018 3019 3020 3021

int
ha_innobase::create(
/*================*/
					/* out: error number */
	const char*	name,		/* in: table name */
	TABLE*		form,		/* in: information on table
					columns and indexes */
3022 3023 3024
	HA_CREATE_INFO*	create_info)	/* in: more information of the
					created table, contains also the
					create statement string */
3025 3026 3027
{
	int		error;
	dict_table_t*	innobase_table;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3028
	trx_t*		parent_trx;
3029
	trx_t*		trx;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3030
	int		primary_key_no;
3031
	uint		i;
3032 3033
	char		name2[FN_REFLEN];
	char		norm_name[FN_REFLEN];
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3034
	THD		*thd= current_thd;
3035

3036 3037
  	DBUG_ENTER("ha_innobase::create");

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3038
	DBUG_ASSERT(thd != NULL);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3039

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3040 3041 3042 3043 3044 3045 3046 3047 3048 3049
	/* Get the transaction associated with the current thd, or create one
	if not yet created */
	
	parent_trx = check_trx_exists(current_thd);

	/* In case MySQL calls this in the middle of a SELECT query, release
	possible adaptive hash latch to avoid deadlocks of threads */

	trx_search_latch_release_if_reserved(parent_trx);	
	
3050 3051
	trx = trx_allocate_for_mysql();

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3052
	if (thd->options & OPTION_NO_FOREIGN_KEY_CHECKS) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3053 3054 3055
		trx->check_foreigns = FALSE;
	}

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3056
	if (thd->options & OPTION_RELAXED_UNIQUE_CHECKS) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3057 3058 3059
		trx->check_unique_secondary = FALSE;
	}

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3060 3061 3062 3063 3064
	if (lower_case_table_names) {
		srv_lower_case_table_names = TRUE;
	} else {
		srv_lower_case_table_names = FALSE;
	}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3065

3066
	fn_format(name2, name, "", "",2);	// Remove the .frm extension
3067 3068

	normalize_table_name(norm_name, name2);
3069

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3070
	/* Latch the InnoDB data dictionary exclusively so that no deadlocks
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3071
	or lock waits can happen in it during a table create operation.
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3072
	Drop table etc. do this latching in row0mysql.c. */
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3073

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3074
	row_mysql_lock_data_dictionary(trx);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3075 3076

	/* Create the table definition in InnoDB */
3077

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3078 3079 3080
  	error = create_table_def(trx, form, norm_name);
  	
  	if (error) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3081
		innobase_commit_low(trx);
3082

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3083
		row_mysql_unlock_data_dictionary(trx);
3084 3085 3086 3087 3088 3089

  		trx_free_for_mysql(trx);

 		DBUG_RETURN(error);
 	}

3090 3091
	/* Look for a primary key */

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3092 3093 3094
	primary_key_no= (table->primary_key != MAX_KEY ?
			 (int) table->primary_key : 
			 -1);
3095

3096 3097 3098
	/* Our function row_get_mysql_key_number_for_index assumes
	the primary key is always number 0, if it exists */

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3099
	DBUG_ASSERT(primary_key_no == -1 || primary_key_no == 0);
3100

3101 3102
	/* Create the keys */

3103 3104 3105
	if (form->keys == 0 || primary_key_no == -1) {
		/* Create an index which is used as the clustered index;
		order the rows by their row id which is internally generated
3106
		by InnoDB */
3107

3108
		error = create_clustered_index_when_no_primary(trx,
3109
							norm_name);
3110
  		if (error) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3111 3112
			innobase_commit_low(trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3113
			row_mysql_unlock_data_dictionary(trx);
3114

3115 3116 3117 3118
			trx_free_for_mysql(trx);

			DBUG_RETURN(error);
      		}
3119 3120 3121
	}

	if (primary_key_no != -1) {
3122
		/* In InnoDB the clustered index must always be created
3123
		first */
monty@donna.mysql.fi's avatar
monty@donna.mysql.fi committed
3124 3125
	    	if ((error = create_index(trx, form, norm_name,
					  (uint) primary_key_no))) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3126 3127
			innobase_commit_low(trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3128
			row_mysql_unlock_data_dictionary(trx);
3129 3130 3131 3132 3133 3134 3135 3136 3137 3138 3139

  			trx_free_for_mysql(trx);

			DBUG_RETURN(error);
      		}
      	}

	for (i = 0; i < form->keys; i++) {

		if (i != (uint) primary_key_no) {

monty@donna.mysql.fi's avatar
monty@donna.mysql.fi committed
3140
    			if ((error = create_index(trx, form, norm_name, i))) {
3141

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3142
			  	innobase_commit_low(trx);
3143

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3144
				row_mysql_unlock_data_dictionary(trx);
3145 3146 3147 3148 3149

  				trx_free_for_mysql(trx);

				DBUG_RETURN(error);
      			}
3150
      		}
3151
  	}
3152

3153 3154 3155 3156
	if (current_thd->query != NULL) {
  	
		error = row_table_add_foreign_constraints(trx,
					current_thd->query, norm_name);
3157

3158
		error = convert_error_code_to_mysql(error, NULL);
3159

3160 3161
		if (error) {
			innobase_commit_low(trx);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3162

3163
			row_mysql_unlock_data_dictionary(trx);
3164

3165
  			trx_free_for_mysql(trx);
3166

3167 3168
			DBUG_RETURN(error);
		}
3169 3170
	}

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3171 3172
  	innobase_commit_low(trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3173
	row_mysql_unlock_data_dictionary(trx);
3174

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3175 3176 3177
	/* Flush the log to reduce probability that the .frm files and
	the InnoDB data dictionary get out-of-sync if the user runs
	with innodb_flush_log_at_trx_commit = 0 */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3178

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3179 3180
	log_flush_up_to(ut_dulint_max, LOG_WAIT_ONE_GROUP);

3181
	innobase_table = dict_table_get(norm_name, NULL);
3182

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3183
	DBUG_ASSERT(innobase_table != 0);
3184

3185
	/* Tell the InnoDB server that there might be work for
3186 3187 3188 3189 3190 3191 3192 3193 3194 3195
	utility threads: */

	srv_active_wake_master_thread();

  	trx_free_for_mysql(trx);

	DBUG_RETURN(0);
}

/*********************************************************************
3196
Drops a table from an InnoDB database. Before calling this function,
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3197 3198
MySQL calls innobase_commit to commit the transaction of the current user.
Then the current user cannot have locks set on the table. Drop table
3199 3200
operation inside InnoDB will remove all locks any user has on the table
inside InnoDB. */
3201 3202 3203 3204

int
ha_innobase::delete_table(
/*======================*/
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
3205 3206
				/* out: error number */
	const char*	name)	/* in: table name */
3207 3208 3209
{
	ulint	name_len;
	int	error;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3210
	trx_t*	parent_trx;
3211
	trx_t*	trx;
3212
	char	norm_name[1000];
3213

3214 3215
  	DBUG_ENTER("ha_innobase::delete_table");

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3216 3217 3218 3219 3220 3221 3222 3223 3224 3225
	/* Get the transaction associated with the current thd, or create one
	if not yet created */
	
	parent_trx = check_trx_exists(current_thd);

	/* In case MySQL calls this in the middle of a SELECT query, release
	possible adaptive hash latch to avoid deadlocks of threads */

	trx_search_latch_release_if_reserved(parent_trx);	

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3226 3227 3228 3229 3230 3231
	if (lower_case_table_names) {
		srv_lower_case_table_names = TRUE;
	} else {
		srv_lower_case_table_names = FALSE;
	}

3232 3233 3234 3235 3236
	trx = trx_allocate_for_mysql();

	name_len = strlen(name);

	assert(name_len < 1000);
3237

3238 3239
	/* Strangely, MySQL passes the table name without the '.frm'
	extension, in contrast to ::create */
3240

3241 3242
	normalize_table_name(norm_name, name);

3243
  	/* Drop the table in InnoDB */
3244

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3245
  	error = row_drop_table_for_mysql(norm_name, trx);
3246

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3247 3248 3249
	/* Flush the log to reduce probability that the .frm files and
	the InnoDB data dictionary get out-of-sync if the user runs
	with innodb_flush_log_at_trx_commit = 0 */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3250

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3251 3252
	log_flush_up_to(ut_dulint_max, LOG_WAIT_ONE_GROUP);

3253
	/* Tell the InnoDB server that there might be work for
3254 3255 3256 3257
	utility threads: */

	srv_active_wake_master_thread();

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3258
  	innobase_commit_low(trx);
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3259

3260 3261
  	trx_free_for_mysql(trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3262
	error = convert_error_code_to_mysql(error, NULL);
3263 3264 3265 3266

	DBUG_RETURN(error);
}

3267 3268 3269 3270 3271 3272 3273 3274 3275 3276 3277 3278 3279
/*********************************************************************
Removes all tables in the named database inside InnoDB. */

int
innobase_drop_database(
/*===================*/
			/* out: error number */
	char*	path)	/* in: database path; inside InnoDB the name
			of the last directory in the path is used as
			the database name: for example, in 'mysql/data/test'
			the database name is 'test' */
{
	ulint	len		= 0;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3280
	trx_t*	parent_trx;
3281 3282 3283 3284
	trx_t*	trx;
	char*	ptr;
	int	error;
	char	namebuf[10000];
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3285

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3286 3287 3288 3289 3290 3291 3292 3293 3294 3295
	/* Get the transaction associated with the current thd, or create one
	if not yet created */
	
	parent_trx = check_trx_exists(current_thd);

	/* In case MySQL calls this in the middle of a SELECT query, release
	possible adaptive hash latch to avoid deadlocks of threads */

	trx_search_latch_release_if_reserved(parent_trx);	

3296
	ptr = strend(path) - 2;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3297

3298 3299 3300 3301 3302 3303 3304 3305 3306 3307
	while (ptr >= path && *ptr != '\\' && *ptr != '/') {
		ptr--;
		len++;
	}

	ptr++;

	memcpy(namebuf, ptr, len);
	namebuf[len] = '/';
	namebuf[len + 1] = '\0';
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3308
#ifdef __WIN__
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3309
	casedn_str(namebuf);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3310
#endif
3311 3312 3313 3314
	trx = trx_allocate_for_mysql();

  	error = row_drop_database_for_mysql(namebuf, trx);

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3315 3316 3317
	/* Flush the log to reduce probability that the .frm files and
	the InnoDB data dictionary get out-of-sync if the user runs
	with innodb_flush_log_at_trx_commit = 0 */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3318

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3319 3320
	log_flush_up_to(ut_dulint_max, LOG_WAIT_ONE_GROUP);

3321 3322 3323 3324 3325
	/* Tell the InnoDB server that there might be work for
	utility threads: */

	srv_active_wake_master_thread();

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3326
  	innobase_commit_low(trx);
3327 3328
  	trx_free_for_mysql(trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3329
	error = convert_error_code_to_mysql(error, NULL);
3330 3331 3332 3333

	return(error);
}

3334
/*************************************************************************
3335
Renames an InnoDB table. */
3336 3337 3338 3339 3340 3341 3342 3343 3344 3345 3346

int
ha_innobase::rename_table(
/*======================*/
				/* out: 0 or error code */
	const char*	from,	/* in: old name of the table */
	const char*	to)	/* in: new name of the table */
{
	ulint	name_len1;
	ulint	name_len2;
	int	error;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3347
	trx_t*	parent_trx;
3348
	trx_t*	trx;
3349 3350
	char	norm_from[1000];
	char	norm_to[1000];
3351

3352 3353
  	DBUG_ENTER("ha_innobase::rename_table");

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3354 3355 3356 3357 3358 3359 3360 3361 3362 3363
	/* Get the transaction associated with the current thd, or create one
	if not yet created */
	
	parent_trx = check_trx_exists(current_thd);

	/* In case MySQL calls this in the middle of a SELECT query, release
	possible adaptive hash latch to avoid deadlocks of threads */

	trx_search_latch_release_if_reserved(parent_trx);	

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3364 3365 3366 3367 3368 3369
	if (lower_case_table_names) {
		srv_lower_case_table_names = TRUE;
	} else {
		srv_lower_case_table_names = FALSE;
	}

3370 3371 3372 3373 3374 3375 3376
	trx = trx_allocate_for_mysql();

	name_len1 = strlen(from);
	name_len2 = strlen(to);

	assert(name_len1 < 1000);
	assert(name_len2 < 1000);
3377

3378 3379 3380
	normalize_table_name(norm_from, from);
	normalize_table_name(norm_to, to);

3381
  	/* Rename the table in InnoDB */
3382

3383
  	error = row_rename_table_for_mysql(norm_from, norm_to, trx);
3384

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3385 3386 3387
	/* Flush the log to reduce probability that the .frm files and
	the InnoDB data dictionary get out-of-sync if the user runs
	with innodb_flush_log_at_trx_commit = 0 */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3388

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3389 3390
	log_flush_up_to(ut_dulint_max, LOG_WAIT_ONE_GROUP);

3391
	/* Tell the InnoDB server that there might be work for
3392 3393 3394 3395
	utility threads: */

	srv_active_wake_master_thread();

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3396
  	innobase_commit_low(trx);
3397 3398
  	trx_free_for_mysql(trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3399
	error = convert_error_code_to_mysql(error, NULL);
3400 3401 3402 3403 3404 3405 3406 3407 3408 3409

	DBUG_RETURN(error);
}

/*************************************************************************
Estimates the number of index records in a range. */

ha_rows
ha_innobase::records_in_range(
/*==========================*/
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3410 3411
						/* out: estimated number of
						rows */
3412
	int 			keynr,		/* in: index number */
3413
	const mysql_byte*	start_key,	/* in: start key value of the
3414 3415 3416 3417 3418
						range, may also be empty */
	uint 			start_key_len,	/* in: start key val len, may
						also be 0 */
	enum ha_rkey_function 	start_search_flag,/* in: start search condition
						e.g., 'greater than' */
3419
	const mysql_byte*	end_key,	/* in: range end key val, may
3420 3421 3422 3423 3424 3425 3426 3427
						also be empty */
	uint 			end_key_len,	/* in: range end key val len,
						may also be 0 */
	enum ha_rkey_function 	end_search_flag)/* in: range end search cond */
{
	row_prebuilt_t* prebuilt	= (row_prebuilt_t*) innobase_prebuilt;
	KEY*		key;
	dict_index_t*	index;
3428
	mysql_byte*	key_val_buff2 	= (mysql_byte*) my_malloc(
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3429 3430
						  table->reclength
      						+ table->max_key_length + 100,
3431
								MYF(MY_WME));
3432
	dtuple_t*	range_start;
3433
	dtuple_t*	range_end;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3434
	ib_longlong	n_rows;
3435 3436
	ulint		mode1;
	ulint		mode2;
3437 3438
	void*           heap1;
	void*           heap2;
3439

3440
   	DBUG_ENTER("records_in_range");
3441

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3442 3443 3444 3445 3446 3447
	/* We do not know if MySQL can call this function before calling
	external_lock(). To be safe, update the thd of the current table
	handle. */

	update_thd(current_thd);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3448 3449
	prebuilt->trx->op_info = (char*)"estimating records in index range";

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3450 3451 3452 3453
	/* In case MySQL calls this in the middle of a SELECT query, release
	possible adaptive hash latch to avoid deadlocks of threads */

	trx_search_latch_release_if_reserved(prebuilt->trx);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3454

3455 3456 3457
	active_index = keynr;

	key = table->key_info + active_index;
3458

3459
	index = dict_table_get_index_noninline(prebuilt->table, key->name);
3460

3461
	range_start = dtuple_create_for_mysql(&heap1, key->key_parts);
3462
 	dict_index_copy_types(range_start, index, key->key_parts);
3463

3464
	range_end = dtuple_create_for_mysql(&heap2, key->key_parts);
3465
 	dict_index_copy_types(range_end, index, key->key_parts);
3466

3467 3468 3469 3470
	row_sel_convert_mysql_key_to_innobase(
				range_start, (byte*) key_val_buff, index,
				(byte*) start_key,
				(ulint) start_key_len);
3471

3472 3473 3474 3475 3476
	row_sel_convert_mysql_key_to_innobase(
				range_end, (byte*) key_val_buff2, index,
				(byte*) end_key,
				(ulint) end_key_len);

3477 3478 3479
	mode1 = convert_search_mode_to_innobase(start_search_flag);
	mode2 = convert_search_mode_to_innobase(end_search_flag);

3480
	n_rows = btr_estimate_n_rows_in_range(index, range_start,
3481
						mode1, range_end, mode2);
3482 3483
	dtuple_free_for_mysql(heap1);
	dtuple_free_for_mysql(heap2);
3484

3485 3486
    	my_free((char*) key_val_buff2, MYF(0));

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3487 3488
	prebuilt->trx->op_info = (char*)"";

3489 3490 3491
	DBUG_RETURN((ha_rows) n_rows);
}

3492 3493 3494 3495 3496 3497 3498 3499 3500 3501
/*************************************************************************
Gives an UPPER BOUND to the number of rows in a table. This is used in
filesort.cc and the upper bound must hold. TODO: Since the number of
rows in a table may change after this function is called, we still may
get a 'Sort aborted' error in filesort.cc of MySQL. The ultimate fix is to
improve the algorithm of filesort.cc. */

ha_rows
ha_innobase::estimate_number_of_rows(void)
/*======================================*/
3502
			/* out: upper bound of rows */
3503 3504
{
	row_prebuilt_t* prebuilt	= (row_prebuilt_t*) innobase_prebuilt;
3505 3506
	dict_index_t*	index;
	ulonglong	estimate;
3507
	ulonglong	local_data_file_length;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3508

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3509
 	DBUG_ENTER("estimate_number_of_rows");
3510

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3511 3512 3513 3514 3515 3516
	/* We do not know if MySQL can call this function before calling
	external_lock(). To be safe, update the thd of the current table
	handle. */

	update_thd(current_thd);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3517 3518 3519
	prebuilt->trx->op_info = (char*)
	                         "calculating upper bound for table rows";

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3520 3521 3522 3523 3524
	/* In case MySQL calls this in the middle of a SELECT query, release
	possible adaptive hash latch to avoid deadlocks of threads */

	trx_search_latch_release_if_reserved(prebuilt->trx);

3525
	index = dict_table_get_first_index_noninline(prebuilt->table);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3526

3527
	local_data_file_length = ((ulonglong) index->stat_n_leaf_pages)
3528
    							* UNIV_PAGE_SIZE;
3529

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3530 3531
	/* Calculate a minimum length for a clustered index record and from
	that an upper bound for the number of rows. Since we only calculate
3532 3533
	new statistics in row0mysql.c when a tablehas grown
        by a threshold factor, we must add a safety factor 2 in front
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3534 3535
	of the formula below. */

3536
	estimate = 2 * local_data_file_length / dict_index_calc_min_rec_len(index);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3537

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3538 3539
	prebuilt->trx->op_info = (char*)"";

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3540
	DBUG_RETURN((ha_rows) estimate);
3541 3542
}

3543 3544 3545 3546 3547 3548 3549 3550 3551 3552 3553 3554
/*************************************************************************
How many seeks it will take to read through the table. This is to be
comparable to the number returned by records_in_range so that we can
decide if we should scan the table or use keys. */

double
ha_innobase::scan_time()
/*====================*/
			/* out: estimated time measured in disk seeks */
{
	row_prebuilt_t* prebuilt	= (row_prebuilt_t*) innobase_prebuilt;

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3555 3556 3557 3558 3559 3560
	/* Since MySQL seems to favor table scans too much over index
	searches, we pretend that a sequential read takes the same time
	as a random disk read, that is, we do not divide the following
	by 10, which would be physically realistic. */
	
	return((double) (prebuilt->table->stat_clustered_index_size));
3561 3562 3563 3564 3565 3566 3567 3568 3569 3570 3571 3572 3573 3574
}

/*************************************************************************
Returns statistics information of the table to the MySQL interpreter,
in various fields of the handle object. */

void
ha_innobase::info(
/*==============*/
	uint flag)	/* in: what information MySQL requests */
{
	row_prebuilt_t* prebuilt	= (row_prebuilt_t*) innobase_prebuilt;
	dict_table_t*	ib_table;
	dict_index_t*	index;
3575
	ha_rows		rec_per_key;
3576 3577
	ulong		j;
	ulong		i;
3578

3579 3580
 	DBUG_ENTER("info");

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3581 3582 3583 3584 3585 3586 3587 3588 3589
        /* If we are forcing recovery at a high level, we will suppress
	statistics calculation on tables, because that may crash the
	server if an index is badly corrupted. */

        if (srv_force_recovery >= SRV_FORCE_NO_IBUF_MERGE) {

                return;
        }

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3590 3591 3592 3593 3594 3595 3596 3597 3598
	/* We do not know if MySQL can call this function before calling
	external_lock(). To be safe, update the thd of the current table
	handle. */

	update_thd(current_thd);

	/* In case MySQL calls this in the middle of a SELECT query, release
	possible adaptive hash latch to avoid deadlocks of threads */

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3599 3600
	prebuilt->trx->op_info = (char*)"returning various info to MySQL";

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3601
	trx_search_latch_release_if_reserved(prebuilt->trx);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3602

3603 3604 3605 3606 3607 3608
 	ib_table = prebuilt->table;

 	if (flag & HA_STATUS_TIME) {
 		/* In sql_show we call with this flag: update then statistics
 		so that they are up-to-date */

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3609 3610
	        prebuilt->trx->op_info = (char*)"updating table statistics";

3611
 		dict_update_statistics(ib_table);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3612 3613 3614

		prebuilt->trx->op_info = (char*)
		                          "returning various info to MySQL";
3615 3616 3617
 	}

	if (flag & HA_STATUS_VARIABLE) {
3618
    		records = (ha_rows)ib_table->stat_n_rows;
3619 3620 3621 3622 3623 3624 3625 3626 3627 3628 3629 3630 3631
    		deleted = 0;
    		data_file_length = ((ulonglong)
				ib_table->stat_clustered_index_size)
    					* UNIV_PAGE_SIZE;
    		index_file_length = ((ulonglong)
				ib_table->stat_sum_of_other_index_sizes)
    					* UNIV_PAGE_SIZE;
    		delete_length = 0;
    		check_time = 0;

    		if (records == 0) {
    			mean_rec_length = 0;
    		} else {
3632
    			mean_rec_length = (ulong) (data_file_length / records);
3633 3634 3635 3636 3637 3638 3639 3640 3641
    		}
    	}

	if (flag & HA_STATUS_CONST) {
		index = dict_table_get_first_index_noninline(ib_table);

		if (prebuilt->clust_index_was_generated) {
			index = dict_table_get_next_index_noninline(index);
		}
3642

3643
		for (i = 0; i < table->keys; i++) {
3644 3645 3646 3647 3648 3649
			for (j = 0; j < table->key_info[i].key_parts; j++) {

				if (index->stat_n_diff_key_vals[j + 1] == 0) {

					rec_per_key = records;
				} else {
3650
					rec_per_key = (ha_rows)(records /
3651 3652 3653
   				         index->stat_n_diff_key_vals[j + 1]);
				}

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3654 3655 3656 3657 3658 3659 3660
				/* Since MySQL seems to favor table scans
				too much over index searches, we pretend
				index selectivity is 2 times better than
				our estimate: */

				rec_per_key = rec_per_key / 2;

3661 3662 3663
				if (rec_per_key == 0) {
					rec_per_key = 1;
				}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3664

3665 3666 3667
 				table->key_info[i].rec_per_key[j]=
				  rec_per_key >= ~(ulong) 0 ? ~(ulong) 0 :
				  rec_per_key;
3668
			}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3669

3670
			index = dict_table_get_next_index_noninline(index);
3671 3672
		}
	}
3673 3674

  	if (flag & HA_STATUS_ERRKEY) {
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3675 3676
		ut_a(prebuilt->trx && prebuilt->trx->magic_n == TRX_MAGIC_N);

3677
		errkey = (unsigned int) row_get_mysql_key_number_for_index(
3678 3679
				       (dict_index_t*)
				       trx_get_error_info(prebuilt->trx));
3680 3681
  	}

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3682 3683
	prebuilt->trx->op_info = (char*)"";

3684 3685 3686
  	DBUG_VOID_RETURN;
}

3687 3688 3689 3690 3691 3692 3693 3694 3695 3696 3697 3698 3699 3700 3701 3702
/***********************************************************************
Tries to check that an InnoDB table is not corrupted. If corruption is
noticed, prints to stderr information about it. In case of corruption
may also assert a failure and crash the server. */

int
ha_innobase::check(
/*===============*/
					/* out: HA_ADMIN_CORRUPT or
					HA_ADMIN_OK */
	THD* 		thd,		/* in: user thread handle */
	HA_CHECK_OPT* 	check_opt)	/* in: check options, currently
					ignored */
{
	row_prebuilt_t* prebuilt	= (row_prebuilt_t*) innobase_prebuilt;
	ulint		ret;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3703

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3704
	ut_a(prebuilt->trx && prebuilt->trx->magic_n == TRX_MAGIC_N);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3705 3706
	ut_a(prebuilt->trx ==
		(trx_t*) current_thd->transaction.all.innobase_tid);
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3707

3708 3709 3710 3711 3712 3713 3714 3715 3716 3717 3718 3719
	if (prebuilt->mysql_template == NULL) {
		/* Build the template; we will use a dummy template
		in index scans done in checking */

		build_template(prebuilt, NULL, table, ROW_MYSQL_WHOLE_ROW);
	}

	ret = row_check_table_for_mysql(prebuilt);

	if (ret == DB_SUCCESS) {
		return(HA_ADMIN_OK);
	}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3720

3721 3722 3723
  	return(HA_ADMIN_CORRUPT); 
}

3724
/*****************************************************************
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3725 3726 3727
Adds information about free space in the InnoDB tablespace to a table comment
which is printed out when a user calls SHOW TABLE STATUS. Adds also info on
foreign keys. */
3728 3729 3730 3731

char*
ha_innobase::update_table_comment(
/*==============================*/
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3732 3733 3734
				/* out: table comment + InnoDB free space +
				info on foreign keys */
        const char*	comment)/* in: table comment defined by user */
3735
{
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3736 3737
	row_prebuilt_t* prebuilt = (row_prebuilt_t*)innobase_prebuilt;
  	uint 		length 	= strlen(comment);
3738
  	char*		str 	= my_malloc(length + 16500, MYF(0));
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3739
  	char*		pos;
3740

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3741 3742 3743 3744 3745 3746
	/* We do not know if MySQL can call this function before calling
	external_lock(). To be safe, update the thd of the current table
	handle. */

	update_thd(current_thd);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3747 3748
	prebuilt->trx->op_info = (char*)"returning table comment";

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3749 3750 3751 3752
	/* In case MySQL calls this in the middle of a SELECT query, release
	possible adaptive hash latch to avoid deadlocks of threads */

	trx_search_latch_release_if_reserved(prebuilt->trx);
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3753
   	
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3754
	if (!str) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3755 3756
	        prebuilt->trx->op_info = (char*)"";

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3757 3758 3759 3760 3761 3762 3763 3764 3765
    		return((char*)comment);
	}

	pos = str;
  	if (length) {
    		pos=strmov(str, comment);
    		*pos++=';';
    		*pos++=' ';
  	}
3766

3767 3768 3769
  	pos += my_sprintf(pos,
			  (pos,"InnoDB free: %lu kB",
			   (ulong) innobase_get_free_space()));
3770

3771 3772 3773
	/* We assume 16000 - length bytes of space to print info; the limit
        16000 bytes is arbitrary, and MySQL could handle at least 64000
	bytes */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3774
  
3775 3776
	if (length < 16000) {
  		dict_print_info_on_foreign_keys(FALSE, pos, 16000 - length,
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3777 3778
							prebuilt->table);
	}
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3779

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3780 3781
        prebuilt->trx->op_info = (char*)"";

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3782
  	return(str);
3783 3784
}

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3785 3786 3787 3788 3789 3790 3791 3792 3793 3794 3795 3796
/***********************************************************************
Gets the foreign key create info for a table stored in InnoDB. */

char*
ha_innobase::get_foreign_key_create_info(void)
/*==========================================*/
			/* out, own: character string in the form which
			can be inserted to the CREATE TABLE statement,
			MUST be freed with ::free_foreign_key_create_info */
{
	row_prebuilt_t* prebuilt = (row_prebuilt_t*)innobase_prebuilt;
	char*	str;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3797

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3798 3799
	ut_a(prebuilt != NULL);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3800 3801 3802 3803 3804 3805
	/* We do not know if MySQL can call this function before calling
	external_lock(). To be safe, update the thd of the current table
	handle. */

	update_thd(current_thd);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3806 3807
        prebuilt->trx->op_info = (char*)"getting info on foreign keys";

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3808 3809 3810 3811
	/* In case MySQL calls this in the middle of a SELECT query, release
	possible adaptive hash latch to avoid deadlocks of threads */

	trx_search_latch_release_if_reserved(prebuilt->trx);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3812 3813
	
	str = (char*)ut_malloc(10000);
3814

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3815 3816 3817
	str[0] = '\0';
	
  	dict_print_info_on_foreign_keys(TRUE, str, 9000, prebuilt->table);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3818

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3819 3820
        prebuilt->trx->op_info = (char*)"";

monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
3821
  	return(str);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3822 3823 3824 3825 3826 3827 3828 3829 3830 3831 3832 3833 3834 3835
}			

/***********************************************************************
Frees the foreign key create info for a table stored in InnoDB, if it is
non-NULL. */

void
ha_innobase::free_foreign_key_create_info(
/*======================================*/
	char*	str)	/* in, own: create info string to free  */
{
	if (str) {
		ut_free(str);
	}
3836 3837
}

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3838 3839 3840 3841 3842 3843 3844 3845 3846 3847 3848 3849 3850 3851 3852 3853 3854 3855 3856 3857 3858 3859 3860 3861 3862
/***********************************************************************
Tells something additional to the handler about how to do things. */

int
ha_innobase::extra(
/*===============*/
			   /* out: 0 or error number */
	enum ha_extra_function operation)
                           /* in: HA_EXTRA_DONT_USE_CURSOR_TO_UPDATE */
{
	row_prebuilt_t*	prebuilt = (row_prebuilt_t*) innobase_prebuilt;

	/* Warning: since it is not sure that MySQL calls external_lock
	before calling this function, the trx field in prebuilt can be
	obsolete! */

	switch (operation) {
 		case HA_EXTRA_RESET:
  		case HA_EXTRA_RESET_STATE:
	        	prebuilt->read_just_key = 0;
	        	break;
		case HA_EXTRA_NO_KEYREAD:
    			prebuilt->read_just_key = 0;
    			break;
	        case HA_EXTRA_DONT_USE_CURSOR_TO_UPDATE:
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3863
			prebuilt->hint_no_need_to_fetch_extra_cols = FALSE;
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3864 3865 3866 3867 3868 3869 3870 3871 3872 3873 3874 3875 3876 3877 3878 3879 3880 3881 3882 3883 3884
			break;
	        case HA_EXTRA_KEYREAD:
	        	prebuilt->read_just_key = 1;
	        	break;
		default:/* Do nothing */
			;
	}

	return(0);
}

/**********************************************************************
????????????? */

int
ha_innobase::reset(void)
/*====================*/
{
  	return(0);
}

3885
/**********************************************************************
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3886 3887 3888 3889
Inside LOCK TABLES MySQL will not call external_lock() between SQL
statements. It will call this function at the start of each SQL statement.
Note also a spacial case: if a temporary table is created inside LOCK
TABLES, MySQL has not called external_lock() at all on that table. */
3890 3891

int
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3892 3893
ha_innobase::start_stmt(
/*====================*/
3894 3895 3896 3897 3898 3899 3900 3901 3902 3903 3904 3905 3906
	              /* out: 0 or error code */
	THD*    thd)  /* in: handle to the user thread */
{
	row_prebuilt_t* prebuilt = (row_prebuilt_t*) innobase_prebuilt;
	trx_t*		trx;

	update_thd(thd);

	trx = prebuilt->trx;

	innobase_release_stat_resources(trx);
	trx_mark_sql_stat_end(trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3907 3908 3909 3910 3911 3912 3913 3914
	if (trx->isolation_level <= TRX_ISO_READ_COMMITTED
	    						&& trx->read_view) {
	    	/* At low transaction isolation levels we let
		each consistent read set its own snapshot */

	    	read_view_close_for_mysql(trx);
	}

3915 3916 3917 3918
	auto_inc_counter_for_this_stat = 0;
	prebuilt->sql_stat_start = TRUE;
	prebuilt->hint_no_need_to_fetch_extra_cols = TRUE;
	prebuilt->read_just_key = 0;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3919

3920
	if (!prebuilt->mysql_has_locked) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3921 3922 3923 3924 3925 3926 3927
	        /* This handle is for a temporary table created inside
	        this same LOCK TABLES; since MySQL does NOT call external_lock
	        in this case, we must use x-row locks inside InnoDB to be
	        prepared for an update of a row */
	  
	        prebuilt->select_lock_type = LOCK_X;
	}
3928 3929

	thd->transaction.all.innodb_active_trans = 1;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3930 3931

	return(0);
3932 3933
}

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3934 3935 3936 3937 3938 3939 3940 3941 3942 3943 3944
/**********************************************************************
Maps a MySQL trx isolation level code to the InnoDB isolation level code */
inline
ulint
innobase_map_isolation_level(
/*=========================*/
					/* out: InnoDB isolation level */
	enum_tx_isolation	iso)	/* in: MySQL isolation level code */
{
	switch(iso) {
		case ISO_REPEATABLE_READ: return(TRX_ISO_REPEATABLE_READ);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3945
		case ISO_READ_COMMITTED: return(TRX_ISO_READ_COMMITTED);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3946 3947 3948 3949 3950 3951
		case ISO_SERIALIZABLE: return(TRX_ISO_SERIALIZABLE);
		case ISO_READ_UNCOMMITTED: return(TRX_ISO_READ_UNCOMMITTED);
		default: ut_a(0); return(0);
	}	
}
	
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3952 3953
/**********************************************************************
As MySQL will execute an external lock for every new table it uses when it
3954 3955 3956
starts to process an SQL statement (an exception is when MySQL calls
start_stmt for the handle) we can use this function to store the pointer to
the THD in the handle. We will also use this function to communicate
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3957 3958 3959 3960 3961 3962 3963
to InnoDB that a new SQL statement has started and that we must store a
savepoint to our transaction handle, so that we are able to roll back
the SQL statement in case of an error. */

int
ha_innobase::external_lock(
/*=======================*/
3964
			        /* out: 0 or error code */
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3965 3966 3967 3968 3969 3970 3971 3972
	THD*	thd,		/* in: handle to the user thread */
	int 	lock_type)	/* in: lock type */
{
	row_prebuilt_t* prebuilt = (row_prebuilt_t*) innobase_prebuilt;
	int 		error = 0;
	trx_t*		trx;

  	DBUG_ENTER("ha_innobase::external_lock");
3973
	DBUG_PRINT("enter",("lock_type: %d", lock_type));
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3974 3975 3976 3977 3978 3979

	update_thd(thd);

	trx = prebuilt->trx;

	prebuilt->sql_stat_start = TRUE;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
3980
	prebuilt->hint_no_need_to_fetch_extra_cols = TRUE;
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3981 3982 3983 3984 3985 3986 3987 3988 3989 3990 3991 3992 3993 3994 3995 3996 3997

	prebuilt->read_just_key = 0;

	if (lock_type == F_WRLCK) {

		/* If this is a SELECT, then it is in UPDATE TABLE ...
		or SELECT ... FOR UPDATE */
		prebuilt->select_lock_type = LOCK_X;
	}

	if (lock_type != F_UNLCK) {
		if (trx->n_mysql_tables_in_use == 0) {
			trx_mark_sql_stat_end(trx);
		}

		thd->transaction.all.innodb_active_trans = 1;
		trx->n_mysql_tables_in_use++;
3998
		prebuilt->mysql_has_locked = TRUE;
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
3999

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4000
		trx->isolation_level = innobase_map_isolation_level(
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4001 4002 4003 4004
						(enum_tx_isolation)
						thd->variables.tx_isolation);

		if (trx->isolation_level == TRX_ISO_SERIALIZABLE
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4005 4006 4007 4008 4009 4010 4011 4012 4013
		    && prebuilt->select_lock_type == LOCK_NONE) {

		    	/* To get serializable execution we let InnoDB
		    	conceptually add 'LOCK IN SHARE MODE' to all SELECTs
			which otherwise would have been consistent reads */

			prebuilt->select_lock_type = LOCK_S;
		}

heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
4014 4015 4016 4017 4018 4019
		if (prebuilt->select_lock_type != LOCK_NONE) {

		  	trx->mysql_n_tables_locked++;
		}
	} else {
		trx->n_mysql_tables_in_use--;
4020
		prebuilt->mysql_has_locked = FALSE;
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
4021 4022 4023 4024 4025 4026
		auto_inc_counter_for_this_stat = 0;

		if (trx->n_mysql_tables_in_use == 0) {

		  	trx->mysql_n_tables_locked = 0;

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4027 4028
			/* Here we release the search latch and InnoDB
			thread FIFO ticket if they were reserved. */
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
4029 4030 4031

			innobase_release_stat_resources(trx);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4032 4033 4034 4035 4036 4037 4038 4039 4040
			if (trx->isolation_level <= TRX_ISO_READ_COMMITTED
	    						&& trx->read_view) {

	    			/* At low transaction isolation levels we let
				each consistent read set its own snapshot */

	    			read_view_close_for_mysql(trx);
			}
			
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
4041
		  	if (!(thd->options
4042
				 & (OPTION_NOT_AUTOCOMMIT | OPTION_BEGIN))) {
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
4043 4044 4045 4046 4047 4048 4049 4050 4051

		    		innobase_commit(thd, trx);
		  	}
		}
	}

	DBUG_RETURN(error);
}

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4052 4053 4054 4055 4056 4057 4058 4059 4060 4061 4062 4063 4064
/****************************************************************************
Implements the SHOW INNODB STATUS command. Send the output of the InnoDB
Monitor to the client. */

int
innodb_show_status(
/*===============*/
	THD*	thd)	/* in: the MySQL query thread of the caller */
{
	String* 	packet 	= &thd->packet;
	char*		buf;

  	DBUG_ENTER("innodb_show_status");
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4065
	
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4066
	if (innodb_skip) {
4067
	        my_message(ER_NOT_SUPPORTED_YET,
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4068
	  "Cannot call SHOW INNODB STATUS because skip-innodb is defined",
4069
			   MYF(0));
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4070 4071
                DBUG_RETURN(-1);
        }
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4072

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4073
	/* We let the InnoDB Monitor to output at most 200 kB of text, add
4074 4075
	a safety margin of 10 kB for buffer overruns */

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4076
	buf = (char*)ut_malloc(210 * 1024);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4077
	
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4078
	srv_sprintf_innodb_monitor(buf, 200 * 1024);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4079 4080 4081 4082 4083 4084
	
	List<Item> field_list;

	field_list.push_back(new Item_empty_string("Status", strlen(buf)));

	if(send_fields(thd, field_list, 1)) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4085 4086 4087

		ut_free(buf);

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4088 4089 4090 4091 4092 4093 4094 4095 4096 4097 4098 4099 4100 4101 4102 4103 4104 4105 4106 4107 4108
	  	DBUG_RETURN(-1);
	}

  	packet->length(0);
  
  	net_store_data(packet, buf);
  
  	if (my_net_write(&thd->net, (char*)thd->packet.ptr(),
						packet->length())) {
		ut_free(buf);
	
    		DBUG_RETURN(-1);
    	}

	ut_free(buf);

  	send_eof(&thd->net);

  	DBUG_RETURN(0);
}

4109 4110 4111 4112 4113
/****************************************************************************
 Handling the shared INNOBASE_SHARE structure that is needed to provide table
 locking.
****************************************************************************/

4114
static mysql_byte* innobase_get_key(INNOBASE_SHARE *share,uint *length,
4115 4116 4117
			      my_bool not_used __attribute__((unused)))
{
  *length=share->table_name_length;
4118
  return (mysql_byte*) share->table_name;
4119 4120 4121 4122 4123 4124 4125
}

static INNOBASE_SHARE *get_share(const char *table_name)
{
  INNOBASE_SHARE *share;
  pthread_mutex_lock(&innobase_mutex);
  uint length=(uint) strlen(table_name);
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4126
  if (!(share=(INNOBASE_SHARE*) hash_search(&innobase_open_tables,
4127
					(mysql_byte*) table_name,
4128 4129 4130 4131 4132 4133 4134 4135
					    length)))
  {
    if ((share=(INNOBASE_SHARE *) my_malloc(sizeof(*share)+length+1,
				       MYF(MY_WME | MY_ZEROFILL))))
    {
      share->table_name_length=length;
      share->table_name=(char*) (share+1);
      strmov(share->table_name,table_name);
4136
      if (hash_insert(&innobase_open_tables, (mysql_byte*) share))
4137 4138 4139 4140 4141 4142
      {
	pthread_mutex_unlock(&innobase_mutex);
	my_free((gptr) share,0);
	return 0;
      }
      thr_lock_init(&share->lock);
4143
      pthread_mutex_init(&share->mutex,MY_MUTEX_INIT_FAST);
4144 4145 4146 4147 4148 4149 4150 4151 4152 4153 4154 4155
    }
  }
  share->use_count++;
  pthread_mutex_unlock(&innobase_mutex);
  return share;
}

static void free_share(INNOBASE_SHARE *share)
{
  pthread_mutex_lock(&innobase_mutex);
  if (!--share->use_count)
  {
4156
    hash_delete(&innobase_open_tables, (mysql_byte*) share);
4157 4158 4159 4160 4161 4162
    thr_lock_delete(&share->lock);
    pthread_mutex_destroy(&share->mutex);
    my_free((gptr) share, MYF(0));
  }
  pthread_mutex_unlock(&innobase_mutex);
}
4163 4164

/*********************************************************************
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4165
Converts a MySQL table lock stored in the 'lock' field of the handle to
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4166 4167 4168 4169 4170 4171
a proper type before storing pointer to the lock into an array of pointers.
MySQL also calls this if it wants to reset some table locks to a not-locked
state during the processing of an SQL query. An example is that during a
SELECT the read lock is released early on the 'const' tables where we only
fetch one row. MySQL does not call this when it releases all locks at the
end of an SQL statement. */
4172 4173 4174 4175 4176 4177 4178 4179 4180 4181 4182 4183 4184 4185 4186 4187 4188

THR_LOCK_DATA**
ha_innobase::store_lock(
/*====================*/
						/* out: pointer to the next
						element in the 'to' array */
	THD*			thd,		/* in: user thread handle */
	THR_LOCK_DATA**		to,		/* in: pointer to an array
						of pointers to lock structs;
						pointer to the 'lock' field
						of current handle is stored
						next to this array */
	enum thr_lock_type 	lock_type)	/* in: lock type to store in
						'lock' */
{
	row_prebuilt_t* prebuilt	= (row_prebuilt_t*) innobase_prebuilt;

4189 4190 4191 4192
	if (lock_type == TL_READ_WITH_SHARED_LOCKS ||
	    lock_type == TL_READ_NO_INSERT) {
		/* This is a SELECT ... IN SHARE MODE, or
		we are doing a complex SQL statement like
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4193 4194
		INSERT INTO ... SELECT ... and the logical logging (MySQL
		binlog) requires the use of a locking read */
4195

4196
		prebuilt->select_lock_type = LOCK_S;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4197 4198 4199 4200 4201 4202 4203
	} else if (lock_type != TL_IGNORE) {

	        /* In ha_berkeley.cc there is a comment that MySQL
	        may in exceptional cases call this with TL_IGNORE also
	        when it is NOT going to release the lock. */

	        /* We set possible LOCK_X value in external_lock, not yet
4204
		here even if this would be SELECT ... FOR UPDATE */
4205

4206 4207 4208 4209 4210 4211 4212 4213 4214 4215 4216 4217 4218 4219
		prebuilt->select_lock_type = LOCK_NONE;
	}

	if (lock_type != TL_IGNORE && lock.type == TL_UNLOCK) {

    		/* If we are not doing a LOCK TABLE, then allow multiple
		writers */

    		if ((lock_type >= TL_WRITE_CONCURRENT_INSERT &&
	 	    lock_type <= TL_WRITE) && !thd->in_lock_tables) {

      			lock_type = TL_WRITE_ALLOW_WRITE;
      		}

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4220 4221 4222 4223 4224 4225 4226 4227 4228 4229
		/* In queries of type INSERT INTO t1 SELECT ... FROM t2 ...
		MySQL would use the lock TL_READ_NO_INSERT on t2, and that
		would conflict with TL_WRITE_ALLOW_WRITE, blocking all inserts
		to t2. Convert the lock to a normal read lock to allow
		concurrent inserts to t2. */
      		
		if (lock_type == TL_READ_NO_INSERT && !thd->in_lock_tables) {
			lock_type = TL_READ;
		}
		
4230 4231 4232 4233
 		lock.type=lock_type;
  	}

  	*to++= &lock;
4234

4235 4236 4237
	return(to);
}

4238
/***********************************************************************
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4239 4240 4241 4242
This function initializes the auto-inc counter if it has not been
initialized yet. This function does not change the value of the auto-inc
counter if it already has been initialized. In parameter ret returns
the value of the auto-inc counter. */
4243

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4244 4245 4246 4247 4248 4249
int
ha_innobase::innobase_read_and_init_auto_inc(
/*=========================================*/
				/* out: 0 or error code: deadlock or
				lock wait timeout */
	longlong*	ret)	/* out: auto-inc value */
4250
{
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4251
  	row_prebuilt_t* prebuilt	= (row_prebuilt_t*) innobase_prebuilt;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4252
    	longlong        auto_inc;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4253
  	int     	error;
4254

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4255
  	ut_a(prebuilt);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4256 4257
	ut_a(prebuilt->trx ==
		(trx_t*) current_thd->transaction.all.innobase_tid);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4258 4259 4260
	ut_a(prebuilt->table);
	
	auto_inc = dict_table_autoinc_read(prebuilt->table);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4261

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4262 4263 4264 4265 4266 4267
	if (auto_inc != 0) {
		/* Already initialized */
		*ret = auto_inc;
	
		return(0);
	}
4268

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4269 4270 4271
	srv_conc_enter_innodb(prebuilt->trx);
	error = row_lock_table_autoinc_for_mysql(prebuilt);
	srv_conc_exit_innodb(prebuilt->trx);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4272

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4273 4274
	if (error != DB_SUCCESS) {
		error = convert_error_code_to_mysql(error, user_thd);
4275

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4276 4277
		goto func_exit;
	}	
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4278

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4279 4280
	/* Check again if someone has initialized the counter meanwhile */
	auto_inc = dict_table_autoinc_read(prebuilt->table);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4281

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4282 4283 4284 4285
	if (auto_inc != 0) {
		*ret = auto_inc;
	
		return(0);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4286
	}
4287

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4288 4289 4290 4291 4292 4293 4294 4295 4296
  	(void) extra(HA_EXTRA_KEYREAD);
  	index_init(table->next_number_index);

	/* We use an exclusive lock when we read the max key value from the
  	auto-increment column index. This is because then build_template will
  	advise InnoDB to fetch all columns. In SHOW TABLE STATUS the query
  	id of the auto-increment column is not changed, and previously InnoDB
  	did not fetch it, causing SHOW TABLE STATUS to show wrong values
  	for the autoinc column. */
4297

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4298
  	prebuilt->select_lock_type = LOCK_X;
4299

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4300 4301 4302 4303
  	/* Play safe and also give in another way the hint to fetch
  	all columns in the key: */
  	
	prebuilt->hint_no_need_to_fetch_extra_cols = FALSE;
4304

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4305
	prebuilt->trx->mysql_n_tables_locked += 1;
4306
  
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4307
	error = index_last(table->record[1]);
4308

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4309
  	if (error) {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4310 4311 4312 4313 4314 4315 4316 4317 4318 4319 4320
		if (error == HA_ERR_END_OF_FILE) {
			/* The table was empty, initialize to 1 */
			auto_inc = 1;

			error = 0;
		} else {
			/* Deadlock or a lock wait timeout */
  			auto_inc = -1;

  			goto func_exit;
  		}
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4321
  	} else {
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4322 4323
		/* Initialize to max(col) + 1 */
    		auto_inc = (longlong) table->next_number_field->
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4324 4325
                        	val_int_offset(table->rec_buff_length) + 1;
  	}
4326

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4327 4328 4329
	dict_table_autoinc_initialize(prebuilt->table, auto_inc);

func_exit:
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4330
  	(void) extra(HA_EXTRA_NO_KEYREAD);
4331

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4332 4333 4334 4335 4336 4337 4338 4339 4340 4341 4342 4343 4344 4345 4346 4347 4348 4349 4350 4351 4352 4353 4354 4355 4356 4357 4358 4359
	index_end();

	*ret = auto_inc;

  	return(error);
}

/***********************************************************************
This function initializes the auto-inc counter if it has not been
initialized yet. This function does not change the value of the auto-inc
counter if it already has been initialized. Returns the value of the
auto-inc counter. */

longlong
ha_innobase::get_auto_increment()
/*=============================*/
                         /* out: auto-increment column value, -1 if error
                         (deadlock or lock wait timeout) */
{
  	longlong        nr;
  	int     	error;
	
	error = innobase_read_and_init_auto_inc(&nr);

	if (error) {

		return(-1);
	}
4360

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4361
	return(nr);
4362 4363
}

4364
#endif /* HAVE_INNOBASE_DB */
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
4365