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

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

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

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


/* Some general useful functions */

#include "mysql_priv.h"
21
#include "sql_trigger.h"
bk@work.mysql.com's avatar
bk@work.mysql.com committed
22
#include <m_ctype.h>
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
23
#include "md5.h"
bk@work.mysql.com's avatar
bk@work.mysql.com committed
24 25 26

	/* Functions defined in this file */

27 28
void open_table_error(TABLE_SHARE *share, int error, int db_errno,
                      myf errortype, int errarg);
29 30
static int open_binary_frm(THD *thd, TABLE_SHARE *share,
                           uchar *head, File file);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
31 32
static void fix_type_pointers(const char ***array, TYPELIB *point_to_type,
			      uint types, char **names);
33
static uint find_field(Field **fields, byte *record, uint start, uint length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
34 35


36 37 38
/* Get column name from column hash */

static byte *get_field_name(Field **buff, uint *length,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
39 40
			    my_bool not_used __attribute__((unused)))
{
41 42
  *length= (uint) strlen((*buff)->field_name);
  return (byte*) (*buff)->field_name;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
43 44
}

45

46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70

/*
  Returns pointer to '.frm' extension of the file name.

  SYNOPSIS
    fn_rext()
    name       file name

  DESCRIPTION
    Checks file name part starting with the rightmost '.' character,
    and returns it if it is equal to '.frm'. 

  TODO
    It is a good idea to get rid of this function modifying the code
    to garantee that the functions presently calling fn_rext() always
    get arguments in the same format: either with '.frm' or without '.frm'.

  RETURN VALUES
    Pointer to the '.frm' extension. If there is no extension,
    or extension is not '.frm', pointer at the end of file name.
*/

char *fn_rext(char *name)
{
  char *res= strrchr(name, '.');
71
  if (res && !strcmp(res, reg_ext))
72 73 74 75 76
    return res;
  return name + strlen(name);
}


77 78 79 80 81 82 83 84 85 86 87 88 89 90
/*
  Allocate a setup TABLE_SHARE structure

  SYNOPSIS
    alloc_table_share()
    TABLE_LIST		Take database and table name from there
    key			Table cache key (db \0 table_name \0...)
    key_length		Length of key

  RETURN
    0  Error (out of memory)
    #  Share
*/

91
TABLE_SHARE *alloc_table_share(TABLE_LIST *table_list, char *key,
92 93 94 95
                               uint key_length)
{
  MEM_ROOT mem_root;
  TABLE_SHARE *share;
96
  char *key_buff, *path_buff;
97 98
  char path[FN_REFLEN];
  uint path_length;
99 100 101
  DBUG_ENTER("alloc_table_share");
  DBUG_PRINT("enter", ("table: '%s'.'%s'",
                       table_list->db, table_list->table_name));
102

103 104
  path_length= build_table_filename(path, sizeof(path) - 1,
                                    table_list->db,
105
                                    table_list->table_name, "", 0);
106
  init_sql_alloc(&mem_root, TABLE_ALLOC_BLOCK_SIZE, 0);
107 108 109 110 111
  if (multi_alloc_root(&mem_root,
                       &share, sizeof(*share),
                       &key_buff, key_length,
                       &path_buff, path_length + 1,
                       NULL))
112 113 114
  {
    bzero((char*) share, sizeof(*share));

115
    share->set_table_cache_key(key_buff, key, key_length);
116

117
    share->path.str= path_buff;
118 119
    share->path.length= path_length;
    strmov(share->path.str, path);
120 121
    share->normalized_path.str=    share->path.str;
    share->normalized_path.length= path_length;
122 123 124 125

    share->version=       refresh_version;
    share->flush_version= flush_version;

126 127 128 129 130 131 132 133 134 135 136 137 138 139 140
#ifdef HAVE_ROW_BASED_REPLICATION
    /*
      This constant is used to mark that no table map version has been
      assigned.  No arithmetic is done on the value: it will be
      overwritten with a value taken from MYSQL_BIN_LOG.
    */
    share->table_map_version= ~(ulonglong)0;

    /*
      Since alloc_table_share() can be called without any locking (for
      example, ha_create_table... functions), we do not assign a table
      map id here.  Instead we assign a value that is not used
      elsewhere, and then assign a table map id inside open_table()
      under the protection of the LOCK_open mutex.
    */
141
    share->table_map_id= ~0UL;
142 143
    share->cached_row_logging_check= -1;

144 145
#endif

146 147 148 149
    memcpy((char*) &share->mem_root, (char*) &mem_root, sizeof(mem_root));
    pthread_mutex_init(&share->mutex, MY_MUTEX_INIT_FAST);
    pthread_cond_init(&share->cond, NULL);
  }
150
  DBUG_RETURN(share);
151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180
}


/*
  Initialize share for temporary tables

  SYNOPSIS
    init_tmp_table_share()
    share	Share to fill
    key		Table_cache_key, as generated from create_table_def_key.
		must start with db name.    
    key_length	Length of key
    table_name	Table name
    path	Path to file (possible in lower case) without .frm

  NOTES
    This is different from alloc_table_share() because temporary tables
    don't have to be shared between threads or put into the table def
    cache, so we can do some things notable simpler and faster

    If table is not put in thd->temporary_tables (happens only when
    one uses OPEN TEMPORARY) then one can specify 'db' as key and
    use key_length= 0 as neither table_cache_key or key_length will be used).
*/

void init_tmp_table_share(TABLE_SHARE *share, const char *key,
                          uint key_length, const char *table_name,
                          const char *path)
{
  DBUG_ENTER("init_tmp_table_share");
181
  DBUG_PRINT("enter", ("table: '%s'.'%s'", key, table_name));
182 183 184 185 186 187 188 189 190 191 192 193 194 195 196

  bzero((char*) share, sizeof(*share));
  init_sql_alloc(&share->mem_root, TABLE_ALLOC_BLOCK_SIZE, 0);
  share->tmp_table=  	         INTERNAL_TMP_TABLE;
  share->db.str=                 (char*) key;
  share->db.length=		 strlen(key);
  share->table_cache_key.str=    (char*) key;
  share->table_cache_key.length= key_length;
  share->table_name.str=         (char*) table_name;
  share->table_name.length=      strlen(table_name);
  share->path.str=               (char*) path;
  share->normalized_path.str=    (char*) path;
  share->path.length= share->normalized_path.length= strlen(path);
  share->frm_version= 		 FRM_VER_TRUE_VARCHAR;

197 198 199 200 201 202
#ifdef HAVE_ROW_BASED_REPLICATION
  /*
    Temporary tables are not replicated, but we set up these fields
    anyway to be able to catch errors.
   */
  share->table_map_version= ~(ulonglong)0;
203
  share->table_map_id= ~0UL;
204
  share->cached_row_logging_check= -1;
205 206
#endif

207 208 209 210
  DBUG_VOID_RETURN;
}


211
/*
212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252
  Free table share and memory used by it

  SYNOPSIS
    free_table_share()
    share		Table share

  NOTES
    share->mutex must be locked when we come here if it's not a temp table
*/

void free_table_share(TABLE_SHARE *share)
{
  MEM_ROOT mem_root;
  DBUG_ENTER("free_table_share");
  DBUG_PRINT("enter", ("table: %s.%s", share->db.str, share->table_name.str));
  DBUG_ASSERT(share->ref_count == 0);

  /*
    If someone is waiting for this to be deleted, inform it about this.
    Don't do a delete until we know that no one is refering to this anymore.
  */
  if (share->tmp_table == NO_TMP_TABLE)
  {
    /* share->mutex is locked in release_table_share() */
    while (share->waiting_on_cond)
    {
      pthread_cond_broadcast(&share->cond);
      pthread_cond_wait(&share->cond, &share->mutex);
    }
    /* No thread refers to this anymore */
    pthread_mutex_unlock(&share->mutex);
    pthread_mutex_destroy(&share->mutex);
    pthread_cond_destroy(&share->cond);
  }
  hash_free(&share->name_hash);

  /* We must copy mem_root from share because share is allocated through it */
  memcpy((char*) &mem_root, (char*) &share->mem_root, sizeof(mem_root));
  free_root(&mem_root, MYF(0));                 // Free's share
  DBUG_VOID_RETURN;
}
253

254 255 256 257

/*
  Read table definition from a binary / text based .frm file
  
258
  SYNOPSIS
259 260 261 262
  open_table_def()
  thd		Thread handler
  share		Fill this with table definition
  db_flags	Bit mask of the following flags: OPEN_VIEW
263

264 265 266 267 268
  NOTES
    This function is called when the table definition is not cached in
    table_def_cache
    The data is returned in 'share', which is alloced by
    alloc_table_share().. The code assumes that share is initialized.
269 270 271

  RETURN VALUES
   0	ok
272 273
   1	Error (see open_table_error)
   2    Error (see open_table_error)
274
   3    Wrong data in .frm file
275 276
   4    Error (see open_table_error)
   5    Error (see open_table_error: charset unavailable)
277
   6    Unknown .frm version
278
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
279

280 281 282 283 284 285 286
int open_table_def(THD *thd, TABLE_SHARE *share, uint db_flags)
{
  int error, table_type;
  bool error_given;
  File file;
  uchar head[288], *disk_buff;
  char	path[FN_REFLEN];
287
  MEM_ROOT **root_ptr, *old_root;
288
  DBUG_ENTER("open_table_def");
289 290
  DBUG_PRINT("enter", ("table: '%s'.'%s'  path: '%s'", share->db.str,
                       share->table_name.str, share->normalized_path.str));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
291

292
  error= 1;
293
  error_given= 0;
294
  disk_buff= NULL;
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
295

296 297
  strxmov(path, share->normalized_path.str, reg_ext, NullS);
  if ((file= my_open(path, O_RDONLY | O_SHARE, MYF(0))) < 0)
bar@mysql.com's avatar
bar@mysql.com committed
298
  {
299 300 301
    if (strchr(share->table_name.str, '@'))
      goto err_not_open;

bar@mysql.com's avatar
bar@mysql.com committed
302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326
    /* Try unecoded 5.0 name */
    uint length;
    strxnmov(path, sizeof(path)-1,
             mysql_data_home, "/", share->db.str, "/",
             share->table_name.str, reg_ext, NullS);
    length= unpack_filename(path, path) - reg_ext_length;
    /*
      The following is a safety test and should never fail
      as the old file name should never be longer than the new one.
    */
    DBUG_ASSERT(length <= share->normalized_path.length);
    /*
      If the old and the new names have the same length,
      then table name does not have tricky characters,
      so no need to check the old file name.
    */
    if (length == share->normalized_path.length ||
        ((file= my_open(path, O_RDONLY | O_SHARE, MYF(0))) < 0))
      goto err_not_open;

    /* Unencoded 5.0 table name found */
    path[length]= '\0'; // Remove .frm extension
    strmov(share->normalized_path.str, path);
    share->normalized_path.length= length;
  }
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
327

328
  error= 4;
329
  if (my_read(file,(byte*) head, 64, MYF(MY_NABP)))
330
    goto err;
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
331

332
  if (head[0] == (uchar) 254 && head[1] == 1)
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
333
  {
334 335 336 337 338 339 340 341 342
    if (head[2] == FRM_VER || head[2] == FRM_VER+1 ||
        (head[2] >= FRM_VER+3 && head[2] <= FRM_VER+4))
      table_type= 1;
    else
    {
      error= 6;                                 // Unkown .frm version
      goto err;
    }
  }
343
  else if (memcmp(head, STRING_WITH_LEN("TYPE=")) == 0)
344 345 346 347 348 349 350 351 352 353 354
  {
    error= 5;
    if (memcmp(head+5,"VIEW",4) == 0)
    {
      share->is_view= 1;
      if (db_flags & OPEN_VIEW)
        error= 0;
    }
    goto err;
  }
  else
355
    goto err;
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
356

357 358 359 360 361 362 363 364 365
  /* No handling of text based files yet */
  if (table_type == 1)
  {
    root_ptr= my_pthread_getspecific_ptr(MEM_ROOT**, THR_MALLOC);
    old_root= *root_ptr;
    *root_ptr= &share->mem_root;
    error= open_binary_frm(thd, share, head, file);
    *root_ptr= old_root;

366 367 368
    if (share->db.length == 5 && !(lower_case_table_names ?
        my_strcasecmp(system_charset_info, share->db.str, "mysql") :
        strcmp(share->db.str, "mysql")))
369 370 371 372 373 374
    {
      /*
        We can't mark all tables in 'mysql' database as system since we don't
        allow to lock such tables for writing with any other tables (even with
        other system tables) and some privilege tables need this.
      */
375 376 377
      if (!(lower_case_table_names ?
            my_strcasecmp(system_charset_info, share->table_name.str, "proc") :
            strcmp(share->table_name.str, "proc")))
378 379 380
        share->system_table= 1;
      else
      {
381 382 383
        share->log_table= check_if_log_table(share->db.length, share->db.str,
                                             share->table_name.length,
                                             share->table_name.str, 0);
384 385
      }
    }
386
    error_given= 1;
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
387 388
  }

389 390
  if (!error)
    thd->status_var.opened_shares++;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
391

392 393
err:
  my_close(file, MYF(MY_WME));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
394

395 396
err_not_open:
  if (error && !error_given)
397
  {
398 399
    share->error= error;
    open_table_error(share, error, (share->open_errno= my_errno), 0);
400
  }
401

402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429
  DBUG_RETURN(error);
}


/*
  Read data from a binary .frm file from MySQL 3.23 - 5.0 into TABLE_SHARE
*/

static int open_binary_frm(THD *thd, TABLE_SHARE *share, uchar *head,
                           File file)
{
  int error, errarg= 0;
  uint new_frm_ver, field_pack_length, new_field_pack_flag;
  uint interval_count, interval_parts, read_length, int_length;
  uint db_create_options, keys, key_parts, n_length;
  uint key_info_length, com_length, null_bit_pos;
  uint extra_rec_buf_length;
  uint i,j;
  bool use_hash;
  char *keynames, *record, *names, *comment_pos;
  uchar *disk_buff, *strpos, *null_flags, *null_pos;
  ulong pos, record_offset, *rec_per_key, rec_buff_length;
  handler *handler_file= 0;
  KEY	*keyinfo;
  KEY_PART_INFO *key_part;
  SQL_CRYPT *crypted=0;
  Field  **field_ptr, *reg_field;
  const char **interval_array;
430
  enum legacy_db_type legacy_db_type;
431
  my_bitmap_map *bitmaps;
432 433 434
  DBUG_ENTER("open_binary_frm");

  new_field_pack_flag= head[27];
435
  new_frm_ver= (head[2] - FRM_VER);
436
  field_pack_length= new_frm_ver < 2 ? 11 : 17;
437
  disk_buff= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
438

439
  error= 3;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
440
  if (!(pos=get_form_pos(file,head,(TYPELIB*) 0)))
441
    goto err;                                   /* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
442

443
  share->frm_version= head[2];
444 445 446 447 448 449 450 451 452
  /*
    Check if .frm file created by MySQL 5.0. In this case we want to
    display CHAR fields as CHAR and not as VARCHAR.
    We do it this way as we want to keep the old frm version to enable
    MySQL 4.1 to read these files.
  */
  if (share->frm_version == FRM_VER_TRUE_VARCHAR -1 && head[33] == 5)
    share->frm_version= FRM_VER_TRUE_VARCHAR;

453
#ifdef WITH_PARTITION_STORAGE_ENGINE
454 455 456 457
  if (*(head+61) &&
      !(share->default_part_db_type= 
        ha_checktype(thd, (enum legacy_db_type) (uint) *(head+61), 1, 0)))
    goto err;
458
  DBUG_PRINT("info", ("default_part_db_type = %u", head[61]));
459
#endif
460 461
  legacy_db_type= (enum legacy_db_type) (uint) *(head+3);
  share->db_type= ha_checktype(thd, legacy_db_type, 0, 0);
462
  share->db_create_options= db_create_options= uint2korr(head+30);
463
  share->db_options_in_use= share->db_create_options;
464
  share->mysql_version= uint4korr(head+51);
465
  share->null_field_first= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
466 467
  if (!head[32])				// New frm file in 3.23
  {
468 469 470
    share->avg_row_length= uint4korr(head+34);
    share-> row_type= (row_type) head[40];
    share->table_charset= get_charset((uint) head[38],MYF(0));
471
    share->null_field_first= 1;
472 473 474 475
  }
  if (!share->table_charset)
  {
    /* unknown charset in head[38] or pre-3.23 frm */
476 477 478 479 480 481
    if (use_mb(default_charset_info))
    {
      /* Warn that we may be changing the size of character columns */
      sql_print_warning("'%s' had no or invalid character set, "
                        "and default character set is multi-byte, "
                        "so character column sizes may have changed",
482
                        share->path.str);
483
    }
484
    share->table_charset= default_charset_info;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
485
  }
486
  share->db_record_offset= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
487
  if (db_create_options & HA_OPTION_LONG_BLOB_PTR)
488
    share->blob_ptr_size= portable_sizeof_char_ptr;
489
  /* Set temporarily a good value for db_low_byte_first */
490
  share->db_low_byte_first= test(legacy_db_type != DB_TYPE_ISAM);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
491
  error=4;
492 493
  share->max_rows= uint4korr(head+18);
  share->min_rows= uint4korr(head+22);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
494 495

  /* Read keyinformation */
496
  key_info_length= (uint) uint2korr(head+28);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
497
  VOID(my_seek(file,(ulong) uint2korr(head+6),MY_SEEK_SET,MYF(0)));
498
  if (read_string(file,(gptr*) &disk_buff,key_info_length))
499
    goto err;                                   /* purecov: inspected */
serg@serg.mylan's avatar
serg@serg.mylan committed
500
  if (disk_buff[0] & 0x80)
serg@serg.mylan's avatar
serg@serg.mylan committed
501
  {
502 503
    share->keys=      keys=      (disk_buff[1] << 7) | (disk_buff[0] & 0x7f);
    share->key_parts= key_parts= uint2korr(disk_buff+2);
serg@serg.mylan's avatar
serg@serg.mylan committed
504 505 506
  }
  else
  {
507 508
    share->keys=      keys=      disk_buff[0];
    share->key_parts= key_parts= disk_buff[1];
serg@serg.mylan's avatar
serg@serg.mylan committed
509
  }
510 511
  share->keys_for_keyread.init(0);
  share->keys_in_use.init(keys);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
512 513

  n_length=keys*sizeof(KEY)+key_parts*sizeof(KEY_PART_INFO);
514 515
  if (!(keyinfo = (KEY*) alloc_root(&share->mem_root,
				    n_length + uint2korr(disk_buff+4))))
516
    goto err;                                   /* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
517
  bzero((char*) keyinfo,n_length);
518
  share->key_info= keyinfo;
519
  key_part= my_reinterpret_cast(KEY_PART_INFO*) (keyinfo+keys);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
520 521
  strpos=disk_buff+6;

522
  if (!(rec_per_key= (ulong*) alloc_root(&share->mem_root,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
523
					 sizeof(ulong*)*key_parts)))
524
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
525 526 527

  for (i=0 ; i < keys ; i++, keyinfo++)
  {
528
    keyinfo->table= 0;                           // Updated in open_frm
529
    if (new_frm_ver >= 3)
530 531 532 533 534
    {
      keyinfo->flags=	   (uint) uint2korr(strpos) ^ HA_NOSAME;
      keyinfo->key_length= (uint) uint2korr(strpos+2);
      keyinfo->key_parts=  (uint) strpos[4];
      keyinfo->algorithm=  (enum ha_key_alg) strpos[5];
535
      keyinfo->block_size= uint2korr(strpos+6);
536 537 538 539 540 541 542 543 544 545
      strpos+=8;
    }
    else
    {
      keyinfo->flags=	 ((uint) strpos[0]) ^ HA_NOSAME;
      keyinfo->key_length= (uint) uint2korr(strpos+1);
      keyinfo->key_parts=  (uint) strpos[3];
      keyinfo->algorithm= HA_KEY_ALG_UNDEF;
      strpos+=4;
    }
546

bk@work.mysql.com's avatar
bk@work.mysql.com committed
547 548 549 550 551 552 553 554 555
    keyinfo->key_part=	 key_part;
    keyinfo->rec_per_key= rec_per_key;
    for (j=keyinfo->key_parts ; j-- ; key_part++)
    {
      *rec_per_key++=0;
      key_part->fieldnr=	(uint16) (uint2korr(strpos) & FIELD_NR_MASK);
      key_part->offset= (uint) uint2korr(strpos+2)-1;
      key_part->key_type=	(uint) uint2korr(strpos+5);
      // key_part->field=	(Field*) 0;	// Will be fixed later
556
      if (new_frm_ver >= 1)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575
      {
	key_part->key_part_flag= *(strpos+4);
	key_part->length=	(uint) uint2korr(strpos+7);
	strpos+=9;
      }
      else
      {
	key_part->length=	*(strpos+4);
	key_part->key_part_flag=0;
	if (key_part->length > 128)
	{
	  key_part->length&=127;		/* purecov: inspected */
	  key_part->key_part_flag=HA_REVERSE_SORT; /* purecov: inspected */
	}
	strpos+=7;
      }
      key_part->store_length=key_part->length;
    }
  }
