23
23
str is a (long) to record position where 0 is the first position.
26
#include <drizzled/server_includes.h>
27
#include <drizzled/drizzled_error_messages.h>
26
#include "mysql_priv.h"
29
30
#define FCOMP 17 /* Bytes for a packed field */
31
static unsigned char * pack_screens(List<Create_field> &create_fields,
32
uint32_t *info_length, uint32_t *screens, bool small_file);
33
static uint32_t pack_keys(unsigned char *keybuff,uint32_t key_count, KEY *key_info,
32
static uchar * pack_screens(List<Create_field> &create_fields,
33
uint *info_length, uint *screens, bool small_file);
34
static uint pack_keys(uchar *keybuff,uint key_count, KEY *key_info,
34
35
ulong data_offset);
35
static bool pack_header(unsigned char *forminfo,
36
static bool pack_header(uchar *forminfo,enum legacy_db_type table_type,
36
37
List<Create_field> &create_fields,
37
uint32_t info_length, uint32_t screens, uint32_t table_options,
38
uint info_length, uint screens, uint table_options,
38
39
ulong data_offset, handler *file);
39
static uint32_t get_interval_id(uint32_t *int_count,List<Create_field> &create_fields,
40
static uint get_interval_id(uint *int_count,List<Create_field> &create_fields,
40
41
Create_field *last_field);
41
42
static bool pack_fields(File file, List<Create_field> &create_fields,
42
43
ulong data_offset);
43
44
static bool make_empty_rec(THD *thd, int file, enum legacy_db_type table_type,
44
uint32_t table_options,
45
46
List<Create_field> &create_fields,
46
uint32_t reclength, ulong data_offset,
47
uint reclength, ulong data_offset,
56
57
struct Pack_header_error_handler: public Internal_error_handler
58
virtual bool handle_error(uint32_t sql_errno,
59
virtual bool handle_error(uint sql_errno,
59
60
const char *message,
60
DRIZZLE_ERROR::enum_warning_level level,
61
MYSQL_ERROR::enum_warning_level level,
63
Pack_header_error_handler() :is_handled(false) {}
64
Pack_header_error_handler() :is_handled(FALSE) {}
68
69
Pack_header_error_handler::
69
handle_error(uint32_t sql_errno,
70
handle_error(uint sql_errno,
70
71
const char * /* message */,
71
DRIZZLE_ERROR::enum_warning_level /* level */,
72
MYSQL_ERROR::enum_warning_level /* level */,
74
75
is_handled= (sql_errno == ER_TOO_MANY_FIELDS);
99
100
const char *db, const char *table,
100
101
HA_CREATE_INFO *create_info,
101
102
List<Create_field> &create_fields,
102
uint32_t keys, KEY *key_info,
103
uint keys, KEY *key_info,
103
104
handler *db_file)
105
106
LEX_STRING str_db_type;
106
uint32_t reclength, info_length, screens, key_info_length, maxlength, tmp_len;
107
uint reclength, info_length, screens, key_info_length, maxlength, tmp_len;
107
108
ulong key_buff_length;
109
110
ulong filepos, data_offset;
110
unsigned char fileinfo[64],forminfo[288],*keybuff;
111
uchar fileinfo[64],forminfo[288],*keybuff;
111
112
TYPELIB formnames;
112
unsigned char *screen_buff;
114
const uint32_t format_section_header_size= 8;
115
uint32_t format_section_len;
115
const uint format_section_header_size= 8;
116
uint format_section_len;
117
uint tablespace_len= 0;
116
118
Pack_header_error_handler pack_header_error_handler;
120
DBUG_ENTER("mysql_create_frm");
119
assert(*fn_rext((char*)file_name)); // Check .frm extension
122
DBUG_ASSERT(*fn_rext((char*)file_name)); // Check .frm extension
120
123
formnames.type_names=0;
121
124
if (!(screen_buff=pack_screens(create_fields,&info_length,&screens,0)))
123
assert(db_file != NULL);
126
DBUG_ASSERT(db_file != NULL);
125
128
/* If fixed row records, we need one bit to check for deleted rows */
126
129
if (!(create_info->table_options & HA_OPTION_PACK_RECORD))
200
207
strmake((char*) forminfo+47, create_info->comment.str ?
201
208
create_info->comment.str : "", create_info->comment.length);
202
forminfo[46]=(unsigned char) create_info->comment.length;
209
forminfo[46]=(uchar) create_info->comment.length;
203
210
#ifdef EXTRA_DEBUG
205
212
EXTRA_DEBUG causes strmake() to initialize its buffer behind the
206
213
payload with a magic value to detect wrong buffer-sizes. We
207
214
explicitly zero that segment again.
209
memset(forminfo+47 + forminfo[46], 0, 61 - forminfo[46]);
216
memset((char*) forminfo+47 + forminfo[46], 0, 61 - forminfo[46]);
213
220
if ((file=create_frm(thd, file_name, db, table, reclength, fileinfo,
214
221
create_info, keys, key_info)) < 0)
223
my_free(screen_buff, MYF(0));
220
227
key_buff_length= uint4korr(fileinfo+47);
221
keybuff=(unsigned char*) my_malloc(key_buff_length, MYF(0));
228
keybuff=(uchar*) my_malloc(key_buff_length, MYF(0));
222
229
key_info_length= pack_keys(keybuff, keys, key_info, data_offset);
223
get_form_pos(file,fileinfo,&formnames);
230
VOID(get_form_pos(file,fileinfo,&formnames));
224
231
if (!(filepos=make_new_entry(file,fileinfo,&formnames,"")))
226
233
maxlength=(uint) next_io_size((ulong) (uint2korr(forminfo)+1000));
227
234
int2store(forminfo+2,maxlength);
228
235
int4store(fileinfo+10,(ulong) (filepos+maxlength));
229
fileinfo[26]= (unsigned char) test((create_info->max_rows == 1) &&
236
fileinfo[26]= (uchar) test((create_info->max_rows == 1) &&
230
237
(create_info->min_rows == 1) && (keys == 0));
231
238
int2store(fileinfo+28,key_info_length);
234
241
int2store(fileinfo+59,db_file->extra_rec_buf_length());
236
if (pwrite(file, fileinfo, 64, 0L) == 0 ||
237
pwrite(file, keybuff, key_info_length, (ulong) uint2korr(fileinfo+6)) == 0)
243
if (my_pwrite(file, fileinfo, 64, 0L, MYF_RW) ||
244
my_pwrite(file, keybuff, key_info_length,
245
(ulong) uint2korr(fileinfo+6),MYF_RW))
240
248
(ulong) uint2korr(fileinfo+6)+ (ulong) key_buff_length,
249
MY_SEEK_SET,MYF(0)));
242
250
if (make_empty_rec(thd,file,ha_legacy_type(create_info->db_type),
243
251
create_info->table_options,
244
252
create_fields,reclength, data_offset, db_file))
247
255
int2store(buff, create_info->connect_string.length);
248
if (my_write(file, (const unsigned char*)buff, 2, MYF(MY_NABP)) ||
249
my_write(file, (const unsigned char*)create_info->connect_string.str,
256
if (my_write(file, (const uchar*)buff, 2, MYF(MY_NABP)) ||
257
my_write(file, (const uchar*)create_info->connect_string.str,
250
258
create_info->connect_string.length, MYF(MY_NABP)))
253
261
int2store(buff, str_db_type.length);
254
if (my_write(file, (const unsigned char*)buff, 2, MYF(MY_NABP)) ||
255
my_write(file, (const unsigned char*)str_db_type.str,
262
if (my_write(file, (const uchar*)buff, 2, MYF(MY_NABP)) ||
263
my_write(file, (const uchar*)str_db_type.str,
256
264
str_db_type.length, MYF(MY_NABP)))
261
if (my_write(file, (unsigned char*) buff, 6, MYF_RW))
268
bzero((uchar*) buff, 6);
269
if (my_write(file, (uchar*) buff, 6, MYF_RW))
265
if (forminfo[46] == (unsigned char)255)
273
if (forminfo[46] == (uchar)255)
267
unsigned char comment_length_buff[2];
275
uchar comment_length_buff[2];
268
276
int2store(comment_length_buff,create_info->comment.length);
269
277
if (my_write(file, comment_length_buff, 2, MYF(MY_NABP)) ||
270
my_write(file, (unsigned char*)create_info->comment.str,
278
my_write(file, (uchar*)create_info->comment.str,
271
279
create_info->comment.length, MYF(MY_NABP)))
286
295
/* 2 bytes left for future use */
288
297
/* write header */
289
if (my_write(file, (const unsigned char*)buff, format_section_header_size, MYF_RW))
298
if (my_write(file, (const uchar*)buff, format_section_header_size, MYF_RW))
300
/* write tablespace name */
301
if (tablespace_len > 0)
302
if (my_write(file, (const uchar*)create_info->tablespace, tablespace_len, MYF_RW))
292
if (my_write(file, (const unsigned char*)buff, 1, MYF_RW))
305
if (my_write(file, (const uchar*)buff, 1, MYF_RW))
294
307
/* write column info, 1 byte per column */
296
309
List_iterator<Create_field> it(create_fields);
297
310
Create_field *field;
298
unsigned char column_format, write_byte;
311
uchar storage_type, column_format, write_byte;
299
312
while ((field=it++))
301
column_format= (unsigned char)field->column_format();
302
write_byte= (column_format << COLUMN_FORMAT_SHIFT);
314
storage_type= (uchar)field->field_storage_type();
315
column_format= (uchar)field->column_format();
316
write_byte= storage_type + (column_format << COLUMN_FORMAT_SHIFT);
303
317
if (my_write(file, &write_byte, 1, MYF_RW))
308
my_seek(file,filepos,MY_SEEK_SET,MYF(0));
322
VOID(my_seek(file,filepos,MY_SEEK_SET,MYF(0)));
309
323
if (my_write(file, forminfo, 288, MYF_RW) ||
310
324
my_write(file, screen_buff, info_length, MYF_RW) ||
311
325
pack_fields(file, create_fields, data_offset))
328
my_free(screen_buff,MYF(0));
329
my_free(keybuff, MYF(0));
317
if (!(create_info->options & HA_LEX_CREATE_TMP_TABLE) &&
331
if (opt_sync_frm && !(create_info->options & HA_LEX_CREATE_TMP_TABLE) &&
318
332
(my_sync(file, MYF(MY_WME)) ||
319
333
my_sync_dir_by_file(file_name, MYF(MY_WME))))
375
389
const char *db, const char *table_name,
376
390
HA_CREATE_INFO *create_info,
377
391
List<Create_field> &create_fields,
378
uint32_t keys, KEY *key_info, handler *file)
392
uint keys, KEY *key_info, handler *file)
394
DBUG_ENTER("rea_create_table");
382
396
char frm_name[FN_REFLEN];
383
strxmov(frm_name, path, reg_ext, NULL);
397
strxmov(frm_name, path, reg_ext, NullS);
384
398
if (mysql_create_frm(thd, frm_name, db, table_name, create_info,
385
399
create_fields, keys, key_info, file))
389
403
// Make sure mysql_create_frm din't remove extension
390
assert(*fn_rext(frm_name));
404
DBUG_ASSERT(*fn_rext(frm_name));
391
405
if (thd->variables.keep_files_on_create)
392
406
create_info->options|= HA_CREATE_KEEP_FILES;
393
407
if (file->ha_create_handler_files(path, NULL, CHF_CREATE_FLAG, create_info))
395
409
if (!create_info->frm_only && ha_create_table(thd, path, db, table_name,
397
411
goto err_handler;
401
file->ha_create_handler_files(path, NULL, CHF_DELETE_FLAG, create_info);
415
VOID(file->ha_create_handler_files(path, NULL, CHF_DELETE_FLAG, create_info));
402
416
my_delete(frm_name, MYF(0));
404
418
} /* rea_create_table */
407
421
/* Pack screens to a screen for save in a form-file */
409
static unsigned char *pack_screens(List<Create_field> &create_fields,
410
uint32_t *info_length, uint32_t *screens,
423
static uchar *pack_screens(List<Create_field> &create_fields,
424
uint *info_length, uint *screens,
414
uint32_t row,start_row,end_row,fields_on_screen;
415
uint32_t length,cols;
416
unsigned char *info,*pos,*start_screen;
417
uint32_t fields=create_fields.elements;
428
uint row,start_row,end_row,fields_on_screen;
430
uchar *info,*pos,*start_screen;
431
uint fields=create_fields.elements;
418
432
List_iterator<Create_field> it(create_fields);
433
DBUG_ENTER("pack_screens");
421
435
start_row=4; end_row=22; cols=80; fields_on_screen=end_row+1-start_row;
464
pos[0]=(unsigned char) row;
466
pos[2]=(unsigned char) (length+1);
467
pos=(unsigned char*) strmake((char*) pos+3,cfield->field_name,length)+1;
480
pos[2]=(uchar) (length+1);
481
pos=(uchar*) strmake((char*) pos+3,cfield->field_name,length)+1;
469
cfield->row=(uint8_t) row;
470
cfield->col=(uint8_t) (length+1);
471
cfield->sc_length=(uint8_t) cmin(cfield->length,(uint32_t)cols-(length+2));
483
cfield->row=(uint8) row;
484
cfield->col=(uint8) (length+1);
485
cfield->sc_length=(uint8) min(cfield->length,cols-(length+2));
473
487
length=(uint) (pos-start_screen);
474
488
int2store(start_screen,length);
475
start_screen[2]=(unsigned char) (row-start_row+2);
476
start_screen[3]=(unsigned char) (row-start_row+1);
489
start_screen[2]=(uchar) (row-start_row+2);
490
start_screen[3]=(uchar) (row-start_row+1);
478
492
*info_length=(uint) (pos-info);
480
494
} /* pack_screens */
483
497
/* Pack keyinfo and keynames to keybuff for save in form-file. */
485
static uint32_t pack_keys(unsigned char *keybuff, uint32_t key_count, KEY *keyinfo,
499
static uint pack_keys(uchar *keybuff, uint key_count, KEY *keyinfo,
486
500
ulong data_offset)
488
uint32_t key_parts,length;
489
unsigned char *pos, *keyname_pos;
502
uint key_parts,length;
503
uchar *pos, *keyname_pos;
491
505
KEY_PART_INFO *key_part,*key_part_end;
506
DBUG_ENTER("pack_keys");
498
512
int2store(pos, (key->flags ^ HA_NOSAME));
499
513
int2store(pos+2,key->key_length);
500
pos[4]= (unsigned char) key->key_parts;
501
pos[5]= (unsigned char) key->algorithm;
514
pos[4]= (uchar) key->key_parts;
515
pos[5]= (uchar) key->algorithm;
502
516
int2store(pos+6, key->block_size);
504
518
key_parts+=key->key_parts;
519
DBUG_PRINT("loop", ("flags: %lu key_parts: %d at 0x%lx",
520
key->flags, key->key_parts,
521
(long) key->key_part));
505
522
for (key_part=key->key_part,key_part_end=key_part+key->key_parts ;
506
523
key_part != key_part_end ;
528
DBUG_PRINT("loop",("field: %d startpos: %lu length: %d",
529
key_part->fieldnr, key_part->offset + data_offset,
511
531
int2store(pos,key_part->fieldnr+1+FIELD_NAME_USED);
512
532
offset= (uint) (key_part->offset+data_offset+1);
513
533
int2store(pos+2, offset);
550
keybuff[0]=(unsigned char) key_count;
551
keybuff[1]=(unsigned char) key_parts;
570
keybuff[0]=(uchar) key_count;
571
keybuff[1]=(uchar) key_parts;
552
572
keybuff[2]= keybuff[3]= 0;
554
574
length=(uint) (pos-keyname_pos);
555
575
int2store(keybuff+4,length);
556
return((uint) (pos-keybuff));
576
DBUG_RETURN((uint) (pos-keybuff));
557
577
} /* pack_keys */
560
/* Make formheader */
580
/* Make formheader */
562
static bool pack_header(unsigned char *forminfo,
563
List<Create_field> &create_fields,
564
uint32_t info_length, uint32_t screens, uint32_t table_options,
582
static bool pack_header(uchar *forminfo, enum legacy_db_type table_type,
583
List<Create_field> &create_fields,
584
uint info_length, uint screens, uint table_options,
565
585
ulong data_offset, handler *file)
567
uint32_t length,int_count,int_length,no_empty, int_parts;
568
uint32_t time_stamp_pos,null_fields;
587
uint length,int_count,int_length,no_empty, int_parts;
588
uint time_stamp_pos,null_fields;
569
589
ulong reclength, totlength, n_length, com_length;
590
DBUG_ENTER("pack_header");
572
592
if (create_fields.elements > MAX_FIELDS)
574
594
my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF(0));
682
702
if (reclength > (ulong) file->max_record_length())
684
704
my_error(ER_TOO_BIG_ROWSIZE, MYF(0), (uint) file->max_record_length());
687
707
/* Hack to avoid bugs with small static rows in MySQL */
688
reclength=cmax((ulong)file->min_record_length(table_options),reclength);
708
reclength=max(file->min_record_length(table_options),reclength);
689
709
if (info_length+(ulong) create_fields.elements*FCOMP+288+
690
710
n_length+int_length+com_length > 65535L || int_count > 255)
692
712
my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF(0));
696
memset(forminfo, 0, 288);
716
bzero((char*)forminfo,288);
697
717
length=(info_length+create_fields.elements*FCOMP+288+n_length+int_length+
699
719
int2store(forminfo,length);
700
forminfo[256] = (uint8_t) screens;
720
forminfo[256] = (uint8) screens;
701
721
int2store(forminfo+258,create_fields.elements);
702
722
int2store(forminfo+260,info_length);
703
723
int2store(forminfo+262,totlength);
764
784
while ((field=it++))
767
buff[0]= (unsigned char) field->row;
768
buff[1]= (unsigned char) field->col;
769
buff[2]= (unsigned char) field->sc_length;
787
buff[0]= (uchar) field->row;
788
buff[1]= (uchar) field->col;
789
buff[2]= (uchar) field->sc_length;
770
790
int2store(buff+3, field->length);
771
791
/* The +1 is here becasue the col offset in .frm file have offset 1 */
772
792
recpos= field->offset+1 + (uint) data_offset;
773
793
int3store(buff+5,recpos);
774
794
int2store(buff+8,field->pack_flag);
775
795
int2store(buff+10,field->unireg_check);
776
buff[12]= (unsigned char) field->interval_id;
777
buff[13]= (unsigned char) field->sql_type;
796
buff[12]= (uchar) field->interval_id;
797
buff[13]= (uchar) field->sql_type;
778
798
if (field->charset)
779
buff[14]= (unsigned char) field->charset->number;
799
buff[14]= (uchar) field->charset->number;
781
801
buff[14]= 0; // Numerical
782
802
int2store(buff+15, field->comment.length);
783
803
comment_length+= field->comment.length;
784
804
set_if_bigger(int_count,field->interval_id);
785
805
if (my_write(file, buff, FCOMP, MYF_RW))
789
809
/* Write fieldnames */
790
buff[0]=(unsigned char) NAMES_SEP_CHAR;
810
buff[0]=(uchar) NAMES_SEP_CHAR;
791
811
if (my_write(file, buff, 1, MYF_RW))
795
815
while ((field=it++))
797
char *pos= my_stpcpy((char*) buff,field->field_name);
817
char *pos= strmov((char*) buff,field->field_name);
798
818
*pos++=NAMES_SEP_CHAR;
799
819
if (i == create_fields.elements-1)
801
821
if (my_write(file, buff, (size_t) (pos-(char*) buff),MYF_RW))
868
888
while ((field=it++))
870
890
if (field->comment.length)
871
if (my_write(file, (unsigned char*) field->comment.str, field->comment.length,
891
if (my_write(file, (uchar*) field->comment.str, field->comment.length,
880
/* save an empty record on start of formfile */
900
/* save an empty record on start of formfile */
882
static bool make_empty_rec(THD *thd, File file,
883
enum legacy_db_type table_type __attribute__((unused)),
884
uint32_t table_options,
885
List<Create_field> &create_fields,
902
static bool make_empty_rec(THD *thd, File file,enum legacy_db_type table_type,
904
List<Create_field> &create_fields,
887
906
ulong data_offset,
888
907
handler *handler)
891
910
Field::utype type;
893
unsigned char *buff,*null_pos;
912
uchar *buff,*null_pos;
895
914
TABLE_SHARE share;
896
915
Create_field *field;
897
916
enum_check_fields old_count_cuted_fields= thd->count_cuted_fields;
917
DBUG_ENTER("make_empty_rec");
900
919
/* We need a table to generate columns for default values */
901
memset(&table, 0, sizeof(table));
902
memset(&share, 0, sizeof(share));
920
bzero((char*) &table, sizeof(table));
921
bzero((char*) &share, sizeof(share));
905
if (!(buff=(unsigned char*) my_malloc((size_t) reclength,MYF(MY_WME | MY_ZEROFILL))))
924
if (!(buff=(uchar*) my_malloc((size_t) reclength,MYF(MY_WME | MY_ZEROFILL))))
910
929
table.in_use= thd;