1
1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
2
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
4
* Copyright (C) 2008-2009 Sun Microsystems, Inc.
4
* Copyright (C) 2008-2009 Sun Microsystems
6
6
* This program is free software; you can redistribute it and/or modify
7
7
* it under the terms of the GNU General Public License as published by
21
21
* @file Implementation of CreateField class
24
#include "drizzled/server_includes.h"
27
#include <drizzled/sql_select.h>
28
#include <drizzled/error.h>
29
#include <drizzled/field.h>
30
#include <drizzled/create_field.h>
31
#include <drizzled/field/str.h>
32
#include <drizzled/field/num.h>
33
#include <drizzled/field/blob.h>
34
#include <drizzled/field/boolean.h>
35
#include <drizzled/field/enum.h>
36
#include <drizzled/field/null.h>
37
#include <drizzled/field/date.h>
38
#include <drizzled/field/decimal.h>
39
#include <drizzled/field/real.h>
40
#include <drizzled/field/double.h>
41
#include <drizzled/field/int32.h>
42
#include <drizzled/field/int64.h>
43
#include <drizzled/field/num.h>
44
#include <drizzled/field/epoch.h>
45
#include <drizzled/field/datetime.h>
46
#include <drizzled/field/varstring.h>
47
#include <drizzled/field/uuid.h>
48
#include <drizzled/temporal.h>
49
#include <drizzled/item/string.h>
50
#include <drizzled/table.h>
52
#include <drizzled/display.h>
26
#include "drizzled/sql_select.h"
27
#include "drizzled/error.h"
28
#include "drizzled/field.h"
29
#include "drizzled/create_field.h"
30
#include "drizzled/field/str.h"
31
#include "drizzled/field/num.h"
32
#include "drizzled/field/blob.h"
33
#include "drizzled/field/enum.h"
34
#include "drizzled/field/null.h"
35
#include "drizzled/field/date.h"
36
#include "drizzled/field/decimal.h"
37
#include "drizzled/field/real.h"
38
#include "drizzled/field/double.h"
39
#include "drizzled/field/long.h"
40
#include "drizzled/field/int64_t.h"
41
#include "drizzled/field/num.h"
42
#include "drizzled/field/timestamp.h"
43
#include "drizzled/field/datetime.h"
44
#include "drizzled/field/varstring.h"
45
#include "drizzled/temporal.h"
54
47
#include <algorithm>
56
49
using namespace std;
61
52
/** Create a field suitable for create of table. */
62
53
CreateField::CreateField(Field *old_field, Field *orig_field)
98
if (flags & ENUM_FLAG)
87
if (flags & (ENUM_FLAG | SET_FLAG))
99
88
interval= ((Field_enum*) old_field)->typelib;
103
92
char_length= length;
105
if (!(flags & (NO_DEFAULT_VALUE_FLAG)) &&
106
!(flags & AUTO_INCREMENT_FLAG) &&
94
if (!(flags & (NO_DEFAULT_VALUE_FLAG )) &&
107
95
old_field->ptr && orig_field &&
108
(not old_field->is_timestamp() || /* set def only if */
109
old_field->getTable()->timestamp_field != old_field || /* timestamp field */
96
(sql_type != DRIZZLE_TYPE_TIMESTAMP || /* set def only if */
97
old_field->table->timestamp_field != old_field || /* timestamp field */
110
98
unireg_check == Field::TIMESTAMP_UN_FIELD)) /* has default val */
114
102
/* Get the value from default_values */
115
diff= (ptrdiff_t) (orig_field->getTable()->getDefaultValues() - orig_field->getTable()->getInsertRecord());
103
diff= (ptrdiff_t) (orig_field->table->s->default_values - orig_field->table->record[0]);
116
104
orig_field->move_field_offset(diff); // Points now at default_values
117
105
if (! orig_field->is_real_null())
119
107
char buff[MAX_FIELD_WIDTH], *pos;
120
108
String tmp(buff, sizeof(buff), charset), *res;
121
res= orig_field->val_str_internal(&tmp);
122
pos= (char*) memory::sql_strmake(res->ptr(), res->length());
109
res= orig_field->val_str(&tmp);
110
pos= (char*) sql_strmake(res->ptr(), res->length());
123
111
def= new Item_string(pos, res->length(), charset);
125
orig_field->move_field_offset(-diff); // Back to getInsertRecord()
113
orig_field->move_field_offset(-diff); // Back to record[0]
172
159
unireg_check= Field::NONE;
174
161
charset= &my_charset_bin;
175
decimals= decimals_arg & FIELDFLAG_MAX_DEC;
178
flags= NOT_NULL_FLAG;
162
pack_flag= (FIELDFLAG_NUMBER |
163
((decimals_arg & FIELDFLAG_MAX_DEC) << FIELDFLAG_DEC_SHIFT) |
164
(maybe_null ? FIELDFLAG_MAYBE_NULL : 0) |
165
(is_unsigned ? 0 : FIELDFLAG_DECIMAL));
183
168
bool CreateField::init(Session *,
230
215
it is NOT NULL, not an AUTO_INCREMENT field and not a TIMESTAMP.
232
217
if (!fld_default_value && !(fld_type_modifier & AUTO_INCREMENT_FLAG) &&
233
(fld_type_modifier & NOT_NULL_FLAG) && (fld_type != DRIZZLE_TYPE_TIMESTAMP and fld_type != DRIZZLE_TYPE_MICROTIME))
218
(fld_type_modifier & NOT_NULL_FLAG) && fld_type != DRIZZLE_TYPE_TIMESTAMP)
235
219
flags|= NO_DEFAULT_VALUE_FLAG;
238
221
if (fld_length && !(length= (uint32_t) atoi(fld_length)))
222
fld_length= 0; /* purecov: inspected */
240
223
sign_len= fld_type_modifier & UNSIGNED_FLAG ? 0 : 1;
242
225
switch (fld_type)
227
case DRIZZLE_TYPE_TINY:
229
length= MAX_TINYINT_WIDTH+sign_len;
230
allowed_type_modifier= AUTO_INCREMENT_FLAG;
244
232
case DRIZZLE_TYPE_LONG:
246
234
length= MAX_INT_WIDTH+sign_len;
254
242
case DRIZZLE_TYPE_NULL:
256
case DRIZZLE_TYPE_DECIMAL:
257
class_decimal_trim(&length, &decimals);
244
case DRIZZLE_TYPE_NEWDECIMAL:
245
my_decimal_trim(&length, &decimals);
258
246
if (length > DECIMAL_MAX_PRECISION)
260
248
my_error(ER_TOO_BIG_PRECISION, MYF(0), length, fld_name,
266
254
my_error(ER_M_BIGGER_THAN_D, MYF(0), fld_name);
269
length= class_decimal_precision_to_length(length, decimals, fld_type_modifier & UNSIGNED_FLAG);
270
pack_length= class_decimal_get_binary_size(length, decimals);
257
length= my_decimal_precision_to_length(length, decimals, fld_type_modifier & UNSIGNED_FLAG);
258
pack_length= my_decimal_get_binary_size(length, decimals);
272
260
case DRIZZLE_TYPE_VARCHAR:
308
case DRIZZLE_TYPE_MICROTIME:
310
This assert() should be correct due to absence of length
311
specifiers for timestamp. Previous manipulation also wasn't
312
ever called (from examining lcov)
315
296
case DRIZZLE_TYPE_TIMESTAMP:
316
length= MicroTimestamp::MAX_STRING_LENGTH;
299
length= drizzled::DateTime::MAX_STRING_LENGTH;
302
/* This assert() should be correct due to absence of length
303
specifiers for timestamp. Previous manipulation also wasn't
304
ever called (from examining lcov)
306
assert(length == (uint32_t)drizzled::DateTime::MAX_STRING_LENGTH);
308
flags|= UNSIGNED_FLAG;
318
309
if (fld_default_value)
320
311
/* Grammar allows only NOW() value for ON UPDATE clause */
358
347
case DRIZZLE_TYPE_DATE:
359
length= Date::MAX_STRING_LENGTH;
361
case DRIZZLE_TYPE_UUID:
362
length= field::Uuid::max_string_length();
364
case DRIZZLE_TYPE_BOOLEAN:
365
length= field::Boolean::max_string_length();
348
length= drizzled::Date::MAX_STRING_LENGTH;
367
350
case DRIZZLE_TYPE_DATETIME:
368
length= DateTime::MAX_STRING_LENGTH;
370
case DRIZZLE_TYPE_TIME:
371
length= DateTime::MAX_STRING_LENGTH;
351
length= drizzled::DateTime::MAX_STRING_LENGTH;
373
353
case DRIZZLE_TYPE_ENUM:
375
355
/* Should be safe. */
356
pack_length= get_enum_pack_length(fld_interval_list->elements);
378
List<String>::iterator it(fld_interval_list->begin());
358
List_iterator<String> it(*fld_interval_list);
380
360
while ((tmp= it++))
381
361
interval_list.push_back(tmp);
407
387
return false; /* success */
410
std::ostream& operator<<(std::ostream& output, const CreateField &field)
412
output << "CreateField:(";
413
output << field.field_name;
415
output << drizzled::display::type(field.type());
418
if (field.flags & NOT_NULL_FLAG)
419
output << " NOT_NULL";
421
if (field.flags & PRI_KEY_FLAG)
422
output << ", PRIMARY KEY";
424
if (field.flags & UNIQUE_KEY_FLAG)
425
output << ", UNIQUE KEY";
427
if (field.flags & MULTIPLE_KEY_FLAG)
428
output << ", MULTIPLE KEY";
430
if (field.flags & BLOB_FLAG)
433
if (field.flags & UNSIGNED_FLAG)
434
output << ", UNSIGNED";
436
if (field.flags & BINARY_FLAG)
437
output << ", BINARY";
440
output << *field.field;
443
return output; // for multiple << operators.
446
} /* namespace drizzled */