~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to drizzled/unireg.cc

  • Committer: Monty Taylor
  • Date: 2008-09-16 01:37:05 UTC
  • mto: This revision was merged to the branch mainline in revision 391.
  • Revision ID: monty@inaugust.com-20080916013705-772d1t7rh9ah9j1x
Moved more functions into drizzle.c as part of the split of code.
Added accessor function for drizzle_port.

Show diffs side-by-side

added added

removed removed

Lines of Context:
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 */
15
15
 
 
16
 
 
17
/*
 
18
  Functions to create a unireg form-file from a FIELD and a fieldname-fieldinfo
 
19
  struct.
 
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.
 
24
*/
 
25
 
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>
21
 
 
22
 
/* For proto */
23
 
#include <string>
24
 
#include <fstream>
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>
29
 
using namespace std;
30
 
 
31
 
int drizzle_read_table_proto(const char* path, drizzle::Table* table)
32
 
{
33
 
  int fd= open(path, O_RDONLY);
34
 
 
35
 
  if(fd==-1)
36
 
    return errno;
37
 
 
38
 
  google::protobuf::io::ZeroCopyInputStream* input=
39
 
    new google::protobuf::io::FileInputStream(fd);
40
 
 
41
 
  if (!table->ParseFromZeroCopyStream(input))
42
 
  {
43
 
    delete input;
44
 
    close(fd);
45
 
    return -1;
46
 
  }
47
 
 
48
 
  delete input;
49
 
  close(fd);
50
 
  return 0;
 
27
#include <drizzled/drizzled_error_messages.h>
 
28
 
 
29
#define FCOMP                   17              /* Bytes for a packed field */
 
30
 
 
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,
 
34
                      ulong data_offset);
 
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,
 
42
                        ulong data_offset);
 
43
static bool make_empty_rec(THD *thd, int file, enum legacy_db_type table_type,
 
44
                           uint table_options,
 
45
                           List<Create_field> &create_fields,
 
46
                           uint reclength, ulong data_offset,
 
47
                           handler *handler);
 
48
 
 
49
/**
 
50
  An interceptor to hijack ER_TOO_MANY_FIELDS error from
 
51
  pack_screens and retry again without UNIREG screens.
 
52
 
 
53
  XXX: what is a UNIREG  screen?
 
54
*/
 
55
 
 
56
struct Pack_header_error_handler: public Internal_error_handler
 
57
{
 
58
  virtual bool handle_error(uint sql_errno,
 
59
                            const char *message,
 
60
                            DRIZZLE_ERROR::enum_warning_level level,
 
61
                            THD *thd);
 
62
  bool is_handled;
 
63
  Pack_header_error_handler() :is_handled(false) {}
 
64
};
 
65
 
 
66
 
 
67
bool
 
68
Pack_header_error_handler::
 
69
handle_error(uint sql_errno,
 
70
             const char * /* message */,
 
71
             DRIZZLE_ERROR::enum_warning_level /* level */,
 
72
             THD * /* thd */)
 
73
{
 
74
  is_handled= (sql_errno == ER_TOO_MANY_FIELDS);
 
75
  return is_handled;
51
76
}
52
77
 
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,
57
 
                            uint32_t keys,
58
 
                            KEY *key_info)
 
78
/*
 
79
  Create a frm (table definition) file
 
80
 
 
81
  SYNOPSIS
 
82
    mysql_create_frm()
 
83
    thd                 Thread handler
 
84
    file_name           Path for file (including database and .frm)
 
85
    db                  Name of database
 
86
    table               Name of table
 
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
 
92
                        create_info->db_type
 
93
  RETURN
 
94
    0  ok
 
95
    1  error
 
96
*/
 
97
 
 
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,
 
103
                      handler *db_file)
59
104
{
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();
64
 
 
65
 
  if (create_fields.elements > MAX_FIELDS)
66
 
  {
67
 
    my_error(ER_TOO_MANY_FIELDS, MYF(0), ER(ER_TOO_MANY_FIELDS));
68
 
    return(1);
69
 
  }
70
 
 
71
 
  engine->set_name(create_info->db_type->getName());
72
 
 
73
 
  table_proto->set_name(table_name);
74
 
  table_proto->set_type(drizzle::Table::STANDARD);
75
 
 
76
 
  while ((field_arg= it++))
77
 
  {
78
 
    drizzle::Table::Field *attribute;
79
 
 
80
 
    attribute= table_proto->add_field();
81
 
    attribute->set_name(field_arg->field_name);
82
 
 
83
 
    attribute->set_pack_flag(field_arg->pack_flag); /* TODO: MUST DIE */
84
 
 
85
 
    if(f_maybe_null(field_arg->pack_flag))
86
 
    {
87
 
      drizzle::Table::Field::FieldConstraints *constraints;
88
 
 
89
 
      constraints= attribute->mutable_constraints();
90
 
      constraints->set_is_nullable(true);
91
 
    }
92
 
 
93
 
    switch (field_arg->sql_type) {
94
 
    case DRIZZLE_TYPE_TINY:
95
 
      attribute->set_type(drizzle::Table::Field::TINYINT);
96
 
      break;
97
 
    case DRIZZLE_TYPE_LONG:
98
 
      attribute->set_type(drizzle::Table::Field::INTEGER);
99
 
      break;
100
 
    case DRIZZLE_TYPE_DOUBLE:
101
 
      attribute->set_type(drizzle::Table::Field::DOUBLE);
102
 
      break;
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);
107
 
      break;
108
 
    case DRIZZLE_TYPE_LONGLONG:
109
 
      attribute->set_type(drizzle::Table::Field::BIGINT);
110
 
      break;
111
 
    case DRIZZLE_TYPE_DATETIME:
112
 
      attribute->set_type(drizzle::Table::Field::DATETIME);
113
 
      break;
114
 
    case DRIZZLE_TYPE_DATE:
115
 
      attribute->set_type(drizzle::Table::Field::DATE);
116
 
      break;
117
 
    case DRIZZLE_TYPE_VARCHAR:
118
 
      {
119
 
        drizzle::Table::Field::StringFieldOptions *string_field_options;
120
 
 
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);
127
 
 
128
 
        break;
129
 
      }
130
 
    case DRIZZLE_TYPE_NEWDECIMAL:
131
 
      {
132
 
        drizzle::Table::Field::NumericFieldOptions *numeric_field_options;
133
 
 
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);
139
 
        break;
140
 
      }
