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.
26
16
#include <drizzled/server_includes.h>
27
#include <drizzled/drizzled_error_messages.h>
29
#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,
35
static bool pack_header(unsigned char *forminfo,
36
List<Create_field> &create_fields,
37
uint32_t info_length, uint32_t screens, uint32_t table_options,
38
ulong data_offset, handler *file);
39
static uint32_t get_interval_id(uint32_t *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,
44
uint32_t table_options,
45
List<Create_field> &create_fields,
46
uint32_t 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(uint32_t 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(uint32_t sql_errno,
70
const char * /* message */,
71
DRIZZLE_ERROR::enum_warning_level /* level */,
74
is_handled= (sql_errno == ER_TOO_MANY_FIELDS);
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
uint32_t keys, KEY *key_info,
105
LEX_STRING str_db_type;
106
uint32_t reclength, info_length, screens, key_info_length, maxlength, tmp_len;
107
ulong key_buff_length;
109
ulong filepos, data_offset;
110
unsigned char fileinfo[64],forminfo[288],*keybuff;
112
unsigned char *screen_buff;
114
const uint32_t format_section_header_size= 8;
115
uint32_t 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)))
17
#include <drizzled/error.h>
18
#include <drizzled/session.h>
19
#include <drizzled/unireg.h>
24
#include <drizzled/message/schema.pb.h>
25
#include <drizzled/message/table.pb.h>
26
#include <google/protobuf/io/zero_copy_stream.h>
27
#include <google/protobuf/io/zero_copy_stream_impl.h>
29
#include <drizzled/table_proto.h>
32
int fill_table_proto(drizzled::message::Table *table_proto,
33
const char *table_name,
34
List<CreateField> &create_fields,
35
HA_CREATE_INFO *create_info,
39
CreateField *field_arg;
40
List_iterator<CreateField> it(create_fields);
41
drizzled::message::Table::TableOptions *table_options= table_proto->mutable_options();
43
if (create_fields.elements > MAX_FIELDS)
45
my_error(ER_TOO_MANY_FIELDS, MYF(0), ER(ER_TOO_MANY_FIELDS));
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,
133
create_fields,info_length,
134
screens, create_info->table_options,
135
data_offset, db_file);
137
thd->pop_internal_handler();
49
assert(strcmp(table_proto->engine().name().c_str(),
50
create_info->db_type->getName().c_str())==0);
52
assert(strcmp(table_proto->name().c_str(),table_name)==0);
54
while ((field_arg= it++))
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,
149
create_fields,info_length,
150
screens, create_info->table_options, data_offset, db_file))
56
drizzled::message::Table::Field *attribute;
58
attribute= table_proto->add_field();
59
attribute->set_name(field_arg->field_name);
61
attribute->set_pack_flag(field_arg->pack_flag); /* TODO: MUST DIE */
63
if(f_maybe_null(field_arg->pack_flag))
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);
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]=(unsigned char) 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]);
65
drizzled::message::Table::Field::FieldConstraints *constraints;
67
constraints= attribute->mutable_constraints();
68
constraints->set_is_nullable(true);
71
switch (field_arg->sql_type) {
72
case DRIZZLE_TYPE_TINY:
73
attribute->set_type(drizzled::message::Table::Field::TINYINT);
75
case DRIZZLE_TYPE_LONG:
76
attribute->set_type(drizzled::message::Table::Field::INTEGER);
78
case DRIZZLE_TYPE_DOUBLE:
79
attribute->set_type(drizzled::message::Table::Field::DOUBLE);
81
case DRIZZLE_TYPE_NULL :
82
assert(1); /* Not a user definable type */
83
case DRIZZLE_TYPE_TIMESTAMP:
84
attribute->set_type(drizzled::message::Table::Field::TIMESTAMP);
86
case DRIZZLE_TYPE_LONGLONG:
87
attribute->set_type(drizzled::message::Table::Field::BIGINT);
89
case DRIZZLE_TYPE_DATETIME:
90
attribute->set_type(drizzled::message::Table::Field::DATETIME);
92
case DRIZZLE_TYPE_DATE:
93
attribute->set_type(drizzled::message::Table::Field::DATE);
95
case DRIZZLE_TYPE_VARCHAR:
97
drizzled::message::Table::Field::StringFieldOptions *string_field_options;
99
string_field_options= attribute->mutable_string_options();
100
attribute->set_type(drizzled::message::Table::Field::VARCHAR);
101
string_field_options->set_length(field_arg->length
102
/ field_arg->charset->mbmaxlen);
103
string_field_options->set_collation_id(field_arg->charset->number);
104
string_field_options->set_collation(field_arg->charset->name);
108
case DRIZZLE_TYPE_NEWDECIMAL:
110
drizzled::message::Table::Field::NumericFieldOptions *numeric_field_options;
112
attribute->set_type(drizzled::message::Table::Field::DECIMAL);
113
numeric_field_options= attribute->mutable_numeric_options();
114
/* This is magic, I hate magic numbers -Brian */
115
numeric_field_options->set_precision(field_arg->length + ( field_arg->decimals ? -2 : -1));
116
numeric_field_options->set_scale(field_arg->decimals);
119
case DRIZZLE_TYPE_ENUM:
121
drizzled::message::Table::Field::SetFieldOptions *set_field_options;
123
assert(field_arg->interval);
125
attribute->set_type(drizzled::message::Table::Field::ENUM);
126
set_field_options= attribute->mutable_set_options();
128
for (uint32_t pos= 0; pos < field_arg->interval->count; pos++)
130
const char *src= field_arg->interval->type_names[pos];
132
set_field_options->add_field_value(src);
134
set_field_options->set_count_elements(set_field_options->field_value_size());
135
set_field_options->set_collation_id(field_arg->charset->number);
136
set_field_options->set_collation(field_arg->charset->name);
139
case DRIZZLE_TYPE_BLOB:
141
attribute->set_type(drizzled::message::Table::Field::BLOB);
143
drizzled::message::Table::Field::StringFieldOptions *string_field_options;
145
string_field_options= attribute->mutable_string_options();
146
string_field_options->set_collation_id(field_arg->charset->number);
147
string_field_options->set_collation(field_arg->charset->name);
152
assert(0); /* Tell us, since this shouldn't happend */
156
field_constraints= attribute->mutable_constraints();
157
constraints->set_is_nullable(field_arg->def->null_value);
213
if ((file=create_frm(thd, file_name, db, table, reclength, fileinfo,
214
create_info, keys, key_info)) < 0)
220
key_buff_length= uint4korr(fileinfo+47);
221
keybuff=(unsigned char*) my_malloc(key_buff_length, MYF(0));
222
key_info_length= pack_keys(keybuff, keys, key_info, data_offset);
223
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]= (unsigned char) 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,
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 unsigned char*)buff, 2, MYF(MY_NABP)) ||
249
my_write(file, (const unsigned char*)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 unsigned char*)buff, 2, MYF(MY_NABP)) ||
255
my_write(file, (const unsigned char*)str_db_type.str,
256
str_db_type.length, MYF(MY_NABP)))
261
if (my_write(file, (unsigned char*) buff, 6, MYF_RW))
265
if (forminfo[46] == (unsigned char)255)
267
unsigned char 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, (unsigned char*)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 unsigned char*)buff, format_section_header_size, MYF_RW))
292
if (my_write(file, (const unsigned char*)buff, 1, MYF_RW))
294
/* write column info, 1 byte per column */
296
List_iterator<Create_field> it(create_fields);
298
unsigned char column_format, write_byte;
301
column_format= (unsigned char)field->column_format();
302
write_byte= (column_format << COLUMN_FORMAT_SHIFT);
303
if (my_write(file, &write_byte, 1, MYF_RW))
308
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))
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;
347
my_close(file,MYF(MY_WME));
349
my_delete(file_name,MYF(0));
351
} /* mysql_create_frm */
160
switch(field_arg->column_format())
162
case COLUMN_FORMAT_TYPE_NOT_USED:
164
case COLUMN_FORMAT_TYPE_DEFAULT:
165
attribute->set_format(drizzled::message::Table::Field::DefaultFormat);
167
case COLUMN_FORMAT_TYPE_FIXED:
168
attribute->set_format(drizzled::message::Table::Field::FixedFormat);
170
case COLUMN_FORMAT_TYPE_DYNAMIC:
171
attribute->set_format(drizzled::message::Table::Field::DynamicFormat);
174
assert(0); /* Tell us, since this shouldn't happend */
177
if (field_arg->comment.length)
180
tmp_len= system_charset_info->cset->charpos(system_charset_info,
181
field_arg->comment.str,
182
field_arg->comment.str +
183
field_arg->comment.length,
184
COLUMN_COMMENT_MAXLEN);
186
if (tmp_len < field_arg->comment.length)
188
my_error(ER_WRONG_STRING_LENGTH, MYF(0),
189
field_arg->comment.str,"COLUMN COMMENT",
190
(uint32_t) COLUMN_COMMENT_MAXLEN);
194
attribute->set_comment(field_arg->comment.str);
197
if(field_arg->unireg_check == Field::NEXT_NUMBER)
199
drizzled::message::Table::Field::NumericFieldOptions *field_options;
200
field_options= attribute->mutable_numeric_options();
201
field_options->set_is_autoincrement(true);
204
if(field_arg->unireg_check == Field::TIMESTAMP_DN_FIELD
205
|| field_arg->unireg_check == Field::TIMESTAMP_DNUN_FIELD)
207
drizzled::message::Table::Field::FieldOptions *field_options;
208
field_options= attribute->mutable_options();
209
field_options->set_default_value("NOW()");
212
if(field_arg->unireg_check == Field::TIMESTAMP_UN_FIELD
213
|| field_arg->unireg_check == Field::TIMESTAMP_DNUN_FIELD)
215
drizzled::message::Table::Field::FieldOptions *field_options;
216
field_options= attribute->mutable_options();
217
field_options->set_update_value("NOW()");
222
drizzled::message::Table::Field::FieldOptions *field_options;
223
field_options= attribute->mutable_options();
225
if(field_arg->def->is_null())
227
field_options->set_default_null(true);
232
String *default_value= field_arg->def->val_str(&d);
234
assert(default_value);
236
if((field_arg->sql_type==DRIZZLE_TYPE_VARCHAR
237
|| field_arg->sql_type==DRIZZLE_TYPE_BLOB)
238
&& ((field_arg->length / field_arg->charset->mbmaxlen)
239
< default_value->length()))
241
my_error(ER_INVALID_DEFAULT, MYF(0), field_arg->field_name);
245
if((field_arg->sql_type==DRIZZLE_TYPE_VARCHAR
246
&& field_arg->charset==&my_charset_bin)
247
|| (field_arg->sql_type==DRIZZLE_TYPE_BLOB
248
&& field_arg->charset==&my_charset_bin))
251
bin_default.assign(default_value->c_ptr(),
252
default_value->length());
253
field_options->set_default_bin_value(bin_default);
257
field_options->set_default_value(default_value->c_ptr());
263
drizzled::message::Table::Field::FieldOptions *field_options;
264
field_options= attribute->mutable_options();
266
field_options->set_length(field_arg->length);
269
assert(field_arg->unireg_check == Field::NONE
270
|| field_arg->unireg_check == Field::NEXT_NUMBER
271
|| field_arg->unireg_check == Field::TIMESTAMP_DN_FIELD
272
|| field_arg->unireg_check == Field::TIMESTAMP_UN_FIELD
273
|| field_arg->unireg_check == Field::TIMESTAMP_DNUN_FIELD);
277
if (create_info->used_fields & HA_CREATE_USED_PACK_KEYS)
279
if(create_info->table_options & HA_OPTION_PACK_KEYS)
280
table_options->set_pack_keys(true);
281
else if(create_info->table_options & HA_OPTION_NO_PACK_KEYS)
282
table_options->set_pack_keys(false);
285
if(create_info->table_options & HA_OPTION_PACK_KEYS)
286
table_options->set_pack_keys(true);
289
if (create_info->used_fields & HA_CREATE_USED_CHECKSUM)
291
assert(create_info->table_options & (HA_OPTION_CHECKSUM | HA_OPTION_NO_CHECKSUM));
293
if(create_info->table_options & HA_OPTION_CHECKSUM)
294
table_options->set_checksum(true);
296
table_options->set_checksum(false);
298
else if(create_info->table_options & HA_OPTION_CHECKSUM)
299
table_options->set_checksum(true);
302
if (create_info->used_fields & HA_CREATE_USED_PAGE_CHECKSUM)
304
if (create_info->page_checksum == HA_CHOICE_YES)
305
table_options->set_page_checksum(true);
306
else if (create_info->page_checksum == HA_CHOICE_NO)
307
table_options->set_page_checksum(false);
309
else if (create_info->page_checksum == HA_CHOICE_YES)
310
table_options->set_page_checksum(true);
313
if (create_info->used_fields & HA_CREATE_USED_DELAY_KEY_WRITE)
315
if(create_info->table_options & HA_OPTION_DELAY_KEY_WRITE)
316
table_options->set_delay_key_write(true);
317
else if(create_info->table_options & HA_OPTION_NO_DELAY_KEY_WRITE)
318
table_options->set_delay_key_write(false);
320
else if(create_info->table_options & HA_OPTION_DELAY_KEY_WRITE)
321
table_options->set_delay_key_write(true);
324
switch(create_info->row_type)
326
case ROW_TYPE_DEFAULT:
327
table_options->set_row_type(drizzled::message::Table::TableOptions::ROW_TYPE_DEFAULT);
330
table_options->set_row_type(drizzled::message::Table::TableOptions::ROW_TYPE_FIXED);
332
case ROW_TYPE_DYNAMIC:
333
table_options->set_row_type(drizzled::message::Table::TableOptions::ROW_TYPE_DYNAMIC);
335
case ROW_TYPE_COMPRESSED:
336
table_options->set_row_type(drizzled::message::Table::TableOptions::ROW_TYPE_COMPRESSED);
338
case ROW_TYPE_REDUNDANT:
339
table_options->set_row_type(drizzled::message::Table::TableOptions::ROW_TYPE_REDUNDANT);
341
case ROW_TYPE_COMPACT:
342
table_options->set_row_type(drizzled::message::Table::TableOptions::ROW_TYPE_COMPACT);
345
table_options->set_row_type(drizzled::message::Table::TableOptions::ROW_TYPE_PAGE);
351
table_options->set_pack_record(create_info->table_options
352
& HA_OPTION_PACK_RECORD);
354
if (create_info->comment.length)
357
tmp_len= system_charset_info->cset->charpos(system_charset_info,
358
create_info->comment.str,
359
create_info->comment.str +
360
create_info->comment.length,
361
TABLE_COMMENT_MAXLEN);
363
if (tmp_len < create_info->comment.length)
365
my_error(ER_WRONG_STRING_LENGTH, MYF(0),
366
create_info->comment.str,"Table COMMENT",
367
(uint32_t) TABLE_COMMENT_MAXLEN);
371
table_options->set_comment(create_info->comment.str);
373
if (create_info->default_table_charset)
375
table_options->set_collation_id(
376
create_info->default_table_charset->number);
377
table_options->set_collation(create_info->default_table_charset->name);
380
if (create_info->connect_string.length)
381
table_options->set_connect_string(create_info->connect_string.str);
383
if (create_info->data_file_name)
384
table_options->set_data_file_name(create_info->data_file_name);
386
if (create_info->index_file_name)
387
table_options->set_index_file_name(create_info->index_file_name);
389
if (create_info->max_rows)
390
table_options->set_max_rows(create_info->max_rows);
392
if (create_info->min_rows)
393
table_options->set_min_rows(create_info->min_rows);
395
if (create_info->auto_increment_value)
396
table_options->set_auto_increment_value(create_info->auto_increment_value);
398
if (create_info->avg_row_length)
399
table_options->set_avg_row_length(create_info->avg_row_length);
401
if (create_info->key_block_size)
402
table_options->set_key_block_size(create_info->key_block_size);
404
if (create_info->block_size)
405
table_options->set_block_size(create_info->block_size);
407
for (unsigned int i= 0; i < keys; i++)
409
drizzled::message::Table::Index *idx;
411
idx= table_proto->add_indexes();
413
assert(test(key_info[i].flags & HA_USES_COMMENT) ==
414
(key_info[i].comment.length > 0));
416
idx->set_name(key_info[i].name);
418
idx->set_key_length(key_info[i].key_length);
420
if(is_primary_key_name(key_info[i].name))
421
idx->set_is_primary(true);
423
idx->set_is_primary(false);
425
switch(key_info[i].algorithm)
427
case HA_KEY_ALG_HASH:
428
idx->set_type(drizzled::message::Table::Index::HASH);
431
case HA_KEY_ALG_BTREE:
432
idx->set_type(drizzled::message::Table::Index::BTREE);
435
case HA_KEY_ALG_RTREE:
436
idx->set_type(drizzled::message::Table::Index::RTREE);
437
case HA_KEY_ALG_FULLTEXT:
438
idx->set_type(drizzled::message::Table::Index::FULLTEXT);
439
case HA_KEY_ALG_UNDEF:
440
idx->set_type(drizzled::message::Table::Index::UNKNOWN_INDEX);
444
abort(); /* Somebody's brain broke. haven't added index type to proto */
447
if (key_info[i].flags & HA_NOSAME)
448
idx->set_is_unique(true);
450
idx->set_is_unique(false);
452
drizzled::message::Table::Index::IndexOptions *index_options= idx->mutable_options();
454
if(key_info[i].flags & HA_USES_BLOCK_SIZE)
455
index_options->set_key_block_size(key_info[i].block_size);
457
if(key_info[i].flags & HA_PACK_KEY)
458
index_options->set_pack_key(true);
460
if(key_info[i].flags & HA_BINARY_PACK_KEY)
461
index_options->set_binary_pack_key(true);
463
if(key_info[i].flags & HA_VAR_LENGTH_PART)
464
index_options->set_var_length_key(true);
466
if(key_info[i].flags & HA_NULL_PART_KEY)
467
index_options->set_null_part_key(true);
469
if(key_info[i].flags & HA_KEY_HAS_PART_KEY_SEG)
470
index_options->set_has_partial_segments(true);
472
if(key_info[i].flags & HA_GENERATED_KEY)
473
index_options->set_auto_generated_key(true);
475
if (key_info[i].flags & HA_USES_COMMENT)
478
tmp_len= system_charset_info->cset->charpos(system_charset_info,
479
key_info[i].comment.str,
480
key_info[i].comment.str +
481
key_info[i].comment.length,
482
TABLE_COMMENT_MAXLEN);
484
if (tmp_len < key_info[i].comment.length)
486
my_error(ER_WRONG_STRING_LENGTH, MYF(0),
487
key_info[i].comment.str,"Index COMMENT",
488
(uint32_t) TABLE_COMMENT_MAXLEN);
492
idx->set_comment(key_info[i].comment.str);
494
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))
495
abort(); // Invalid (unknown) index flag.
497
for(unsigned int j=0; j< key_info[i].key_parts; j++)
499
drizzled::message::Table::Index::IndexPart *idxpart;
501
idxpart= idx->add_index_part();
503
idxpart->set_fieldnr(key_info[i].key_part[j].fieldnr);
505
idxpart->set_compare_length(key_info[i].key_part[j].length);
507
idxpart->set_key_type(key_info[i].key_part[j].key_type);
515
int rename_table_proto_file(const char *from, const char* to)
517
string from_path(from);
519
string file_ext = ".dfe";
521
from_path.append(file_ext);
522
to_path.append(file_ext);
524
return my_rename(from_path.c_str(),to_path.c_str(),MYF(MY_WME));
527
int delete_table_proto_file(const char *file_name)
529
string new_path(file_name);
530
string file_ext = ".dfe";
532
new_path.append(file_ext);
533
return my_delete(new_path.c_str(), MYF(0));
536
int drizzle_write_proto_file(const std::string file_name,
537
drizzled::message::Table *table_proto)
539
int fd= open(file_name.c_str(), O_RDWR|O_CREAT|O_TRUNC, my_umask);
544
google::protobuf::io::ZeroCopyOutputStream* output=
545
new google::protobuf::io::FileOutputStream(fd);
547
if (table_proto->SerializeToZeroCopyStream(output) == false)
355
Create a frm (table definition) file and the tables
560
Create a table definition proto file and the tables
358
563
rea_create_table()
564
session Thread handler
360
565
path Name of file (including database, without .frm)
361
566
db Data base name
362
567
table_name Table name
365
570
keys number of keys to create
366
571
key_info Keys to create
367
572
file Handler to use
573
is_like is true for mysql_create_like_schema_frm
374
int rea_create_table(THD *thd, const char *path,
580
int rea_create_table(Session *session, const char *path,
375
581
const char *db, const char *table_name,
582
drizzled::message::Table *table_proto,
376
583
HA_CREATE_INFO *create_info,
377
List<Create_field> &create_fields,
378
uint32_t keys, KEY *key_info, handler *file)
584
List<CreateField> &create_fields,
585
uint32_t keys, KEY *key_info)
382
char frm_name[FN_REFLEN];
383
strxmov(frm_name, path, reg_ext, NULL);
384
if (mysql_create_frm(thd, frm_name, db, table_name, create_info,
385
create_fields, keys, key_info, file))
389
// Make sure mysql_create_frm din't remove extension
390
assert(*fn_rext(frm_name));
391
if (thd->variables.keep_files_on_create)
392
create_info->options|= HA_CREATE_KEEP_FILES;
393
if (file->ha_create_handler_files(path, NULL, CHF_CREATE_FLAG, create_info))
395
if (!create_info->frm_only && ha_create_table(thd, path, db, table_name,
587
/* Proto will blow up unless we give a name */
590
if (fill_table_proto(table_proto, table_name, create_fields, create_info,
594
string new_path(path);
595
string file_ext = ".dfe";
597
new_path.append(file_ext);
601
StorageEngine* engine= ha_resolve_by_name(session,
602
table_proto->engine().name());
603
if (engine->check_flag(HTON_BIT_HAS_DATA_DICTIONARY) == false)
604
err= drizzle_write_proto_file(new_path, table_proto);
609
my_error(ER_BAD_DB_ERROR,MYF(0),db);
611
my_error(ER_CANT_CREATE_TABLE,MYF(0),table_name,err);
616
if (ha_create_table(session, path, db, table_name,
617
create_info,0, table_proto))
401
file->ha_create_handler_files(path, NULL, CHF_DELETE_FLAG, create_info);
402
my_delete(frm_name, MYF(0));
622
if (engine->check_flag(HTON_BIT_HAS_DATA_DICTIONARY) == false)
623
delete_table_proto_file(path);
404
626
} /* rea_create_table */
407
/* 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,
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;
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=(unsigned char*) 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]=(unsigned char) (fields_on_screen+1);
447
start_screen[3]=(unsigned char) (fields_on_screen);
452
pos[0]= (unsigned char) start_row-2; /* Header string */
453
pos[1]= (unsigned char) (cols >> 2);
454
pos[2]= (unsigned char) (cols >> 1) +1;
455
strfill((char *) pos+3,(uint) (cols >> 1),' ');
458
length=(uint) strlen(cfield->field_name);
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;
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));
473
length=(uint) (pos-start_screen);
474
int2store(start_screen,length);
475
start_screen[2]=(unsigned char) (row-start_row+2);
476
start_screen[3]=(unsigned char) (row-start_row+1);
478
*info_length=(uint) (pos-info);
483
/* 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,
488
uint32_t key_parts,length;
489
unsigned char *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]= (unsigned char) key->key_parts;
501
pos[5]= (unsigned char) 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++=(unsigned char) NAMES_SEP_CHAR;
523
for (key=keyinfo ; key != end ; key++)
525
unsigned char *tmp=(unsigned char*) my_stpcpy((char*) pos,key->name);
526
*tmp++= (unsigned char) 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
unsigned char *tmp= (unsigned char*)my_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]=(unsigned char) key_count;
551
keybuff[1]=(unsigned char) 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(unsigned char *forminfo,
563
List<Create_field> &create_fields,
564
uint32_t info_length, uint32_t screens, uint32_t table_options,
565
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;
569
ulong reclength, totlength, n_length, com_length;
572
if (create_fields.elements > MAX_FIELDS)
574
my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF(0));
579
reclength= data_offset;
580
no_empty=int_count=int_parts=int_length=time_stamp_pos=null_fields=
586
List_iterator<Create_field> it(create_fields);
590
uint32_t tmp_len= system_charset_info->cset->charpos(system_charset_info,
593
field->comment.length,
594
COLUMN_COMMENT_MAXLEN);
596
if (tmp_len < field->comment.length)
598
my_error(ER_WRONG_STRING_LENGTH, MYF(0),
599
field->comment.str,"COLUMN COMMENT",
600
(uint) COLUMN_COMMENT_MAXLEN);
604
totlength+= field->length;
605
com_length+= field->comment.length;
606
if (MTYP_TYPENR(field->unireg_check) == Field::NOEMPTY ||
607
field->unireg_check & MTYP_NOEMPTY_BIT)
609
field->unireg_check= (Field::utype) ((uint) field->unireg_check |
614
We mark first TIMESTAMP field with NOW() in DEFAULT or ON UPDATE
615
as auto-update field.
617
if (field->sql_type == DRIZZLE_TYPE_TIMESTAMP &&
618
MTYP_TYPENR(field->unireg_check) != Field::NONE &&
620
time_stamp_pos= (uint) field->offset+ (uint) data_offset + 1;
621
length=field->pack_length;
622
/* Ensure we don't have any bugs when generating offsets */
623
assert(reclength == field->offset + data_offset);
624
if ((uint) field->offset+ (uint) data_offset+ length > reclength)
625
reclength=(uint) (field->offset+ data_offset + length);
626
n_length+= (ulong) strlen(field->field_name)+1;
627
field->interval_id=0;
628
field->save_interval= 0;
631
uint32_t old_int_count=int_count;
633
if (field->charset->mbminlen > 1)
636
Escape UCS2 intervals using HEX notation to avoid
637
problems with delimiters between enum elements.
638
As the original representation is still needed in
639
the function make_empty_rec to create a record of
640
filled with default values it is saved in save_interval
641
The HEX representation is created from this copy.
643
field->save_interval= field->interval;
644
field->interval= (TYPELIB*) sql_alloc(sizeof(TYPELIB));
645
*field->interval= *field->save_interval;
646
field->interval->type_names=
647
(const char **) sql_alloc(sizeof(char*) *
648
(field->interval->count+1));
649
field->interval->type_names[field->interval->count]= 0;
650
field->interval->type_lengths=
651
(uint32_t *) sql_alloc(sizeof(uint) * field->interval->count);
653
for (uint32_t pos= 0; pos < field->interval->count; pos++)
656
const char *src= field->save_interval->type_names[pos];
658
length= field->save_interval->type_lengths[pos];
659
hex_length= length * 2;
660
field->interval->type_lengths[pos]= hex_length;
661
field->interval->type_names[pos]= dst= (char*) sql_alloc(hex_length +
663
octet2hex(dst, src, length);
667
field->interval_id=get_interval_id(&int_count,create_fields,field);
668
if (old_int_count != int_count)
670
for (const char **pos=field->interval->type_names ; *pos ; pos++)
671
int_length+=(uint) strlen(*pos)+1; // field + suffix prefix
672
int_parts+=field->interval->count+1;
675
if (f_maybe_null(field->pack_flag))
678
int_length+=int_count*2; // 255 prefix + 0 suffix
680
/* Save values in forminfo */
682
if (reclength > (ulong) file->max_record_length())
684
my_error(ER_TOO_BIG_ROWSIZE, MYF(0), (uint) file->max_record_length());
687
/* Hack to avoid bugs with small static rows in MySQL */
688
reclength=cmax((ulong)file->min_record_length(table_options),reclength);
689
if (info_length+(ulong) create_fields.elements*FCOMP+288+
690
n_length+int_length+com_length > 65535L || int_count > 255)
692
my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF(0));
696
memset(forminfo, 0, 288);
697
length=(info_length+create_fields.elements*FCOMP+288+n_length+int_length+
699
int2store(forminfo,length);
700
forminfo[256] = (uint8_t) screens;
701
int2store(forminfo+258,create_fields.elements);
702
int2store(forminfo+260,info_length);
703
int2store(forminfo+262,totlength);
704
int2store(forminfo+264,no_empty);
705
int2store(forminfo+266,reclength);
706
int2store(forminfo+268,n_length);
707
int2store(forminfo+270,int_count);
708
int2store(forminfo+272,int_parts);
709
int2store(forminfo+274,int_length);
710
int2store(forminfo+276,time_stamp_pos);
711
int2store(forminfo+278,80); /* Columns needed */
712
int2store(forminfo+280,22); /* Rows needed */
713
int2store(forminfo+282,null_fields);
714
int2store(forminfo+284,com_length);
715
/* Up to forminfo+288 is free to use for additional information */
720
/* get each unique interval each own id */
722
static uint32_t get_interval_id(uint32_t *int_count,List<Create_field> &create_fields,
723
Create_field *last_field)
725
List_iterator<Create_field> it(create_fields);
727
TYPELIB *interval=last_field->interval;
729
while ((field=it++) != last_field)
731
if (field->interval_id && field->interval->count == interval->count)
734
for (a=field->interval->type_names, b=interval->type_names ;
735
*a && !strcmp(*a,*b);
740
return field->interval_id; // Re-use last interval
744
return ++*int_count; // New unique interval
748
/* Save fields, fieldnames and intervals */
750
static bool pack_fields(File file, List<Create_field> &create_fields,
754
uint32_t int_count, comment_length=0;
755
unsigned char buff[MAX_FIELD_WIDTH];
759
/* Write field info */
761
List_iterator<Create_field> it(create_fields);
767
buff[0]= (unsigned char) field->row;
768
buff[1]= (unsigned char) field->col;
769
buff[2]= (unsigned char) field->sc_length;
770
int2store(buff+3, field->length);
771
/* The +1 is here becasue the col offset in .frm file have offset 1 */
772
recpos= field->offset+1 + (uint) data_offset;
773
int3store(buff+5,recpos);
774
int2store(buff+8,field->pack_flag);
775
int2store(buff+10,field->unireg_check);
776
buff[12]= (unsigned char) field->interval_id;
777
buff[13]= (unsigned char) field->sql_type;
779
buff[14]= (unsigned char) field->charset->number;
781
buff[14]= 0; // Numerical
782
int2store(buff+15, field->comment.length);
783
comment_length+= field->comment.length;
784
set_if_bigger(int_count,field->interval_id);
785
if (my_write(file, buff, FCOMP, MYF_RW))
789
/* Write fieldnames */
790
buff[0]=(unsigned char) NAMES_SEP_CHAR;
791
if (my_write(file, buff, 1, MYF_RW))
797
char *pos= my_stpcpy((char*) buff,field->field_name);
798
*pos++=NAMES_SEP_CHAR;
799
if (i == create_fields.elements-1)
801
if (my_write(file, buff, (size_t) (pos-(char*) buff),MYF_RW))
806
/* Write intervals */
809
String tmp((char*) buff,sizeof(buff), &my_charset_bin);
815
if (field->interval_id > int_count)
817
unsigned char sep= 0;
818
unsigned char occ[256];
820
unsigned char *val= NULL;
822
memset(occ, 0, sizeof(occ));
824
for (i=0; (val= (unsigned char*) field->interval->type_names[i]); i++)
825
for (uint32_t j = 0; j < field->interval->type_lengths[i]; j++)
826
occ[(unsigned int) (val[j])]= 1;
828
if (!occ[(unsigned char)NAMES_SEP_CHAR])
829
sep= (unsigned char) NAMES_SEP_CHAR;
830
else if (!occ[(unsigned int)','])
834
for (uint32_t i=1; i<256; i++)
843
if(!sep) /* disaster, enum uses all characters, none left as separator */
845
my_message(ER_WRONG_FIELD_TERMINATORS,ER(ER_WRONG_FIELD_TERMINATORS),
851
int_count= field->interval_id;
853
for (const char **pos=field->interval->type_names ; *pos ; pos++)
858
tmp.append('\0'); // End of intervall
861
if (my_write(file,(unsigned char*) tmp.ptr(),tmp.length(),MYF_RW))
870
if (field->comment.length)
871
if (my_write(file, (unsigned char*) field->comment.str, field->comment.length,
880
/* 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,
893
unsigned char *buff,*null_pos;
897
enum_check_fields old_count_cuted_fields= thd->count_cuted_fields;
900
/* We need a table to generate columns for default values */
901
memset(&table, 0, sizeof(table));
902
memset(&share, 0, sizeof(share));
905
if (!(buff=(unsigned char*) my_malloc((size_t) reclength,MYF(MY_WME | MY_ZEROFILL))))
911
table.s->db_low_byte_first= handler->low_byte_first();
912
table.s->blob_ptr_size= portable_sizeof_char_ptr;
915
if (!(table_options & HA_OPTION_PACK_RECORD))
917
null_count++; // Need one bit for delete mark
922
List_iterator<Create_field> it(create_fields);
923
thd->count_cuted_fields= CHECK_FIELD_WARN; // To find wrong default values
927
regfield don't have to be deleted as it's allocated with sql_alloc()
929
Field *regfield= make_field(&share,
930
buff+field->offset + data_offset,
932
null_pos + null_count / 8,
938
field->save_interval ? field->save_interval :
944
goto err; // End of memory
947
/* save_in_field() will access regfield->table->in_use */
948
regfield->init(&table);
950
if (!(field->flags & NOT_NULL_FLAG))
952
*regfield->null_ptr|= regfield->null_bit;
956
type= (Field::utype) MTYP_TYPENR(field->unireg_check);
960
int res= field->def->save_in_field(regfield, 1);
961
/* If not ok or warning of level 'note' */
962
if (res != 0 && res != 3)
964
my_error(ER_INVALID_DEFAULT, MYF(0), regfield->field_name);
966
delete regfield; //To avoid memory leak
970
else if (regfield->real_type() == DRIZZLE_TYPE_ENUM &&
971
(field->flags & NOT_NULL_FLAG))
973
regfield->set_notnull();
974
regfield->store((int64_t) 1, true);
976
else if (type == Field::YES) // Old unireg type
977
regfield->store(ER(ER_YES),(uint) strlen(ER(ER_YES)),system_charset_info);
978
else if (type == Field::NO) // Old unireg type
979
regfield->store(ER(ER_NO), (uint) strlen(ER(ER_NO)),system_charset_info);
983
assert(data_offset == ((null_count + 7) / 8));
986
We need to set the unused bits to 1. If the number of bits is a multiple
987
of 8 there are no unused bits.
990
*(null_pos + null_count / 8)|= ~(((unsigned char) 1 << (null_count & 7)) - 1);
992
error= my_write(file, buff, (size_t) reclength,MYF_RW) != 0;
996
thd->count_cuted_fields= old_count_cuted_fields;
998
} /* make_empty_rec */