13
13
along with this program; if not, write to the Free Software
14
14
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */
18
Functions to create a unireg form-file from a FIELD and a fieldname-fieldinfo
20
In the following functions FIELD * is an ordinary field-structure with
21
the following exeptions:
22
sc_length,typepos,row,kol,dtype,regnr and field need not to be set.
23
str is a (long) to record position where 0 is the first position.
16
26
#include <drizzled/server_includes.h>
17
#include <drizzled/error.h>
18
#include <drizzled/virtual_column_info.h>
19
#include <drizzled/session.h>
20
#include <drizzled/unireg.h>
25
#include <drizzled/serialize/serialize.h>
26
#include <drizzled/serialize/table.pb.h>
27
#include <google/protobuf/io/zero_copy_stream.h>
28
#include <google/protobuf/io/zero_copy_stream_impl.h>
31
int drizzle_read_table_proto(const char* path, drizzle::Table* table)
33
int fd= open(path, O_RDONLY);
38
google::protobuf::io::ZeroCopyInputStream* input=
39
new google::protobuf::io::FileInputStream(fd);
41
if (!table->ParseFromZeroCopyStream(input))
27
#include <drizzled/drizzled_error_messages.h>
29
#define FCOMP 17 /* Bytes for a packed field */
31
static uchar * pack_screens(List<Create_field> &create_fields,
32
uint *info_length, uint *screens, bool small_file);
33
static uint pack_keys(uchar *keybuff,uint key_count, KEY *key_info,
35
static bool pack_header(uchar *forminfo,enum legacy_db_type table_type,
36
List<Create_field> &create_fields,
37
uint info_length, uint screens, uint table_options,
38
ulong data_offset, handler *file);
39
static uint get_interval_id(uint *int_count,List<Create_field> &create_fields,
40
Create_field *last_field);
41
static bool pack_fields(File file, List<Create_field> &create_fields,
43
static bool make_empty_rec(THD *thd, int file, enum legacy_db_type table_type,
45
List<Create_field> &create_fields,
46
uint reclength, ulong data_offset,
50
An interceptor to hijack ER_TOO_MANY_FIELDS error from
51
pack_screens and retry again without UNIREG screens.
53
XXX: what is a UNIREG screen?
56
struct Pack_header_error_handler: public Internal_error_handler
58
virtual bool handle_error(uint sql_errno,
60
DRIZZLE_ERROR::enum_warning_level level,
63
Pack_header_error_handler() :is_handled(false) {}
68
Pack_header_error_handler::
69
handle_error(uint sql_errno,
70
const char * /* message */,
71
DRIZZLE_ERROR::enum_warning_level /* level */,
74
is_handled= (sql_errno == ER_TOO_MANY_FIELDS);
53
static int fill_table_proto(drizzle::Table *table_proto,
54
const char *table_name,
55
List<Create_field> &create_fields,
56
HA_CREATE_INFO *create_info,
79
Create a frm (table definition) file
84
file_name Path for file (including database and .frm)
87
create_info create info parameters
88
create_fields Fields to create
89
keys number of keys to create
90
key_info Keys to create
91
db_file Handler to use. May be zero, in which case we use
98
bool mysql_create_frm(THD *thd, const char *file_name,
99
const char *db, const char *table,
100
HA_CREATE_INFO *create_info,
101
List<Create_field> &create_fields,
102
uint keys, KEY *key_info,
60
Create_field *field_arg;
61
List_iterator<Create_field> it(create_fields);
62
drizzle::Table::StorageEngine *engine= table_proto->mutable_engine();
63
drizzle::Table::TableOptions *table_options= table_proto->mutable_options();
65
if (create_fields.elements > MAX_FIELDS)
67
my_error(ER_TOO_MANY_FIELDS, MYF(0), ER(ER_TOO_MANY_FIELDS));
71
engine->set_name(create_info->db_type->getName());
73
table_proto->set_name(table_name);
74
table_proto->set_type(drizzle::Table::STANDARD);
76
while ((field_arg= it++))
78
drizzle::Table::Field *attribute;
80
attribute= table_proto->add_field();
81
attribute->set_name(field_arg->field_name);
83
attribute->set_pack_flag(field_arg->pack_flag); /* TODO: MUST DIE */
85
if(f_maybe_null(field_arg->pack_flag))
87
drizzle::Table::Field::FieldConstraints *constraints;
89
constraints= attribute->mutable_constraints();
90
constraints->set_is_nullable(true);
93
switch (field_arg->sql_type) {
94
case DRIZZLE_TYPE_TINY:
95
attribute->set_type(drizzle::Table::Field::TINYINT);
97
case DRIZZLE_TYPE_LONG:
98
attribute->set_type(drizzle::Table::Field::INTEGER);
100
case DRIZZLE_TYPE_DOUBLE:
101
attribute->set_type(drizzle::Table::Field::DOUBLE);
103
case DRIZZLE_TYPE_NULL :
104
assert(1); /* Not a user definable type */
105
case DRIZZLE_TYPE_TIMESTAMP:
106
attribute->set_type(drizzle::Table::Field::TIMESTAMP);
108
case DRIZZLE_TYPE_LONGLONG:
109
attribute->set_type(drizzle::Table::Field::BIGINT);
111
case DRIZZLE_TYPE_DATETIME:
112
attribute->set_type(drizzle::Table::Field::DATETIME);
114
case DRIZZLE_TYPE_DATE:
115
attribute->set_type(drizzle::Table::Field::DATE);
117
case DRIZZLE_TYPE_VARCHAR:
119
drizzle::Table::Field::StringFieldOptions *string_field_options;
121
string_field_options= attribute->mutable_string_options();
122
attribute->set_type(drizzle::Table::Field::VARCHAR);
123
string_field_options->set_length(field_arg->length
124
/ field_arg->charset->mbmaxlen);
125
string_field_options->set_collation_id(field_arg->charset->number);
126
string_field_options->set_collation(field_arg->charset->name);
130
case DRIZZLE_TYPE_NEWDECIMAL:
132
drizzle::Table::Field::NumericFieldOptions *numeric_field_options;
134
attribute->set_type(drizzle::Table::Field::DECIMAL);
135
numeric_field_options= attribute->mutable_numeric_options();
136
/* This is magic, I hate magic numbers -Brian */
137
numeric_field_options->set_precision(field_arg->length + ( field_arg->decimals ? -2 : -1));
138
numeric_field_options->set_scale(field_arg->decimals);
141
case DRIZZLE_TYPE_ENUM:
143
drizzle::Table::Field::SetFieldOptions *set_field_options;
145
assert(field_arg->interval);
147
attribute->set_type(drizzle::Table::Field::ENUM);
148
set_field_options= attribute->mutable_set_options();
150
for (uint32_t pos= 0; pos < field_arg->interval->count; pos++)
152
const char *src= field_arg->interval->type_names[pos];
154
set_field_options->add_field_value(src);
156
set_field_options->set_count_elements(set_field_options->field_value_size());
157
set_field_options->set_collation_id(field_arg->charset->number);
158
set_field_options->set_collation(field_arg->charset->name);
161
case DRIZZLE_TYPE_BLOB:
163
attribute->set_type(drizzle::Table::Field::BLOB);
165
drizzle::Table::Field::StringFieldOptions *string_field_options;
167
string_field_options= attribute->mutable_string_options();
168
string_field_options->set_collation_id(field_arg->charset->number);
169
string_field_options->set_collation(field_arg->charset->name);
174
assert(0); /* Tell us, since this shouldn't happend */
177
if(field_arg->vcol_info)
180
tmp_len= system_charset_info->cset->charpos(system_charset_info,
181
field_arg->vcol_info->expr_str.str,
182
field_arg->vcol_info->expr_str.str +
183
field_arg->vcol_info->expr_str.length,
184
VIRTUAL_COLUMN_EXPRESSION_MAXLEN);
186
if (tmp_len < field_arg->vcol_info->expr_str.length)
188
my_error(ER_WRONG_STRING_LENGTH, MYF(0),
189
field_arg->vcol_info->expr_str.str,"VIRTUAL COLUMN EXPRESSION",
190
(uint32_t) VIRTUAL_COLUMN_EXPRESSION_MAXLEN);
194
drizzle::Table::Field::VirtualFieldOptions *field_options;
196
field_options= attribute->mutable_virtual_options();
198
field_options->set_type(attribute->type());
199
attribute->set_type(drizzle::Table::Field::VIRTUAL);
201
string expr(field_arg->vcol_info->expr_str.str,
202
field_arg->vcol_info->expr_str.length);
204
field_options->set_expression(expr);
205
field_options->set_physically_stored(field_arg->is_stored);
209
field_constraints= attribute->mutable_constraints();
210
constraints->set_is_nullable(field_arg->def->null_value);
105
LEX_STRING str_db_type;
106
uint reclength, info_length, screens, key_info_length, maxlength, tmp_len;
107
ulong key_buff_length;
109
ulong filepos, data_offset;
110
uchar fileinfo[64],forminfo[288],*keybuff;
114
const uint format_section_header_size= 8;
115
uint format_section_len;
116
Pack_header_error_handler pack_header_error_handler;
119
assert(*fn_rext((char*)file_name)); // Check .frm extension
120
formnames.type_names=0;
121
if (!(screen_buff=pack_screens(create_fields,&info_length,&screens,0)))
123
assert(db_file != NULL);
125
/* If fixed row records, we need one bit to check for deleted rows */
126
if (!(create_info->table_options & HA_OPTION_PACK_RECORD))
127
create_info->null_bits++;
128
data_offset= (create_info->null_bits + 7) / 8;
130
thd->push_internal_handler(&pack_header_error_handler);
132
error= pack_header(forminfo, ha_legacy_type(create_info->db_type),
133
create_fields,info_length,
134
screens, create_info->table_options,
135
data_offset, db_file);
137
thd->pop_internal_handler();
141
my_free(screen_buff, MYF(0));
142
if (! pack_header_error_handler.is_handled)
145
// Try again without UNIREG screens (to get more columns)
146
if (!(screen_buff=pack_screens(create_fields,&info_length,&screens,1)))
148
if (pack_header(forminfo, ha_legacy_type(create_info->db_type),
149
create_fields,info_length,
150
screens, create_info->table_options, data_offset, db_file))
152
my_free(screen_buff, MYF(0));
156
reclength=uint2korr(forminfo+266);
158
/* Calculate extra data segment length */
159
str_db_type.str= (char *) ha_resolve_storage_engine_name(create_info->db_type);
160
str_db_type.length= strlen(str_db_type.str);
162
create_info->extra_size= (2 + str_db_type.length +
163
2 + create_info->connect_string.length);
166
Length of partition info = 4 byte
167
Potential NULL byte at end of partition info string = 1 byte
168
Indicator if auto-partitioned table = 1 byte
171
create_info->extra_size+= 6;
173
/* Add space for storage type and field format array of fields */
175
format_section_header_size + 1 + create_fields.elements;
176
create_info->extra_size+= format_section_len;
178
tmp_len= system_charset_info->cset->charpos(system_charset_info,
179
create_info->comment.str,
180
create_info->comment.str +
181
create_info->comment.length,
182
TABLE_COMMENT_MAXLEN);
184
if (tmp_len < create_info->comment.length)
186
my_error(ER_WRONG_STRING_LENGTH, MYF(0),
187
create_info->comment.str,"Table COMMENT",
188
(uint) TABLE_COMMENT_MAXLEN);
189
my_free(screen_buff,MYF(0));
193
//if table comment is larger than 180 bytes, store into extra segment.
194
if (create_info->comment.length > 180)
197
create_info->extra_size+= 2 + create_info->comment.length;
200
strmake((char*) forminfo+47, create_info->comment.str ?
201
create_info->comment.str : "", create_info->comment.length);
202
forminfo[46]=(uchar) create_info->comment.length;
205
EXTRA_DEBUG causes strmake() to initialize its buffer behind the
206
payload with a magic value to detect wrong buffer-sizes. We
207
explicitly zero that segment again.
209
memset(forminfo+47 + forminfo[46], 0, 61 - forminfo[46]);
213
switch(field_arg->column_format())
215
case COLUMN_FORMAT_TYPE_NOT_USED:
217
case COLUMN_FORMAT_TYPE_DEFAULT:
218
attribute->set_format(drizzle::Table::Field::DefaultFormat);
220
case COLUMN_FORMAT_TYPE_FIXED:
221
attribute->set_format(drizzle::Table::Field::FixedFormat);
223
case COLUMN_FORMAT_TYPE_DYNAMIC:
224
attribute->set_format(drizzle::Table::Field::DynamicFormat);
227
assert(0); /* Tell us, since this shouldn't happend */
230
if (field_arg->comment.length)
233
tmp_len= system_charset_info->cset->charpos(system_charset_info,
234
field_arg->comment.str,
235
field_arg->comment.str +
236
field_arg->comment.length,
237
COLUMN_COMMENT_MAXLEN);
239
if (tmp_len < field_arg->comment.length)
241
my_error(ER_WRONG_STRING_LENGTH, MYF(0),
242
field_arg->comment.str,"COLUMN COMMENT",
243
(uint32_t) COLUMN_COMMENT_MAXLEN);
247
attribute->set_comment(field_arg->comment.str);
250
if(field_arg->unireg_check == Field::NEXT_NUMBER)
252
drizzle::Table::Field::NumericFieldOptions *field_options;
253
field_options= attribute->mutable_numeric_options();
254
field_options->set_is_autoincrement(true);
257
if(field_arg->unireg_check == Field::TIMESTAMP_DN_FIELD
258
|| field_arg->unireg_check == Field::TIMESTAMP_DNUN_FIELD)
260
drizzle::Table::Field::FieldOptions *field_options;
261
field_options= attribute->mutable_options();
262
field_options->set_default_value("NOW()");
265
if(field_arg->unireg_check == Field::TIMESTAMP_UN_FIELD
266
|| field_arg->unireg_check == Field::TIMESTAMP_DNUN_FIELD)
268
drizzle::Table::Field::FieldOptions *field_options;
269
field_options= attribute->mutable_options();
270
field_options->set_update_value("NOW()");
275
drizzle::Table::Field::FieldOptions *field_options;
276
field_options= attribute->mutable_options();
278
if(field_arg->def->is_null())
280
field_options->set_default_null(true);
285
String *default_value= field_arg->def->val_str(&d);
287
assert(default_value);
289
if((field_arg->sql_type==DRIZZLE_TYPE_VARCHAR
290
|| field_arg->sql_type==DRIZZLE_TYPE_BLOB)
291
&& ((field_arg->length / field_arg->charset->mbmaxlen)
292
< default_value->length()))
294
my_error(ER_INVALID_DEFAULT, MYF(0), field_arg->field_name);
298
if((field_arg->sql_type==DRIZZLE_TYPE_VARCHAR
299
&& field_arg->charset==&my_charset_bin)
300
|| (field_arg->sql_type==DRIZZLE_TYPE_BLOB
301
&& field_arg->charset==&my_charset_bin))
304
bin_default.assign(default_value->c_ptr(),
305
default_value->length());
306
field_options->set_default_bin_value(bin_default);
310
field_options->set_default_value(default_value->c_ptr());
316
drizzle::Table::Field::FieldOptions *field_options;
317
field_options= attribute->mutable_options();
319
field_options->set_length(field_arg->length);
322
assert(field_arg->unireg_check == Field::NONE
323
|| field_arg->unireg_check == Field::NEXT_NUMBER
324
|| field_arg->unireg_check == Field::TIMESTAMP_DN_FIELD
325
|| field_arg->unireg_check == Field::TIMESTAMP_UN_FIELD
326
|| field_arg->unireg_check == Field::TIMESTAMP_DNUN_FIELD);
330
if (create_info->used_fields & HA_CREATE_USED_PACK_KEYS)
332
if(create_info->table_options & HA_OPTION_PACK_KEYS)
333
table_options->set_pack_keys(true);
334
else if(create_info->table_options & HA_OPTION_NO_PACK_KEYS)
335
table_options->set_pack_keys(false);
338
if(create_info->table_options & HA_OPTION_PACK_KEYS)
339
table_options->set_pack_keys(true);
342
if (create_info->used_fields & HA_CREATE_USED_CHECKSUM)
344
assert(create_info->table_options & (HA_OPTION_CHECKSUM | HA_OPTION_NO_CHECKSUM));
346
if(create_info->table_options & HA_OPTION_CHECKSUM)
347
table_options->set_checksum(true);
349
table_options->set_checksum(false);
351
else if(create_info->table_options & HA_OPTION_CHECKSUM)
352
table_options->set_checksum(true);
355
if (create_info->used_fields & HA_CREATE_USED_PAGE_CHECKSUM)
357
if (create_info->page_checksum == HA_CHOICE_YES)
358
table_options->set_page_checksum(true);
359
else if (create_info->page_checksum == HA_CHOICE_NO)
360
table_options->set_page_checksum(false);
362
else if (create_info->page_checksum == HA_CHOICE_YES)
363
table_options->set_page_checksum(true);
366
if (create_info->used_fields & HA_CREATE_USED_DELAY_KEY_WRITE)
368
if(create_info->table_options & HA_OPTION_DELAY_KEY_WRITE)
369
table_options->set_delay_key_write(true);
370
else if(create_info->table_options & HA_OPTION_NO_DELAY_KEY_WRITE)
371
table_options->set_delay_key_write(false);
373
else if(create_info->table_options & HA_OPTION_DELAY_KEY_WRITE)
374
table_options->set_delay_key_write(true);
377
switch(create_info->row_type)
379
case ROW_TYPE_DEFAULT:
380
table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_DEFAULT);
383
table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_FIXED);
385
case ROW_TYPE_DYNAMIC:
386
table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_DYNAMIC);
388
case ROW_TYPE_COMPRESSED:
389
table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_COMPRESSED);
391
case ROW_TYPE_REDUNDANT:
392
table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_REDUNDANT);
394
case ROW_TYPE_COMPACT:
395
table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_COMPACT);
398
table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_PAGE);
404
table_options->set_pack_record(create_info->table_options
405
& HA_OPTION_PACK_RECORD);
407
if (create_info->comment.length)
410
tmp_len= system_charset_info->cset->charpos(system_charset_info,
411
create_info->comment.str,
412
create_info->comment.str +
413
create_info->comment.length,
414
TABLE_COMMENT_MAXLEN);
416
if (tmp_len < create_info->comment.length)
418
my_error(ER_WRONG_STRING_LENGTH, MYF(0),
419
create_info->comment.str,"Table COMMENT",
420
(uint32_t) TABLE_COMMENT_MAXLEN);
424
table_options->set_comment(create_info->comment.str);
426
if (create_info->default_table_charset)
428
table_options->set_collation_id(
429
create_info->default_table_charset->number);
430
table_options->set_collation(create_info->default_table_charset->name);
433
if (create_info->connect_string.length)
434
table_options->set_connect_string(create_info->connect_string.str);
436
if (create_info->data_file_name)
437
table_options->set_data_file_name(create_info->data_file_name);
439
if (create_info->index_file_name)
440
table_options->set_index_file_name(create_info->index_file_name);
442
if (create_info->max_rows)
443
table_options->set_max_rows(create_info->max_rows);
445
if (create_info->min_rows)
446
table_options->set_min_rows(create_info->min_rows);
448
if (create_info->auto_increment_value)
449
table_options->set_auto_increment_value(create_info->auto_increment_value);
451
if (create_info->avg_row_length)
452
table_options->set_avg_row_length(create_info->avg_row_length);
454
if (create_info->key_block_size)
455
table_options->set_key_block_size(create_info->key_block_size);
457
if (create_info->block_size)
458
table_options->set_block_size(create_info->block_size);
460
for (unsigned int i= 0; i < keys; i++)
462
drizzle::Table::Index *idx;
464
idx= table_proto->add_indexes();
466
assert(test(key_info[i].flags & HA_USES_COMMENT) ==
467
(key_info[i].comment.length > 0));
469
idx->set_name(key_info[i].name);
471
idx->set_key_length(key_info[i].key_length);
473
if(is_primary_key_name(key_info[i].name))
474
idx->set_is_primary(true);
476
idx->set_is_primary(false);
478
switch(key_info[i].algorithm)
480
case HA_KEY_ALG_HASH:
481
idx->set_type(drizzle::Table::Index::HASH);
484
case HA_KEY_ALG_BTREE:
485
idx->set_type(drizzle::Table::Index::BTREE);
488
case HA_KEY_ALG_RTREE:
489
idx->set_type(drizzle::Table::Index::RTREE);
490
case HA_KEY_ALG_FULLTEXT:
491
idx->set_type(drizzle::Table::Index::FULLTEXT);
492
case HA_KEY_ALG_UNDEF:
493
idx->set_type(drizzle::Table::Index::UNKNOWN_INDEX);
497
abort(); /* Somebody's brain broke. haven't added index type to proto */
500
if (key_info[i].flags & HA_NOSAME)
501
idx->set_is_unique(true);
503
idx->set_is_unique(false);
505
drizzle::Table::Index::IndexOptions *index_options= idx->mutable_options();
507
if(key_info[i].flags & HA_USES_BLOCK_SIZE)
508
index_options->set_key_block_size(key_info[i].block_size);
510
if(key_info[i].flags & HA_PACK_KEY)
511
index_options->set_pack_key(true);
513
if(key_info[i].flags & HA_BINARY_PACK_KEY)
514
index_options->set_binary_pack_key(true);
516
if(key_info[i].flags & HA_VAR_LENGTH_PART)
517
index_options->set_var_length_key(true);
519
if(key_info[i].flags & HA_NULL_PART_KEY)
520
index_options->set_null_part_key(true);
522
if(key_info[i].flags & HA_KEY_HAS_PART_KEY_SEG)
523
index_options->set_has_partial_segments(true);
525
if(key_info[i].flags & HA_GENERATED_KEY)
526
index_options->set_auto_generated_key(true);
528
if (key_info[i].flags & HA_USES_COMMENT)
531
tmp_len= system_charset_info->cset->charpos(system_charset_info,
532
key_info[i].comment.str,
533
key_info[i].comment.str +
534
key_info[i].comment.length,
535
TABLE_COMMENT_MAXLEN);
537
if (tmp_len < key_info[i].comment.length)
539
my_error(ER_WRONG_STRING_LENGTH, MYF(0),
540
key_info[i].comment.str,"Index COMMENT",
541
(uint32_t) TABLE_COMMENT_MAXLEN);
545
idx->set_comment(key_info[i].comment.str);
547
if(key_info[i].flags & ~(HA_NOSAME | HA_PACK_KEY | HA_USES_BLOCK_SIZE | HA_BINARY_PACK_KEY | HA_VAR_LENGTH_PART | HA_NULL_PART_KEY | HA_KEY_HAS_PART_KEY_SEG | HA_GENERATED_KEY | HA_USES_COMMENT))
548
abort(); // Invalid (unknown) index flag.
550
for(unsigned int j=0; j< key_info[i].key_parts; j++)
552
drizzle::Table::Index::IndexPart *idxpart;
554
idxpart= idx->add_index_part();
556
idxpart->set_fieldnr(key_info[i].key_part[j].fieldnr);
558
idxpart->set_compare_length(key_info[i].key_part[j].length);
560
idxpart->set_key_type(key_info[i].key_part[j].key_type);
568
int copy_table_proto_file(const char *from, const char* to)
572
string file_ext = ".dfe";
574
dfesrc.append(file_ext);
575
dfedst.append(file_ext);
577
return my_copy(dfesrc.c_str(), dfedst.c_str(),
578
MYF(MY_DONT_OVERWRITE_FILE));
581
int rename_table_proto_file(const char *from, const char* to)
583
string from_path(from);
585
string file_ext = ".dfe";
587
from_path.append(file_ext);
588
to_path.append(file_ext);
590
return my_rename(from_path.c_str(),to_path.c_str(),MYF(MY_WME));
593
int delete_table_proto_file(const char *file_name)
595
string new_path(file_name);
596
string file_ext = ".dfe";
598
new_path.append(file_ext);
599
return my_delete(new_path.c_str(), MYF(0));
602
int table_proto_exists(const char *path)
604
string proto_path(path);
605
string file_ext(".dfe");
606
proto_path.append(file_ext);
608
int error= access(proto_path.c_str(), F_OK);
616
static int create_table_proto_file(const char *file_name,
618
const char *table_name,
619
HA_CREATE_INFO *create_info,
620
List<Create_field> &create_fields,
624
drizzle::Table table_proto;
625
string new_path(file_name);
626
string file_ext = ".dfe";
628
if(fill_table_proto(&table_proto, table_name, create_fields, create_info,
632
new_path.append(file_ext);
634
int fd= open(new_path.c_str(), O_RDWR|O_CREAT|O_TRUNC, my_umask);
639
my_error(ER_BAD_DB_ERROR,MYF(0),db);
641
my_error(ER_CANT_CREATE_TABLE,MYF(0),table_name,errno);
645
google::protobuf::io::ZeroCopyOutputStream* output=
646
new google::protobuf::io::FileOutputStream(fd);
648
if (!table_proto.SerializeToZeroCopyStream(output))
213
if ((file=create_frm(thd, file_name, db, table, reclength, fileinfo,
214
create_info, keys, key_info)) < 0)
216
my_free(screen_buff, MYF(0));
220
key_buff_length= uint4korr(fileinfo+47);
221
keybuff=(uchar*) my_malloc(key_buff_length, MYF(0));
222
key_info_length= pack_keys(keybuff, keys, key_info, data_offset);
223
VOID(get_form_pos(file,fileinfo,&formnames));
224
if (!(filepos=make_new_entry(file,fileinfo,&formnames,"")))
226
maxlength=(uint) next_io_size((ulong) (uint2korr(forminfo)+1000));
227
int2store(forminfo+2,maxlength);
228
int4store(fileinfo+10,(ulong) (filepos+maxlength));
229
fileinfo[26]= (uchar) test((create_info->max_rows == 1) &&
230
(create_info->min_rows == 1) && (keys == 0));
231
int2store(fileinfo+28,key_info_length);
234
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)
240
(ulong) uint2korr(fileinfo+6)+ (ulong) key_buff_length,
241
MY_SEEK_SET,MYF(0)));
242
if (make_empty_rec(thd,file,ha_legacy_type(create_info->db_type),
243
create_info->table_options,
244
create_fields,reclength, data_offset, db_file))
247
int2store(buff, create_info->connect_string.length);
248
if (my_write(file, (const uchar*)buff, 2, MYF(MY_NABP)) ||
249
my_write(file, (const uchar*)create_info->connect_string.str,
250
create_info->connect_string.length, MYF(MY_NABP)))
253
int2store(buff, str_db_type.length);
254
if (my_write(file, (const uchar*)buff, 2, MYF(MY_NABP)) ||
255
my_write(file, (const uchar*)str_db_type.str,
256
str_db_type.length, MYF(MY_NABP)))
261
if (my_write(file, (uchar*) buff, 6, MYF_RW))
265
if (forminfo[46] == (uchar)255)
267
uchar comment_length_buff[2];
268
int2store(comment_length_buff,create_info->comment.length);
269
if (my_write(file, comment_length_buff, 2, MYF(MY_NABP)) ||
270
my_write(file, (uchar*)create_info->comment.str,
271
create_info->comment.length, MYF(MY_NABP)))
275
/* Store storage type and field format array of fields */
281
memset(buff, 0, format_section_header_size);
282
/* length of section 2 bytes*/
283
int2store(buff+0, format_section_len);
284
/* flags of section 4 bytes*/
285
int4store(buff+2, flags);
286
/* 2 bytes left for future use */
289
if (my_write(file, (const uchar*)buff, format_section_header_size, MYF_RW))
292
if (my_write(file, (const uchar*)buff, 1, MYF_RW))
294
/* write column info, 1 byte per column */
296
List_iterator<Create_field> it(create_fields);
298
uchar column_format, write_byte;
301
column_format= (uchar)field->column_format();
302
write_byte= (column_format << COLUMN_FORMAT_SHIFT);
303
if (my_write(file, &write_byte, 1, MYF_RW))
308
VOID(my_seek(file,filepos,MY_SEEK_SET,MYF(0)));
309
if (my_write(file, forminfo, 288, MYF_RW) ||
310
my_write(file, screen_buff, info_length, MYF_RW) ||
311
pack_fields(file, create_fields, data_offset))
314
my_free(screen_buff,MYF(0));
315
my_free(keybuff, MYF(0));
317
if (!(create_info->options & HA_LEX_CREATE_TMP_TABLE) &&
318
(my_sync(file, MYF(MY_WME)) ||
319
my_sync_dir_by_file(file_name, MYF(MY_WME))))
322
if (my_close(file,MYF(MY_WME)))
327
Restore all UCS2 intervals.
328
HEX representation of them is not needed anymore.
330
List_iterator<Create_field> it(create_fields);
334
if (field->save_interval)
336
field->interval= field->save_interval;
337
field->save_interval= 0;
344
my_free(screen_buff, MYF(0));
345
my_free(keybuff, MYF(0));
347
VOID(my_close(file,MYF(MY_WME)));
349
my_delete(file_name,MYF(0));
351
} /* mysql_create_frm */
661
Create a table definition proto file and the tables
355
Create a frm (table definition) file and the tables
664
358
rea_create_table()
665
session Thread handler
666
360
path Name of file (including database, without .frm)
667
361
db Data base name
668
362
table_name Table name
671
365
keys number of keys to create
672
366
key_info Keys to create
673
367
file Handler to use
674
is_like is true for mysql_create_like_schema_frm
681
int rea_create_table(Session *session, const char *path,
374
int rea_create_table(THD *thd, const char *path,
682
375
const char *db, const char *table_name,
683
376
HA_CREATE_INFO *create_info,
684
377
List<Create_field> &create_fields,
685
uint32_t keys, KEY *key_info, handler *file,
378
uint keys, KEY *key_info, handler *file)
688
/* Proto will blow up unless we give a name */
691
/* For is_like we return once the file has been created */
694
if (create_table_proto_file(path, db, table_name, create_info,
695
create_fields, keys, key_info)!=0)
700
/* Here we need to build the full frm from the path */
703
if (create_table_proto_file(path, db, table_name, create_info,
704
create_fields, keys, key_info))
382
char frm_name[FN_REFLEN];
383
strxmov(frm_name, path, reg_ext, NullS);
384
if (mysql_create_frm(thd, frm_name, db, table_name, create_info,
385
create_fields, keys, key_info, file))
708
389
// Make sure mysql_create_frm din't remove extension
709
if (session->variables.keep_files_on_create)
390
assert(*fn_rext(frm_name));
391
if (thd->variables.keep_files_on_create)
710
392
create_info->options|= HA_CREATE_KEEP_FILES;
711
393
if (file->ha_create_handler_files(path, NULL, CHF_CREATE_FLAG, create_info))
712
394
goto err_handler;
713
if (ha_create_table(session, path, db, table_name,
395
if (!create_info->frm_only && ha_create_table(thd, path, db, table_name,
715
397
goto err_handler;
719
file->ha_create_handler_files(path, NULL, CHF_DELETE_FLAG, create_info);
721
delete_table_proto_file(path);
401
VOID(file->ha_create_handler_files(path, NULL, CHF_DELETE_FLAG, create_info));
402
my_delete(frm_name, MYF(0));
724
404
} /* rea_create_table */
407
/* Pack screens to a screen for save in a form-file */
409
static uchar *pack_screens(List<Create_field> &create_fields,
410
uint *info_length, uint *screens,
414
uint row,start_row,end_row,fields_on_screen;
416
uchar *info,*pos,*start_screen;
417
uint fields=create_fields.elements;
418
List_iterator<Create_field> it(create_fields);
421
start_row=4; end_row=22; cols=80; fields_on_screen=end_row+1-start_row;
423
*screens=(fields-1)/fields_on_screen+1;
424
length= (*screens) * (SC_INFO_LENGTH+ (cols>> 1)+4);
428
length+=(uint) strlen(field->field_name)+1+TE_INFO_LENGTH+cols/2;
430
if (!(info=(uchar*) my_malloc(length,MYF(MY_WME))))
437
for (i=0 ; i < fields ; i++)
439
Create_field *cfield=it++;
440
if (row++ == end_row)
444
length=(uint) (pos-start_screen);
445
int2store(start_screen,length);
446
start_screen[2]=(uchar) (fields_on_screen+1);
447
start_screen[3]=(uchar) (fields_on_screen);
452
pos[0]= (uchar) start_row-2; /* Header string */
453
pos[1]= (uchar) (cols >> 2);
454
pos[2]= (uchar) (cols >> 1) +1;
455
strfill((char *) pos+3,(uint) (cols >> 1),' ');
458
length=(uint) strlen(cfield->field_name);
466
pos[2]=(uchar) (length+1);
467
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) min(cfield->length,(uint32_t)cols-(length+2));
473
length=(uint) (pos-start_screen);
474
int2store(start_screen,length);
475
start_screen[2]=(uchar) (row-start_row+2);
476
start_screen[3]=(uchar) (row-start_row+1);
478
*info_length=(uint) (pos-info);
483
/* Pack keyinfo and keynames to keybuff for save in form-file. */
485
static uint pack_keys(uchar *keybuff, uint key_count, KEY *keyinfo,
488
uint key_parts,length;
489
uchar *pos, *keyname_pos;
491
KEY_PART_INFO *key_part,*key_part_end;
496
for (key=keyinfo,end=keyinfo+key_count ; key != end ; key++)
498
int2store(pos, (key->flags ^ HA_NOSAME));
499
int2store(pos+2,key->key_length);
500
pos[4]= (uchar) key->key_parts;
501
pos[5]= (uchar) key->algorithm;
502
int2store(pos+6, key->block_size);
504
key_parts+=key->key_parts;
505
for (key_part=key->key_part,key_part_end=key_part+key->key_parts ;
506
key_part != key_part_end ;
511
int2store(pos,key_part->fieldnr+1+FIELD_NAME_USED);
512
offset= (uint) (key_part->offset+data_offset+1);
513
int2store(pos+2, offset);
514
pos[4]=0; // Sort order
515
int2store(pos+5,key_part->key_type);
516
int2store(pos+7,key_part->length);
522
*pos++=(uchar) NAMES_SEP_CHAR;
523
for (key=keyinfo ; key != end ; key++)
525
uchar *tmp=(uchar*) stpcpy((char*) pos,key->name);
526
*tmp++= (uchar) NAMES_SEP_CHAR;
532
for (key=keyinfo,end=keyinfo+key_count ; key != end ; key++)
534
if (key->flags & HA_USES_COMMENT)
536
int2store(pos, key->comment.length);
537
uchar *tmp= (uchar*)stpncpy((char*) pos+2,key->comment.str,key->comment.length);
542
if (key_count > 127 || key_parts > 127)
544
keybuff[0]= (key_count & 0x7f) | 0x80;
545
keybuff[1]= key_count >> 7;
546
int2store(keybuff+2,key_parts);
550
keybuff[0]=(uchar) key_count;
551
keybuff[1]=(uchar) key_parts;
552
keybuff[2]= keybuff[3]= 0;
554
length=(uint) (pos-keyname_pos);
555
int2store(keybuff+4,length);
556
return((uint) (pos-keybuff));
560
/* Make formheader */
562
static bool pack_header(uchar *forminfo,
563
enum legacy_db_type table_type __attribute__((unused)),
564
List<Create_field> &create_fields,
565
uint info_length, uint screens, uint table_options,
566
ulong data_offset, handler *file)
568
uint length,int_count,int_length,no_empty, int_parts;
569
uint time_stamp_pos,null_fields;
570
ulong reclength, totlength, n_length, com_length;
573
if (create_fields.elements > MAX_FIELDS)
575
my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF(0));
580
reclength= data_offset;
581
no_empty=int_count=int_parts=int_length=time_stamp_pos=null_fields=
587
List_iterator<Create_field> it(create_fields);
591
uint tmp_len= system_charset_info->cset->charpos(system_charset_info,
594
field->comment.length,
595
COLUMN_COMMENT_MAXLEN);
597
if (tmp_len < field->comment.length)
599
my_error(ER_WRONG_STRING_LENGTH, MYF(0),
600
field->comment.str,"COLUMN COMMENT",
601
(uint) COLUMN_COMMENT_MAXLEN);
605
totlength+= field->length;
606
com_length+= field->comment.length;
607
if (MTYP_TYPENR(field->unireg_check) == Field::NOEMPTY ||
608
field->unireg_check & MTYP_NOEMPTY_BIT)
610
field->unireg_check= (Field::utype) ((uint) field->unireg_check |
615
We mark first TIMESTAMP field with NOW() in DEFAULT or ON UPDATE
616
as auto-update field.
618
if (field->sql_type == DRIZZLE_TYPE_TIMESTAMP &&
619
MTYP_TYPENR(field->unireg_check) != Field::NONE &&
621
time_stamp_pos= (uint) field->offset+ (uint) data_offset + 1;
622
length=field->pack_length;
623
/* Ensure we don't have any bugs when generating offsets */
624
assert(reclength == field->offset + data_offset);
625
if ((uint) field->offset+ (uint) data_offset+ length > reclength)
626
reclength=(uint) (field->offset+ data_offset + length);
627
n_length+= (ulong) strlen(field->field_name)+1;
628
field->interval_id=0;
629
field->save_interval= 0;
632
uint old_int_count=int_count;
634
if (field->charset->mbminlen > 1)
637
Escape UCS2 intervals using HEX notation to avoid
638
problems with delimiters between enum elements.
639
As the original representation is still needed in
640
the function make_empty_rec to create a record of
641
filled with default values it is saved in save_interval
642
The HEX representation is created from this copy.
644
field->save_interval= field->interval;
645
field->interval= (TYPELIB*) sql_alloc(sizeof(TYPELIB));
646
*field->interval= *field->save_interval;
647
field->interval->type_names=
648
(const char **) sql_alloc(sizeof(char*) *
649
(field->interval->count+1));
650
field->interval->type_names[field->interval->count]= 0;
651
field->interval->type_lengths=
652
(uint *) sql_alloc(sizeof(uint) * field->interval->count);
654
for (uint pos= 0; pos < field->interval->count; pos++)
657
const char *src= field->save_interval->type_names[pos];
659
length= field->save_interval->type_lengths[pos];
660
hex_length= length * 2;
661
field->interval->type_lengths[pos]= hex_length;
662
field->interval->type_names[pos]= dst= (char*) sql_alloc(hex_length +
664
octet2hex(dst, src, length);
668
field->interval_id=get_interval_id(&int_count,create_fields,field);
669
if (old_int_count != int_count)
671
for (const char **pos=field->interval->type_names ; *pos ; pos++)
672
int_length+=(uint) strlen(*pos)+1; // field + suffix prefix
673
int_parts+=field->interval->count+1;
676
if (f_maybe_null(field->pack_flag))
679
int_length+=int_count*2; // 255 prefix + 0 suffix
681
/* Save values in forminfo */
683
if (reclength > (ulong) file->max_record_length())
685
my_error(ER_TOO_BIG_ROWSIZE, MYF(0), (uint) file->max_record_length());
688
/* Hack to avoid bugs with small static rows in MySQL */
689
reclength=max((ulong)file->min_record_length(table_options),reclength);
690
if (info_length+(ulong) create_fields.elements*FCOMP+288+
691
n_length+int_length+com_length > 65535L || int_count > 255)
693
my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF(0));
697
memset(forminfo, 0, 288);
698
length=(info_length+create_fields.elements*FCOMP+288+n_length+int_length+
700
int2store(forminfo,length);
701
forminfo[256] = (uint8_t) screens;
702
int2store(forminfo+258,create_fields.elements);
703
int2store(forminfo+260,info_length);
704
int2store(forminfo+262,totlength);
705
int2store(forminfo+264,no_empty);
706
int2store(forminfo+266,reclength);
707
int2store(forminfo+268,n_length);
708
int2store(forminfo+270,int_count);
709
int2store(forminfo+272,int_parts);
710
int2store(forminfo+274,int_length);
711
int2store(forminfo+276,time_stamp_pos);
712
int2store(forminfo+278,80); /* Columns needed */
713
int2store(forminfo+280,22); /* Rows needed */
714
int2store(forminfo+282,null_fields);
715
int2store(forminfo+284,com_length);
716
/* Up to forminfo+288 is free to use for additional information */
721
/* get each unique interval each own id */
723
static uint get_interval_id(uint *int_count,List<Create_field> &create_fields,
724
Create_field *last_field)
726
List_iterator<Create_field> it(create_fields);
728
TYPELIB *interval=last_field->interval;
730
while ((field=it++) != last_field)
732
if (field->interval_id && field->interval->count == interval->count)
735
for (a=field->interval->type_names, b=interval->type_names ;
736
*a && !strcmp(*a,*b);
741
return field->interval_id; // Re-use last interval
745
return ++*int_count; // New unique interval
749
/* Save fields, fieldnames and intervals */
751
static bool pack_fields(File file, List<Create_field> &create_fields,
755
uint int_count, comment_length=0;
756
uchar buff[MAX_FIELD_WIDTH];
760
/* Write field info */
762
List_iterator<Create_field> it(create_fields);
768
buff[0]= (uchar) field->row;
769
buff[1]= (uchar) field->col;
770
buff[2]= (uchar) field->sc_length;
771
int2store(buff+3, field->length);
772
/* The +1 is here becasue the col offset in .frm file have offset 1 */
773
recpos= field->offset+1 + (uint) data_offset;
774
int3store(buff+5,recpos);
775
int2store(buff+8,field->pack_flag);
776
int2store(buff+10,field->unireg_check);
777
buff[12]= (uchar) field->interval_id;
778
buff[13]= (uchar) field->sql_type;
780
buff[14]= (uchar) field->charset->number;
782
buff[14]= 0; // Numerical
783
int2store(buff+15, field->comment.length);
784
comment_length+= field->comment.length;
785
set_if_bigger(int_count,field->interval_id);
786
if (my_write(file, buff, FCOMP, MYF_RW))
790
/* Write fieldnames */
791
buff[0]=(uchar) NAMES_SEP_CHAR;
792
if (my_write(file, buff, 1, MYF_RW))
798
char *pos= stpcpy((char*) buff,field->field_name);
799
*pos++=NAMES_SEP_CHAR;
800
if (i == create_fields.elements-1)
802
if (my_write(file, buff, (size_t) (pos-(char*) buff),MYF_RW))
807
/* Write intervals */
810
String tmp((char*) buff,sizeof(buff), &my_charset_bin);
816
if (field->interval_id > int_count)
818
unsigned char sep= 0;
819
unsigned char occ[256];
821
unsigned char *val= NULL;
823
memset(occ, 0, sizeof(occ));
825
for (i=0; (val= (unsigned char*) field->interval->type_names[i]); i++)
826
for (uint j = 0; j < field->interval->type_lengths[i]; j++)
827
occ[(unsigned int) (val[j])]= 1;
829
if (!occ[(unsigned char)NAMES_SEP_CHAR])
830
sep= (unsigned char) NAMES_SEP_CHAR;
831
else if (!occ[(unsigned int)','])
835
for (uint i=1; i<256; i++)
844
if(!sep) /* disaster, enum uses all characters, none left as separator */
846
my_message(ER_WRONG_FIELD_TERMINATORS,ER(ER_WRONG_FIELD_TERMINATORS),
852
int_count= field->interval_id;
854
for (const char **pos=field->interval->type_names ; *pos ; pos++)
859
tmp.append('\0'); // End of intervall
862
if (my_write(file,(uchar*) tmp.ptr(),tmp.length(),MYF_RW))
871
if (field->comment.length)
872
if (my_write(file, (uchar*) field->comment.str, field->comment.length,
881
/* save an empty record on start of formfile */
883
static bool make_empty_rec(THD *thd, File file,
884
enum legacy_db_type table_type __attribute__((unused)),
886
List<Create_field> &create_fields,
894
uchar *buff,*null_pos;
898
enum_check_fields old_count_cuted_fields= thd->count_cuted_fields;
901
/* We need a table to generate columns for default values */
902
memset(&table, 0, sizeof(table));
903
memset(&share, 0, sizeof(share));
906
if (!(buff=(uchar*) my_malloc((size_t) reclength,MYF(MY_WME | MY_ZEROFILL))))
912
table.s->db_low_byte_first= handler->low_byte_first();
913
table.s->blob_ptr_size= portable_sizeof_char_ptr;
916
if (!(table_options & HA_OPTION_PACK_RECORD))
918
null_count++; // Need one bit for delete mark
923
List_iterator<Create_field> it(create_fields);
924
thd->count_cuted_fields= CHECK_FIELD_WARN; // To find wrong default values
928
regfield don't have to be deleted as it's allocated with sql_alloc()
930
Field *regfield= make_field(&share,
931
buff+field->offset + data_offset,
933
null_pos + null_count / 8,
939
field->save_interval ? field->save_interval :
945
goto err; // End of memory
948
/* save_in_field() will access regfield->table->in_use */
949
regfield->init(&table);
951
if (!(field->flags & NOT_NULL_FLAG))
953
*regfield->null_ptr|= regfield->null_bit;
957
type= (Field::utype) MTYP_TYPENR(field->unireg_check);
961
int res= field->def->save_in_field(regfield, 1);
962
/* If not ok or warning of level 'note' */
963
if (res != 0 && res != 3)
965
my_error(ER_INVALID_DEFAULT, MYF(0), regfield->field_name);
967
delete regfield; //To avoid memory leak
971
else if (regfield->real_type() == DRIZZLE_TYPE_ENUM &&
972
(field->flags & NOT_NULL_FLAG))
974
regfield->set_notnull();
975
regfield->store((int64_t) 1, true);
977
else if (type == Field::YES) // Old unireg type
978
regfield->store(ER(ER_YES),(uint) strlen(ER(ER_YES)),system_charset_info);
979
else if (type == Field::NO) // Old unireg type
980
regfield->store(ER(ER_NO), (uint) strlen(ER(ER_NO)),system_charset_info);
984
assert(data_offset == ((null_count + 7) / 8));
987
We need to set the unused bits to 1. If the number of bits is a multiple
988
of 8 there are no unused bits.
991
*(null_pos + null_count / 8)|= ~(((uchar) 1 << (null_count & 7)) - 1);
993
error= my_write(file, buff, (size_t) reclength,MYF_RW) != 0;
996
my_free(buff, MYF(MY_FAE));
997
thd->count_cuted_fields= old_count_cuted_fields;
999
} /* make_empty_rec */