141
 
    case DRIZZLE_TYPE_ENUM:
142
 
      {
143
 
        drizzle::Table::Field::SetFieldOptions *set_field_options;
144
 
 
145
 
        assert(field_arg->interval);
146
 
 
147
 
        attribute->set_type(drizzle::Table::Field::ENUM);
148
 
        set_field_options= attribute->mutable_set_options();
149
 
 
150
 
        for (uint32_t pos= 0; pos < field_arg->interval->count; pos++)
151
 
        {
152
 
          const char *src= field_arg->interval->type_names[pos];
153
 
 
154
 
          set_field_options->add_field_value(src);
155
 
        }
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);
159
 
        break;
160
 
      }
161
 
    case DRIZZLE_TYPE_BLOB:
162
 
      {
163
 
        attribute->set_type(drizzle::Table::Field::BLOB);
164
 
 
165
 
        drizzle::Table::Field::StringFieldOptions *string_field_options;
166
 
 
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);
170
 
      }
171
 
 
172
 
      break;
173
 
    default:
174
 
      assert(0); /* Tell us, since this shouldn't happend */
175
 
    }
176
 
 
177
 
    if(field_arg->vcol_info)
178
 
    {
179
 
      uint32_t tmp_len;
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);
185
 
 
186
 
      if (tmp_len < field_arg->vcol_info->expr_str.length)
187
 
      {
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);
191
 
        return(1);
192
 
      }
193
 
 
194
 
      drizzle::Table::Field::VirtualFieldOptions *field_options;
195
 
 
196
 
      field_options= attribute->mutable_virtual_options();
197
 
 
198
 
      field_options->set_type(attribute->type());
199
 
      attribute->set_type(drizzle::Table::Field::VIRTUAL);
200
 
 
201
 
      string expr(field_arg->vcol_info->expr_str.str,
202
 
                  field_arg->vcol_info->expr_str.length);
203
 
 
204
 
      field_options->set_expression(expr);
205
 
      field_options->set_physically_stored(field_arg->is_stored);
206
 
    }
207
 
 
208
 
#ifdef NOTDONE
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;
 
108
  File file;
 
109
  ulong filepos, data_offset;
 
110
  uchar fileinfo[64],forminfo[288],*keybuff;
 
111
  TYPELIB formnames;
 
112
  uchar *screen_buff;
 
113
  char buff[128];
 
114
  const uint format_section_header_size= 8;
 
115
  uint format_section_len;
 
116
  Pack_header_error_handler pack_header_error_handler;
 
117
  int error;
 
118
 
 
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)))
 
122
    return(1);
 
123
  assert(db_file != NULL);
 
124
 
 
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;
 
129
 
 
130
  thd->push_internal_handler(&pack_header_error_handler);
 
131
 
 
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);
 
136
 
 
137
  thd->pop_internal_handler();
 
138
 
 
139
  if (error)
 
140
  {
 
141
    my_free(screen_buff, MYF(0));
 
142
    if (! pack_header_error_handler.is_handled)
 
143
      return(1);
 
144
 
 
145
    // Try again without UNIREG screens (to get more columns)
 
146
    if (!(screen_buff=pack_screens(create_fields,&info_length,&screens,1)))
 
147
      return(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))
 
151
    {
 
152
      my_free(screen_buff, MYF(0));
 
153
      return(1);
 
154
    }
 
155
  }
 
156
  reclength=uint2korr(forminfo+266);
 
157
 
 
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);
 
161
  /* str_db_type */
 
162
  create_info->extra_size= (2 + str_db_type.length +
 
163
                            2 + create_info->connect_string.length);
 
164
  /*
 
165
    Partition:
 
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
 
169
      => Total 6 byte
 
170
  */
 
171
  create_info->extra_size+= 6;
 
172
 
 
173
  /* Add space for storage type and field format array of fields */
 
174
  format_section_len=
 
175
    format_section_header_size + 1 + create_fields.elements;
 
176
  create_info->extra_size+= format_section_len;
 
177
 
 
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);
 
183
 
 
184
  if (tmp_len < create_info->comment.length)
 
185
  {
 
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));
 
190
    return(1);
 
191
  }
 
192
 
 
193
  //if table comment is larger than 180 bytes, store into extra segment.
 
194
  if (create_info->comment.length > 180)
 
195
  {
 
196
    forminfo[46]=255;
 
197
    create_info->extra_size+= 2 + create_info->comment.length;
 
198
  }
 
199
  else{
 
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;
 
203
#ifdef EXTRA_DEBUG
 
204
    /*
 
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.
 
208
    */
 
209
    memset(forminfo+47 + forminfo[46], 0, 61 - forminfo[46]);
211
210
#endif
212
 
 
213
 
    switch(field_arg->column_format())
214
 
    {
215
 
    case COLUMN_FORMAT_TYPE_NOT_USED:
216
 
      break;
217
 
    case COLUMN_FORMAT_TYPE_DEFAULT:
218
 
      attribute->set_format(drizzle::Table::Field::DefaultFormat);
219
 
      break;
220
 
    case COLUMN_FORMAT_TYPE_FIXED:
221
 
      attribute->set_format(drizzle::Table::Field::FixedFormat);
222
 
      break;
223
 
    case COLUMN_FORMAT_TYPE_DYNAMIC:
224
 
      attribute->set_format(drizzle::Table::Field::DynamicFormat);
225
 
      break;
226
 
    default:
227
 
      assert(0); /* Tell us, since this shouldn't happend */
228
 
    }
229
 
 
230
 
    if (field_arg->comment.length)
231
 
    {
232
 
      uint32_t tmp_len;
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);
238
 
 
239
 
      if (tmp_len < field_arg->comment.length)
240
 
      {
241
 
        my_error(ER_WRONG_STRING_LENGTH, MYF(0),
242
 
                 field_arg->comment.str,"COLUMN COMMENT",
243
 
                 (uint32_t) COLUMN_COMMENT_MAXLEN);
244
 
        return(1);
245
 
      }
246
 
 
247
 
      attribute->set_comment(field_arg->comment.str);
248
 
    }
249
 
 
250
 
    if(field_arg->unireg_check == Field::NEXT_NUMBER)
