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>
33
25
Old options is used when recreating database, from myisamchk
36
int mi_create(const char *name,uint32_t keys,MI_KEYDEF *keydefs,
37
uint32_t columns, MI_COLUMNDEF *recinfo,
38
uint32_t uniques, MI_UNIQUEDEF *uniquedefs,
39
MI_CREATE_INFO *ci,uint32_t flags)
28
int mi_create(const char *name,uint keys,MI_KEYDEF *keydefs,
29
uint columns, MI_COLUMNDEF *recinfo,
30
uint uniques, MI_UNIQUEDEF *uniquedefs,
31
MI_CREATE_INFO *ci,uint flags)
41
register uint32_t i, j;
42
int dfile= 0, file= 0;
34
File dfile= 0, file= 0;
43
35
int errpos,save_errno, create_mode= O_RDWR | O_TRUNC;
45
uint32_t fields,length,max_key_length,packed,pointer,real_length_diff,
37
uint fields,length,max_key_length,packed,pointer,real_length_diff,
46
38
key_length,info_length,key_segs,options,min_key_length_skip,
47
39
base_pos,long_varchar_count,varchar_length,
48
40
max_key_block_length,unique_key_parts,fulltext_keys,offset;
49
uint32_t aligned_key_start, block_length;
41
uint aligned_key_start, block_length;
50
42
ulong reclength, real_reclength,min_pack_length;
51
43
char filename[FN_REFLEN],linkname[FN_REFLEN], *linkname_ptr;
52
44
ulong pack_reclength;
80
72
if (!(ci->old_options & HA_OPTION_TEMP_COMPRESS_RECORD))
81
73
options=ci->old_options &
82
74
(HA_OPTION_COMPRESS_RECORD | HA_OPTION_PACK_RECORD |
83
HA_OPTION_READ_ONLY_DATA |
84
HA_OPTION_TMP_TABLE );
75
HA_OPTION_READ_ONLY_DATA | HA_OPTION_CHECKSUM |
76
HA_OPTION_TMP_TABLE | HA_OPTION_DELAY_KEY_WRITE);
86
78
options=ci->old_options &
87
(HA_OPTION_TMP_TABLE );
79
(HA_OPTION_CHECKSUM | HA_OPTION_TMP_TABLE | HA_OPTION_DELAY_KEY_WRITE);
90
82
if (ci->reloc_rows > ci->max_rows)
91
83
ci->reloc_rows=ci->max_rows; /* Check if wrong parameter */
93
85
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));
86
(ulong*) my_malloc((keys + uniques)*MI_MAX_KEY_SEG*sizeof(long),
87
MYF(MY_WME | MY_ZEROFILL))))
98
90
/* Start by checking fields and field-types used */
170
162
if (packed || (flags & HA_PACK_RECORD))
171
163
options|=HA_OPTION_PACK_RECORD; /* Must use packed records */
164
/* We can't use checksum with static length rows */
165
if (!(options & HA_OPTION_PACK_RECORD))
166
options&= ~HA_OPTION_CHECKSUM;
172
167
if (!(options & (HA_OPTION_PACK_RECORD | HA_OPTION_COMPRESS_RECORD)))
173
168
min_pack_length+= varchar_length;
174
169
if (flags & HA_CREATE_TMP_TABLE)
176
171
options|= HA_OPTION_TMP_TABLE;
177
create_mode|= O_EXCL;
172
create_mode|= O_EXCL | O_NOFOLLOW;
174
if (flags & HA_CREATE_CHECKSUM || (options & HA_OPTION_CHECKSUM))
176
options|= HA_OPTION_CHECKSUM;
179
if (flags & HA_CREATE_DELAY_KEY_WRITE)
180
options|= HA_OPTION_DELAY_KEY_WRITE;
181
if (flags & HA_CREATE_RELIES_ON_SQL_LAYER)
182
options|= HA_OPTION_RELIES_ON_SQL_LAYER;
180
184
packed=(packed+7)/8;
181
185
if (pack_reclength != INT32_MAX)
182
186
pack_reclength+= reclength+packed +
183
test(test_all_bits(options,
184
uint32_t(HA_PACK_RECORD)));
187
test(test_all_bits(options, HA_OPTION_CHECKSUM | HA_PACK_RECORD));
185
188
min_pack_length+=packed;
187
190
if (!ci->data_file_length && ci->max_rows)
200
203
if (options & (HA_OPTION_COMPRESS_RECORD | HA_OPTION_PACK_RECORD))
201
pointer=mi_get_pointer_length(ci->data_file_length, data_pointer_size);
204
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);
206
pointer=mi_get_pointer_length(ci->max_rows,myisam_data_pointer_size);
204
207
if (!(max_rows=(uint64_t) ci->max_rows))
205
208
max_rows= ((((uint64_t) 1 << (pointer*8)) -1) / min_pack_length);
236
239
/* Test if prefix compression */
237
240
if (keydef->flag & HA_PACK_KEY)
242
/* Can't use space_compression on number keys */
243
if ((keydef->seg[0].flag & HA_SPACE_PACK) &&
244
keydef->seg[0].type == (int) HA_KEYTYPE_NUM)
245
keydef->seg[0].flag&= ~HA_SPACE_PACK;
239
247
/* Only use HA_PACK_KEY when first segment is a variable length key */
240
248
if (!(keydef->seg[0].flag & (HA_SPACE_PACK | HA_BLOB_PART |
241
249
HA_VAR_LENGTH_PART)))
261
269
/* numbers are stored with high by first to make compression easier */
262
270
switch (keyseg->type) {
271
case HA_KEYTYPE_SHORT_INT:
263
272
case HA_KEYTYPE_LONG_INT:
273
case HA_KEYTYPE_FLOAT:
264
274
case HA_KEYTYPE_DOUBLE:
275
case HA_KEYTYPE_USHORT_INT:
265
276
case HA_KEYTYPE_ULONG_INT:
266
277
case HA_KEYTYPE_LONGLONG:
267
278
case HA_KEYTYPE_ULONGLONG:
279
case HA_KEYTYPE_INT24:
268
280
case HA_KEYTYPE_UINT24:
281
case HA_KEYTYPE_INT8:
269
282
keyseg->flag|= HA_SWAP_KEY;
271
284
case HA_KEYTYPE_VARTEXT1:
338
351
share.state.rec_per_key_part[key_segs-1]=1L;
339
352
length+=key_length;
340
353
/* Get block length for key, if defined by user */
341
block_length= (keydef->block_length ?
354
block_length= (keydef->block_length ?
342
355
my_round_up_to_next_power(keydef->block_length) :
343
356
myisam_block_size);
344
block_length= max(block_length, (uint32_t)MI_MIN_KEY_BLOCK_LENGTH);
345
block_length= min(block_length, (uint32_t)MI_MAX_KEY_BLOCK_LENGTH);
357
block_length= max(block_length, MI_MIN_KEY_BLOCK_LENGTH);
358
block_length= min(block_length, MI_MAX_KEY_BLOCK_LENGTH);
347
360
keydef->block_length= (uint16_t) MI_BLOCK_SIZE(length-real_length_diff,
348
361
pointer,MI_MAX_KEYPTR_SIZE,
350
363
if (keydef->block_length > MI_MAX_KEY_BLOCK_LENGTH ||
351
364
length >= MI_MAX_KEY_BUFF)
353
errno=HA_WRONG_CREATE_OPTION;
366
my_errno=HA_WRONG_CREATE_OPTION;
356
set_if_bigger(max_key_block_length,(uint32_t)keydef->block_length);
369
set_if_bigger(max_key_block_length,keydef->block_length);
357
370
keydef->keylength= (uint16_t) key_length;
358
371
keydef->minlength= (uint16_t) (length-min_key_length_skip);
359
372
keydef->maxlength= (uint16_t) length;
396
409
my_printf_error(0, "MyISAM table '%s' has too many columns and/or "
397
410
"indexes and/or unique constraints.",
398
MYF(0), name + internal::dirname_length(name));
399
errno= HA_WRONG_CREATE_OPTION;
411
MYF(0), name + dirname_length(name));
412
my_errno= HA_WRONG_CREATE_OPTION;
403
memmove(share.state.header.file_version,myisam_file_magic,4);
416
memcpy(share.state.header.file_version,myisam_file_magic,4);
404
417
ci->old_options=options| (ci->old_options & HA_OPTION_TEMP_COMPRESS_RECORD ?
405
418
HA_OPTION_COMPRESS_RECORD |
406
419
HA_OPTION_TEMP_COMPRESS_RECORD: 0);
449
462
share.base.records=ci->max_rows;
450
463
share.base.reloc= ci->reloc_rows;
451
464
share.base.reclength=real_reclength;
452
share.base.pack_reclength=reclength;
465
share.base.pack_reclength=reclength+ test(options & HA_OPTION_CHECKSUM);
453
466
share.base.max_pack_length=pack_reclength;
454
467
share.base.min_pack_length=min_pack_length;
455
468
share.base.pack_bits=packed;
459
472
/* max_data_file_length and max_key_file_length are recalculated on open */
460
473
if (options & HA_OPTION_TMP_TABLE)
461
share.base.max_data_file_length=(internal::my_off_t) ci->data_file_length;
474
share.base.max_data_file_length=(my_off_t) ci->data_file_length;
463
476
share.base.min_block_length=
464
477
(share.base.pack_reclength+3 < MI_EXTEND_BLOCK_LENGTH &&
465
478
! share.base.blobs) ?
466
max(share.base.pack_reclength,(ulong)MI_MIN_BLOCK_LENGTH) :
479
max(share.base.pack_reclength,MI_MIN_BLOCK_LENGTH) :
467
480
MI_EXTEND_BLOCK_LENGTH;
468
481
if (! (flags & HA_DONT_TOUCH_DATA))
469
482
share.state.create_time= (long) time((time_t*) 0);
474
487
NOTE: For test_if_reopen() we need a real path name. Hence we need
475
MY_RETURN_REAL_PATH for every internal::fn_format(filename, ...).
488
MY_RETURN_REAL_PATH for every fn_format(filename, ...).
477
490
if (ci->index_file_name)
479
char *iext= strrchr((char *)ci->index_file_name, '.');
492
char *iext= strrchr(ci->index_file_name, '.');
480
493
int have_iext= iext && !strcmp(iext, MI_NAME_IEXT);
481
494
if (options & HA_OPTION_TMP_TABLE)
484
497
/* chop off the table name, tempory tables use generated name */
485
if ((path= strrchr((char *)ci->index_file_name, FN_LIBCHAR)))
498
if ((path= strrchr(ci->index_file_name, FN_LIBCHAR)))
487
internal::fn_format(filename, name, ci->index_file_name, MI_NAME_IEXT,
500
fn_format(filename, name, ci->index_file_name, MI_NAME_IEXT,
488
501
MY_REPLACE_DIR | MY_UNPACK_FILENAME |
489
502
MY_RETURN_REAL_PATH | MY_APPEND_EXT);
493
internal::fn_format(filename, ci->index_file_name, "", MI_NAME_IEXT,
506
fn_format(filename, ci->index_file_name, "", MI_NAME_IEXT,
494
507
MY_UNPACK_FILENAME | MY_RETURN_REAL_PATH |
495
508
(have_iext ? MY_REPLACE_EXT : MY_APPEND_EXT));
497
internal::fn_format(linkname, name, "", MI_NAME_IEXT,
510
fn_format(linkname, name, "", MI_NAME_IEXT,
498
511
MY_UNPACK_FILENAME|MY_APPEND_EXT);
499
512
linkname_ptr=linkname;
508
char *iext= strrchr((char *)name, '.');
521
char *iext= strrchr(name, '.');
509
522
int have_iext= iext && !strcmp(iext, MI_NAME_IEXT);
510
internal::fn_format(filename, name, "", MI_NAME_IEXT,
523
fn_format(filename, name, "", MI_NAME_IEXT,
511
524
MY_UNPACK_FILENAME | MY_RETURN_REAL_PATH |
512
525
(have_iext ? MY_REPLACE_EXT : MY_APPEND_EXT));
530
543
my_printf_error(0, "MyISAM table '%s' is in use "
531
544
"(most likely by a MERGE table). Try FLUSH TABLES.",
532
MYF(0), name + internal::dirname_length(name));
533
errno= HA_ERR_TABLE_EXIST;
545
MYF(0), name + dirname_length(name));
546
my_errno= HA_ERR_TABLE_EXIST;
537
if ((file= internal::my_create_with_symlink(linkname_ptr,
541
MYF(MY_WME | create_flag))) < 0)
550
if ((file= my_create_with_symlink(linkname_ptr, filename, 0, create_mode,
551
MYF(MY_WME | create_flag))) < 0)
548
558
if (ci->data_file_name)
550
char *dext= strrchr((char *)ci->data_file_name, '.');
560
char *dext= strrchr(ci->data_file_name, '.');
551
561
int have_dext= dext && !strcmp(dext, MI_NAME_DEXT);
553
563
if (options & HA_OPTION_TMP_TABLE)
556
566
/* chop off the table name, tempory tables use generated name */
557
if ((path= strrchr((char *)ci->data_file_name, FN_LIBCHAR)))
567
if ((path= strrchr(ci->data_file_name, FN_LIBCHAR)))
559
internal::fn_format(filename, name, ci->data_file_name, MI_NAME_DEXT,
569
fn_format(filename, name, ci->data_file_name, MI_NAME_DEXT,
560
570
MY_REPLACE_DIR | MY_UNPACK_FILENAME | MY_APPEND_EXT);
564
internal::fn_format(filename, ci->data_file_name, "", MI_NAME_DEXT,
574
fn_format(filename, ci->data_file_name, "", MI_NAME_DEXT,
565
575
MY_UNPACK_FILENAME |
566
576
(have_dext ? MY_REPLACE_EXT : MY_APPEND_EXT));
569
internal::fn_format(linkname, name, "",MI_NAME_DEXT,
579
fn_format(linkname, name, "",MI_NAME_DEXT,
570
580
MY_UNPACK_FILENAME | MY_APPEND_EXT);
571
581
linkname_ptr=linkname;
576
internal::fn_format(filename,name,"", MI_NAME_DEXT,
586
fn_format(filename,name,"", MI_NAME_DEXT,
577
587
MY_UNPACK_FILENAME | MY_APPEND_EXT);
579
589
create_flag=(flags & HA_CREATE_KEEP_FILES) ? 0 : MY_DELETE_OLD;
581
if ((dfile= internal::my_create_with_symlink(linkname_ptr,
582
filename, 0, create_mode,
583
MYF(MY_WME | create_flag))) < 0)
592
my_create_with_symlink(linkname_ptr, filename, 0, create_mode,
593
MYF(MY_WME | create_flag))) < 0)
670
if (internal::my_close(dfile,MYF(0)))
680
if (my_close(dfile,MYF(0)))
674
684
pthread_mutex_unlock(&THR_LOCK_myisam);
675
if (internal::my_close(file,MYF(0)))
685
if (my_close(file,MYF(0)))
677
free((char*) rec_per_key_part);
687
my_free((char*) rec_per_key_part,MYF(0));
681
691
pthread_mutex_unlock(&THR_LOCK_myisam);
683
693
switch (errpos) {
685
internal::my_close(dfile,MYF(0));
695
VOID(my_close(dfile,MYF(0)));
686
696
/* fall through */
698
/* QQ: T�nu should add a call to my_raid_delete() here */
688
699
if (! (flags & HA_DONT_TOUCH_DATA))
689
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,
690
701
MY_UNPACK_FILENAME | MY_APPEND_EXT),
692
703
/* fall through */
694
internal::my_close(file,MYF(0));
705
VOID(my_close(file,MYF(0)));
695
706
if (! (flags & HA_DONT_TOUCH_DATA))
696
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,
697
708
MY_UNPACK_FILENAME | MY_APPEND_EXT),
700
free((char*) rec_per_key_part);
701
return(errno=save_errno); /* return the fatal errno */
711
my_free((char*) rec_per_key_part, MYF(0));
712
return(my_errno=save_errno); /* return the fatal errno */
705
uint32_t mi_get_pointer_length(uint64_t file_length, uint32_t def)
716
uint mi_get_pointer_length(uint64_t file_length, uint def)
707
718
assert(def >= 2 && def <= 7);
708
719
if (file_length) /* If not default */