16
16
/* Create a MyISAM table */
18
#include "myisam_priv.h"
19
#include "drizzled/internal/my_bit.h"
20
#include "drizzled/internal/my_sys.h"
22
#include "drizzled/util/test.h"
23
#include "drizzled/global_charset_info.h"
24
#include "drizzled/error.h"
30
using namespace drizzled;
18
#include "myisamdef.h"
19
#include <mysys/my_tree.h>
20
#include <mysys/queues.h>
21
#include <mysys/my_bit.h>
23
#include <drizzled/util/test.h>
33
26
Old options is used when recreating database, from myisamchk
39
32
MI_CREATE_INFO *ci,uint32_t flags)
41
34
register uint32_t i, j;
42
int dfile= 0, file= 0;
35
File dfile= 0, file= 0;
43
36
int errpos,save_errno, create_mode= O_RDWR | O_TRUNC;
45
38
uint32_t fields,length,max_key_length,packed,pointer,real_length_diff,
80
73
if (!(ci->old_options & HA_OPTION_TEMP_COMPRESS_RECORD))
81
74
options=ci->old_options &
82
75
(HA_OPTION_COMPRESS_RECORD | HA_OPTION_PACK_RECORD |
83
HA_OPTION_READ_ONLY_DATA |
84
HA_OPTION_TMP_TABLE );
76
HA_OPTION_READ_ONLY_DATA | HA_OPTION_CHECKSUM |
77
HA_OPTION_TMP_TABLE | HA_OPTION_DELAY_KEY_WRITE);
86
79
options=ci->old_options &
87
(HA_OPTION_TMP_TABLE );
80
(HA_OPTION_CHECKSUM | HA_OPTION_TMP_TABLE | HA_OPTION_DELAY_KEY_WRITE);
90
83
if (ci->reloc_rows > ci->max_rows)
91
84
ci->reloc_rows=ci->max_rows; /* Check if wrong parameter */
93
86
if (!(rec_per_key_part=
94
(ulong*) malloc((keys + uniques)*MI_MAX_KEY_SEG*sizeof(long))))
96
memset(rec_per_key_part, 0, (keys + uniques)*MI_MAX_KEY_SEG*sizeof(long));
87
(ulong*) my_malloc((keys + uniques)*MI_MAX_KEY_SEG*sizeof(long),
88
MYF(MY_WME | MY_ZEROFILL))))
98
91
/* Start by checking fields and field-types used */
170
163
if (packed || (flags & HA_PACK_RECORD))
171
164
options|=HA_OPTION_PACK_RECORD; /* Must use packed records */
165
/* We can't use checksum with static length rows */
166
if (!(options & HA_OPTION_PACK_RECORD))
167
options&= ~HA_OPTION_CHECKSUM;
172
168
if (!(options & (HA_OPTION_PACK_RECORD | HA_OPTION_COMPRESS_RECORD)))
173
169
min_pack_length+= varchar_length;
174
170
if (flags & HA_CREATE_TMP_TABLE)
176
172
options|= HA_OPTION_TMP_TABLE;
177
173
create_mode|= O_EXCL;
175
if (flags & HA_CREATE_CHECKSUM || (options & HA_OPTION_CHECKSUM))
177
options|= HA_OPTION_CHECKSUM;
180
if (flags & HA_CREATE_DELAY_KEY_WRITE)
181
options|= HA_OPTION_DELAY_KEY_WRITE;
182
if (flags & HA_CREATE_RELIES_ON_SQL_LAYER)
183
options|= HA_OPTION_RELIES_ON_SQL_LAYER;
180
185
packed=(packed+7)/8;
181
186
if (pack_reclength != INT32_MAX)
182
187
pack_reclength+= reclength+packed +
183
test(test_all_bits(options,
184
uint32_t(HA_PACK_RECORD)));
188
test(test_all_bits(options, HA_OPTION_CHECKSUM | HA_PACK_RECORD));
185
189
min_pack_length+=packed;
187
191
if (!ci->data_file_length && ci->max_rows)
200
204
if (options & (HA_OPTION_COMPRESS_RECORD | HA_OPTION_PACK_RECORD))
201
pointer=mi_get_pointer_length(ci->data_file_length, data_pointer_size);
205
pointer=mi_get_pointer_length(ci->data_file_length,myisam_data_pointer_size);
203
pointer=mi_get_pointer_length(ci->max_rows, data_pointer_size);
207
pointer=mi_get_pointer_length(ci->max_rows,myisam_data_pointer_size);
204
208
if (!(max_rows=(uint64_t) ci->max_rows))
205
209
max_rows= ((((uint64_t) 1 << (pointer*8)) -1) / min_pack_length);
236
240
/* Test if prefix compression */
237
241
if (keydef->flag & HA_PACK_KEY)
243
/* Can't use space_compression on number keys */
244
if ((keydef->seg[0].flag & HA_SPACE_PACK) &&
245
keydef->seg[0].type == (int) HA_KEYTYPE_NUM)
246
keydef->seg[0].flag&= ~HA_SPACE_PACK;
239
248
/* Only use HA_PACK_KEY when first segment is a variable length key */
240
249
if (!(keydef->seg[0].flag & (HA_SPACE_PACK | HA_BLOB_PART |
241
250
HA_VAR_LENGTH_PART)))
261
270
/* numbers are stored with high by first to make compression easier */
262
271
switch (keyseg->type) {
272
case HA_KEYTYPE_SHORT_INT:
263
273
case HA_KEYTYPE_LONG_INT:
274
case HA_KEYTYPE_FLOAT:
264
275
case HA_KEYTYPE_DOUBLE:
276
case HA_KEYTYPE_USHORT_INT:
265
277
case HA_KEYTYPE_ULONG_INT:
266
278
case HA_KEYTYPE_LONGLONG:
267
279
case HA_KEYTYPE_ULONGLONG:
280
case HA_KEYTYPE_INT24:
281
case HA_KEYTYPE_UINT24:
282
case HA_KEYTYPE_INT8:
268
283
keyseg->flag|= HA_SWAP_KEY;
270
285
case HA_KEYTYPE_VARTEXT1:
337
352
share.state.rec_per_key_part[key_segs-1]=1L;
338
353
length+=key_length;
339
354
/* Get block length for key, if defined by user */
340
block_length= (keydef->block_length ?
355
block_length= (keydef->block_length ?
341
356
my_round_up_to_next_power(keydef->block_length) :
342
357
myisam_block_size);
343
block_length= max(block_length, (uint32_t)MI_MIN_KEY_BLOCK_LENGTH);
344
block_length= min(block_length, (uint32_t)MI_MAX_KEY_BLOCK_LENGTH);
358
block_length= cmax(block_length, MI_MIN_KEY_BLOCK_LENGTH);
359
block_length= cmin(block_length, MI_MAX_KEY_BLOCK_LENGTH);
346
361
keydef->block_length= (uint16_t) MI_BLOCK_SIZE(length-real_length_diff,
347
362
pointer,MI_MAX_KEYPTR_SIZE,
349
364
if (keydef->block_length > MI_MAX_KEY_BLOCK_LENGTH ||
350
365
length >= MI_MAX_KEY_BUFF)
352
errno=HA_WRONG_CREATE_OPTION;
367
my_errno=HA_WRONG_CREATE_OPTION;
355
set_if_bigger(max_key_block_length,(uint32_t)keydef->block_length);
370
set_if_bigger(max_key_block_length,keydef->block_length);
356
371
keydef->keylength= (uint16_t) key_length;
357
372
keydef->minlength= (uint16_t) (length-min_key_length_skip);
358
373
keydef->maxlength= (uint16_t) length;
395
410
my_printf_error(0, "MyISAM table '%s' has too many columns and/or "
396
411
"indexes and/or unique constraints.",
397
MYF(0), name + internal::dirname_length(name));
398
errno= HA_WRONG_CREATE_OPTION;
412
MYF(0), name + dirname_length(name));
413
my_errno= HA_WRONG_CREATE_OPTION;
402
memmove(share.state.header.file_version,myisam_file_magic,4);
417
memcpy(share.state.header.file_version,myisam_file_magic,4);
403
418
ci->old_options=options| (ci->old_options & HA_OPTION_TEMP_COMPRESS_RECORD ?
404
419
HA_OPTION_COMPRESS_RECORD |
405
420
HA_OPTION_TEMP_COMPRESS_RECORD: 0);
429
444
got from MYI file header (see also myisampack.c:save_state)
431
446
share.base.key_reflength=
432
mi_get_pointer_length(max(ci->key_file_length,tmp),3);
447
mi_get_pointer_length(cmax(ci->key_file_length,tmp),3);
433
448
share.base.keys= share.state.header.keys= keys;
434
449
share.state.header.uniques= uniques;
435
450
share.state.header.fulltext_keys= fulltext_keys;
448
463
share.base.records=ci->max_rows;
449
464
share.base.reloc= ci->reloc_rows;
450
465
share.base.reclength=real_reclength;
451
share.base.pack_reclength=reclength;
466
share.base.pack_reclength=reclength+ test(options & HA_OPTION_CHECKSUM);
452
467
share.base.max_pack_length=pack_reclength;
453
468
share.base.min_pack_length=min_pack_length;
454
469
share.base.pack_bits=packed;
458
473
/* max_data_file_length and max_key_file_length are recalculated on open */
459
474
if (options & HA_OPTION_TMP_TABLE)
460
share.base.max_data_file_length=(internal::my_off_t) ci->data_file_length;
475
share.base.max_data_file_length=(my_off_t) ci->data_file_length;
462
477
share.base.min_block_length=
463
478
(share.base.pack_reclength+3 < MI_EXTEND_BLOCK_LENGTH &&
464
479
! share.base.blobs) ?
465
max(share.base.pack_reclength,(ulong)MI_MIN_BLOCK_LENGTH) :
480
cmax(share.base.pack_reclength,MI_MIN_BLOCK_LENGTH) :
466
481
MI_EXTEND_BLOCK_LENGTH;
467
482
if (! (flags & HA_DONT_TOUCH_DATA))
468
483
share.state.create_time= (long) time((time_t*) 0);
470
THR_LOCK_myisam.lock();
485
pthread_mutex_lock(&THR_LOCK_myisam);
473
488
NOTE: For test_if_reopen() we need a real path name. Hence we need
474
MY_RETURN_REAL_PATH for every internal::fn_format(filename, ...).
489
MY_RETURN_REAL_PATH for every fn_format(filename, ...).
476
491
if (ci->index_file_name)
478
char *iext= strrchr((char *)ci->index_file_name, '.');
493
char *iext= strrchr(ci->index_file_name, '.');
479
494
int have_iext= iext && !strcmp(iext, MI_NAME_IEXT);
480
495
if (options & HA_OPTION_TMP_TABLE)
483
498
/* chop off the table name, tempory tables use generated name */
484
if ((path= strrchr((char *)ci->index_file_name, FN_LIBCHAR)))
499
if ((path= strrchr(ci->index_file_name, FN_LIBCHAR)))
486
internal::fn_format(filename, name, ci->index_file_name, MI_NAME_IEXT,
501
fn_format(filename, name, ci->index_file_name, MI_NAME_IEXT,
487
502
MY_REPLACE_DIR | MY_UNPACK_FILENAME |
488
503
MY_RETURN_REAL_PATH | MY_APPEND_EXT);
492
internal::fn_format(filename, ci->index_file_name, "", MI_NAME_IEXT,
507
fn_format(filename, ci->index_file_name, "", MI_NAME_IEXT,
493
508
MY_UNPACK_FILENAME | MY_RETURN_REAL_PATH |
494
509
(have_iext ? MY_REPLACE_EXT : MY_APPEND_EXT));
496
internal::fn_format(linkname, name, "", MI_NAME_IEXT,
511
fn_format(linkname, name, "", MI_NAME_IEXT,
497
512
MY_UNPACK_FILENAME|MY_APPEND_EXT);
498
513
linkname_ptr=linkname;
507
char *iext= strrchr((char *)name, '.');
522
char *iext= strrchr(name, '.');
508
523
int have_iext= iext && !strcmp(iext, MI_NAME_IEXT);
509
internal::fn_format(filename, name, "", MI_NAME_IEXT,
524
fn_format(filename, name, "", MI_NAME_IEXT,
510
525
MY_UNPACK_FILENAME | MY_RETURN_REAL_PATH |
511
526
(have_iext ? MY_REPLACE_EXT : MY_APPEND_EXT));
529
544
my_printf_error(0, "MyISAM table '%s' is in use "
530
545
"(most likely by a MERGE table). Try FLUSH TABLES.",
531
MYF(0), name + internal::dirname_length(name));
532
errno= HA_ERR_TABLE_EXIST;
546
MYF(0), name + dirname_length(name));
547
my_errno= HA_ERR_TABLE_EXIST;
536
if ((file= internal::my_create_with_symlink(linkname_ptr,
540
MYF(MY_WME | create_flag))) < 0)
551
if ((file= my_create_with_symlink(linkname_ptr, filename, 0, create_mode,
552
MYF(MY_WME | create_flag))) < 0)
547
559
if (ci->data_file_name)
549
char *dext= strrchr((char *)ci->data_file_name, '.');
561
char *dext= strrchr(ci->data_file_name, '.');
550
562
int have_dext= dext && !strcmp(dext, MI_NAME_DEXT);
552
564
if (options & HA_OPTION_TMP_TABLE)
555
567
/* chop off the table name, tempory tables use generated name */
556
if ((path= strrchr((char *)ci->data_file_name, FN_LIBCHAR)))
568
if ((path= strrchr(ci->data_file_name, FN_LIBCHAR)))
558
internal::fn_format(filename, name, ci->data_file_name, MI_NAME_DEXT,
570
fn_format(filename, name, ci->data_file_name, MI_NAME_DEXT,
559
571
MY_REPLACE_DIR | MY_UNPACK_FILENAME | MY_APPEND_EXT);
563
internal::fn_format(filename, ci->data_file_name, "", MI_NAME_DEXT,
575
fn_format(filename, ci->data_file_name, "", MI_NAME_DEXT,
564
576
MY_UNPACK_FILENAME |
565
577
(have_dext ? MY_REPLACE_EXT : MY_APPEND_EXT));
568
internal::fn_format(linkname, name, "",MI_NAME_DEXT,
580
fn_format(linkname, name, "",MI_NAME_DEXT,
569
581
MY_UNPACK_FILENAME | MY_APPEND_EXT);
570
582
linkname_ptr=linkname;
575
internal::fn_format(filename,name,"", MI_NAME_DEXT,
587
fn_format(filename,name,"", MI_NAME_DEXT,
576
588
MY_UNPACK_FILENAME | MY_APPEND_EXT);
578
590
create_flag=(flags & HA_CREATE_KEEP_FILES) ? 0 : MY_DELETE_OLD;
580
if ((dfile= internal::my_create_with_symlink(linkname_ptr,
581
filename, 0, create_mode,
582
MYF(MY_WME | create_flag))) < 0)
593
my_create_with_symlink(linkname_ptr, filename, 0, create_mode,
594
MYF(MY_WME | create_flag))) < 0)
669
if (internal::my_close(dfile,MYF(0)))
681
if (my_close(dfile,MYF(0)))
673
THR_LOCK_myisam.unlock();
674
if (internal::my_close(file,MYF(0)))
685
pthread_mutex_unlock(&THR_LOCK_myisam);
686
if (my_close(file,MYF(0)))
676
688
free((char*) rec_per_key_part);
680
THR_LOCK_myisam.unlock();
692
pthread_mutex_unlock(&THR_LOCK_myisam);
682
694
switch (errpos) {
684
internal::my_close(dfile,MYF(0));
696
my_close(dfile,MYF(0));
685
697
/* fall through */
687
699
if (! (flags & HA_DONT_TOUCH_DATA))
688
internal::my_delete_with_symlink(internal::fn_format(filename,name,"",MI_NAME_DEXT,
700
my_delete_with_symlink(fn_format(filename,name,"",MI_NAME_DEXT,
689
701
MY_UNPACK_FILENAME | MY_APPEND_EXT),
691
703
/* fall through */
693
internal::my_close(file,MYF(0));
705
my_close(file,MYF(0));
694
706
if (! (flags & HA_DONT_TOUCH_DATA))
695
internal::my_delete_with_symlink(internal::fn_format(filename,name,"",MI_NAME_IEXT,
707
my_delete_with_symlink(fn_format(filename,name,"",MI_NAME_IEXT,
696
708
MY_UNPACK_FILENAME | MY_APPEND_EXT),
699
711
free((char*) rec_per_key_part);
700
return(errno=save_errno); /* return the fatal errno */
712
return(my_errno=save_errno); /* return the fatal errno */