251
 
    {
252
 
      drizzle::Table::Field::NumericFieldOptions *field_options;
253
 
      field_options= attribute->mutable_numeric_options();
254
 
      field_options->set_is_autoincrement(true);
255
 
    }
256
 
 
257
 
    if(field_arg->unireg_check == Field::TIMESTAMP_DN_FIELD
258
 
       || field_arg->unireg_check == Field::TIMESTAMP_DNUN_FIELD)
259
 
    {
260
 
      drizzle::Table::Field::FieldOptions *field_options;
261
 
      field_options= attribute->mutable_options();
262
 
      field_options->set_default_value("NOW()");
263
 
    }
264
 
 
265
 
    if(field_arg->unireg_check == Field::TIMESTAMP_UN_FIELD
266
 
       || field_arg->unireg_check == Field::TIMESTAMP_DNUN_FIELD)
267
 
    {
268
 
      drizzle::Table::Field::FieldOptions *field_options;
269
 
      field_options= attribute->mutable_options();
270
 
      field_options->set_update_value("NOW()");
271
 
    }
272
 
 
273
 
    if(field_arg->def)
274
 
    {
275
 
      drizzle::Table::Field::FieldOptions *field_options;
276
 
      field_options= attribute->mutable_options();
277
 
 
278
 
      if(field_arg->def->is_null())
279
 
      {
280
 
        field_options->set_default_null(true);
281
 
      }
282
 
      else
283
 
      {
284
 
        String d;
285
 
        String *default_value= field_arg->def->val_str(&d);
286
 
 
287
 
        assert(default_value);
288
 
 
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()))
293
 
        {
294
 
          my_error(ER_INVALID_DEFAULT, MYF(0), field_arg->field_name);
295
 
          return 1;
296
 
        }
297
 
 
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))
302
 
        {
303
 
          string bin_default;
304
 
          bin_default.assign(default_value->c_ptr(),
305
 
                             default_value->length());
306
 
          field_options->set_default_bin_value(bin_default);
307
 
        }
308
 
        else
309
 
        {
310
 
          field_options->set_default_value(default_value->c_ptr());
311
 
        }
312
 
      }
313
 
    }
314
 
 
315
 
    {
316
 
      drizzle::Table::Field::FieldOptions *field_options;
317
 
      field_options= attribute->mutable_options();
318
 
 
319
 
      field_options->set_length(field_arg->length);
320
 
    }
321
 
 
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);
327
 
 
328
 
  }
329
 
 
330
 
  if (create_info->used_fields & HA_CREATE_USED_PACK_KEYS)
331
 
  {
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);
336
 
  }
337
 
  else
338
 
    if(create_info->table_options & HA_OPTION_PACK_KEYS)
339
 
      table_options->set_pack_keys(true);
340
 
 
341
 
 
342
 
  if (create_info->used_fields & HA_CREATE_USED_CHECKSUM)
343
 
  {
344
 
    assert(create_info->table_options & (HA_OPTION_CHECKSUM | HA_OPTION_NO_CHECKSUM));
345
 
 
346
 
    if(create_info->table_options & HA_OPTION_CHECKSUM)
347
 
      table_options->set_checksum(true);
348
 
    else
349
 
      table_options->set_checksum(false);
350
 
  }
351
 
  else if(create_info->table_options & HA_OPTION_CHECKSUM)
352
 
    table_options->set_checksum(true);
353
 
 
354
 
 
355
 
  if (create_info->used_fields & HA_CREATE_USED_PAGE_CHECKSUM)
356
 
  {
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);
361
 
  }
362
 
  else if (create_info->page_checksum == HA_CHOICE_YES)
363
 
    table_options->set_page_checksum(true);
364
 
 
365
 
 
366
 
  if (create_info->used_fields & HA_CREATE_USED_DELAY_KEY_WRITE)
367
 
  {
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);
372
 
  }
373
 
  else if(create_info->table_options & HA_OPTION_DELAY_KEY_WRITE)
374
 
    table_options->set_delay_key_write(true);
375
 
 
376
 
 
377
 
  switch(create_info->row_type)
378
 
  {
379
 
  case ROW_TYPE_DEFAULT:
380
 
    table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_DEFAULT);
381
 
    break;
382
 
  case ROW_TYPE_FIXED:
383
 
    table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_FIXED);
384
 
    break;
385
 
  case ROW_TYPE_DYNAMIC:
386
 
    table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_DYNAMIC);
387
 
    break;
388
 
  case ROW_TYPE_COMPRESSED:
389
 
    table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_COMPRESSED);
390
 
    break;
391
 
  case ROW_TYPE_REDUNDANT:
392
 
    table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_REDUNDANT);
393
 
    break;
394
 
  case ROW_TYPE_COMPACT:
395
 
    table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_COMPACT);
396
 
    break;
397
 
  case ROW_TYPE_PAGE:
398
 
    table_options->set_row_type(drizzle::Table::TableOptions::ROW_TYPE_PAGE);
399
 
    break;
400
 
  default:
401
 
    abort();
402
 
  }
403
 
 
404
 
  table_options->set_pack_record(create_info->table_options
405
 
                                 & HA_OPTION_PACK_RECORD);
406
 
 
407
 
  if (create_info->comment.length)
408
 
  {
409
 
    uint32_t tmp_len;
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);
415
 
 
416
 
    if (tmp_len < create_info->comment.length)
417
 
    {
418
 
      my_error(ER_WRONG_STRING_LENGTH, MYF(0),
419
 
               create_info->comment.str,"Table COMMENT",
420
 
               (uint32_t) TABLE_COMMENT_MAXLEN);
421
 
      return(1);
422
 
    }
423
 
 
424
 
    table_options->set_comment(create_info->comment.str);
425
 
  }
426
 
  if (create_info->default_table_charset)
427
 
  {
428
 
    table_options->set_collation_id(
429
 
                               create_info->default_table_charset->number);
430
 
    table_options->set_collation(create_info->default_table_charset->name);
431
 
  }
432
 
 
433
 
  if (create_info->connect_string.length)
434
 
    table_options->set_connect_string(create_info->connect_string.str);
435
 
 
436
 
  if (create_info->data_file_name)
437
 
    table_options->set_data_file_name(create_info->data_file_name);
438
 
 
439
 
  if (create_info->index_file_name)