576 577
  keynames=(char*) key_part;
  strpos+= (strmov(keynames, (char *) strpos) - keynames)+1;
578

579
  share->reclength = uint2korr((head+16));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
580
  if (*(head+26) == 1)
581
    share->system= 1;				/* one-record-database */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
582 583 584
#ifdef HAVE_CRYPTED_FRM
  else if (*(head+26) == 2)
  {
585 586
    crypted= get_crypt_for_frm();
    share->crypted= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
587 588 589
  }
#endif

590 591 592 593
  record_offset= (ulong) (uint2korr(head+6)+
                          ((uint2korr(head+14) == 0xffff ?
                            uint4korr(head+47) : uint2korr(head+14))));
 
594
  if ((n_length= uint4korr(head+55)))
595 596 597
  {
    /* Read extra data segment */
    char *buff, *next_chunk, *buff_end;
598
    DBUG_PRINT("info", ("extra segment size is %u bytes", n_length));
599 600 601 602 603 604 605 606
    if (!(next_chunk= buff= my_malloc(n_length, MYF(MY_WME))))
      goto err;
    if (my_pread(file, (byte*)buff, n_length, record_offset + share->reclength,
                 MYF(MY_NABP)))
    {
      my_free(buff, MYF(0));
      goto err;
    }
607
    share->connect_string.length= uint2korr(buff);
608
    if (! (share->connect_string.str= strmake_root(&share->mem_root,
609
            next_chunk + 2, share->connect_string.length)))
610
    {
611 612
      my_free(buff, MYF(0));
      goto err;
613
    }
614
    next_chunk+= share->connect_string.length + 2;
615
    buff_end= buff + n_length;
616 617 618
    if (next_chunk + 2 < buff_end)
    {
      uint str_db_type_length= uint2korr(next_chunk);
619 620 621
      LEX_STRING name= { next_chunk + 2, str_db_type_length };
      handlerton *tmp_db_type= ha_resolve_by_name(thd, &name);
      if (tmp_db_type != NULL)
622 623 624 625
      {
        share->db_type= tmp_db_type;
        DBUG_PRINT("info", ("setting dbtype to '%.*s' (%d)",
                            str_db_type_length, next_chunk + 2,
626
                            ha_legacy_type(share->db_type)));
627
      }
628
#ifdef WITH_PARTITION_STORAGE_ENGINE
629 630 631 632 633
      else
      {
        if (!strncmp(next_chunk + 2, "partition", str_db_type_length))
        {
          /* Use partition handler */
634
          share->db_type= partition_hton;
635 636
          DBUG_PRINT("info", ("setting dbtype to '%.*s' (%d)",
                              str_db_type_length, next_chunk + 2,
637
                              ha_legacy_type(share->db_type)));
638 639 640
        }
      }
#endif
641 642
      next_chunk+= str_db_type_length + 2;
    }
643
    if (next_chunk + 5 < buff_end)
644
    {
645 646 647
      uint32 partition_info_len = uint4korr(next_chunk);
#ifdef WITH_PARTITION_STORAGE_ENGINE
      if ((share->partition_info_len= partition_info_len))
648
      {
649 650
        if (!(share->partition_info=
              (uchar*) memdup_root(&share->mem_root, next_chunk + 4,
651
                                   partition_info_len + 1)))
652 653 654 655
        {
          my_free(buff, MYF(0));
          goto err;
        }
656 657 658 659 660 661 662
      }
#else
      if (partition_info_len)
      {
        DBUG_PRINT("info", ("WITH_PARTITION_STORAGE_ENGINE is not defined"));
        my_free(buff, MYF(0));
        goto err;
663
      }
664
#endif
665
      next_chunk+= 5 + partition_info_len;
666
    }
667 668
#if MYSQL_VERSION_ID < 50200
    if (share->mysql_version >= 50106 && share->mysql_version <= 50109)
669 670
    {
      /*
671 672 673 674 675
         Partition state array was here in version 5.1.6 to 5.1.9, this code
         makes it possible to load a 5.1.6 table in later versions. Can most
         likely be removed at some point in time. Will only be used for
         upgrades within 5.1 series of versions. Upgrade to 5.2 can only be
         done from newer 5.1 versions.
676
      */
677
      next_chunk+= 4;
678
    }
679
    else if (share->mysql_version >= 50110)
680
#endif
681 682 683 684 685 686 687
    {
      /* New auto_partitioned indicator introduced in 5.1.11 */
#ifdef WITH_PARTITION_STORAGE_ENGINE
      share->auto_partitioned= *next_chunk;
#endif
      next_chunk++;
    }
688
    keyinfo= share->key_info;
689 690 691 692 693 694 695
    for (i= 0; i < keys; i++, keyinfo++)
    {
      if (keyinfo->flags & HA_USES_PARSER)
      {
        LEX_STRING parser_name;
        if (next_chunk >= buff_end)
        {
696 697
          DBUG_PRINT("error",
                     ("fulltext key uses parser that is not defined in .frm"));
698 699 700 701 702 703 704 705 706
          my_free(buff, MYF(0));
          goto err;
        }
        parser_name.str= next_chunk;
        parser_name.length= strlen(next_chunk);
        keyinfo->parser= plugin_lock(&parser_name, MYSQL_FTPARSER_PLUGIN);
        if (! keyinfo->parser)
        {
          my_error(ER_PLUGIN_IS_NOT_LOADED, MYF(0), parser_name.str);
707
          my_free(buff, MYF(0));
708 709 710 711
          goto err;
        }
      }
    }
712 713
    my_free(buff, MYF(0));
  }
714
  share->key_block_size= uint2korr(head+62);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
715 716

  error=4;
717
  extra_rec_buf_length= uint2korr(head+59);
718
  rec_buff_length= ALIGN_SIZE(share->reclength + 1 + extra_rec_buf_length);
719
  share->rec_buff_length= rec_buff_length;
720 721
  if (!(record= (char *) alloc_root(&share->mem_root,
                                    rec_buff_length)))
722
    goto err;                                   /* purecov: inspected */
723
  share->default_values= (byte *) record;
724
  if (my_pread(file,(byte*) record, (uint) share->reclength,
725
               record_offset, MYF(MY_NABP)))
726
    goto err;                                   /* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
727 728

  VOID(my_seek(file,pos,MY_SEEK_SET,MYF(0)));
729 730
  if (my_read(file,(byte*) head,288,MYF(MY_NABP)))
    goto err;
731
#ifdef HAVE_CRYPTED_FRM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
732 733 734 735
  if (crypted)
  {
    crypted->decode((char*) head+256,288-256);
    if (sint2korr(head+284) != 0)		// Should be 0
736
      goto err;                                 // Wrong password
bk@work.mysql.com's avatar
bk@work.mysql.com committed
737
  }
738
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
739

740 741 742 743 744 745 746 747
  share->fields= uint2korr(head+258);
  pos= uint2korr(head+260);			/* Length of all screens */
  n_length= uint2korr(head+268);
  interval_count= uint2korr(head+270);
  interval_parts= uint2korr(head+272);
  int_length= uint2korr(head+274);
  share->null_fields= uint2korr(head+282);
  com_length= uint2korr(head+284);
748
  share->comment.length=  (int) (head[46]);