440
 
    table_options->set_index_file_name(create_info->index_file_name);
441
 
 
442
 
  if (create_info->max_rows)
443
 
    table_options->set_max_rows(create_info->max_rows);
444
 
 
445
 
  if (create_info->min_rows)
446
 
    table_options->set_min_rows(create_info->min_rows);
447
 
 
448
 
  if (create_info->auto_increment_value)
449
 
    table_options->set_auto_increment_value(create_info->auto_increment_value);
450
 
 
451
 
  if (create_info->avg_row_length)
452
 
    table_options->set_avg_row_length(create_info->avg_row_length);
453
 
 
454
 
  if (create_info->key_block_size)
455
 
    table_options->set_key_block_size(create_info->key_block_size);
456
 
 
457
 
  if (create_info->block_size)
458
 
    table_options->set_block_size(create_info->block_size);
459
 
 
460
 
  for (unsigned int i= 0; i < keys; i++)
461
 
  {
462
 
    drizzle::Table::Index *idx;
463
 
 
464
 
    idx= table_proto->add_indexes();
465
 
 
466
 
    assert(test(key_info[i].flags & HA_USES_COMMENT) ==
467
 
           (key_info[i].comment.length > 0));
468
 
 
469
 
    idx->set_name(key_info[i].name);
470
 
 
471
 
    idx->set_key_length(key_info[i].key_length);
472
 
 
473
 
    if(is_primary_key_name(key_info[i].name))
474
 
      idx->set_is_primary(true);
475
 
    else
476
 
      idx->set_is_primary(false);
477
 
 
478
 
    switch(key_info[i].algorithm)
479
 
    {
480
 
    case HA_KEY_ALG_HASH:
481
 
      idx->set_type(drizzle::Table::Index::HASH);
482
 
      break;
483
 
 
484
 
    case HA_KEY_ALG_BTREE:
485
 
      idx->set_type(drizzle::Table::Index::BTREE);
486
 
      break;
487
 
 
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);
494
 
      break;
495
 
 
496
 
    default:
497
 
      abort(); /* Somebody's brain broke. haven't added index type to proto */
498
 
    }
499
 
 
500
 
    if (key_info[i].flags & HA_NOSAME)
501
 
      idx->set_is_unique(true);
502
 
    else
503
 
      idx->set_is_unique(false);
504
 
 
505
 
    drizzle::Table::Index::IndexOptions *index_options= idx->mutable_options();
506
 
 
507
 
    if(key_info[i].flags & HA_USES_BLOCK_SIZE)
508
 
      index_options->set_key_block_size(key_info[i].block_size);
509
 
 
510
 
    if(key_info[i].flags & HA_PACK_KEY)
511
 
      index_options->set_pack_key(true);
512
 
 
513
 
    if(key_info[i].flags & HA_BINARY_PACK_KEY)
514
 
      index_options->set_binary_pack_key(true);
515
 
 
516
 
    if(key_info[i].flags & HA_VAR_LENGTH_PART)
517
 
      index_options->set_var_length_key(true);
518
 
 
519
 
    if(key_info[i].flags & HA_NULL_PART_KEY)
520
 
      index_options->set_null_part_key(true);
521
 
 
522
 
    if(key_info[i].flags & HA_KEY_HAS_PART_KEY_SEG)
523
 
      index_options->set_has_partial_segments(true);
524
 
 
525
 
    if(key_info[i].flags & HA_GENERATED_KEY)
526
 
      index_options->set_auto_generated_key(true);
527
 
 
528
 
    if (key_info[i].flags & HA_USES_COMMENT)
529
 
    {
530
 
      uint32_t tmp_len;
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);
536
 
 
537
 
      if (tmp_len < key_info[i].comment.length)
538
 
      {
539
 
        my_error(ER_WRONG_STRING_LENGTH, MYF(0),
540
 
                 key_info[i].comment.str,"Index COMMENT",
541
 
                 (uint32_t) TABLE_COMMENT_MAXLEN);
542
 
        return(1);
543
 
      }
544
 
 
545
 
      idx->set_comment(key_info[i].comment.str);
546
 
    }
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.
549
 
 
550
 
    for(unsigned int j=0; j< key_info[i].key_parts; j++)
551
 
    {
552
 
      drizzle::Table::Index::IndexPart *idxpart;
553
 
 
554
 
      idxpart= idx->add_index_part();
555
 
 
556
 
      idxpart->set_fieldnr(key_info[i].key_part[j].fieldnr);
557
 
 
558
 
      idxpart->set_compare_length(key_info[i].key_part[j].length);
559
 
 
560
 
      idxpart->set_key_type(key_info[i].key_part[j].key_type);
561
 
 
562
 
    }
563
 
  }
564
 
 
565
 
  return 0;
566
 
}
567
 
 
568
 
int copy_table_proto_file(const char *from, const char* to)
569
 
{
570
 
  string dfesrc(from);
571
 
  string dfedst(to);
572
 
  string file_ext = ".dfe";
573
 
 
574
 
  dfesrc.append(file_ext);
575
 
  dfedst.append(file_ext);
576
 
 
577
 
  return my_copy(dfesrc.c_str(), dfedst.c_str(),
578
 
                 MYF(MY_DONT_OVERWRITE_FILE));
579
 
}
580
 
 
581
 
int rename_table_proto_file(const char *from, const char* to)
582
 
{
583
 
  string from_path(from);
584
 
  string to_path(to);
585
 
  string file_ext = ".dfe";
586
 
 
587
 
  from_path.append(file_ext);
588
 
  to_path.append(file_ext);
589
 
 
590
 
  return my_rename(from_path.c_str(),to_path.c_str(),MYF(MY_WME));
591
 
}
592
 
 
593
 
int delete_table_proto_file(const char *file_name)
594
 
{
595
 
  string new_path(file_name);
596
 
  string file_ext = ".dfe";
597
 
 
598
 
  new_path.append(file_ext);
599
 
  return my_delete(new_path.c_str(), MYF(0));
600
 
}
601
 
 
602
 
int table_proto_exists(const char *path)
603
 
{
604
 
  string proto_path(path);
605
 
  string file_ext(".dfe");
606
 
  proto_path.append(file_ext);
607
 
 
608
 
  int error= access(proto_path.c_str(), F_OK);
609
 
 
610
 
  if(error==0)
611
 
    return EEXIST;
612
 
  else
613
 
    return errno;
614
 
}
615
 
 
616
 
static int create_table_proto_file(const char *file_name,
617
 
                                   const char *db,
618
 
                                   const char *table_name,
619
 
                                   HA_CREATE_INFO *create_info,
620
 
                                   List<Create_field> &create_fields,
621
 
                                   uint32_t keys,
622
 
                                   KEY *key_info)
623
 
{
624
 
  drizzle::Table table_proto;
625
 
  string new_path(file_name);
626
 
  string file_ext = ".dfe";
627
 
 
628
 
  if(fill_table_proto(&table_proto, table_name, create_fields, create_info,
629
 
                      keys, key_info))
630
 
    return -1;
631
 
 
632
 
  new_path.append(file_ext);
633
 
 
634
 
  int fd= open(new_path.c_str(), O_RDWR|O_CREAT|O_TRUNC, my_umask);
635
 
 
636
 
  if(fd==-1)
637
 
  {
638
 
    if(errno==ENOENT)
639
 
      my_error(ER_BAD_DB_ERROR,MYF(0),db);
640
 
    else
641
 
      my_error(ER_CANT_CREATE_TABLE,MYF(0),table_name,errno);
642
 
    return errno;
643
 
  }
644
 
 
645
 
  google::protobuf::io::ZeroCopyOutputStream* output=
646
 
    new google::protobuf::io::FileOutputStream(fd);
647
 
 
648
 
  if (!table_proto.SerializeToZeroCopyStream(output))
649
 
  {
650
 
    delete output;
651
 
    close(fd);
652
 
    return errno;
653
 
  }
654
 
 
655
 
  delete output;
656
 
  close(fd);
657
 
  return 0;
658
 
}
 
211
  }
 
212
 
 
213
  if ((file=create_frm(thd, file_name, db, table, reclength, fileinfo,
 
214
                       create_info, keys, key_info)) < 0)
 
215
  {
 
216
    my_free(screen_buff, MYF(0));
 
217
    return(1);
 
218
  }
 
219
 
 
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,"")))
 
225
    goto err;
 
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);
 
232
 
 
233
 
 
234
  int2store(fileinfo+59,db_file->extra_rec_buf_length());
 
235
 
 
236
  if (pwrite(file, fileinfo, 64, 0L) == 0 ||
 
237
      pwrite(file, keybuff, key_info_length, (ulong) uint2korr(fileinfo+6)) == 0)
 
238
    goto err;
 
239
  VOID(my_seek(file,
 
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))
 
245
    goto err;
 
246
 
 
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)))
 
251
      goto err;
 
252
 
 
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)))
 
257
    goto err;
 
258
 
 
259
  {
 
260
    memset(buff, 0, 6);
 
261
    if (my_write(file, (uchar*) buff, 6, MYF_RW))
 
262
      goto err;
 
263
  }
 
264
 
 
265
  if (forminfo[46] == (uchar)255)
 
266
  {
 
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)))
 
272
      goto err;
 
273
  }
 
274
 
 
275
  /* Store storage type and field format array of fields */
 
276
  {
 
277
    /* prepare header */
 
278
    {
 
279
      uint flags= 0;
 
280
 
 
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 */
 
287
    }
 
288
    /* write header */
 
289
    if (my_write(file, (const uchar*)buff, format_section_header_size, MYF_RW))
 
290
      goto err;
 
291
    buff[0]= 0;
 
292
    if (my_write(file, (const uchar*)buff, 1, MYF_RW))
 
293
      goto err;
 
294
    /* write column info, 1 byte per column */
 
295
    {
 
296
      List_iterator<Create_field> it(create_fields);
 
297
      Create_field *field;
 
298
      uchar column_format, write_byte;
 
299
      while ((field=it++))
 
300
      {
 
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))
 
304
          goto err;
 
305
      }
 
306
    }
 
307
  }
 
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))
 
312
    goto err;
 
313
 
 
314
  my_free(screen_buff,MYF(0));
 
315
  my_free(keybuff, MYF(0));
 
316
 
 
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))))
 
320
      goto err2;
 
321
 
 
322
  if (my_close(file,MYF(MY_WME)))
 
323
    goto err3;
 
324
 
 
325
  {
 
326
    /* 
 
327
      Restore all UCS2 intervals.
 
328
      HEX representation of them is not needed anymore.
 
329
    */
 
330
    List_iterator<Create_field> it(create_fields);
 
331
    Create_field *field;
 
332
    while ((field=it++))
 
333
    {
 
334
      if (field->save_interval)
 
335
      {
 
336
        field->interval= field->save_interval;
 
337
        field->save_interval= 0;
 
338
      }
 
339
    }
 
340
  }
 
341
  return(0);
 
342
 
 
343
err:
 
344
  my_free(screen_buff, MYF(0));
 
345
  my_free(keybuff, MYF(0));
 
346
err2:
 
347
  VOID(my_close(file,MYF(MY_WME)));
 
348
err3:
 
349
  my_delete(file_name,MYF(0));
 
350
  return(1);
 
351
} /* mysql_create_frm */
 
352
 
659
353
 
660
354
/*
661
 
  Create a table definition proto file and the tables
 
355
  Create a frm (table definition) file and the tables
662
356
 
663
357
  SYNOPSIS
664
358
    rea_create_table()
665
 
    session                     Thread handler
 
359
    thd                 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
675
368
 
676
369
  RETURN
677
370
    0  ok
678
371
    1  error
679
372
*/
680
373
 
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,
686
 
                     bool is_like)
 
378
                     uint keys, KEY *key_info, handler *file)
687
379
{
688
 
  /* Proto will blow up unless we give a name */
689
 
  assert(table_name);
690
 
 
691
 
  /* For is_like we return once the file has been created */
692
 
  if (is_like)
693
 
  {
694
 
    if (create_table_proto_file(path, db, table_name, create_info,
695
 
                                create_fields, keys, key_info)!=0)
696
 
      return 1;
697
 
 
698
 
    return 0;
699
 
  }
700
 
  /* Here we need to build the full frm from the path */
701
 
  else
702
 
  {
703
 
    if (create_table_proto_file(path, db, table_name, create_info,
704
 
                                create_fields, keys, key_info))
705
 
      return 1;
706
 
  }
 
380
  
 
381
 
 
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))
 