749
  share->comment.str= strmake_root(&share->mem_root, (char*) head+47,
750
                                   share->comment.length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
751

752
  DBUG_PRINT("info",("i_count: %d  i_parts: %d  index: %d  n_length: %d  int_length: %d  com_length: %d", interval_count,interval_parts, share->keys,n_length,int_length, com_length));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
753 754

  if (!(field_ptr = (Field **)
755
	alloc_root(&share->mem_root,
756
		   (uint) ((share->fields+1)*sizeof(Field*)+
bk@work.mysql.com's avatar
bk@work.mysql.com committed
757
			   interval_count*sizeof(TYPELIB)+
758
			   (share->fields+interval_parts+
bk@work.mysql.com's avatar
bk@work.mysql.com committed
759
			    keys+3)*sizeof(my_string)+
760
			   (n_length+int_length+com_length)))))
761
    goto err;                                   /* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
762

763
  share->field= field_ptr;
764
  read_length=(uint) (share->fields * field_pack_length +
765
		      pos+ (uint) (n_length+int_length+com_length));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
766
  if (read_string(file,(gptr*) &disk_buff,read_length))
767
    goto err;                                   /* purecov: inspected */
768
#ifdef HAVE_CRYPTED_FRM
bk@work.mysql.com's avatar
bk@work.mysql.com committed
769 770 771 772 773 774
  if (crypted)
  {
    crypted->decode((char*) disk_buff,read_length);
    delete crypted;
    crypted=0;
  }
775
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
776 777
  strpos= disk_buff+pos;

778
  share->intervals= (TYPELIB*) (field_ptr+share->fields+1);
779 780
  interval_array= (const char **) (share->intervals+interval_count);
  names= (char*) (interval_array+share->fields+interval_parts+keys+3);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
781
  if (!interval_count)
782 783
    share->intervals= 0;			// For better debugging
  memcpy((char*) names, strpos+(share->fields*field_pack_length),
bk@work.mysql.com's avatar
bk@work.mysql.com committed
784
	 (uint) (n_length+int_length));
785
  comment_pos= names+(n_length+int_length);
786
  memcpy(comment_pos, disk_buff+read_length-com_length, com_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
787

788 789
  fix_type_pointers(&interval_array, &share->fieldnames, 1, &names);
  fix_type_pointers(&interval_array, share->intervals, interval_count,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
790
		    &names);
791 792 793 794

  {
    /* Set ENUM and SET lengths */
    TYPELIB *interval;
795 796
    for (interval= share->intervals;
         interval < share->intervals + interval_count;
797 798 799
         interval++)
    {
      uint count= (uint) (interval->count + 1) * sizeof(uint);
800
      if (!(interval->type_lengths= (uint *) alloc_root(&share->mem_root,
801
                                                        count)))
802
        goto err;
803
      for (count= 0; count < interval->count; count++)
804 805 806 807 808 809 810 811 812 813 814 815 816 817 818
      {
        char *val= (char*) interval->type_names[count];
        interval->type_lengths[count]= strlen(val);
        /*
          Replace all ',' symbols with NAMES_SEP_CHAR.
          See the comment in unireg.cc, pack_fields() function
          for details.
        */
        for (uint cnt= 0 ; cnt < interval->type_lengths[count] ; cnt++)
        {
          char c= val[cnt];
          if (c == ',')
            val[cnt]= NAMES_SEP_CHAR;
        }       
      }
819 820 821 822
      interval->type_lengths[count]= 0;
    }
  }

bk@work.mysql.com's avatar
bk@work.mysql.com committed
823
  if (keynames)
824
    fix_type_pointers(&interval_array, &share->keynames, 1, &keynames);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
825

826 827 828
 /* Allocate handler */
  if (!(handler_file= get_new_handler(share, thd->mem_root,
                                      share->db_type)))
829 830
    goto err;

831 832
  record= (char*) share->default_values-1;	/* Fieldstart = 1 */
  if (share->null_field_first)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
833
  {
834
    null_flags= null_pos= (uchar*) record+1;
ram@gw.mysql.r18.ru's avatar
ram@gw.mysql.r18.ru committed
835
    null_bit_pos= (db_create_options & HA_OPTION_PACK_RECORD) ? 0 : 1;
836 837 838 839 840
    /*
      null_bytes below is only correct under the condition that
      there are no bit fields.  Correct values is set below after the
      table struct is initialized
    */
841
    share->null_bytes= (share->null_fields + null_bit_pos + 7) / 8;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
842
  }
843
#ifndef WE_WANT_TO_SUPPORT_VERY_OLD_FRM_FILES
bk@work.mysql.com's avatar
bk@work.mysql.com committed
844 845
  else
  {
846
    share->null_bytes= (share->null_fields+7)/8;
847 848
    null_flags= null_pos= (uchar*) (record + 1 +share->reclength -
                                    share->null_bytes);
ram@gw.mysql.r18.ru's avatar
ram@gw.mysql.r18.ru committed
849
    null_bit_pos= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
850
  }
851
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
852

853
  use_hash= share->fields >= MAX_FIELDS_BEFORE_HASH;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
854
  if (use_hash)
855
    use_hash= !hash_init(&share->name_hash,
856
			 system_charset_info,
857
			 share->fields,0,0,
858
			 (hash_get_key) get_field_name,0,0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
859

860
  for (i=0 ; i < share->fields; i++, strpos+=field_pack_length, field_ptr++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
861
  {
862
    uint pack_flag, interval_nr, unireg_type, recpos, field_length;
863
    enum_field_types field_type;
864
    CHARSET_INFO *charset=NULL;
865
    Field::geometry_type geom_type= Field::GEOM_GEOMETRY;
866
    LEX_STRING comment;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
867

868
    if (new_frm_ver >= 3)
869 870
    {
      /* new frm file in 4.1 */
871 872 873 874 875 876 877
      field_length= uint2korr(strpos+3);
      recpos=	    uint3korr(strpos+5);
      pack_flag=    uint2korr(strpos+8);
      unireg_type=  (uint) strpos[10];
      interval_nr=  (uint) strpos[12];
      uint comment_length=uint2korr(strpos+15);
      field_type=(enum_field_types) (uint) strpos[13];
878

879
      /* charset and geometry_type share the same byte in frm */
880 881
      if (field_type == FIELD_TYPE_GEOMETRY)
      {
hf@deer.(none)'s avatar
hf@deer.(none) committed
882
#ifdef HAVE_SPATIAL
883 884
	geom_type= (Field::geometry_type) strpos[14];
	charset= &my_charset_bin;
hf@deer.(none)'s avatar
hf@deer.(none) committed
885 886
#else
	error= 4;  // unsupported field type
887
	goto err;
hf@deer.(none)'s avatar
hf@deer.(none) committed
888
#endif
889 890 891
      }
      else
      {
892 893 894 895 896 897
        if (!strpos[14])
          charset= &my_charset_bin;
        else if (!(charset=get_charset((uint) strpos[14], MYF(0))))
        {
          error= 5; // Unknown or unavailable charset
          errarg= (int) strpos[14];
898
          goto err;
899
        }
900
      }
901 902 903 904 905 906 907 908 909 910 911 912 913 914
      if (!comment_length)
      {
	comment.str= (char*) "";
	comment.length=0;
      }
      else
      {
	comment.str=    (char*) comment_pos;
	comment.length= comment_length;
	comment_pos+=   comment_length;
      }
    }
    else
    {
915 916 917
      field_length= (uint) strpos[3];
      recpos=	    uint2korr(strpos+4),
      pack_flag=    uint2korr(strpos+6);
918
      pack_flag&=   ~FIELDFLAG_NO_DEFAULT;     // Safety for old files
919 920 921
      unireg_type=  (uint) strpos[8];
      interval_nr=  (uint) strpos[10];

922 923
      /* old frm file */
      field_type= (enum_field_types) f_packtype(pack_flag);
bar@mysql.com's avatar
bar@mysql.com committed
924 925 926 927 928 929 930 931 932 933 934
      if (f_is_binary(pack_flag))
      {
        /*
          Try to choose the best 4.1 type:
          - for 4.0 "CHAR(N) BINARY" or "VARCHAR(N) BINARY" 
            try to find a binary collation for character set.
          - for other types (e.g. BLOB) just use my_charset_bin. 
        */
        if (!f_is_blob(pack_flag))
        {
          // 3.23 or 4.0 string
935
          if (!(charset= get_charset_by_csname(share->table_charset->csname,
bar@mysql.com's avatar
bar@mysql.com committed
936 937 938 939 940 941 942
                                               MY_CS_BINSORT, MYF(0))))
            charset= &my_charset_bin;
        }
        else
          charset= &my_charset_bin;
      }
      else
943
        charset= share->table_charset;
944 945
      bzero((char*) &comment, sizeof(comment));
    }
946 947 948 949

    if (interval_nr && charset->mbminlen > 1)
    {
      /* Unescape UCS2 intervals from HEX notation */
950
      TYPELIB *interval= share->intervals + interval_nr - 1;
951
      unhex_type2(interval);
952 953
    }
    
954 955 956 957 958 959 960 961 962 963 964 965
#ifndef TO_BE_DELETED_ON_PRODUCTION
    if (field_type == FIELD_TYPE_NEWDECIMAL && !share->mysql_version)
    {
      /*
        Fix pack length of old decimal values from 5.0.3 -> 5.0.4
        The difference is that in the old version we stored precision
        in the .frm table while we now store the display_length
      */
      uint decimals= f_decimals(pack_flag);
      field_length= my_decimal_precision_to_length(field_length,
                                                   decimals,
                                                   f_is_dec(pack_flag) == 0);
966 967 968 969
      sql_print_error("Found incompatible DECIMAL field '%s' in %s; "
                      "Please do \"ALTER TABLE '%s' FORCE\" to fix it!",
                      share->fieldnames.type_names[i], share->table_name.str,
                      share->table_name.str);
970 971
      push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_ERROR,
                          ER_CRASHED_ON_USAGE,
972 973 974 975 976
                          "Found incompatible DECIMAL field '%s' in %s; "
                          "Please do \"ALTER TABLE '%s' FORCE\" to fix it!",
                          share->fieldnames.type_names[i],
                          share->table_name.str,
                          share->table_name.str);
977 978 979 980
      share->crashed= 1;                        // Marker for CHECK TABLE
    }
#endif

981 982
    *field_ptr= reg_field=
      make_field(share, record+recpos,
983
		 (uint32) field_length,
ram@gw.mysql.r18.ru's avatar
ram@gw.mysql.r18.ru committed
984
		 null_pos, null_bit_pos,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
985
		 pack_flag,
986
		 field_type,
987
		 charset,
988
		 geom_type,
989
		 (Field::utype) MTYP_TYPENR(unireg_type),
bk@work.mysql.com's avatar
bk@work.mysql.com committed
990
		 (interval_nr ?
991
		  share->intervals+interval_nr-1 :
bk@work.mysql.com's avatar
bk@work.mysql.com committed
992
		  (TYPELIB*) 0),
993
		 share->fieldnames.type_names[i]);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
994
    if (!reg_field)				// Not supported field type
995 996
    {
      error= 4;
997
      goto err;			/* purecov: inspected */
998
    }
999

1000
    reg_field->field_index= i;
1001
    reg_field->comment=comment;
1002
    if (field_type == FIELD_TYPE_BIT && !f_bit_as_char(pack_flag))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1003
    {
ram@gw.mysql.r18.ru's avatar
ram@gw.mysql.r18.ru committed
1004
      if ((null_bit_pos+= field_length & 7) > 7)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1005
      {
ram@gw.mysql.r18.ru's avatar
ram@gw.mysql.r18.ru committed
1006 1007
        null_pos++;
        null_bit_pos-= 8;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1008 1009
      }
    }
ram@gw.mysql.r18.ru's avatar
ram@gw.mysql.r18.ru committed
1010 1011 1012 1013 1014
    if (!(reg_field->flags & NOT_NULL_FLAG))
    {
      if (!(null_bit_pos= (null_bit_pos + 1) & 7))
        null_pos++;
    }
1015 1016
    if (f_no_default(pack_flag))
      reg_field->flags|= NO_DEFAULT_VALUE_FLAG;
1017

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1018
    if (reg_field->unireg_check == Field::NEXT_NUMBER)
1019 1020
      share->found_next_number_field= field_ptr;
    if (share->timestamp_field == reg_field)
1021
      share->timestamp_field_offset= i;
1022

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1023
    if (use_hash)
1024 1025
      (void) my_hash_insert(&share->name_hash,
                            (byte*) field_ptr); // never fail
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1026 1027 1028 1029 1030 1031
  }
  *field_ptr=0;					// End marker

  /* Fix key->name and key_part->field */
  if (key_parts)
  {
1032
    uint primary_key=(uint) (find_type((char*) primary_key_name,
1033
				       &share->keynames, 3) - 1);
1034
    uint ha_option= handler_file->ha_table_flags();
1035 1036
    keyinfo= share->key_info;
    key_part= keyinfo->key_part;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1037

1038
    for (uint key=0 ; key < share->keys ; key++,keyinfo++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1039
    {
1040
      uint usable_parts= 0;
1041
      keyinfo->name=(char*) share->keynames.type_names[key];
1042
      /* Fix fulltext keys for old .frm files */
1043 1044
      if (share->key_info[key].flags & HA_FULLTEXT)
	share->key_info[key].algorithm= HA_KEY_ALG_FULLTEXT;
1045

1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066
      if (primary_key >= MAX_KEY && (keyinfo->flags & HA_NOSAME))
      {
	/*
	  If the UNIQUE key doesn't have NULL columns and is not a part key
	  declare this as a primary key.
	*/
	primary_key=key;
	for (i=0 ; i < keyinfo->key_parts ;i++)
	{
	  uint fieldnr= key_part[i].fieldnr;
	  if (!fieldnr ||
	      share->field[fieldnr-1]->null_ptr ||
	      share->field[fieldnr-1]->key_length() !=
	      key_part[i].length)
	  {
	    primary_key=MAX_KEY;		// Can't be used
	    break;
	  }
	}
      }

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1067 1068
      for (i=0 ; i < keyinfo->key_parts ; key_part++,i++)
      {
1069
        Field *field;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1070
	if (new_field_pack_flag <= 1)
1071
	  key_part->fieldnr= (uint16) find_field(share->field,
1072
                                                 share->default_values,
1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123
                                                 (uint) key_part->offset,
                                                 (uint) key_part->length);
	if (!key_part->fieldnr)
        {
          error= 4;                             // Wrong file
          goto err;
        }
        field= key_part->field= share->field[key_part->fieldnr-1];
        if (field->null_ptr)
        {
          key_part->null_offset=(uint) ((byte*) field->null_ptr -
                                        share->default_values);
          key_part->null_bit= field->null_bit;
          key_part->store_length+=HA_KEY_NULL_LENGTH;
          keyinfo->flags|=HA_NULL_PART_KEY;
          keyinfo->extra_length+= HA_KEY_NULL_LENGTH;
          keyinfo->key_length+= HA_KEY_NULL_LENGTH;
        }
        if (field->type() == FIELD_TYPE_BLOB ||
            field->real_type() == MYSQL_TYPE_VARCHAR)
        {
          if (field->type() == FIELD_TYPE_BLOB)
            key_part->key_part_flag|= HA_BLOB_PART;
          else
            key_part->key_part_flag|= HA_VAR_LENGTH_PART;
          keyinfo->extra_length+=HA_KEY_BLOB_LENGTH;
          key_part->store_length+=HA_KEY_BLOB_LENGTH;
          keyinfo->key_length+= HA_KEY_BLOB_LENGTH;
          /*
            Mark that there may be many matching values for one key
            combination ('a', 'a ', 'a  '...)
          */
          if (!(field->flags & BINARY_FLAG))
            keyinfo->flags|= HA_END_SPACE_KEY;
        }
        if (field->type() == MYSQL_TYPE_BIT)
          key_part->key_part_flag|= HA_BIT_PART;

        if (i == 0 && key != primary_key)
          field->flags |= (((keyinfo->flags & HA_NOSAME) &&
                           (keyinfo->key_parts == 1)) ?
                           UNIQUE_KEY_FLAG : MULTIPLE_KEY_FLAG);
        if (i == 0)
          field->key_start.set_bit(key);
        if (field->key_length() == key_part->length &&
            !(field->flags & BLOB_FLAG))
        {
          if (handler_file->index_flags(key, i, 0) & HA_KEYREAD_ONLY)
          {
            share->keys_for_keyread.set_bit(key);
            field->part_of_key.set_bit(key);
1124
            field->part_of_key_not_clustered.set_bit(key);
1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144
          }
          if (handler_file->index_flags(key, i, 1) & HA_READ_ORDER)
            field->part_of_sortkey.set_bit(key);
        }
        if (!(key_part->key_part_flag & HA_REVERSE_SORT) &&
            usable_parts == i)
          usable_parts++;			// For FILESORT
        field->flags|= PART_KEY_FLAG;
        if (key == primary_key)
        {
          field->flags|= PRI_KEY_FLAG;
          /*
            If this field is part of the primary key and all keys contains
            the primary key, then we can use any key to find this column
          */
          if (ha_option & HA_PRIMARY_KEY_IN_READ_INDEX)
            field->part_of_key= share->keys_in_use;
        }
        if (field->key_length() != key_part->length)
        {
1145
#ifndef TO_BE_DELETED_ON_PRODUCTION
1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172
          if (field->type() == FIELD_TYPE_NEWDECIMAL)
          {
            /*
              Fix a fatal error in decimal key handling that causes crashes
              on Innodb. We fix it by reducing the key length so that
              InnoDB never gets a too big key when searching.
              This allows the end user to do an ALTER TABLE to fix the
              error.
            */
            keyinfo->key_length-= (key_part->length - field->key_length());
            key_part->store_length-= (uint16)(key_part->length -
                                              field->key_length());
            key_part->length= (uint16)field->key_length();
            sql_print_error("Found wrong key definition in %s; "
                            "Please do \"ALTER TABLE '%s' FORCE \" to fix it!",
                            share->table_name.str,
                            share->table_name.str);
            push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_ERROR,
                                ER_CRASHED_ON_USAGE,
                                "Found wrong key definition in %s; "
                                "Please do \"ALTER TABLE '%s' FORCE\" to fix "
                                "it!",
                                share->table_name.str,
                                share->table_name.str);
            share->crashed= 1;                // Marker for CHECK TABLE
            goto to_be_deleted;
          }
1173
#endif
1174 1175
          key_part->key_part_flag|= HA_PART_KEY_SEG;
        }
1176 1177 1178

	to_be_deleted:

1179 1180 1181 1182 1183 1184
        /*
          If the field can be NULL, don't optimize away the test
          key_part_column = expression from the WHERE clause
          as we need to test for NULL = NULL.
        */
        if (field->real_maybe_null())
1185
          key_part->key_part_flag|= HA_NULL_PART;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1186
      }
1187
      keyinfo->usable_key_parts= usable_parts; // Filesort
1188

1189
      set_if_bigger(share->max_key_length,keyinfo->key_length+
1190
                    keyinfo->key_parts);
1191
      share->total_key_length+= keyinfo->key_length;
1192 1193 1194 1195 1196 1197
      /*
        MERGE tables do not have unique indexes. But every key could be
        an unique index on the underlying MyISAM table. (Bug #10400)
      */
      if ((keyinfo->flags & HA_NOSAME) ||
          (ha_option & HA_ANY_INDEX_MAY_BE_UNIQUE))
jimw@mysql.com's avatar
jimw@mysql.com committed
1198
        set_if_bigger(share->max_unique_length,keyinfo->key_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1199
    }
1200
    if (primary_key < MAX_KEY &&
1201
	(share->keys_in_use.is_set(primary_key)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1202
    {
1203
      share->primary_key= primary_key;
1204 1205 1206 1207
      /*
	If we are using an integer as the primary key then allow the user to
	refer to it as '_rowid'
      */
1208
      if (share->key_info[primary_key].key_parts == 1)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1209
      {
1210
	Field *field= share->key_info[primary_key].key_part[0].field;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1211
	if (field && field->result_type() == INT_RESULT)
1212 1213 1214 1215 1216
        {
          /* note that fieldnr here (and rowid_field_offset) starts from 1 */
	  share->rowid_field_offset= (share->key_info[primary_key].key_part[0].
                                      fieldnr);
        }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1217 1218 1219
      }
    }
    else
1220
      share->primary_key = MAX_KEY; // we do not have a primary key
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1221
  }
1222
  else
1223
    share->primary_key= MAX_KEY;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1224
  x_free((gptr) disk_buff);
1225
  disk_buff=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1226
  if (new_field_pack_flag <= 1)
1227 1228 1229
  {
    /* Old file format with default as not null */
    uint null_length= (share->null_fields+7)/8;
1230
    bfill(share->default_values + (null_flags - (uchar*) record),
1231
          null_length, 255);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1232 1233
  }

1234
  if (share->found_next_number_field)
1235
  {
1236
    reg_field= *share->found_next_number_field;
1237
    if ((int) (share->next_number_index= (uint)
1238 1239
	       find_ref_key(share->key_info, share->keys,
                            share->default_values, reg_field,
1240
			    &share->next_number_key_offset)) < 0)
1241
    {
1242 1243
      /* Wrong field definition */
      DBUG_ASSERT(0);
1244 1245
      reg_field->unireg_check= Field::NONE;	/* purecov: inspected */
      share->found_next_number_field= 0;
1246 1247
    }
    else
1248
      reg_field->flags |= AUTO_INCREMENT_FLAG;
1249 1250
  }

1251
  if (share->blob_fields)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1252 1253
  {
    Field **ptr;
1254
    uint i, *save;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1255

1256 1257
    /* Store offsets to blob fields to find them fast */
    if (!(share->blob_field= save=
1258
	  (uint*) alloc_root(&share->mem_root,
1259
                             (uint) (share->blob_fields* sizeof(uint)))))
1260
      goto err;
1261
    for (i=0, ptr= share->field ; *ptr ; ptr++, i++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1262 1263
    {
      if ((*ptr)->flags & BLOB_FLAG)
1264
	(*save++)= i;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1265 1266 1267
    }
  }

1268 1269 1270 1271
  /*
    the correct null_bytes can now be set, since bitfields have been taken
    into account
  */
1272
  share->null_bytes= (null_pos - (uchar*) null_flags +
1273
                      (null_bit_pos + 7) / 8);
1274
  share->last_null_bit_pos= null_bit_pos;
1275

1276
  share->db_low_byte_first= handler_file->low_byte_first();
1277 1278 1279 1280 1281 1282 1283 1284
  share->column_bitmap_size= bitmap_buffer_size(share->fields);

  if (!(bitmaps= (my_bitmap_map*) alloc_root(&share->mem_root,
                                    share->column_bitmap_size)))
    goto err;
  bitmap_init(&share->all_set, bitmaps, share->fields, FALSE);
  bitmap_set_all(&share->all_set);

1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332
  delete handler_file;
#ifndef DBUG_OFF
  if (use_hash)
    (void) hash_check(&share->name_hash);
#endif
  DBUG_RETURN (0);

 err:
  share->error= error;
  share->open_errno= my_errno;
  share->errarg= errarg;
  x_free((gptr) disk_buff);
  delete crypted;
  delete handler_file;
  hash_free(&share->name_hash);

  open_table_error(share, error, share->open_errno, errarg);
  DBUG_RETURN(error);
} /* open_binary_frm */


/*
  Open a table based on a TABLE_SHARE

  SYNOPSIS
    open_table_from_share()
    thd			Thread handler
    share		Table definition
    alias       	Alias for table
    db_stat		open flags (for example HA_OPEN_KEYFILE|
    			HA_OPEN_RNDFILE..) can be 0 (example in
                        ha_example_table)
    prgflag   		READ_ALL etc..
    ha_open_flags	HA_OPEN_ABORT_IF_LOCKED etc..
    outparam       	result table

  RETURN VALUES
   0	ok
   1	Error (see open_table_error)
   2    Error (see open_table_error)
   3    Wrong data in .frm file
   4    Error (see open_table_error)
   5    Error (see open_table_error: charset unavailable)
   7    Table definition has changed in engine
*/

int open_table_from_share(THD *thd, TABLE_SHARE *share, const char *alias,
                          uint db_stat, uint prgflag, uint ha_open_flags,
1333
                          TABLE *outparam, bool is_create_table)
1334 1335
{
  int error;
1336
  uint records, i, bitmap_size;
1337
  bool error_reported= FALSE;
1338
  byte *record, *bitmaps;
1339 1340 1341
  Field **field_ptr;
  DBUG_ENTER("open_table_from_share");
  DBUG_PRINT("enter",("name: '%s.%s'  form: 0x%lx", share->db.str,
1342
                      share->table_name.str, (long) outparam));
1343 1344 1345 1346 1347 1348

  error= 1;
  bzero((char*) outparam, sizeof(*outparam));
  outparam->in_use= thd;
  outparam->s= share;
  outparam->db_stat= db_stat;
1349
  outparam->write_row_record= NULL;
1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411

  init_sql_alloc(&outparam->mem_root, TABLE_ALLOC_BLOCK_SIZE, 0);

  if (!(outparam->alias= my_strdup(alias, MYF(MY_WME))))
    goto err;
  outparam->quick_keys.init();
  outparam->used_keys.init();
  outparam->keys_in_use_for_query.init();

  /* Allocate handler */
  if (!(outparam->file= get_new_handler(share, &outparam->mem_root,
                                        share->db_type)))
    goto err;

  error= 4;
  outparam->reginfo.lock_type= TL_UNLOCK;
  outparam->current_lock= F_UNLCK;
  records=0;
  if ((db_stat & HA_OPEN_KEYFILE) || (prgflag & DELAYED_OPEN))
    records=1;
  if (prgflag & (READ_ALL+EXTRA_RECORD))
    records++;

  if (!(record= (byte*) alloc_root(&outparam->mem_root,
                                   share->rec_buff_length * records)))
    goto err;                                   /* purecov: inspected */

  if (records == 0)
  {
    /* We are probably in hard repair, and the buffers should not be used */
    outparam->record[0]= outparam->record[1]= share->default_values;
  }
  else
  {
    outparam->record[0]= record;
    if (records > 1)
      outparam->record[1]= record+ share->rec_buff_length;
    else
      outparam->record[1]= outparam->record[0];   // Safety
  }

#ifdef HAVE_purify
  /*
    We need this because when we read var-length rows, we are not updating
    bytes after end of varchar
  */
  if (records > 1)
  {
    memcpy(outparam->record[0], share->default_values, share->rec_buff_length);
    if (records > 2)
      memcpy(outparam->record[1], share->default_values,
             share->rec_buff_length);
  }
#endif

  if (!(field_ptr = (Field **) alloc_root(&outparam->mem_root,
                                          (uint) ((share->fields+1)*
                                                  sizeof(Field*)))))
    goto err;                                   /* purecov: inspected */

  outparam->field= field_ptr;

1412
  record= (byte*) outparam->record[0]-1;	/* Fieldstart = 1 */
1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472
  if (share->null_field_first)
    outparam->null_flags= (uchar*) record+1;
  else
    outparam->null_flags= (uchar*) (record+ 1+ share->reclength -
                                    share->null_bytes);

  /* Setup copy of fields from share, but use the right alias and record */
  for (i=0 ; i < share->fields; i++, field_ptr++)
  {
    if (!((*field_ptr)= share->field[i]->clone(&outparam->mem_root, outparam)))
      goto err;
  }
  (*field_ptr)= 0;                              // End marker

  if (share->found_next_number_field)
    outparam->found_next_number_field=
      outparam->field[(uint) (share->found_next_number_field - share->field)];
  if (share->timestamp_field)
    outparam->timestamp_field= (Field_timestamp*) outparam->field[share->timestamp_field_offset];


  /* Fix key->name and key_part->field */
  if (share->key_parts)
  {
    KEY	*key_info, *key_info_end;
    KEY_PART_INFO *key_part;
    uint n_length;
    n_length= share->keys*sizeof(KEY) + share->key_parts*sizeof(KEY_PART_INFO);
    if (!(key_info= (KEY*) alloc_root(&outparam->mem_root, n_length)))
      goto err;
    outparam->key_info= key_info;
    key_part= (my_reinterpret_cast(KEY_PART_INFO*) (key_info+share->keys));
    
    memcpy(key_info, share->key_info, sizeof(*key_info)*share->keys);
    memcpy(key_part, share->key_info[0].key_part, (sizeof(*key_part) *
                                                   share->key_parts));

    for (key_info_end= key_info + share->keys ;
         key_info < key_info_end ;
         key_info++)
    {
      KEY_PART_INFO *key_part_end;

      key_info->table= outparam;
      key_info->key_part= key_part;

      for (key_part_end= key_part+ key_info->key_parts ;
           key_part < key_part_end ;
           key_part++)
      {
        Field *field= key_part->field= outparam->field[key_part->fieldnr-1];

        if (field->key_length() != key_part->length &&
            !(field->flags & BLOB_FLAG))
        {
          /*
            We are using only a prefix of the column as a key:
            Create a new field for the key part that matches the index
          */
          field= key_part->field=field->new_field(&outparam->mem_root,
ingo@chilla.local's avatar
ingo@chilla.local committed
1473
                                                  outparam, 0);
1474 1475 1476 1477 1478 1479 1480 1481 1482
          field->field_length= key_part->length;
        }
      }
    }
  }

#ifdef WITH_PARTITION_STORAGE_ENGINE
  if (share->partition_info_len)
  {
1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498
  /*
    In this execution we must avoid calling thd->change_item_tree since
    we might release memory before statement is completed. We do this
    by changing to a new statement arena. As part of this arena we also
    set the memory root to be the memory root of the table since we
    call the parser and fix_fields which both can allocate memory for
    item objects. We keep the arena to ensure that we can release the
    free_list when closing the table object.
    SEE Bug #21658
  */

    Query_arena *backup_stmt_arena_ptr= thd->stmt_arena;
    Query_arena backup_arena;
    Query_arena part_func_arena(&outparam->mem_root, Query_arena::INITIALIZED);
    thd->set_n_backup_active_arena(&part_func_arena, &backup_arena);
    thd->stmt_arena= &part_func_arena;
1499 1500
    bool tmp;

1501 1502 1503 1504 1505 1506
    tmp= mysql_unpack_partition(thd, share->partition_info,
                                share->partition_info_len,
                                (uchar*)share->part_state,
                                share->part_state_len,
                                outparam, is_create_table,
                                share->default_part_db_type);
1507
    outparam->part_info->is_auto_partitioned= share->auto_partitioned;
1508 1509
    DBUG_PRINT("info", ("autopartitioned: %u", share->auto_partitioned));
    if (!tmp)
1510
      tmp= fix_partition_func(thd, outparam, is_create_table);
1511 1512
    thd->stmt_arena= backup_stmt_arena_ptr;
    thd->restore_active_arena(&part_func_arena, &backup_arena);
1513 1514
    if (!tmp)
      outparam->part_info->item_free_list= part_func_arena.free_list;
1515
    if (tmp)
1516 1517 1518 1519 1520 1521 1522 1523 1524 1525
    {
      if (is_create_table)
      {
        /*
          During CREATE/ALTER TABLE it is ok to receive errors here.
          It is not ok if it happens during the opening of an frm
          file as part of a normal query.
        */
        error_reported= TRUE;
      }
1526
      goto err;
1527
    }
1528 1529 1530
  }
#endif

1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543
  /* Allocate bitmaps */

  bitmap_size= share->column_bitmap_size;
  if (!(bitmaps= (byte*) alloc_root(&outparam->mem_root, bitmap_size*3)))
    goto err;
  bitmap_init(&outparam->def_read_set,
              (my_bitmap_map*) bitmaps, share->fields, FALSE);
  bitmap_init(&outparam->def_write_set,
              (my_bitmap_map*) (bitmaps+bitmap_size), share->fields, FALSE);
  bitmap_init(&outparam->tmp_set,
              (my_bitmap_map*) (bitmaps+bitmap_size*2), share->fields, FALSE);
  outparam->default_column_bitmaps();

1544
  /* The table struct is now initialized;  Open the table */
1545
  error= 2;
1546 1547
  if (db_stat)
  {
1548 1549
    int ha_err;
    if ((ha_err= (outparam->file->
1550
                  ha_open(outparam, share->normalized_path.str,
1551 1552 1553 1554 1555 1556 1557 1558
                          (db_stat & HA_READ_ONLY ? O_RDONLY : O_RDWR),
                          (db_stat & HA_OPEN_TEMPORARY ? HA_OPEN_TMP_TABLE :
                           ((db_stat & HA_WAIT_IF_LOCKED) ||
                            (specialflag & SPECIAL_WAIT_IF_LOCKED)) ?
                           HA_OPEN_WAIT_IF_LOCKED :
                           (db_stat & (HA_ABORT_IF_LOCKED | HA_GET_INFO)) ?
                          HA_OPEN_ABORT_IF_LOCKED :
                           HA_OPEN_IGNORE_IF_LOCKED) | ha_open_flags))))
1559 1560
    {
      /* Set a flag if the table is crashed and it can be auto. repaired */
1561
      share->crashed= ((ha_err == HA_ERR_CRASHED_ON_USAGE) &&
1562 1563
                       outparam->file->auto_repair() &&
                       !(ha_open_flags & HA_OPEN_FOR_REPAIR));
1564

1565
      if (ha_err == HA_ERR_NO_SUCH_TABLE)
1566
      {
1567 1568 1569 1570
	/*
          The table did not exists in storage engine, use same error message
          as if the .frm file didn't exist
        */
1571 1572 1573
	error= 1;
	my_errno= ENOENT;
      }
1574 1575
      else
      {
1576
        outparam->file->print_error(ha_err, MYF(0));
1577
        error_reported= TRUE;
1578 1579
        if (ha_err == HA_ERR_TABLE_DEF_CHANGED)
          error= 7;
1580
      }
1581
      goto err;                                 /* purecov: inspected */
1582 1583 1584
    }
  }

1585 1586 1587 1588
#if defined(HAVE_purify) && !defined(DBUG_OFF)
  bzero((char*) bitmaps, bitmap_size*3);
#endif

1589
  thd->status_var.opened_tables++;
1590

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1591 1592
  DBUG_RETURN (0);

1593
 err:
1594
  if (! error_reported)
1595
    open_table_error(share, error, my_errno, 0);
1596
  delete outparam->file;
1597
#ifdef WITH_PARTITION_STORAGE_ENGINE
1598 1599
  if (outparam->part_info)
    free_items(outparam->part_info->item_free_list);
1600
#endif
1601
  outparam->file= 0;				// For easier error checking
1602
  outparam->db_stat=0;
1603
  free_root(&outparam->mem_root, MYF(0));       // Safe to call on bzero'd root
1604
  my_free((char*) outparam->alias, MYF(MY_ALLOW_ZERO_PTR));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1605
  DBUG_RETURN (error);
1606
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1607

1608 1609 1610 1611 1612 1613 1614 1615 1616

/*
  Free information allocated by openfrm

  SYNOPSIS
    closefrm()
    table		TABLE object to free
    free_share		Is 1 if we also want to free table_share
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1617

1618
int closefrm(register TABLE *table, bool free_share)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1619 1620
{
  int error=0;
1621 1622
  uint idx;
  KEY *key_info;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1623
  DBUG_ENTER("closefrm");
1624
  DBUG_PRINT("enter", ("table: 0x%lx", (long) table));
1625

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1626 1627
  if (table->db_stat)
    error=table->file->close();
1628 1629 1630 1631
  key_info= table->key_info;
  for (idx= table->s->keys; idx; idx--, key_info++)
  {
    if (key_info->flags & HA_USES_PARSER)
1632
    {
1633
      plugin_unlock(key_info->parser);
1634 1635
      key_info->flags= 0;
    }
1636
  }
1637 1638 1639
  my_free((char*) table->alias, MYF(MY_ALLOW_ZERO_PTR));
  table->alias= 0;
  if (table->field)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1640 1641 1642
  {
    for (Field **ptr=table->field ; *ptr ; ptr++)
      delete *ptr;
1643
    table->field= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1644 1645
  }
  delete table->file;
1646
  table->file= 0;				/* For easier errorchecking */
1647
#ifdef WITH_PARTITION_STORAGE_ENGINE
1648
  if (table->part_info)
1649
  {
1650
    free_items(table->part_info->item_free_list);
1651
    table->part_info->item_free_list= 0;
1652
    table->part_info= 0;
1653 1654
  }
#endif
1655 1656 1657 1658 1659 1660 1661
  if (free_share)
  {
    if (table->s->tmp_table == NO_TMP_TABLE)
      release_table_share(table->s, RELEASE_NORMAL);
    else
      free_table_share(table->s);
  }
1662
  free_root(&table->mem_root, MYF(0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1663 1664 1665 1666 1667 1668 1669 1670
  DBUG_RETURN(error);
}


/* Deallocate temporary blob storage */

void free_blobs(register TABLE *table)
{
1671 1672 1673 1674 1675
  uint *ptr, *end;
  for (ptr= table->s->blob_field, end=ptr + table->s->blob_fields ;
       ptr != end ;
       ptr++)
    ((Field_blob*) table->field[*ptr])->free();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712
}


	/* Find where a form starts */
	/* if formname is NullS then only formnames is read */

ulong get_form_pos(File file, uchar *head, TYPELIB *save_names)
{
  uint a_length,names,length;
  uchar *pos,*buf;
  ulong ret_value=0;
  DBUG_ENTER("get_form_pos");

  names=uint2korr(head+8);
  a_length=(names+2)*sizeof(my_string);		/* Room for two extra */

  if (!save_names)
    a_length=0;
  else
    save_names->type_names=0;			/* Clear if error */

  if (names)
  {
    length=uint2korr(head+4);
    VOID(my_seek(file,64L,MY_SEEK_SET,MYF(0)));
    if (!(buf= (uchar*) my_malloc((uint) length+a_length+names*4,
				  MYF(MY_WME))) ||
	my_read(file,(byte*) buf+a_length,(uint) (length+names*4),
		MYF(MY_NABP)))
    {						/* purecov: inspected */
      x_free((gptr) buf);			/* purecov: inspected */
      DBUG_RETURN(0L);				/* purecov: inspected */
    }
    pos= buf+a_length+length;
    ret_value=uint4korr(pos);
  }
  if (! save_names)
1713 1714 1715 1716
  {
    if (names)
      my_free((gptr) buf,MYF(0));
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758
  else if (!names)
    bzero((char*) save_names,sizeof(save_names));
  else
  {
    char *str;
    str=(char *) (buf+a_length);
    fix_type_pointers((const char ***) &buf,save_names,1,&str);
  }
  DBUG_RETURN(ret_value);
}


	/* Read string from a file with malloc */

int read_string(File file, gptr *to, uint length)
{
  DBUG_ENTER("read_string");

  x_free((gptr) *to);
  if (!(*to= (gptr) my_malloc(length+1,MYF(MY_WME))) ||
      my_read(file,(byte*) *to,length,MYF(MY_NABP)))
  {
    x_free((gptr) *to); /* purecov: inspected */
    *to= 0; /* purecov: inspected */
    DBUG_RETURN(1); /* purecov: inspected */
  }
  *((char*) *to+length)= '\0';
  DBUG_RETURN (0);
} /* read_string */


	/* Add a new form to a form file */

ulong make_new_entry(File file, uchar *fileinfo, TYPELIB *formnames,
		     const char *newname)
{
  uint i,bufflength,maxlength,n_length,length,names;
  ulong endpos,newpos;
  char buff[IO_SIZE];
  uchar *pos;
  DBUG_ENTER("make_new_entry");

1759
  length=(uint) strlen(newname)+1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1760 1761 1762 1763 1764 1765 1766 1767 1768
  n_length=uint2korr(fileinfo+4);
  maxlength=uint2korr(fileinfo+6);
  names=uint2korr(fileinfo+8);
  newpos=uint4korr(fileinfo+10);

  if (64+length+n_length+(names+1)*4 > maxlength)
  {						/* Expand file */
    newpos+=IO_SIZE;
    int4store(fileinfo+10,newpos);
1769
    endpos=(ulong) my_seek(file,0L,MY_SEEK_END,MYF(0));/* Copy from file-end */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1770 1771 1772 1773 1774 1775 1776 1777 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 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812
    bufflength= (uint) (endpos & (IO_SIZE-1));	/* IO_SIZE is a power of 2 */

    while (endpos > maxlength)
    {
      VOID(my_seek(file,(ulong) (endpos-bufflength),MY_SEEK_SET,MYF(0)));
      if (my_read(file,(byte*) buff,bufflength,MYF(MY_NABP+MY_WME)))
	DBUG_RETURN(0L);
      VOID(my_seek(file,(ulong) (endpos-bufflength+IO_SIZE),MY_SEEK_SET,
		   MYF(0)));
      if ((my_write(file,(byte*) buff,bufflength,MYF(MY_NABP+MY_WME))))
	DBUG_RETURN(0);
      endpos-=bufflength; bufflength=IO_SIZE;
    }
    bzero(buff,IO_SIZE);			/* Null new block */
    VOID(my_seek(file,(ulong) maxlength,MY_SEEK_SET,MYF(0)));
    if (my_write(file,(byte*) buff,bufflength,MYF(MY_NABP+MY_WME)))
	DBUG_RETURN(0L);
    maxlength+=IO_SIZE;				/* Fix old ref */
    int2store(fileinfo+6,maxlength);
    for (i=names, pos= (uchar*) *formnames->type_names+n_length-1; i-- ;
	 pos+=4)
    {
      endpos=uint4korr(pos)+IO_SIZE;
      int4store(pos,endpos);
    }
  }

  if (n_length == 1 )
  {						/* First name */
    length++;
    VOID(strxmov(buff,"/",newname,"/",NullS));
  }
  else
    VOID(strxmov(buff,newname,"/",NullS)); /* purecov: inspected */
  VOID(my_seek(file,63L+(ulong) n_length,MY_SEEK_SET,MYF(0)));
  if (my_write(file,(byte*) buff,(uint) length+1,MYF(MY_NABP+MY_WME)) ||
      (names && my_write(file,(byte*) (*formnames->type_names+n_length-1),
			 names*4, MYF(MY_NABP+MY_WME))) ||
      my_write(file,(byte*) fileinfo+10,(uint) 4,MYF(MY_NABP+MY_WME)))
    DBUG_RETURN(0L); /* purecov: inspected */

  int2store(fileinfo+8,names+1);
  int2store(fileinfo+4,n_length+length);
1813
  VOID(my_chsize(file, newpos, 0, MYF(MY_WME)));/* Append file with '\0' */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1814 1815 1816 1817 1818 1819
  DBUG_RETURN(newpos);
} /* make_new_entry */


	/* error message when opening a form file */

1820
void open_table_error(TABLE_SHARE *share, int error, int db_errno, int errarg)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1821 1822 1823
{
  int err_no;
  char buff[FN_REFLEN];
1824 1825
  myf errortype= ME_ERROR+ME_WAITTANG;
  DBUG_ENTER("open_table_error");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1826 1827

  switch (error) {
1828
  case 7:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1829
  case 1:
1830 1831 1832
    if (db_errno == ENOENT)
      my_error(ER_NO_SUCH_TABLE, MYF(0), share->db.str, share->table_name.str);
    else
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1833
    {
1834
      strxmov(buff, share->normalized_path.str, reg_ext, NullS);
1835 1836
      my_error((db_errno == EMFILE) ? ER_CANT_OPEN_FILE : ER_FILE_NOT_FOUND,
               errortype, buff, db_errno);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1837 1838 1839 1840
    }
    break;
  case 2:
  {
1841 1842 1843
    handler *file= 0;
    const char *datext= "";
    
1844
    if (share->db_type != NULL)
1845 1846 1847 1848 1849 1850 1851 1852 1853
    {
      if ((file= get_new_handler(share, current_thd->mem_root,
                                 share->db_type)))
      {
        if (!(datext= *file->bas_ext()))
          datext= "";
      }
    }
    err_no= (db_errno == ENOENT) ? ER_FILE_NOT_FOUND : (db_errno == EAGAIN) ?
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1854
      ER_FILE_USED : ER_CANT_OPEN_FILE;
1855 1856 1857
    strxmov(buff, share->normalized_path.str, datext, NullS);
    my_error(err_no,errortype, buff, db_errno);
    delete file;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1858 1859
    break;
  }
1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870
  case 5:
  {
    const char *csname= get_charset_name((uint) errarg);
    char tmp[10];
    if (!csname || csname[0] =='?')
    {
      my_snprintf(tmp, sizeof(tmp), "#%d", errarg);
      csname= tmp;
    }
    my_printf_error(ER_UNKNOWN_COLLATION,
                    "Unknown collation '%s' in table '%-.64s' definition", 
1871
                    MYF(0), csname, share->table_name.str);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1872 1873
    break;
  }
1874
  case 6:
1875
    strxmov(buff, share->normalized_path.str, reg_ext, NullS);
1876 1877
    my_printf_error(ER_NOT_FORM_FILE,
                    "Table '%-.64s' was created with a different version "
1878 1879
                    "of MySQL and cannot be read", 
                    MYF(0), buff);
1880
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1881 1882
  default:				/* Better wrong error than none */
  case 4:
1883 1884
    strxmov(buff, share->normalized_path.str, reg_ext, NullS);
    my_error(ER_NOT_FORM_FILE, errortype, buff, 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1885 1886 1887
    break;
  }
  DBUG_VOID_RETURN;
1888
} /* open_table_error */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1889 1890 1891 1892


	/*
	** fix a str_type to a array type
1893
	** typeparts separated with some char. differents types are separated
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1894 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917
	** with a '\0'
	*/

static void
fix_type_pointers(const char ***array, TYPELIB *point_to_type, uint types,
		  char **names)
{
  char *type_name, *ptr;
  char chr;

  ptr= *names;
  while (types--)
  {
    point_to_type->name=0;
    point_to_type->type_names= *array;

    if ((chr= *ptr))			/* Test if empty type */
    {
      while ((type_name=strchr(ptr+1,chr)) != NullS)
      {
	*((*array)++) = ptr+1;
	*type_name= '\0';		/* End string */
	ptr=type_name;
      }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1918
      ptr+=2;				/* Skip end mark and last 0 */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930
    }
    else
      ptr++;
    point_to_type->count= (uint) (*array - point_to_type->type_names);
    point_to_type++;
    *((*array)++)= NullS;		/* End of type */
  }
  *names=ptr;				/* Update end */
  return;
} /* fix_type_pointers */


1931
TYPELIB *typelib(MEM_ROOT *mem_root, List<String> &strings)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1932
{
1933
  TYPELIB *result= (TYPELIB*) alloc_root(mem_root, sizeof(TYPELIB));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1934 1935 1936 1937
  if (!result)
    return 0;
  result->count=strings.elements;
  result->name="";
1938
  uint nbytes= (sizeof(char*) + sizeof(uint)) * (result->count + 1);
1939
  if (!(result->type_names= (const char**) alloc_root(mem_root, nbytes)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1940
    return 0;
1941
  result->type_lengths= (uint*) (result->type_names + result->count + 1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1942 1943 1944
  List_iterator<String> it(strings);
  String *tmp;
  for (uint i=0; (tmp=it++) ; i++)
1945 1946 1947 1948 1949 1950
  {
    result->type_names[i]= tmp->ptr();
    result->type_lengths[i]= tmp->length();
  }
  result->type_names[result->count]= 0;		// End marker
  result->type_lengths[result->count]= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1951 1952 1953 1954
  return result;
}


1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966
/*
 Search after a field with given start & length
 If an exact field isn't found, return longest field with starts
 at right position.
 
 NOTES
   This is needed because in some .frm fields 'fieldnr' was saved wrong

 RETURN
   0  error
   #  field number +1
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1967

1968
static uint find_field(Field **fields, byte *record, uint start, uint length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1969 1970
{
  Field **field;
1971
  uint i, pos;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1972

1973 1974
  pos= 0;
  for (field= fields, i=1 ; *field ; i++,field++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1975
  {
1976
    if ((*field)->offset(record) == start)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1977 1978 1979
    {
      if ((*field)->key_length() == length)
	return (i);
1980
      if (!pos || fields[pos-1]->pack_length() <
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1981
	  (*field)->pack_length())
1982
	pos= i;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1983 1984 1985 1986 1987 1988
    }
  }
  return (pos);
}


1989
	/* Check that the integer is in the internal */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010

int set_zone(register int nr, int min_zone, int max_zone)
{
  if (nr<=min_zone)
    return (min_zone);
  if (nr>=max_zone)
    return (max_zone);
  return (nr);
} /* set_zone */

	/* Adjust number to next larger disk buffer */

ulong next_io_size(register ulong pos)
{
  reg2 ulong offset;
  if ((offset= pos & (IO_SIZE-1)))
    return pos-offset+IO_SIZE;
  return pos;
} /* next_io_size */


2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
/*
  Store an SQL quoted string.

  SYNOPSIS  
    append_unescaped()
    res		result String
    pos		string to be quoted
    length	it's length

  NOTE
    This function works correctly with utf8 or single-byte charset strings.
    May fail with some multibyte charsets though.
*/
2024

2025
void append_unescaped(String *res, const char *pos, uint length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2026
{
2027 2028 2029 2030
  const char *end= pos+length;
  res->append('\'');

  for (; pos != end ; pos++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2031
  {
monty@mysql.com's avatar
monty@mysql.com committed
2032
#if defined(USE_MB) && MYSQL_VERSION_ID < 40100
bar@mysql.com's avatar
bar@mysql.com committed
2033 2034 2035 2036 2037 2038 2039 2040 2041 2042
    uint mblen;
    if (use_mb(default_charset_info) &&
        (mblen= my_ismbchar(default_charset_info, pos, end)))
    {
      res->append(pos, mblen);
      pos+= mblen;
      continue;
    }
#endif

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2043 2044 2045 2046 2047 2048 2049 2050 2051 2052
    switch (*pos) {
    case 0:				/* Must be escaped for 'mysql' */
      res->append('\\');
      res->append('0');
      break;
    case '\n':				/* Must be escaped for logs */
      res->append('\\');
      res->append('n');
      break;
    case '\r':
2053
      res->append('\\');		/* This gives better readability */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068
      res->append('r');
      break;
    case '\\':
      res->append('\\');		/* Because of the sql syntax */
      res->append('\\');
      break;
    case '\'':
      res->append('\'');		/* Because of the sql syntax */
      res->append('\'');
      break;
    default:
      res->append(*pos);
      break;
    }
  }
2069
  res->append('\'');
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2070 2071
}

2072

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2073 2074
	/* Create a .frm file */

2075
File create_frm(THD *thd, const char *name, const char *db,
2076
                const char *table, uint reclength, uchar *fileinfo,
2077
  		HA_CREATE_INFO *create_info, uint keys)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2078 2079
{
  register File file;
2080
  uint key_length;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2081 2082
  ulong length;
  char fill[IO_SIZE];
2083 2084 2085 2086
  int create_flags= O_RDWR | O_TRUNC;

  if (create_info->options & HA_LEX_CREATE_TMP_TABLE)
    create_flags|= O_EXCL | O_NOFOLLOW;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2087

monty@mysql.com's avatar
monty@mysql.com committed
2088
  /* Fix this when we have new .frm files;  Current limit is 4G rows (QQ) */
2089 2090 2091 2092
  if (create_info->max_rows > UINT_MAX32)
    create_info->max_rows= UINT_MAX32;
  if (create_info->min_rows > UINT_MAX32)
    create_info->min_rows= UINT_MAX32;
2093

2094
  if ((file= my_create(name, CREATE_MODE, create_flags, MYF(0))) >= 0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2095
  {
2096 2097
    uint key_length, tmp_key_length;
    uint tmp;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2098
    bzero((char*) fileinfo,64);
2099 2100 2101 2102 2103
    /* header */
    fileinfo[0]=(uchar) 254;
    fileinfo[1]= 1;
    fileinfo[2]= FRM_VER+3+ test(create_info->varchar);

2104 2105
    fileinfo[3]= (uchar) ha_legacy_type(
          ha_checktype(thd,ha_legacy_type(create_info->db_type),0,0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2106 2107 2108
    fileinfo[4]=1;
    int2store(fileinfo+6,IO_SIZE);		/* Next block starts here */
    key_length=keys*(7+NAME_LEN+MAX_REF_PARTS*9)+16;
2109 2110
    length= next_io_size((ulong) (IO_SIZE+key_length+reclength+
                                  create_info->extra_size));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2111
    int4store(fileinfo+10,length);
2112 2113
    tmp_key_length= (key_length < 0xffff) ? key_length : 0xffff;
    int2store(fileinfo+14,tmp_key_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2114 2115 2116 2117 2118 2119 2120
    int2store(fileinfo+16,reclength);
    int4store(fileinfo+18,create_info->max_rows);
    int4store(fileinfo+22,create_info->min_rows);
    fileinfo[27]=2;				// Use long pack-fields
    create_info->table_options|=HA_OPTION_LONG_BLOB_PTR; // Use portable blob pointers
    int2store(fileinfo+30,create_info->table_options);
    fileinfo[32]=0;				// No filename anymore
2121
    fileinfo[33]=5;                             // Mark for 5.0 frm file
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2122
    int4store(fileinfo+34,create_info->avg_row_length);
2123 2124
    fileinfo[38]= (create_info->default_table_charset ?
		   create_info->default_table_charset->number : 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2125
    fileinfo[40]= (uchar) create_info->row_type;
2126 2127 2128 2129 2130 2131 2132
    /* Next few bytes were for RAID support */
    fileinfo[41]= 0;
    fileinfo[42]= 0;
    fileinfo[43]= 0;
    fileinfo[44]= 0;
    fileinfo[45]= 0;
    fileinfo[46]= 0;
2133 2134 2135
    int4store(fileinfo+47, key_length);
    tmp= MYSQL_VERSION_ID;          // Store to avoid warning from int4store
    int4store(fileinfo+51, tmp);
2136
    int4store(fileinfo+55, create_info->extra_size);
2137 2138 2139 2140 2141
    /*
      59-60 is reserved for extra_rec_buf_length,
      61 for default_part_db_type
    */
    int2store(fileinfo+62, create_info->key_block_size);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2142 2143 2144 2145 2146 2147 2148 2149 2150 2151 2152
    bzero(fill,IO_SIZE);
    for (; length > IO_SIZE ; length-= IO_SIZE)
    {
      if (my_write(file,(byte*) fill,IO_SIZE,MYF(MY_WME | MY_NABP)))
      {
	VOID(my_close(file,MYF(0)));
	VOID(my_delete(name,MYF(0)));
	return(-1);
      }
    }
  }
2153 2154 2155 2156 2157 2158 2159
  else
  {
    if (my_errno == ENOENT)
      my_error(ER_BAD_DB_ERROR,MYF(0),db);
    else
      my_error(ER_CANT_CREATE_TABLE,MYF(0),table,my_errno);
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2160 2161 2162 2163 2164 2165
  return (file);
} /* create_frm */


void update_create_info_from_table(HA_CREATE_INFO *create_info, TABLE *table)
{
2166
  TABLE_SHARE *share= table->s;
2167
  DBUG_ENTER("update_create_info_from_table");
2168 2169 2170 2171 2172 2173 2174

  create_info->max_rows= share->max_rows;
  create_info->min_rows= share->min_rows;
  create_info->table_options= share->db_create_options;
  create_info->avg_row_length= share->avg_row_length;
  create_info->row_type= share->row_type;
  create_info->default_table_charset= share->table_charset;
2175
  create_info->table_charset= 0;
2176

2177
  DBUG_VOID_RETURN;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2178
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189

int
rename_file_ext(const char * from,const char * to,const char * ext)
{
  char from_b[FN_REFLEN],to_b[FN_REFLEN];
  VOID(strxmov(from_b,from,ext,NullS));
  VOID(strxmov(to_b,to,ext,NullS));
  return (my_rename(from_b,to_b,MYF(MY_WME)));
}


vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
2190 2191 2192 2193 2194 2195 2196 2197 2198 2199
/*
  Allocate string field in MEM_ROOT and return it as String

  SYNOPSIS
    get_field()
    mem   	MEM_ROOT for allocating
    field 	Field for retrieving of string
    res         result String

  RETURN VALUES
2200 2201
    1   string is empty
    0	all ok
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
2202 2203 2204 2205
*/

bool get_field(MEM_ROOT *mem, Field *field, String *res)
{
2206
  char buff[MAX_FIELD_WIDTH], *to;
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
2207
  String str(buff,sizeof(buff),&my_charset_bin);
2208 2209
  uint length;

2210
  field->val_str(&str);
2211
  if (!(length= str.length()))
2212 2213
  {
    res->length(0);
2214
    return 1;
2215 2216 2217
  }
  if (!(to= strmake_root(mem, str.ptr(), length)))
    length= 0;                                  // Safety fix
2218 2219
  res->set(to, length, ((Field_str*)field)->charset());
  return 0;
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
2220 2221
}

2222

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2223
/*
2224 2225 2226 2227 2228 2229 2230 2231 2232 2233
  Allocate string field in MEM_ROOT and return it as NULL-terminated string

  SYNOPSIS
    get_field()
    mem   	MEM_ROOT for allocating
    field 	Field for retrieving of string

  RETURN VALUES
    NullS  string is empty
    #      pointer to NULL-terminated string value of field
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2234 2235
*/

2236
char *get_field(MEM_ROOT *mem, Field *field)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2237
{
monty@mysql.com's avatar
monty@mysql.com committed
2238
  char buff[MAX_FIELD_WIDTH], *to;
2239
  String str(buff,sizeof(buff),&my_charset_bin);
2240 2241
  uint length;

2242
  field->val_str(&str);
monty@mysql.com's avatar
monty@mysql.com committed
2243
  length= str.length();
2244
  if (!length || !(to= (char*) alloc_root(mem,length+1)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2245 2246 2247 2248 2249 2250
    return NullS;
  memcpy(to,str.ptr(),(uint) length);
  to[length]=0;
  return to;
}

2251 2252 2253 2254 2255 2256

/*
  Check if database name is valid

  SYNPOSIS
    check_db_name()
2257
    org_name		Name of database and length
2258 2259 2260 2261 2262 2263 2264 2265 2266

  NOTES
    If lower_case_table_names is set then database is converted to lower case

  RETURN
    0	ok
    1   error
*/

2267
bool check_db_name(LEX_STRING *org_name)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2268
{
2269 2270 2271 2272
  char *name= org_name->str;

  if (!org_name->length || org_name->length > NAME_LEN)
    return 1;
2273

2274
  if (lower_case_table_names && name != any_db)
2275
    my_casedn_str(files_charset_info, name);
2276

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2277
#if defined(USE_MB) && defined(USE_MB_IDENT)
2278 2279 2280 2281 2282
  if (use_mb(system_charset_info))
  {
    bool last_char_is_space= TRUE;
    char *end= name + org_name->length;
    while (name < end)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2283
    {
2284 2285 2286 2287 2288 2289
      int len;
      last_char_is_space= my_isspace(system_charset_info, *name);
      len= my_ismbchar(system_charset_info, name, end);
      if (!len)
        len= 1;
      name+= len;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2290
    }
2291
    return last_char_is_space;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2292
  }
2293 2294 2295
  else
#endif
    return org_name->str[org_name->length - 1] != ' '; /* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2296 2297 2298 2299 2300
}


/*
  Allow anything as a table name, as long as it doesn't contain an
2301
  ' ' at the end
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2302 2303 2304 2305 2306 2307 2308
  returns 1 on error
*/


bool check_table_name(const char *name, uint length)
{
  const char *end= name+length;
2309 2310
  if (!length || length > NAME_LEN)
    return 1;
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
2311
#if defined(USE_MB) && defined(USE_MB_IDENT)
2312
  bool last_char_is_space= FALSE;
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
2313 2314 2315 2316
#else
  if (name[length-1]==' ')
    return 1;
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2317 2318 2319 2320

  while (name != end)
  {
#if defined(USE_MB) && defined(USE_MB_IDENT)
2321
    last_char_is_space= my_isspace(system_charset_info, *name);
2322
    if (use_mb(system_charset_info))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2323
    {
2324
      int len=my_ismbchar(system_charset_info, name, end);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2325 2326 2327 2328 2329 2330 2331 2332 2333
      if (len)
      {
        name += len;
        continue;
      }
    }
#endif
    name++;
  }
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
2334
#if defined(USE_MB) && defined(USE_MB_IDENT)
2335 2336
  return last_char_is_space;
#else
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2337
  return 0;
2338
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2339 2340
}

monty@mysql.com's avatar
monty@mysql.com committed
2341

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2342 2343
bool check_column_name(const char *name)
{
2344
  const char *start= name;
monty@mysql.com's avatar
monty@mysql.com committed
2345
  bool last_char_is_space= TRUE;
2346
  
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2347 2348 2349
  while (*name)
  {
#if defined(USE_MB) && defined(USE_MB_IDENT)
2350
    last_char_is_space= my_isspace(system_charset_info, *name);
2351
    if (use_mb(system_charset_info))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2352
    {
2353
      int len=my_ismbchar(system_charset_info, name, 
2354
                          name+system_charset_info->mbmaxlen);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2355 2356 2357 2358 2359 2360
      if (len)
      {
        name += len;
        continue;
      }
    }
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
2361
#else
2362
    last_char_is_space= *name==' ';
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2363 2364 2365 2366 2367
#endif
    if (*name == NAMES_SEP_CHAR)
      return 1;
    name++;
  }
2368
  /* Error if empty or too long column name */
monty@mysql.com's avatar
monty@mysql.com committed
2369
  return last_char_is_space || (uint) (name - start) > NAME_LEN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2370 2371
}

2372 2373 2374 2375 2376

/*
  Checks whether a table is intact. Should be done *just* after the table has
  been opened.
  
2377
  SYNOPSIS
2378
    table_check_intact()
2379 2380 2381 2382 2383 2384 2385 2386 2387 2388
      table             The table to check
      table_f_count     Expected number of columns in the table
      table_def         Expected structure of the table (column name and type)
      last_create_time  The table->file->create_time of the table in memory
                        we have checked last time
      error_num         ER_XXXX from the error messages file. When 0 no error
                        is sent to the client in case types does not match.
                        If different col number either 
                        ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE or 
                        ER_COL_COUNT_DOESNT_MATCH_CORRUPTED is used
2389 2390

  RETURNS
2391 2392
    FALSE  OK
    TRUE   There was an error
2393 2394 2395
*/

my_bool
2396 2397 2398
table_check_intact(TABLE *table, const uint table_f_count,
                   const TABLE_FIELD_W_TYPE *table_def,
                   time_t *last_create_time, int error_num)
2399 2400 2401 2402 2403
{
  uint i;
  my_bool error= FALSE;
  my_bool fields_diff_count;
  DBUG_ENTER("table_check_intact");
2404 2405
  DBUG_PRINT("info",("table: %s  expected_count: %d  last_create_time: %ld",
                     table->alias, table_f_count, *last_create_time));
2406 2407
  
  if ((fields_diff_count= (table->s->fields != table_f_count)) ||
2408
      (*last_create_time != table->file->stats.create_time))
2409 2410 2411 2412
  {
    DBUG_PRINT("info", ("I am suspecting, checking table"));
    if (fields_diff_count)
    {
2413
      /* previous MySQL version */
2414 2415
      error= TRUE;
      if (MYSQL_VERSION_ID > table->s->mysql_version)
2416
      {
2417 2418 2419
        my_error(ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE, MYF(0), table->alias,
                 table_f_count, table->s->fields, table->s->mysql_version,
                 MYSQL_VERSION_ID);
2420 2421 2422 2423 2424 2425
        sql_print_error(ER(ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE),
                        table->alias, table_f_count, table->s->fields,
                        table->s->mysql_version, MYSQL_VERSION_ID);
        DBUG_RETURN(error);

      }
2426
      else if (MYSQL_VERSION_ID == table->s->mysql_version)
2427
      {
2428 2429
        my_error(ER_COL_COUNT_DOESNT_MATCH_CORRUPTED,MYF(0), table->alias,
                 table_f_count, table->s->fields);
2430 2431 2432
        sql_print_error(ER(ER_COL_COUNT_DOESNT_MATCH_CORRUPTED), table->alias,
                        table_f_count, table->s->fields);
      }
2433
      else
2434
      {
2435
        /*
2436
          Moving from newer mysql to older one -> let's say not an error but
2437 2438
          will check the definition afterwards. If a column was added at the
          end then we don't care much since it's not in the middle.
2439 2440
        */
        error= FALSE;
2441
      }
2442
    }
2443
    /* definitely something has changed */
2444
    char buffer[255];
2445
    for (i=0 ; i < table_f_count; i++, table_def++)
2446 2447 2448 2449
    {      
      String sql_type(buffer, sizeof(buffer), system_charset_info);
      sql_type.length(0);
      /*
2450 2451
        Name changes are not fatal, we use sequence numbers => no problem
        for us but this can show tampered table or broken table.
2452
      */
2453
      if (i < table->s->fields)
2454
      {
2455
        Field *field= table->field[i];
2456 2457 2458 2459 2460 2461 2462 2463 2464
        if (strncmp(field->field_name, table_def->name.str,
                                       table_def->name.length))
        {
          sql_print_error("(%s) Expected field %s at position %d, found %s",
                          table->alias, table_def->name.str, i,
                          field->field_name);
        }
                        
        /*
2465
          If the type does not match than something is really wrong
2466 2467 2468 2469 2470 2471 2472 2473 2474
          Check up to length - 1. Why?
          1. datetime -> datetim -> the same
          2. int(11) -> int(11  -> the same
          3. set('one','two') -> set('one','two'  
             so for sets if the same prefix is there it's ok if more are
             added as part of the set. The same is valid for enum. So a new
             table running on a old server will be valid.
        */ 
        field->sql_type(sql_type);
2475
        if (strncmp(sql_type.c_ptr_safe(), table_def->type.str,
2476 2477 2478 2479
                    table_def->type.length - 1))
        {
          sql_print_error("(%s) Expected field %s at position %d to have type "
                          "%s, found %s", table->alias, table_def->name.str,
2480
                          i, table_def->type.str, sql_type.c_ptr_safe()); 
2481 2482 2483 2484 2485 2486 2487 2488 2489 2490 2491 2492 2493 2494 2495 2496 2497 2498 2499 2500 2501 2502
          error= TRUE;
        }
        else if (table_def->cset.str && !field->has_charset())
        {
          sql_print_error("(%s) Expected field %s at position %d to have "
                          "character set '%s' but found no such", table->alias,
                          table_def->name.str, i, table_def->cset.str);        
          error= TRUE;
        }
        else if (table_def->cset.str && 
                 strcmp(field->charset()->csname, table_def->cset.str))
        {
          sql_print_error("(%s) Expected field %s at position %d to have "
                          "character set '%s' but found '%s'", table->alias,
                          table_def->name.str, i, table_def->cset.str,
                          field->charset()->csname);
          error= TRUE;
        }
      }
      else
      {
        sql_print_error("(%s) Expected field %s at position %d to have type %s "
2503
                        " but no field found.", table->alias,
2504 2505 2506 2507 2508
                        table_def->name.str, i, table_def->type.str);
        error= TRUE;        
      }
    }
    if (!error)
2509
      *last_create_time= table->file->stats.create_time;
2510 2511 2512 2513 2514
    else if (!fields_diff_count && error_num)
      my_error(error_num,MYF(0), table->alias, table_f_count, table->s->fields);
  }
  else
  {
2515
    DBUG_PRINT("info", ("Table seems ok without thorough checking."));
2516
    *last_create_time= table->file->stats.create_time;
2517 2518 2519 2520 2521 2522
  }
   
  DBUG_RETURN(error);  
}


2523 2524 2525 2526 2527 2528 2529 2530 2531 2532 2533 2534 2535 2536 2537 2538 2539 2540 2541 2542 2543 2544 2545 2546 2547 2548 2549 2550 2551 2552 2553 2554 2555 2556 2557 2558 2559 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 2577 2578 2579
/*
  Create Item_field for each column in the table.

  SYNPOSIS
    st_table::fill_item_list()
      item_list          a pointer to an empty list used to store items

  DESCRIPTION
    Create Item_field object for each column in the table and
    initialize it with the corresponding Field. New items are
    created in the current THD memory root.

  RETURN VALUE
    0                    success
    1                    out of memory
*/

bool st_table::fill_item_list(List<Item> *item_list) const
{
  /*
    All Item_field's created using a direct pointer to a field
    are fixed in Item_field constructor.
  */
  for (Field **ptr= field; *ptr; ptr++)
  {
    Item_field *item= new Item_field(*ptr);
    if (!item || item_list->push_back(item))
      return TRUE;
  }
  return FALSE;
}

/*
  Reset an existing list of Item_field items to point to the
  Fields of this table.

  SYNPOSIS
    st_table::fill_item_list()
      item_list          a non-empty list with Item_fields

  DESCRIPTION
    This is a counterpart of fill_item_list used to redirect
    Item_fields to the fields of a newly created table.
    The caller must ensure that number of items in the item_list
    is the same as the number of columns in the table.
*/

void st_table::reset_item_list(List<Item> *item_list) const
{
  List_iterator_fast<Item> it(*item_list);
  for (Field **ptr= field; *ptr; ptr++)
  {
    Item_field *item_field= (Item_field*) it++;
    DBUG_ASSERT(item_field != 0);
    item_field->reset_field(*ptr);
  }
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2580

bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2581 2582 2583 2584 2585 2586 2587
/*
  calculate md5 of query

  SYNOPSIS
    st_table_list::calc_md5()
    buffer	buffer for md5 writing
*/
2588

bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2589 2590 2591
void  st_table_list::calc_md5(char *buffer)
{
  my_MD5_CTX context;
2592 2593 2594 2595
  uchar digest[16];
  my_MD5Init(&context);
  my_MD5Update(&context,(uchar *) query.str, query.length);
  my_MD5Final(digest, &context);
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2596 2597 2598 2599 2600 2601 2602 2603 2604 2605
  sprintf((char *) buffer,
	    "%02x%02x%02x%02x%02x%02x%02x%02x%02x%02x%02x%02x%02x%02x%02x%02x",
	    digest[0], digest[1], digest[2], digest[3],
	    digest[4], digest[5], digest[6], digest[7],
	    digest[8], digest[9], digest[10], digest[11],
	    digest[12], digest[13], digest[14], digest[15]);
}


/*
2606
  set underlying TABLE for table place holder of VIEW
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2607

2608 2609 2610
  DESCRIPTION
    Replace all views that only uses one table with the table itself.
    This allows us to treat the view as a simple table and even update
2611
    it (it is a kind of optimisation)
2612

bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2613
  SYNOPSIS
2614
    st_table_list::set_underlying_merge()
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2615
*/
2616

2617
void st_table_list::set_underlying_merge()
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2618
{
2619 2620
  TABLE_LIST *tbl;

2621
  if ((tbl= merge_underlying_list))
bell@sanja.is.com.ua's avatar
merge  
bell@sanja.is.com.ua committed
2622
  {
2623
    /* This is a view. Process all tables of view */
2624
    DBUG_ASSERT(view && effective_algorithm == VIEW_ALGORITHM_MERGE);
2625 2626
    do
    {
2627
      if (tbl->merge_underlying_list)          // This is a view
2628
      {
2629 2630
        DBUG_ASSERT(tbl->view &&
                    tbl->effective_algorithm == VIEW_ALGORITHM_MERGE);
2631 2632 2633 2634
        /*
          This is the only case where set_ancestor is called on an object
          that may not be a view (in which case ancestor is 0)
        */
2635
        tbl->merge_underlying_list->set_underlying_merge();
2636 2637 2638
      }
    } while ((tbl= tbl->next_local));

igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2639
    if (!multitable_view)
2640
    {
2641 2642
      table= merge_underlying_list->table;
      schema_table= merge_underlying_list->schema_table;
2643
    }
bell@sanja.is.com.ua's avatar
merge  
bell@sanja.is.com.ua committed
2644
  }
2645 2646 2647
}


bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2648 2649 2650 2651
/*
  setup fields of placeholder of merged VIEW

  SYNOPSIS
2652
    st_table_list::setup_underlying()
2653
    thd		    - thread handler
2654

2655 2656
  DESCRIPTION
    It is:
2657
    - preparing translation table for view columns
2658 2659
    If there are underlying view(s) procedure first will be called for them.

bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2660
  RETURN
2661 2662
    FALSE - OK
    TRUE  - error
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2663
*/
2664

2665
bool st_table_list::setup_underlying(THD *thd)
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2666
{
2667 2668 2669
  DBUG_ENTER("st_table_list::setup_underlying");

  if (!field_translation && merge_underlying_list)
2670
  {
2671 2672 2673 2674 2675 2676 2677 2678 2679
    Field_translator *transl;
    SELECT_LEX *select= &view->select_lex;
    Item *item;
    TABLE_LIST *tbl;
    List_iterator_fast<Item> it(select->item_list);
    uint field_count= 0;

    if (check_stack_overrun(thd, STACK_MIN_SIZE, (char *)&field_count))
    {
2680
      DBUG_RETURN(TRUE);
2681
    }
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2682

2683
    for (tbl= merge_underlying_list; tbl; tbl= tbl->next_local)
2684
    {
2685 2686
      if (tbl->merge_underlying_list &&
          tbl->setup_underlying(thd))
2687 2688 2689 2690
      {
        DBUG_RETURN(TRUE);
      }
    }
2691

2692 2693 2694
    /* Create view fields translation table */

    if (!(transl=
konstantin@mysql.com's avatar
konstantin@mysql.com committed
2695
          (Field_translator*)(thd->stmt_arena->
2696 2697
                              alloc(select->item_list.elements *
                                    sizeof(Field_translator)))))
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2698
    {
2699
      DBUG_RETURN(TRUE);
2700
    }
2701 2702

    while ((item= it++))
2703
    {
2704 2705
      transl[field_count].name= item->name;
      transl[field_count++].item= item;
2706
    }
2707 2708 2709
    field_translation= transl;
    field_translation_end= transl + field_count;
    /* TODO: use hash for big number of fields */
2710

2711 2712
    /* full text function moving to current select */
    if (view->select_lex.ftfunc_list->elements)
2713
    {
2714 2715 2716 2717 2718 2719
      Item_func_match *ifm;
      SELECT_LEX *current_select= thd->lex->current_select;
      List_iterator_fast<Item_func_match>
        li(*(view->select_lex.ftfunc_list));
      while ((ifm= li++))
        current_select->ftfunc_list->push_front(ifm);
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2720 2721
    }
  }
2722 2723
  DBUG_RETURN(FALSE);
}
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2724

2725

2726 2727
/*
  Prepare where expression of view
2728

2729 2730 2731 2732 2733 2734
  SYNOPSIS
    st_table_list::prep_where()
    thd             - thread handler
    conds           - condition of this JOIN
    no_where_clause - do not build WHERE or ON outer qwery do not need it
                      (it is INSERT), we do not need conds if this flag is set
2735

2736 2737
  NOTE: have to be called befor CHECK OPTION preparation, because it makes
  fix_fields for view WHERE clause
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2738

2739 2740 2741 2742
  RETURN
    FALSE - OK
    TRUE  - error
*/
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2743

2744 2745 2746 2747 2748
bool st_table_list::prep_where(THD *thd, Item **conds,
                               bool no_where_clause)
{
  DBUG_ENTER("st_table_list::prep_where");

2749
  for (TABLE_LIST *tbl= merge_underlying_list; tbl; tbl= tbl->next_local)
2750
  {
2751 2752 2753 2754
    if (tbl->view && tbl->prep_where(thd, conds, no_where_clause))
    {
      DBUG_RETURN(TRUE);
    }
2755
  }
2756

2757 2758 2759
  if (where)
  {
    if (!where->fixed && where->fix_fields(thd, &where))
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2760
    {
2761
      DBUG_RETURN(TRUE);
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2762
    }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2763 2764 2765 2766 2767

    /*
      check that it is not VIEW in which we insert with INSERT SELECT
      (in this case we can't add view WHERE condition to main SELECT_LEX)
    */
2768
    if (!no_where_clause && !where_processed)
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2769
    {
2770
      TABLE_LIST *tbl= this;
konstantin@mysql.com's avatar
konstantin@mysql.com committed
2771 2772
      Query_arena *arena= thd->stmt_arena, backup;
      arena= thd->activate_stmt_arena_if_needed(&backup);  // For easier test
2773

bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2774 2775
      /* Go up to join tree and try to find left join */
      for (; tbl; tbl= tbl->embedding)
2776
      {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2777 2778 2779 2780
        if (tbl->outer_join)
        {
          /*
            Store WHERE condition to ON expression for outer join, because
2781
            we can't use WHERE to correctly execute left joins on VIEWs and
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2782 2783 2784
            this expression will not be moved to WHERE condition (i.e. will
            be clean correctly for PS/SP)
          */
2785 2786
          tbl->on_expr= and_conds(tbl->on_expr,
                                  where->copy_andor_structure(thd));
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2787 2788
          break;
        }
2789
      }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2790
      if (tbl == 0)
2791
        *conds= and_conds(*conds, where->copy_andor_structure(thd));
2792
      if (arena)
konstantin@mysql.com's avatar
konstantin@mysql.com committed
2793
        thd->restore_active_arena(arena, &backup);
2794
      where_processed= TRUE;
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2795 2796
    }
  }
2797

2798 2799 2800 2801 2802 2803 2804 2805 2806 2807 2808 2809 2810 2811 2812 2813 2814 2815 2816 2817 2818 2819 2820 2821
  DBUG_RETURN(FALSE);
}


/*
  Prepare check option expression of table

  SYNOPSIS
    st_table_list::prep_check_option()
    thd             - thread handler
    check_opt_type  - WITH CHECK OPTION type (VIEW_CHECK_NONE,
                      VIEW_CHECK_LOCAL, VIEW_CHECK_CASCADED)
                      we use this parameter instead of direct check of
                      effective_with_check to change type of underlying
                      views to VIEW_CHECK_CASCADED if outer view have
                      such option and prevent processing of underlying
                      view check options if outer view have just
                      VIEW_CHECK_LOCAL option.

  NOTE
    This method build check options for every call
    (usual execution or every SP/PS call)
    This method have to be called after WHERE preparation
    (st_table_list::prep_where)
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2822

2823 2824 2825 2826 2827 2828 2829 2830 2831
  RETURN
    FALSE - OK
    TRUE  - error
*/

bool st_table_list::prep_check_option(THD *thd, uint8 check_opt_type)
{
  DBUG_ENTER("st_table_list::prep_check_option");

2832
  for (TABLE_LIST *tbl= merge_underlying_list; tbl; tbl= tbl->next_local)
2833
  {
2834 2835 2836 2837 2838 2839
    /* see comment of check_opt_type parameter */
    if (tbl->view &&
        tbl->prep_check_option(thd,
                               ((check_opt_type == VIEW_CHECK_CASCADED) ?
                                VIEW_CHECK_CASCADED :
                                VIEW_CHECK_NONE)))
2840
    {
2841
      DBUG_RETURN(TRUE);
2842 2843
    }
  }
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2844

2845
  if (check_opt_type)
2846
  {
2847 2848 2849 2850 2851 2852 2853 2854
    Item *item= 0;
    if (where)
    {
      DBUG_ASSERT(where->fixed);
      item= where->copy_andor_structure(thd);
    }
    if (check_opt_type == VIEW_CHECK_CASCADED)
    {
2855
      for (TABLE_LIST *tbl= merge_underlying_list; tbl; tbl= tbl->next_local)
2856 2857 2858 2859 2860 2861 2862 2863 2864 2865 2866 2867 2868 2869 2870 2871 2872 2873 2874 2875
      {
        if (tbl->check_option)
          item= and_conds(item, tbl->check_option);
      }
    }
    if (item)
      thd->change_item_tree(&check_option, item);
  }

  if (check_option)
  {
    const char *save_where= thd->where;
    thd->where= "check option";
    if (!check_option->fixed &&
        check_option->fix_fields(thd, &check_option) ||
        check_option->check_cols(1))
    {
      DBUG_RETURN(TRUE);
    }
    thd->where= save_where;
2876
  }
2877 2878 2879
  DBUG_RETURN(FALSE);
}

2880

2881 2882 2883 2884 2885 2886
/*
  Hide errors which show view underlying table information

  SYNOPSIS
    st_table_list::hide_view_error()
    thd     thread handler
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2887

2888 2889 2890 2891
*/

void st_table_list::hide_view_error(THD *thd)
{
2892 2893
  /* Hide "Unknown column" or "Unknown function" error */
  if (thd->net.last_errno == ER_BAD_FIELD_ERROR ||
2894 2895
      thd->net.last_errno == ER_SP_DOES_NOT_EXIST ||
      thd->net.last_errno == ER_PROCACCESS_DENIED_ERROR ||
2896 2897
      thd->net.last_errno == ER_COLUMNACCESS_DENIED_ERROR ||
      thd->net.last_errno == ER_TABLEACCESS_DENIED_ERROR)
2898
  {
2899
    TABLE_LIST *top= top_table();
2900
    thd->clear_error();
2901
    my_error(ER_VIEW_INVALID, MYF(0), top->view_db.str, top->view_name.str);
2902
  }
2903 2904
  else if (thd->net.last_errno == ER_NO_DEFAULT_FOR_FIELD)
  {
2905
    TABLE_LIST *top= top_table();
2906 2907
    thd->clear_error();
    // TODO: make correct error message
2908 2909
    my_error(ER_NO_DEFAULT_FOR_VIEW_FIELD, MYF(0),
             top->view_db.str, top->view_name.str);
2910
  }
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
2911 2912 2913
}


2914 2915 2916 2917 2918 2919 2920 2921 2922 2923 2924 2925 2926 2927 2928 2929
/*
  Find underlying base tables (TABLE_LIST) which represent given
  table_to_find (TABLE)

  SYNOPSIS
    st_table_list::find_underlying_table()
    table_to_find table to find

  RETURN
    0  table is not found
    found table reference
*/

st_table_list *st_table_list::find_underlying_table(TABLE *table_to_find)
{
  /* is this real table and table which we are looking for? */
2930
  if (table == table_to_find && merge_underlying_list == 0)
2931 2932
    return this;

2933
  for (TABLE_LIST *tbl= merge_underlying_list; tbl; tbl= tbl->next_local)
2934 2935 2936 2937 2938 2939 2940 2941
  {
    TABLE_LIST *result;
    if ((result= tbl->find_underlying_table(table_to_find)))
      return result;
  }
  return 0;
}

bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2942 2943 2944 2945 2946 2947 2948 2949 2950 2951 2952 2953
/*
  cleunup items belonged to view fields translation table

  SYNOPSIS
    st_table_list::cleanup_items()
*/

void st_table_list::cleanup_items()
{
  if (!field_translation)
    return;

2954 2955 2956
  for (Field_translator *transl= field_translation;
       transl < field_translation_end;
       transl++)
2957
    transl->item->walk(&Item::cleanup_processor, 0, 0);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2958 2959 2960
}


bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2961 2962 2963 2964 2965 2966 2967 2968 2969 2970 2971 2972 2973 2974 2975 2976 2977
/*
  check CHECK OPTION condition

  SYNOPSIS
    check_option()
    ignore_failure ignore check option fail

  RETURN
    VIEW_CHECK_OK     OK
    VIEW_CHECK_ERROR  FAILED
    VIEW_CHECK_SKIP   FAILED, but continue
*/

int st_table_list::view_check_option(THD *thd, bool ignore_failure)
{
  if (check_option && check_option->val_int() == 0)
  {
2978
    TABLE_LIST *view= top_table();
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2979 2980 2981 2982
    if (ignore_failure)
    {
      push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_ERROR,
                          ER_VIEW_CHECK_FAILED, ER(ER_VIEW_CHECK_FAILED),
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2983
                          view->view_db.str, view->view_name.str);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2984 2985 2986 2987
      return(VIEW_CHECK_SKIP);
    }
    else
    {
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2988
      my_error(ER_VIEW_CHECK_FAILED, MYF(0), view->view_db.str, view->view_name.str);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2989 2990 2991 2992 2993 2994 2995
      return(VIEW_CHECK_ERROR);
    }
  }
  return(VIEW_CHECK_OK);
}


2996
/*
2997
  Find table in underlying tables by mask and check that only this
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2998
  table belong to given mask
2999 3000 3001 3002 3003 3004 3005

  SYNOPSIS
    st_table_list::check_single_table()
    table	reference on variable where to store found table
		(should be 0 on call, to find table, or point to table for
		unique test)
    map         bit mask of tables
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3006
    view        view for which we are looking table
3007 3008

  RETURN
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3009 3010
    FALSE table not found or found only one
    TRUE  found several tables
3011 3012
*/

igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3013 3014
bool st_table_list::check_single_table(st_table_list **table, table_map map,
                                       st_table_list *view)
3015
{
3016
  for (TABLE_LIST *tbl= merge_underlying_list; tbl; tbl= tbl->next_local)
3017 3018 3019 3020 3021 3022
  {
    if (tbl->table)
    {
      if (tbl->table->map & map)
      {
	if (*table)
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3023
	  return TRUE;
3024 3025
        *table= tbl;
        tbl->check_option= view->check_option;
3026 3027
      }
    }
3028 3029
    else if (tbl->check_single_table(table, map, view))
      return TRUE;
3030
  }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3031
  return FALSE;
3032 3033 3034 3035 3036 3037 3038 3039 3040 3041 3042 3043 3044 3045 3046 3047 3048 3049 3050 3051 3052
}


/*
  Set insert_values buffer

  SYNOPSIS
    set_insert_values()
    mem_root   memory pool for allocating

  RETURN
    FALSE - OK
    TRUE  - out of memory
*/

bool st_table_list::set_insert_values(MEM_ROOT *mem_root)
{
  if (table)
  {
    if (!table->insert_values &&
        !(table->insert_values= (byte *)alloc_root(mem_root,
3053
                                                   table->s->rec_buff_length)))
3054 3055 3056 3057
      return TRUE;
  }
  else
  {
3058 3059
    DBUG_ASSERT(view && merge_underlying_list);
    for (TABLE_LIST *tbl= merge_underlying_list; tbl; tbl= tbl->next_local)
3060 3061 3062 3063 3064 3065 3066
      if (tbl->set_insert_values(mem_root))
        return TRUE;
  }
  return FALSE;
}


3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 3079 3080 3081 3082 3083 3084 3085 3086 3087 3088 3089 3090 3091 3092 3093 3094 3095 3096 3097 3098 3099 3100 3101 3102 3103 3104 3105 3106 3107
/*
  Test if this is a leaf with respect to name resolution.

  SYNOPSIS
    st_table_list::is_leaf_for_name_resolution()

  DESCRIPTION
    A table reference is a leaf with respect to name resolution if
    it is either a leaf node in a nested join tree (table, view,
    schema table, subquery), or an inner node that represents a
    NATURAL/USING join, or a nested join with materialized join
    columns.

  RETURN
    TRUE if a leaf, FALSE otherwise.
*/
bool st_table_list::is_leaf_for_name_resolution()
{
  return (view || is_natural_join || is_join_columns_complete ||
          !nested_join);
}


/*
  Retrieve the first (left-most) leaf in a nested join tree with
  respect to name resolution.

  SYNOPSIS
    st_table_list::first_leaf_for_name_resolution()

  DESCRIPTION
    Given that 'this' is a nested table reference, recursively walk
    down the left-most children of 'this' until we reach a leaf
    table reference with respect to name resolution.

  IMPLEMENTATION
    The left-most child of a nested table reference is the last element
    in the list of children because the children are inserted in
    reverse order.

  RETURN
3108
    If 'this' is a nested table reference - the left-most child of
3109
      the tree rooted in 'this',
3110
    else return 'this'
3111 3112 3113 3114
*/

TABLE_LIST *st_table_list::first_leaf_for_name_resolution()
{
3115 3116 3117
  TABLE_LIST *cur_table_ref;
  NESTED_JOIN *cur_nested_join;
  LINT_INIT(cur_table_ref);
3118

3119
  if (is_leaf_for_name_resolution())
3120
    return this;
3121
  DBUG_ASSERT(nested_join);
3122

3123 3124 3125
  for (cur_nested_join= nested_join;
       cur_nested_join;
       cur_nested_join= cur_table_ref->nested_join)
3126 3127 3128 3129
  {
    List_iterator_fast<TABLE_LIST> it(cur_nested_join->join_list);
    cur_table_ref= it++;
    /*
3130 3131 3132 3133
      If the current nested join is a RIGHT JOIN, the operands in
      'join_list' are in reverse order, thus the first operand is
      already at the front of the list. Otherwise the first operand
      is in the end of the list of join operands.
3134 3135 3136
    */
    if (!(cur_table_ref->outer_join & JOIN_TYPE_RIGHT))
    {
3137
      TABLE_LIST *next;
3138 3139 3140 3141 3142 3143 3144 3145 3146 3147 3148 3149 3150 3151 3152 3153 3154 3155 3156 3157 3158 3159 3160 3161 3162 3163 3164 3165 3166 3167 3168 3169 3170 3171 3172 3173
      while ((next= it++))
        cur_table_ref= next;
    }
    if (cur_table_ref->is_leaf_for_name_resolution())
      break;
  }
  return cur_table_ref;
}


/*
  Retrieve the last (right-most) leaf in a nested join tree with
  respect to name resolution.

  SYNOPSIS
    st_table_list::last_leaf_for_name_resolution()

  DESCRIPTION
    Given that 'this' is a nested table reference, recursively walk
    down the right-most children of 'this' until we reach a leaf
    table reference with respect to name resolution.

  IMPLEMENTATION
    The right-most child of a nested table reference is the first
    element in the list of children because the children are inserted
    in reverse order.

  RETURN
    - If 'this' is a nested table reference - the right-most child of
      the tree rooted in 'this',
    - else - 'this'
*/

TABLE_LIST *st_table_list::last_leaf_for_name_resolution()
{
  TABLE_LIST *cur_table_ref= this;
3174
  NESTED_JOIN *cur_nested_join;
3175

3176
  if (is_leaf_for_name_resolution())
3177
    return this;
3178
  DBUG_ASSERT(nested_join);
3179

3180 3181 3182
  for (cur_nested_join= nested_join;
       cur_nested_join;
       cur_nested_join= cur_table_ref->nested_join)
3183
  {
3184
    cur_table_ref= cur_nested_join->join_list.head();
3185
    /*
3186 3187 3188
      If the current nested is a RIGHT JOIN, the operands in
      'join_list' are in reverse order, thus the last operand is in the
      end of the list.
3189 3190 3191 3192
    */
    if ((cur_table_ref->outer_join & JOIN_TYPE_RIGHT))
    {
      List_iterator_fast<TABLE_LIST> it(cur_nested_join->join_list);
3193
      TABLE_LIST *next;
3194 3195 3196 3197 3198 3199 3200 3201 3202 3203 3204
      cur_table_ref= it++;
      while ((next= it++))
        cur_table_ref= next;
    }
    if (cur_table_ref->is_leaf_for_name_resolution())
      break;
  }
  return cur_table_ref;
}


3205 3206 3207 3208 3209 3210 3211 3212 3213 3214 3215 3216 3217 3218 3219 3220 3221 3222 3223 3224 3225 3226 3227 3228
/*
  Register access mode which we need for underlying tables

  SYNOPSIS
    register_want_access()
    want_access          Acess which we require
*/

void st_table_list::register_want_access(ulong want_access)
{
  /* Remove SHOW_VIEW_ACL, because it will be checked during making view */
  want_access&= ~SHOW_VIEW_ACL;
  if (belong_to_view)
  {
    grant.want_privilege= want_access;
    if (table)
      table->grant.want_privilege= want_access;
  }
  for (TABLE_LIST *tbl= merge_underlying_list; tbl; tbl= tbl->next_local)
    tbl->register_want_access(want_access);
}


/*
3229
  Load security context information for this view
3230 3231 3232 3233 3234 3235 3236 3237 3238 3239 3240 3241 3242 3243 3244 3245 3246 3247 3248 3249 3250 3251 3252 3253 3254 3255 3256

  SYNOPSIS
    st_table_list::prepare_view_securety_context()
    thd                  [in] thread handler

  RETURN
    FALSE  OK
    TRUE   Error
*/

#ifndef NO_EMBEDDED_ACCESS_CHECKS
bool st_table_list::prepare_view_securety_context(THD *thd)
{
  DBUG_ENTER("st_table_list::prepare_view_securety_context");
  DBUG_PRINT("enter", ("table: %s", alias));

  DBUG_ASSERT(!prelocking_placeholder && view);
  if (view_suid)
  {
    DBUG_PRINT("info", ("This table is suid view => load contest"));
    DBUG_ASSERT(view && view_sctx);
    if (acl_getroot_no_password(view_sctx,
                                definer.user.str,
                                definer.host.str,
                                definer.host.str,
                                thd->db))
    {
3257 3258 3259 3260 3261 3262 3263 3264 3265
      if (thd->lex->sql_command == SQLCOM_SHOW_CREATE)
      {
        push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_NOTE, 
                            ER_NO_SUCH_USER, 
                            ER(ER_NO_SUCH_USER),
                            definer.user.str, definer.host.str);
      }
      else
      {
3266 3267 3268 3269 3270 3271 3272 3273 3274 3275 3276 3277
        if (thd->security_ctx->master_access & SUPER_ACL)
        {
          my_error(ER_NO_SUCH_USER, MYF(0), definer.user.str, definer.host.str);

        }
        else
        {
           my_error(ER_ACCESS_DENIED_ERROR, MYF(0),
                    thd->security_ctx->priv_user,
                    thd->security_ctx->priv_host,
                    (thd->password ?  ER(ER_YES) : ER(ER_NO)));
        }
3278 3279
        DBUG_RETURN(TRUE);
      }
3280 3281 3282 3283 3284 3285 3286 3287 3288 3289 3290 3291 3292 3293 3294 3295 3296 3297 3298 3299 3300 3301 3302 3303 3304 3305 3306 3307 3308 3309 3310 3311 3312 3313 3314 3315 3316 3317 3318 3319 3320 3321 3322 3323 3324 3325 3326 3327 3328 3329 3330 3331 3332 3333 3334 3335 3336 3337 3338 3339 3340 3341
    }
  }
  DBUG_RETURN(FALSE);
}
#endif


/*
  Find security context of current view

  SYNOPSIS
    st_table_list::find_view_security_context()
    thd                  [in] thread handler

*/

#ifndef NO_EMBEDDED_ACCESS_CHECKS
Security_context *st_table_list::find_view_security_context(THD *thd)
{
  Security_context *sctx;
  TABLE_LIST *upper_view= this;
  DBUG_ENTER("st_table_list::find_view_security_context");

  DBUG_ASSERT(view);
  while (upper_view && !upper_view->view_suid)
  {
    DBUG_ASSERT(!upper_view->prelocking_placeholder);
    upper_view= upper_view->referencing_view;
  }
  if (upper_view)
  {
    DBUG_PRINT("info", ("Securety context of view %s will be used",
                        upper_view->alias));
    sctx= upper_view->view_sctx;
    DBUG_ASSERT(sctx);
  }
  else
  {
    DBUG_PRINT("info", ("Current global context will be used"));
    sctx= thd->security_ctx;
  }
  DBUG_RETURN(sctx);
}
#endif


/*
  Prepare security context and load underlying tables priveleges for view

  SYNOPSIS
    st_table_list::prepare_security()
    thd                  [in] thread handler

  RETURN
    FALSE  OK
    TRUE   Error
*/

bool st_table_list::prepare_security(THD *thd)
{
  List_iterator_fast<TABLE_LIST> tb(*view_tables);
  TABLE_LIST *tbl;
3342
  DBUG_ENTER("st_table_list::prepare_security");
3343 3344 3345 3346 3347 3348 3349 3350 3351 3352 3353 3354 3355 3356 3357 3358 3359 3360 3361 3362 3363 3364 3365 3366 3367 3368 3369 3370 3371 3372
#ifndef NO_EMBEDDED_ACCESS_CHECKS
  Security_context *save_security_ctx= thd->security_ctx;

  DBUG_ASSERT(!prelocking_placeholder);
  if (prepare_view_securety_context(thd))
    DBUG_RETURN(TRUE);
  thd->security_ctx= find_view_security_context(thd);
  while ((tbl= tb++))
  {
    DBUG_ASSERT(tbl->referencing_view);
    char *db, *table_name;
    if (tbl->view)
    {
      db= tbl->view_db.str;
      table_name= tbl->view_name.str;
    }
    else
    {
      db= tbl->db;
      table_name= tbl->table_name;
    }
    fill_effective_table_privileges(thd, &tbl->grant, db, table_name);
    if (tbl->table)
      tbl->table->grant= grant;
  }
  thd->security_ctx= save_security_ctx;
#else
  while ((tbl= tb++))
    tbl->grant.privilege= ~NO_ACCESS;
#endif
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3373
  DBUG_RETURN(FALSE);
3374 3375 3376
}


3377 3378 3379 3380 3381 3382 3383 3384 3385 3386 3387 3388 3389 3390
Natural_join_column::Natural_join_column(Field_translator *field_param,
                                         TABLE_LIST *tab)
{
  DBUG_ASSERT(tab->field_translation);
  view_field= field_param;
  table_field= NULL;
  table_ref= tab;
  is_common= FALSE;
}


Natural_join_column::Natural_join_column(Field *field_param,
                                         TABLE_LIST *tab)
{
3391
  DBUG_ASSERT(tab->table == field_param->table);
3392 3393 3394 3395 3396 3397 3398 3399 3400 3401 3402 3403 3404 3405
  table_field= field_param;
  view_field= NULL;
  table_ref= tab;
  is_common= FALSE;
}


const char *Natural_join_column::name()
{
  if (view_field)
  {
    DBUG_ASSERT(table_field == NULL);
    return view_field->name;
  }
3406 3407

  return table_field->field_name;
3408 3409 3410 3411 3412 3413 3414 3415
}


Item *Natural_join_column::create_item(THD *thd)
{
  if (view_field)
  {
    DBUG_ASSERT(table_field == NULL);
3416 3417
    return create_view_field(thd, table_ref, &view_field->item,
                             view_field->name);
3418
  }
3419
  return new Item_field(thd, &thd->lex->current_select->context, table_field);
3420 3421 3422 3423 3424 3425 3426 3427 3428 3429
}


Field *Natural_join_column::field()
{
  if (view_field)
  {
    DBUG_ASSERT(table_field == NULL);
    return NULL;
  }
3430
  return table_field;
3431 3432 3433 3434 3435 3436 3437 3438 3439 3440 3441 3442 3443
}


const char *Natural_join_column::table_name()
{
  return table_ref->alias;
}


const char *Natural_join_column::db_name()
{
  if (view_field)
    return table_ref->view_db.str;
3444

3445 3446 3447 3448 3449
  /*
    Test that TABLE_LIST::db is the same as st_table_share::db to
    ensure consistency. An exception are I_S schema tables, which
    are inconsistent in this respect.
  */
3450
  DBUG_ASSERT(!strcmp(table_ref->db,
3451
                      table_ref->table->s->db.str) ||
3452
              (table_ref->schema_table &&
3453
               table_ref->table->s->db.str[0] == 0));
3454
  return table_ref->db;
3455 3456 3457 3458 3459 3460 3461
}


GRANT_INFO *Natural_join_column::grant()
{
  if (view_field)
    return &(table_ref->grant);
3462
  return &(table_ref->table->grant);
3463 3464 3465
}


bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
3466 3467
void Field_iterator_view::set(TABLE_LIST *table)
{
3468
  DBUG_ASSERT(table->field_translation);
3469
  view= table;
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
3470
  ptr= table->field_translation;
3471
  array_end= table->field_translation_end;
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
3472 3473 3474 3475 3476 3477 3478 3479 3480
}


const char *Field_iterator_table::name()
{
  return (*ptr)->field_name;
}


3481
Item *Field_iterator_table::create_item(THD *thd)
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
3482
{
3483
  return new Item_field(thd, &thd->lex->current_select->context, *ptr);
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
3484 3485 3486 3487 3488
}


const char *Field_iterator_view::name()
{
3489
  return ptr->name;
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
3490 3491 3492
}


3493 3494 3495 3496 3497 3498 3499 3500 3501 3502 3503 3504 3505 3506 3507
Item *Field_iterator_view::create_item(THD *thd)
{
  return create_view_field(thd, view, &ptr->item, ptr->name);
}

Item *create_view_field(THD *thd, TABLE_LIST *view, Item **field_ref,
                        const char *name)
{
  bool save_wrapper= thd->lex->select_lex.no_wrap_view_item;
  Item *field= *field_ref;
  DBUG_ENTER("create_view_field");

  if (view->schema_table_reformed)
  {
    /*
3508 3509 3510
      Translation table items are always Item_fields and already fixed
      ('mysql_schema_table' function). So we can return directly the
      field. This case happens only for 'show & where' commands.
3511 3512 3513 3514 3515 3516 3517 3518 3519 3520 3521 3522 3523 3524 3525 3526 3527
    */
    DBUG_ASSERT(field && field->fixed);
    DBUG_RETURN(field);
  }

  DBUG_ASSERT(field);
  thd->lex->current_select->no_wrap_view_item= TRUE;
  if (!field->fixed)
  {
    if (field->fix_fields(thd, field_ref))
    {
      thd->lex->current_select->no_wrap_view_item= save_wrapper;
      DBUG_RETURN(0);
    }
    field= *field_ref;
  }
  thd->lex->current_select->no_wrap_view_item= save_wrapper;
3528
  if (save_wrapper)
3529 3530 3531 3532
  {
    DBUG_RETURN(field);
  }
  Item *item= new Item_direct_view_ref(&view->view->select_lex.context,
3533
                                       field_ref, view->alias,
3534 3535 3536 3537 3538
                                       name);
  DBUG_RETURN(item);
}


3539 3540 3541
void Field_iterator_natural_join::set(TABLE_LIST *table_ref)
{
  DBUG_ASSERT(table_ref->join_columns);
3542 3543
  column_ref_it.init(*(table_ref->join_columns));
  cur_column_ref= column_ref_it++;
3544 3545 3546
}


3547 3548
void Field_iterator_natural_join::next()
{
3549
  cur_column_ref= column_ref_it++;
3550 3551 3552
  DBUG_ASSERT(!cur_column_ref || ! cur_column_ref->table_field ||
              cur_column_ref->table_ref->table ==
              cur_column_ref->table_field->table);
3553 3554 3555
}


3556 3557 3558 3559 3560 3561 3562 3563 3564 3565 3566 3567 3568 3569 3570 3571 3572 3573 3574 3575 3576 3577 3578 3579 3580 3581 3582
void Field_iterator_table_ref::set_field_iterator()
{
  DBUG_ENTER("Field_iterator_table_ref::set_field_iterator");
  /*
    If the table reference we are iterating over is a natural join, or it is
    an operand of a natural join, and TABLE_LIST::join_columns contains all
    the columns of the join operand, then we pick the columns from
    TABLE_LIST::join_columns, instead of the  orginial container of the
    columns of the join operator.
  */
  if (table_ref->is_join_columns_complete)
  {
    /* Necesary, but insufficient conditions. */
    DBUG_ASSERT(table_ref->is_natural_join ||
                table_ref->nested_join ||
                table_ref->join_columns &&
                /* This is a merge view. */
                ((table_ref->field_translation &&
                  table_ref->join_columns->elements ==
                  (ulong)(table_ref->field_translation_end -
                          table_ref->field_translation)) ||
                 /* This is stored table or a tmptable view. */
                 (!table_ref->field_translation &&
                  table_ref->join_columns->elements ==
                  table_ref->table->s->fields)));
    field_it= &natural_join_it;
    DBUG_PRINT("info",("field_it for '%s' is Field_iterator_natural_join",
3583
                       table_ref->alias));
3584 3585 3586 3587 3588 3589 3590 3591
  }
  /* This is a merge view, so use field_translation. */
  else if (table_ref->field_translation)
  {
    DBUG_ASSERT(table_ref->view &&
                table_ref->effective_algorithm == VIEW_ALGORITHM_MERGE);
    field_it= &view_field_it;
    DBUG_PRINT("info", ("field_it for '%s' is Field_iterator_view",
3592
                        table_ref->alias));
3593 3594 3595 3596 3597 3598 3599
  }
  /* This is a base table or stored view. */
  else
  {
    DBUG_ASSERT(table_ref->table || table_ref->view);
    field_it= &table_field_it;
    DBUG_PRINT("info", ("field_it for '%s' is Field_iterator_table",
3600
                        table_ref->alias));
3601
  }
3602
  field_it->set(table_ref);
3603 3604 3605 3606 3607 3608 3609 3610 3611 3612 3613 3614 3615 3616 3617 3618 3619 3620 3621 3622 3623 3624 3625 3626 3627 3628 3629 3630 3631 3632 3633 3634 3635 3636 3637 3638 3639 3640
  DBUG_VOID_RETURN;
}


void Field_iterator_table_ref::set(TABLE_LIST *table)
{
  DBUG_ASSERT(table);
  first_leaf= table->first_leaf_for_name_resolution();
  last_leaf=  table->last_leaf_for_name_resolution();
  DBUG_ASSERT(first_leaf && last_leaf);
  table_ref= first_leaf;
  set_field_iterator();
}


void Field_iterator_table_ref::next()
{
  /* Move to the next field in the current table reference. */
  field_it->next();
  /*
    If all fields of the current table reference are exhausted, move to
    the next leaf table reference.
  */
  if (field_it->end_of_fields() && table_ref != last_leaf)
  {
    table_ref= table_ref->next_name_resolution_table;
    DBUG_ASSERT(table_ref);
    set_field_iterator();
  }
}


const char *Field_iterator_table_ref::table_name()
{
  if (table_ref->view)
    return table_ref->view_name.str;
  else if (table_ref->is_natural_join)
    return natural_join_it.column_ref()->table_name();
3641 3642

  DBUG_ASSERT(!strcmp(table_ref->table_name,
3643
                      table_ref->table->s->table_name.str));
3644
  return table_ref->table_name;
3645 3646 3647 3648 3649 3650 3651 3652 3653
}


const char *Field_iterator_table_ref::db_name()
{
  if (table_ref->view)
    return table_ref->view_db.str;
  else if (table_ref->is_natural_join)
    return natural_join_it.column_ref()->db_name();
3654

3655 3656 3657 3658 3659
  /*
    Test that TABLE_LIST::db is the same as st_table_share::db to
    ensure consistency. An exception are I_S schema tables, which
    are inconsistent in this respect.
  */
3660
  DBUG_ASSERT(!strcmp(table_ref->db, table_ref->table->s->db.str) ||
3661
              (table_ref->schema_table &&
3662
               table_ref->table->s->db.str[0] == 0));
3663

3664
  return table_ref->db;
3665 3666 3667 3668 3669 3670 3671 3672 3673
}


GRANT_INFO *Field_iterator_table_ref::grant()
{
  if (table_ref->view)
    return &(table_ref->grant);
  else if (table_ref->is_natural_join)
    return natural_join_it.column_ref()->grant();
3674
  return &(table_ref->table->grant);
3675 3676 3677 3678 3679 3680 3681 3682 3683
}


/*
  Create new or return existing column reference to a column of a
  natural/using join.

  SYNOPSIS
    Field_iterator_table_ref::get_or_create_column_ref()
timour@mysql.com's avatar
timour@mysql.com committed
3684 3685
    parent_table_ref  the parent table reference over which the
                      iterator is iterating
3686 3687

  DESCRIPTION
timour@mysql.com's avatar
timour@mysql.com committed
3688 3689 3690 3691 3692 3693 3694 3695 3696 3697 3698 3699 3700 3701 3702 3703 3704 3705 3706 3707 3708
    Create a new natural join column for the current field of the
    iterator if no such column was created, or return an already
    created natural join column. The former happens for base tables or
    views, and the latter for natural/using joins. If a new field is
    created, then the field is added to 'parent_table_ref' if it is
    given, or to the original table referene of the field if
    parent_table_ref == NULL.

  NOTES
    This method is designed so that when a Field_iterator_table_ref
    walks through the fields of a table reference, all its fields
    are created and stored as follows:
    - If the table reference being iterated is a stored table, view or
      natural/using join, store all natural join columns in a list
      attached to that table reference.
    - If the table reference being iterated is a nested join that is
      not natural/using join, then do not materialize its result
      fields. This is OK because for such table references
      Field_iterator_table_ref iterates over the fields of the nested
      table references (recursively). In this way we avoid the storage
      of unnecessay copies of result columns of nested joins.
3709 3710

  RETURN
3711 3712
    #     Pointer to a column of a natural join (or its operand)
    NULL  No memory to allocate the column
3713 3714 3715
*/

Natural_join_column *
timour@mysql.com's avatar
timour@mysql.com committed
3716
Field_iterator_table_ref::get_or_create_column_ref(TABLE_LIST *parent_table_ref)
3717
{
3718
  Natural_join_column *nj_col;
timour@mysql.com's avatar
timour@mysql.com committed
3719 3720 3721 3722
  bool is_created= TRUE;
  uint field_count;
  TABLE_LIST *add_table_ref= parent_table_ref ?
                             parent_table_ref : table_ref;
3723

3724
  LINT_INIT(field_count);
3725
  if (field_it == &table_field_it)
3726 3727 3728 3729
  {
    /* The field belongs to a stored table. */
    Field *field= table_field_it.field();
    nj_col= new Natural_join_column(field, table_ref);
timour@mysql.com's avatar
timour@mysql.com committed
3730
    field_count= table_ref->table->s->fields;
3731 3732 3733 3734 3735 3736
  }
  else if (field_it == &view_field_it)
  {
    /* The field belongs to a merge view or information schema table. */
    Field_translator *translated_field= view_field_it.field_translator();
    nj_col= new Natural_join_column(translated_field, table_ref);
timour@mysql.com's avatar
timour@mysql.com committed
3737 3738
    field_count= table_ref->field_translation_end -
                 table_ref->field_translation;
3739 3740 3741 3742 3743 3744 3745 3746
  }
  else
  {
    /*
      The field belongs to a NATURAL join, therefore the column reference was
      already created via one of the two constructor calls above. In this case
      we just return the already created column reference.
    */
timour@mysql.com's avatar
timour@mysql.com committed
3747 3748
    DBUG_ASSERT(table_ref->is_join_columns_complete);
    is_created= FALSE;
3749 3750 3751
    nj_col= natural_join_it.column_ref();
    DBUG_ASSERT(nj_col);
  }
3752 3753
  DBUG_ASSERT(!nj_col->table_field ||
              nj_col->table_ref->table == nj_col->table_field->table);
timour@mysql.com's avatar
timour@mysql.com committed
3754 3755 3756 3757 3758 3759 3760 3761 3762 3763 3764 3765 3766 3767 3768 3769 3770 3771 3772 3773 3774 3775 3776 3777 3778 3779 3780 3781 3782 3783

  /*
    If the natural join column was just created add it to the list of
    natural join columns of either 'parent_table_ref' or to the table
    reference that directly contains the original field.
  */
  if (is_created)
  {
    /* Make sure not all columns were materialized. */
    DBUG_ASSERT(!add_table_ref->is_join_columns_complete);
    if (!add_table_ref->join_columns)
    {
      /* Create a list of natural join columns on demand. */
      if (!(add_table_ref->join_columns= new List<Natural_join_column>))
        return NULL;
      add_table_ref->is_join_columns_complete= FALSE;
    }
    add_table_ref->join_columns->push_back(nj_col);
    /*
      If new fields are added to their original table reference, mark if
      all fields were added. We do it here as the caller has no easy way
      of knowing when to do it.
      If the fields are being added to parent_table_ref, then the caller
      must take care to mark when all fields are created/added.
    */
    if (!parent_table_ref &&
        add_table_ref->join_columns->elements == field_count)
      add_table_ref->is_join_columns_complete= TRUE;
  }

3784
  return nj_col;
3785 3786 3787
}


3788 3789 3790 3791 3792 3793 3794 3795 3796 3797 3798 3799 3800 3801 3802 3803 3804 3805 3806 3807 3808 3809 3810 3811 3812 3813 3814 3815 3816 3817 3818 3819 3820 3821
/*
  Return an existing reference to a column of a natural/using join.

  SYNOPSIS
    Field_iterator_table_ref::get_natural_column_ref()

  DESCRIPTION
    The method should be called in contexts where it is expected that
    all natural join columns are already created, and that the column
    being retrieved is a Natural_join_column.

  RETURN
    #     Pointer to a column of a natural join (or its operand)
    NULL  No memory to allocate the column
*/

Natural_join_column *
Field_iterator_table_ref::get_natural_column_ref()
{
  Natural_join_column *nj_col;

  DBUG_ASSERT(field_it == &natural_join_it);
  /*
    The field belongs to a NATURAL join, therefore the column reference was
    already created via one of the two constructor calls above. In this case
    we just return the already created column reference.
  */
  nj_col= natural_join_it.column_ref();
  DBUG_ASSERT(nj_col &&
              (!nj_col->table_field ||
               nj_col->table_ref->table == nj_col->table_field->table));
  return nj_col;
}

3822 3823 3824 3825 3826 3827 3828 3829 3830 3831 3832 3833 3834 3835 3836 3837 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 3863 3864 3865 3866 3867 3868 3869 3870 3871 3872 3873 3874 3875 3876 3877 3878 3879 3880 3881 3882 3883 3884 3885 3886 3887 3888 3889 3890 3891 3892 3893 3894 3895 3896 3897 3898 3899 3900 3901 3902 3903 3904 3905 3906 3907 3908 3909 3910 3911 3912 3913 3914 3915 3916 3917 3918 3919 3920 3921 3922 3923 3924 3925 3926 3927 3928 3929 3930 3931 3932 3933 3934 3935 3936 3937 3938 3939 3940 3941 3942 3943 3944 3945 3946 3947 3948 3949 3950 3951 3952 3953 3954 3955 3956 3957 3958 3959 3960 3961 3962 3963 3964 3965 3966 3967 3968
/*****************************************************************************
  Functions to handle column usage bitmaps (read_set, write_set etc...)
*****************************************************************************/

/* Reset all columns bitmaps */

void st_table::clear_column_bitmaps()
{
  /*
    Reset column read/write usage. It's identical to:
    bitmap_clear_all(&table->def_read_set);
    bitmap_clear_all(&table->def_write_set);
  */
  bzero((char*) def_read_set.bitmap, s->column_bitmap_size*2);
  column_bitmaps_set(&def_read_set, &def_write_set);
}


/*
  Tell handler we are going to call position() and rnd_pos() later.
  
  NOTES:
  This is needed for handlers that uses the primary key to find the
  row. In this case we have to extend the read bitmap with the primary
  key fields.
*/

void st_table::prepare_for_position()
{
  DBUG_ENTER("st_table::prepare_for_position");

  if ((file->ha_table_flags() & HA_PRIMARY_KEY_IN_READ_INDEX) &&
      s->primary_key < MAX_KEY)
  {
    mark_columns_used_by_index_no_reset(s->primary_key, read_set);
    /* signal change */
    file->column_bitmaps_signal();
  }
  DBUG_VOID_RETURN;
}


/*
  Mark that only fields from one key is used

  NOTE:
    This changes the bitmap to use the tmp bitmap
    After this, you can't access any other columns in the table until
    bitmaps are reset, for example with st_table::clear_column_bitmaps()
    or st_table::restore_column_maps_after_mark_index()
*/

void st_table::mark_columns_used_by_index(uint index)
{
  MY_BITMAP *bitmap= &tmp_set;
  DBUG_ENTER("st_table::mark_columns_used_by_index");

  (void) file->extra(HA_EXTRA_KEYREAD);
  bitmap_clear_all(bitmap);
  mark_columns_used_by_index_no_reset(index, bitmap);
  column_bitmaps_set(bitmap, bitmap);
  DBUG_VOID_RETURN;
}


/*
  Restore to use normal column maps after key read

  NOTES
    This reverse the change done by mark_columns_used_by_index

  WARNING
    For this to work, one must have the normal table maps in place
    when calling mark_columns_used_by_index
*/

void st_table::restore_column_maps_after_mark_index()
{
  DBUG_ENTER("st_table::restore_column_maps_after_mark_index");

  key_read= 0;
  (void) file->extra(HA_EXTRA_NO_KEYREAD);
  default_column_bitmaps();
  file->column_bitmaps_signal();
  DBUG_VOID_RETURN;
}


/*
  mark columns used by key, but don't reset other fields
*/

void st_table::mark_columns_used_by_index_no_reset(uint index,
                                                   MY_BITMAP *bitmap)
{
  KEY_PART_INFO *key_part= key_info[index].key_part;
  KEY_PART_INFO *key_part_end= (key_part +
                                key_info[index].key_parts);
  for (;key_part != key_part_end; key_part++)
    bitmap_set_bit(bitmap, key_part->fieldnr-1);
}


/*
  Mark auto-increment fields as used fields in both read and write maps

  NOTES
    This is needed in insert & update as the auto-increment field is
    always set and sometimes read.
*/

void st_table::mark_auto_increment_column()
{
  DBUG_ASSERT(found_next_number_field);
  /*
    We must set bit in read set as update_auto_increment() is using the
    store() to check overflow of auto_increment values
  */
  bitmap_set_bit(read_set, found_next_number_field->field_index);
  bitmap_set_bit(write_set, found_next_number_field->field_index);
  if (s->next_number_key_offset)
    mark_columns_used_by_index_no_reset(s->next_number_index, read_set);
  file->column_bitmaps_signal();
}


/*
  Mark columns needed for doing an delete of a row

  DESCRIPTON
    Some table engines don't have a cursor on the retrieve rows
    so they need either to use the primary key or all columns to
    be able to delete a row.

    If the engine needs this, the function works as follows:
    - If primary key exits, mark the primary key columns to be read.
    - If not, mark all columns to be read

    If the engine has HA_REQUIRES_KEY_COLUMNS_FOR_DELETE, we will
    mark all key columns as 'to-be-read'. This allows the engine to
    loop over the given record to find all keys and doesn't have to
    retrieve the row again.
*/

void st_table::mark_columns_needed_for_delete()
{
  if (triggers)
3969
    triggers->mark_fields_used(TRG_EVENT_DELETE);
3970 3971 3972 3973 3974 3975 3976 3977 3978 3979 3980 3981 3982 3983 3984 3985 3986 3987 3988 3989 3990 3991 3992 3993 3994 3995 3996 3997 3998 3999 4000 4001 4002 4003 4004 4005 4006 4007 4008 4009 4010 4011 4012 4013 4014 4015 4016 4017 4018 4019
  if (file->ha_table_flags() & HA_REQUIRES_KEY_COLUMNS_FOR_DELETE)
  {
    Field **reg_field;
    for (reg_field= field ; *reg_field ; reg_field++)
    {
      if ((*reg_field)->flags & PART_KEY_FLAG)
        bitmap_set_bit(read_set, (*reg_field)->field_index);
    }
    file->column_bitmaps_signal();
  }
  if (file->ha_table_flags() & HA_PRIMARY_KEY_REQUIRED_FOR_DELETE)
  {
    /*
      If the handler has no cursor capabilites, we have to read either
      the primary key, the hidden primary key or all columns to be
      able to do an delete
    */
    if (s->primary_key == MAX_KEY)
      file->use_hidden_primary_key();
    else
    {
      mark_columns_used_by_index_no_reset(s->primary_key, read_set);
      file->column_bitmaps_signal();
    }
  }
}


/*
  Mark columns needed for doing an update of a row

  DESCRIPTON
    Some engines needs to have all columns in an update (to be able to
    build a complete row). If this is the case, we mark all not
    updated columns to be read.

    If this is no the case, we do like in the delete case and mark
    if neeed, either the primary key column or all columns to be read.
    (see mark_columns_needed_for_delete() for details)

    If the engine has HA_REQUIRES_KEY_COLUMNS_FOR_DELETE, we will
    mark all USED key columns as 'to-be-read'. This allows the engine to
    loop over the given record to find all changed keys and doesn't have to
    retrieve the row again.
*/

void st_table::mark_columns_needed_for_update()
{
  DBUG_ENTER("mark_columns_needed_for_update");
  if (triggers)
4020
    triggers->mark_fields_used(TRG_EVENT_UPDATE);
4021 4022 4023 4024 4025 4026 4027 4028 4029 4030 4031 4032 4033 4034 4035 4036 4037 4038 4039 4040 4041 4042 4043 4044 4045 4046 4047 4048 4049 4050 4051 4052 4053 4054 4055 4056 4057 4058 4059 4060 4061 4062
  if (file->ha_table_flags() & HA_REQUIRES_KEY_COLUMNS_FOR_DELETE)
  {
    /* Mark all used key columns for read */
    Field **reg_field;
    for (reg_field= field ; *reg_field ; reg_field++)
    {
      /* Merge keys is all keys that had a column refered to in the query */
      if (merge_keys.is_overlapping((*reg_field)->part_of_key))
        bitmap_set_bit(read_set, (*reg_field)->field_index);
    }
    file->column_bitmaps_signal();
  }
  if (file->ha_table_flags() & HA_PRIMARY_KEY_REQUIRED_FOR_DELETE)
  {
    /*
      If the handler has no cursor capabilites, we have to read either
      the primary key, the hidden primary key or all columns to be
      able to do an update
    */
    if (s->primary_key == MAX_KEY)
      file->use_hidden_primary_key();
    else
    {
      mark_columns_used_by_index_no_reset(s->primary_key, read_set);
      file->column_bitmaps_signal();
    }
  }
  DBUG_VOID_RETURN;
}


/*
  Mark columns the handler needs for doing an insert

  For now, this is used to mark fields used by the trigger
  as changed.
*/

void st_table::mark_columns_needed_for_insert()
{
  if (triggers)
  {
4063 4064 4065 4066 4067 4068 4069 4070
    /*
      We don't need to mark columns which are used by ON DELETE and
      ON UPDATE triggers, which may be invoked in case of REPLACE or
      INSERT ... ON DUPLICATE KEY UPDATE, since before doing actual
      row replacement or update write_record() will mark all table
      fields as used.
    */
    triggers->mark_fields_used(TRG_EVENT_INSERT);
4071 4072 4073 4074 4075
  }
  if (found_next_number_field)
    mark_auto_increment_column();
}

4076 4077 4078 4079 4080 4081 4082
/*
  Cleanup this table for re-execution.

  SYNOPSIS
    st_table_list::reinit_before_use()
*/

4083
void st_table_list::reinit_before_use(THD *thd)
4084 4085 4086 4087 4088 4089
{
  /*
    Reset old pointers to TABLEs: they are not valid since the tables
    were closed in the end of previous prepare or execute call.
  */
  table= 0;
4090 4091 4092 4093 4094 4095 4096 4097 4098 4099 4100 4101 4102 4103
  /* Reset is_schema_table_processed value(needed for I_S tables */
  is_schema_table_processed= FALSE;

  TABLE_LIST *embedded; /* The table at the current level of nesting. */
  TABLE_LIST *embedding= this; /* The parent nested table reference. */
  do
  {
    embedded= embedding;
    if (embedded->prep_on_expr)
      embedded->on_expr= embedded->prep_on_expr->copy_andor_structure(thd);
    embedding= embedded->embedding;
  }
  while (embedding &&
         embedding->nested_join->join_list.head() == embedded);
4104 4105
}

igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
4106 4107 4108 4109 4110 4111 4112 4113 4114 4115 4116 4117 4118 4119 4120 4121 4122
/*
  Return subselect that contains the FROM list this table is taken from

  SYNOPSIS
    st_table_list::containing_subselect()
 
  RETURN
    Subselect item for the subquery that contains the FROM list
    this table is taken from if there is any
    0 - otherwise

*/

Item_subselect *st_table_list::containing_subselect()
{    
  return (select_lex ? select_lex->master_unit()->item : 0);
}
4123

bk@work.mysql.com's avatar
bk@work.mysql.com committed
4124 4125 4126 4127
/*****************************************************************************
** Instansiate templates
*****************************************************************************/

4128
#ifdef HAVE_EXPLICIT_TEMPLATE_INSTANTIATION
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4129 4130 4131
template class List<String>;
template class List_iterator<String>;
#endif