386
 
 
387
    return(1);
707
388
 
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,
714
 
                      create_info,0))
 
395
  if (!create_info->frm_only && ha_create_table(thd, path, db, table_name,
 
396
                                                create_info,0))
715
397
    goto err_handler;
716
 
  return 0;
 
398
  return(0);
717
399
 
718
400
err_handler:
719
 
  file->ha_create_handler_files(path, NULL, CHF_DELETE_FLAG, create_info);
720
 
 
721
 
  delete_table_proto_file(path);
722
 
 
723
 
  return 1;
 
401
  VOID(file->ha_create_handler_files(path, NULL, CHF_DELETE_FLAG, create_info));
 
402
  my_delete(frm_name, MYF(0));
 
403
  return(1);
724
404
} /* rea_create_table */
 
405
 
 
406
 
 
407
        /* Pack screens to a screen for save in a form-file */
 
408
 
 
409
static uchar *pack_screens(List<Create_field> &create_fields,
 
410
                           uint *info_length, uint *screens,
 
411
                           bool small_file)
 
412
{
 
413
  register uint i;
 
414
  uint row,start_row,end_row,fields_on_screen;
 
415
  uint length,cols;
 
416
  uchar *info,*pos,*start_screen;
 
417
  uint fields=create_fields.elements;
 
418
  List_iterator<Create_field> it(create_fields);
 
419
  
 
420
 
 
421
  start_row=4; end_row=22; cols=80; fields_on_screen=end_row+1-start_row;
 
422
 
 
423
  *screens=(fields-1)/fields_on_screen+1;
 
424
  length= (*screens) * (SC_INFO_LENGTH+ (cols>> 1)+4);
 
425
 
 
426
  Create_field *field;
 
427
  while ((field=it++))
 
428
    length+=(uint) strlen(field->field_name)+1+TE_INFO_LENGTH+cols/2;
 
429
 
 
430
  if (!(info=(uchar*) my_malloc(length,MYF(MY_WME))))
 
431
    return(0);
 
432
 
 
433
  start_screen=0;
 
434
  row=end_row;
 
435
  pos=info;
 
436
  it.rewind();
 
437
  for (i=0 ; i < fields ; i++)
 
438
  {
 
439
    Create_field *cfield=it++;
 
440
    if (row++ == end_row)
 
441
    {
 
442
      if (i)
 
443
      {
 
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);
 
448
      }
 
449
      row=start_row;
 
450
      start_screen=pos;
 
451
      pos+=4;
 
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),' ');
 
456
      pos+=(cols >> 1)+4;
 
457
    }
 
458
    length=(uint) strlen(cfield->field_name);
 
459
    if (length > cols-3)
 
460
      length=cols-3;
 
461
 
 
462
    if (!small_file)
 
463
    {
 
464
      pos[0]=(uchar) row;
 
465
      pos[1]=0;
 
466
      pos[2]=(uchar) (length+1);
 
467
      pos=(uchar*) strmake((char*) pos+3,cfield->field_name,length)+1;
 
468
    }
 
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));
 
472
  }
 
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);
 
477
 
 
478
  *info_length=(uint) (pos-info);
 
479
  return(info);
 
480
} /* pack_screens */
 
481
 
 
482
 
 
483
        /* Pack keyinfo and keynames to keybuff for save in form-file. */
 
484
 
 
485
static uint pack_keys(uchar *keybuff, uint key_count, KEY *keyinfo,
 
486
                      ulong data_offset)
 
487
{
 
488
  uint key_parts,length;
 
489
  uchar *pos, *keyname_pos;
 
490
  KEY *key,*end;
 
491
  KEY_PART_INFO *key_part,*key_part_end;
 
492
  
 
493
 
 
494
  pos=keybuff+6;
 
495
  key_parts=0;
 
496
  for (key=keyinfo,end=keyinfo+key_count ; key != end ; key++)
 
497
  {
 
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);
 
503
    pos+=8;
 
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 ;
 
507
         key_part++)
 
508
 
 
509
    {
 
510
      uint offset;
 
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);
 
517
      pos+=9;
 
518
    }
 
519
  }
 
520
        /* Save keynames */
 
521
  keyname_pos=pos;
 
522
  *pos++=(uchar) NAMES_SEP_CHAR;
 
523
  for (key=keyinfo ; key != end ; key++)
 
524
  {
 
525
    uchar *tmp=(uchar*) stpcpy((char*) pos,key->name);
 
526
    *tmp++= (uchar) NAMES_SEP_CHAR;
 
527
    *tmp=0;
 
528
    pos=tmp;
 
529
  }
 
530
  *(pos++)=0;
 
531
 
 
532
  for (key=keyinfo,end=keyinfo+key_count ; key != end ; key++)
 
533
  {
 
534
    if (key->flags & HA_USES_COMMENT)
 
535
    {
 
536
      int2store(pos, key->comment.length);
 
537
      uchar *tmp= (uchar*)stpncpy((char*) pos+2,key->comment.str,key->comment.length);
 
538
      pos= tmp;
 
539
    }
 
540
  }
 
541
 
 
542
  if (key_count > 127 || key_parts > 127)
 
543
  {
 
544
    keybuff[0]= (key_count & 0x7f) | 0x80;
 
545
    keybuff[1]= key_count >> 7;
 
546
    int2store(keybuff+2,key_parts);
 
547
  }
 
548
  else
 
549
  {
 
550
    keybuff[0]=(uchar) key_count;
 
551
    keybuff[1]=(uchar) key_parts;
 
552
    keybuff[2]= keybuff[3]= 0;
 
553
  }
 
554
  length=(uint) (pos-keyname_pos);
 
555
  int2store(keybuff+4,length);
 
556
  return((uint) (pos-keybuff));
 
557
} /* pack_keys */
 
558
 
 
559
 
 
560
/* Make formheader */
 
561
 
 
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)
 
567
{
 
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;
 
571
 
 
572
 
 
573
  if (create_fields.elements > MAX_FIELDS)
 
574
  {
 
575
    my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF(0));
 
576
    return(1);
 
577
  }
 
578
 
 
579
  totlength= 0L;
 
580
  reclength= data_offset;
 
581
  no_empty=int_count=int_parts=int_length=time_stamp_pos=null_fields=
 
582
    com_length=0;
 
583
  n_length=2L;
 
584
 
 
585
        /* Check fields */
 
586
 
 
587
  List_iterator<Create_field> it(create_fields);
 
588
  Create_field *field;
 
589
  while ((field=it++))
 
590
  {
 
591
    uint tmp_len= system_charset_info->cset->charpos(system_charset_info,
 
592
                                                     field->comment.str,
 
593
                                                     field->comment.str +
 
594
                                                     field->comment.length,
 
595
                                                     COLUMN_COMMENT_MAXLEN);
 
596
 
 
597
    if (tmp_len < field->comment.length)
 
598
    {
 
599
      my_error(ER_WRONG_STRING_LENGTH, MYF(0),
 
600
               field->comment.str,"COLUMN COMMENT",
 
601
               (uint) COLUMN_COMMENT_MAXLEN);
 
602
      return(1);
 
603
    }
 
604
 
 
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)
 
609
    {
 
610
      field->unireg_check= (Field::utype) ((uint) field->unireg_check |
 
611
                                           MTYP_NOEMPTY_BIT);
 
612
      no_empty++;
 
613
    }
 
614
    /* 
 
615
      We mark first TIMESTAMP field with NOW() in DEFAULT or ON UPDATE 
 
616
      as auto-update field.
 
617
    */
 
618
    if (field->sql_type == DRIZZLE_TYPE_TIMESTAMP &&
 
619
        MTYP_TYPENR(field->unireg_check) != Field::NONE &&
 
620
        !time_stamp_pos)
 
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;
 
630
    if (field->interval)
 
631
    {
 
632
      uint old_int_count=int_count;
 
633
 
 
634
      if (field->charset->mbminlen > 1)
 
635
      {
 
636
        /* 
 
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.
 
643
        */
 
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);
 
653
 
 
654
        for (uint pos= 0; pos < field->interval->count; pos++)
 
655
        {
 
656
          char *dst;
 
657
          const char *src= field->save_interval->type_names[pos];
 
658
          uint hex_length;
 
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 +
 
663
                                                                   1);
 
664
          octet2hex(dst, src, length);
 
665
        }
 
666
      }
 
667
 
 
668
      field->interval_id=get_interval_id(&int_count,create_fields,field);
 
669
      if (old_int_count != int_count)
 
670
      {
 
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;
 
674
      }
 
675
    }
 
676
    if (f_maybe_null(field->pack_flag))
 
677
      null_fields++;
 
678
  }
 
679
  int_length+=int_count*2;                      // 255 prefix + 0 suffix
 
680
 
 
681
        /* Save values in forminfo */
 
682
 
 
683
  if (reclength > (ulong) file->max_record_length())
 
684
  {
 
685
    my_error(ER_TOO_BIG_ROWSIZE, MYF(0), (uint) file->max_record_length());
 
686
    return(1);
 
687
  }
 
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)
 
692
  {
 
693
    my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF(0));
 
694
    return(1);
 
695
  }
 
696
 
 
697
  memset(forminfo, 0, 288);
 
698
  length=(info_length+create_fields.elements*FCOMP+288+n_length+int_length+
 
699
          com_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 */
 
717
  return(0);
 
718
} /* pack_header */
 
719
 
 
720
 
 
721
        /* get each unique interval each own id */
 
722
 
 
723
static uint get_interval_id(uint *int_count,List<Create_field> &create_fields,
 
724
                            Create_field *last_field)
 
725
{
 
726
  List_iterator<Create_field> it(create_fields);
 
727
  Create_field *field;
 
728
  TYPELIB *interval=last_field->interval;
 
729
 
 
730
  while ((field=it++) != last_field)
 
731
  {
 
732
    if (field->interval_id && field->interval->count == interval->count)
 
733
    {
 
734
      const char **a,**b;
 
735
      for (a=field->interval->type_names, b=interval->type_names ;
 
736
           *a && !strcmp(*a,*b);
 
737
           a++,b++) ;
 
738
 
 
739
      if (! *a)
 
740
      {
 
741
        return field->interval_id;              // Re-use last interval
 
742
      }
 
743
    }
 
744
  }
 
745
  return ++*int_count;                          // New unique interval
 
746
}
 
747
 
 
748
 
 
749
        /* Save fields, fieldnames and intervals */
 
750
 
 
751
static bool pack_fields(File file, List<Create_field> &create_fields,
 
752
                        ulong data_offset)
 
753
{
 
754
  register uint i;
 
755
  uint int_count, comment_length=0;
 
756
  uchar buff[MAX_FIELD_WIDTH];
 
757
  Create_field *field;
 
758
  
 
759
 
 
760
        /* Write field info */
 
761
 
 
762
  List_iterator<Create_field> it(create_fields);
 
763
 
 
764
  int_count=0;
 
765
  while ((field=it++))
 
766
  {
 
767
    uint recpos;
 
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; 
 
779
    if (field->charset) 
 
780
      buff[14]= (uchar) field->charset->number;
 
781
    else
 
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))
 
787
      return(1);
 
788
  }
 
789
 
 
790
        /* Write fieldnames */
 
791
  buff[0]=(uchar) NAMES_SEP_CHAR;
 
792
  if (my_write(file, buff, 1, MYF_RW))
 
793
    return(1);
 
794
  i=0;
 
795
  it.rewind();
 
796
  while ((field=it++))
 
797
  {
 
798
    char *pos= stpcpy((char*) buff,field->field_name);
 
799
    *pos++=NAMES_SEP_CHAR;
 
800
    if (i == create_fields.elements-1)
 
801
      *pos++=0;
 
802
    if (my_write(file, buff, (size_t) (pos-(char*) buff),MYF_RW))
 
803
      return(1);
 
804
    i++;
 
805
  }
 
806
 
 
807
        /* Write intervals */
 
808
  if (int_count)
 
809
  {
 
810
    String tmp((char*) buff,sizeof(buff), &my_charset_bin);
 
811
    tmp.length(0);
 
812
    it.rewind();
 
813
    int_count=0;
 
814
    while ((field=it++))
 
815
    {
 
816
      if (field->interval_id > int_count)
 
817
      {
 
818
        unsigned char  sep= 0;
 
819
        unsigned char  occ[256];
 
820
        uint           i;
 
821
        unsigned char *val= NULL;
 
822
 
 
823
        memset(occ, 0, sizeof(occ));
 
824
 
 
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;
 
828
 
 
829
        if (!occ[(unsigned char)NAMES_SEP_CHAR])
 
830
          sep= (unsigned char) NAMES_SEP_CHAR;
 
831
        else if (!occ[(unsigned int)','])
 
832
          sep= ',';
 
833
        else
 
834
        {
 
835
          for (uint i=1; i<256; i++)
 
836
          {
 
837
            if(!occ[i])
 
838
            {
 
839
              sep= i;
 
840
              break;
 
841
            }
 
842
          }
 
843
 
 
844
          if(!sep)    /* disaster, enum uses all characters, none left as separator */
 
845
          {
 
846
            my_message(ER_WRONG_FIELD_TERMINATORS,ER(ER_WRONG_FIELD_TERMINATORS),
 
847
                       MYF(0));
 
848
            return(1);
 
849
          }
 
850
        }
 
851
 
 
852
        int_count= field->interval_id;
 
853
        tmp.append(sep);
 
854
        for (const char **pos=field->interval->type_names ; *pos ; pos++)
 
855
        {
 
856
          tmp.append(*pos);
 
857
          tmp.append(sep);
 
858
        }
 
859
        tmp.append('\0');                      // End of intervall
 
860
      }
 
861
    }
 
862
    if (my_write(file,(uchar*) tmp.ptr(),tmp.length(),MYF_RW))
 
863
      return(1);
 
864
  }
 
865
  if (comment_length)
 
866
  {
 
867
    it.rewind();
 
868
    int_count=0;
 
869
    while ((field=it++))
 
870
    {
 
871
      if (field->comment.length)
 
872
        if (my_write(file, (uchar*) field->comment.str, field->comment.length,
 
873
                     MYF_RW))
 
874
          return(1);
 
875
    }
 
876
  }
 
877
  return(0);
 
878
}
 
879
 
 
880
 
 
881
/* save an empty record on start of formfile */
 
882
 
 
883
static bool make_empty_rec(THD *thd, File file,
 
884
                           enum legacy_db_type table_type __attribute__((unused)),
 
885
                           uint table_options,
 
886
                           List<Create_field> &create_fields,
 
887
                           uint reclength,
 
888
                           ulong data_offset,
 
889
                           handler *handler)
 
890
{
 
891
  int error= 0;
 
892
  Field::utype type;
 
893
  uint null_count;
 
894
  uchar *buff,*null_pos;
 
895
  Table table;
 
896
  TABLE_SHARE share;
 
897
  Create_field *field;
 
898
  enum_check_fields old_count_cuted_fields= thd->count_cuted_fields;
 
899
  
 
900
 
 
901
  /* We need a table to generate columns for default values */
 
902
  memset(&table, 0, sizeof(table));
 
903
  memset(&share, 0, sizeof(share));
 
904
  table.s= &share;
 
905
 
 
906
  if (!(buff=(uchar*) my_malloc((size_t) reclength,MYF(MY_WME | MY_ZEROFILL))))
 
907
  {
 
908
    return(1);
 
909
  }
 
910
 
 
911
  table.in_use= thd;
 
912
  table.s->db_low_byte_first= handler->low_byte_first();
 
913
  table.s->blob_ptr_size= portable_sizeof_char_ptr;
 
914
 
 
915
  null_count=0;
 
916
  if (!(table_options & HA_OPTION_PACK_RECORD))
 
917
  {
 
918
    null_count++;                       // Need one bit for delete mark
 
919
    *buff|= 1;
 
920
  }
 
921
  null_pos= buff;
 
922
 
 
923
  List_iterator<Create_field> it(create_fields);
 
924
  thd->count_cuted_fields= CHECK_FIELD_WARN;    // To find wrong default values
 
925
  while ((field=it++))
 
926
  {
 
927
    /*
 
928
      regfield don't have to be deleted as it's allocated with sql_alloc()
 
929
    */
 
930
    Field *regfield= make_field(&share,
 
931
                                buff+field->offset + data_offset,
 
932
                                field->length,
 
933
                                null_pos + null_count / 8,
 
934
                                null_count & 7,
 
935
                                field->pack_flag,
 
936
                                field->sql_type,
 
937
                                field->charset,
 
938
                                field->unireg_check,
 
939
                                field->save_interval ? field->save_interval :
 
940
                                field->interval, 
 
941
                                field->field_name);
 
942
    if (!regfield)
 
943
    {
 
944
      error= 1;
 
945
      goto err;                                 // End of memory
 
946
    }
 
947
 
 
948
    /* save_in_field() will access regfield->table->in_use */
 
949
    regfield->init(&table);
 
950
 
 
951
    if (!(field->flags & NOT_NULL_FLAG))
 
952
    {
 
953
      *regfield->null_ptr|= regfield->null_bit;
 
954
      null_count++;
 
955
    }
 
956
 
 
957
    type= (Field::utype) MTYP_TYPENR(field->unireg_check);
 
958
 
 
959
    if (field->def)
 
960
    {
 
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)
 
964
      {
 
965
        my_error(ER_INVALID_DEFAULT, MYF(0), regfield->field_name);
 
966
        error= 1;
 
967
        delete regfield; //To avoid memory leak
 
968
        goto err;
 
969
      }
 
970
    }
 
971
    else if (regfield->real_type() == DRIZZLE_TYPE_ENUM &&
 
972
             (field->flags & NOT_NULL_FLAG))
 
973
    {
 
974
      regfield->set_notnull();
 
975
      regfield->store((int64_t) 1, true);
 
976
    }
 
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);
 
981
    else
 
982
      regfield->reset();
 
983
  }
 
984
  assert(data_offset == ((null_count + 7) / 8));
 
985
 
 
986
  /*
 
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.
 
989
  */
 
990
  if (null_count & 7)
 
991
    *(null_pos + null_count / 8)|= ~(((uchar) 1 << (null_count & 7)) - 1);
 
992
 
 
993
  error= my_write(file, buff, (size_t) reclength,MYF_RW) != 0;
 
994
 
 
995
err:
 
996
  my_free(buff, MYF(MY_FAE));
 
997
  thd->count_cuted_fields= old_count_cuted_fields;
 
998
  return(error);
 
999
} /* make_empty_rec */