field.cc 121 KB
Newer Older
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1
/* Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3 4 5 6
   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
7

bk@work.mysql.com's avatar
bk@work.mysql.com committed
8 9 10 11
   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
12

bk@work.mysql.com's avatar
bk@work.mysql.com committed
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */


/*****************************************************************************
** This file implements classes defined in field.h
*****************************************************************************/

#ifdef __GNUC__
#pragma implementation				// gcc: Class implementation
#endif

#include "mysql_priv.h"
#include "sql_select.h"
#include <m_ctype.h>
#include <errno.h>
#ifdef HAVE_FCONVERT
#include <floatingpoint.h>
#endif

peter@mysql.com's avatar
peter@mysql.com committed
34 35 36
// Maximum allowed exponent value for converting string to decimal
#define MAX_EXPONENT 1024

bk@work.mysql.com's avatar
bk@work.mysql.com committed
37
/*****************************************************************************
38
  Instansiate templates and static variables
bk@work.mysql.com's avatar
bk@work.mysql.com committed
39 40 41 42 43 44 45 46 47 48 49
*****************************************************************************/

#ifdef __GNUC__
template class List<create_field>;
template class List_iterator<create_field>;
#endif

uchar Field_null::null[1]={1};
const char field_separator=',';

/*****************************************************************************
50
  Static help functions
bk@work.mysql.com's avatar
bk@work.mysql.com committed
51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
*****************************************************************************/

void Field_num::prepend_zeros(String *value)
{
  int diff;
  if ((diff= (int) (field_length - value->length())) > 0)
  {
    bmove_upp((char*) value->ptr()+field_length,value->ptr()+value->length(),
	      value->length());
    bfill((char*) value->ptr(),diff,'0');
    value->length(field_length);
    (void) value->c_ptr_quick();		// Avoid warnings in purify
  }
}

/*
67
  Test if given number is a int (or a fixed format float with .000)
68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84

  SYNOPSIS
    test_if_int()
    str		String to test
    end		Pointer to char after last used digit
    cs		Character set

  NOTES
    This is called after one has called my_strntol() or similar function.
    This is only used to give warnings in ALTER TABLE or LOAD DATA...

  TODO
    Make this multi-byte-character safe

  RETURN
    0	ok
    1	error
bk@work.mysql.com's avatar
bk@work.mysql.com committed
85 86
*/

87 88
bool test_if_int(const char *str, int length, const char *int_end,
		 CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
89
{
90 91
  if (str == int_end)
    return 0;					// Empty string
bk@work.mysql.com's avatar
bk@work.mysql.com committed
92
  const char *end=str+length;
93 94
  if ((str= int_end) == end)
    return 1;					// All digits was used
bk@work.mysql.com's avatar
bk@work.mysql.com committed
95

96 97
  /* Allow end .0000 */
  if (*str == '.')
bk@work.mysql.com's avatar
bk@work.mysql.com committed
98
  {
99 100 101 102 103 104 105
    for (str++ ; str != end && *str == '0'; str++) ;
  }
  /* Allow end space */
  for (str++ ; str != end ; str++)
  {
    if (!my_isspace(cs,*str))
      return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
106 107 108 109 110
  }
  return 1;
}


111
static bool test_if_real(const char *str,int length, CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
112
{
113
  cs= system_charset_info; // QQ move test_if_real into CHARSET_INFO struct
114 115

  while (length && my_isspace(cs,*str))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
116 117 118 119 120 121 122 123
  {						// Allow start space
    length--; str++;
  }
  if (!length)
    return 0;
  if (*str == '+' || *str == '-')
  {
    length--; str++;
124
    if (!length || !(my_isdigit(cs,*str) || *str == '.'))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
125 126
      return 0;
  }
127
  while (length && my_isdigit(cs,*str))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
128 129 130 131 132 133 134 135
  {
    length--; str++;
  }
  if (!length)
    return 1;
  if (*str == '.')
  {
    length--; str++;
136
    while (length && my_isdigit(cs,*str))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
137 138 139 140 141 142 143 144
    {
      length--; str++;
    }
  }
  if (!length)
    return 1;
  if (*str == 'E' || *str == 'e')
  {
145
    if (length < 3 || (str[1] != '+' && str[1] != '-') || 
146
        !my_isdigit(cs,str[2]))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
147 148 149
      return 0;
    length-=3;
    str+=3;
150
    while (length && my_isdigit(cs,*str))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
151 152 153 154
    {
      length--; str++;
    }
  }
155
  for (; length ; length--, str++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
156
  {						// Allow end space
157
    if (!my_isspace(cs,*str))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
158 159 160 161 162 163 164 165
      return 0;
  }
  return 1;
}


/****************************************************************************
** Functions for the base classes
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
166
** This is an unpacked number.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
167 168 169
****************************************************************************/

Field::Field(char *ptr_arg,uint32 length_arg,uchar *null_ptr_arg,
170
	     uchar null_bit_arg,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
171 172
	     utype unireg_check_arg, const char *field_name_arg,
	     struct st_table *table_arg)
173 174 175 176 177 178
  :ptr(ptr_arg),null_ptr(null_ptr_arg),
   table(table_arg),table_name(table_arg ? table_arg->table_name : 0),
   field_name(field_name_arg),
   query_id(0),key_start(0),part_of_key(0),part_of_sortkey(0),
   unireg_check(unireg_check_arg),
   field_length(length_arg),null_bit(null_bit_arg)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
179 180
{
  flags=null_ptr ? 0: NOT_NULL_FLAG;
181 182
  comment.str= (char*) "";
  comment.length=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
183 184 185 186 187 188 189 190 191 192 193 194 195
}

uint Field::offset()
{
  return (uint) (ptr - (char*) table->record[0]);
}


void Field::copy_from_tmp(int row_offset)
{
  memcpy(ptr,ptr+row_offset,pack_length());
  if (null_ptr)
  {
196 197
    *null_ptr= (uchar) ((null_ptr[0] & (uchar) ~(uint) null_bit) |
			null_ptr[row_offset] & (uchar) null_bit);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
198 199 200 201
  }
}


202
bool Field::send_binary(Protocol *protocol)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
203 204
{
  char buff[MAX_FIELD_WIDTH];
205
  String tmp(buff,sizeof(buff),charset());
bk@work.mysql.com's avatar
bk@work.mysql.com committed
206
  val_str(&tmp,&tmp);
207
  return protocol->store(tmp.ptr(), tmp.length(), tmp.charset());
bk@work.mysql.com's avatar
bk@work.mysql.com committed
208 209 210 211 212
}


void Field_num::add_zerofill_and_unsigned(String &res) const
{
213 214 215 216
  if (unsigned_flag)
    res.append(" unsigned");
  if (zerofill)
    res.append(" zerofill");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
217 218 219 220
}

void Field_num::make_field(Send_field *field)
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
221
  /* table_cache_key is not set for temp tables */
222 223
  field->db_name=table->table_cache_key ? table->table_cache_key : ""; 
  field->org_table_name=table->real_name;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
224
  field->table_name=table_name;
225
  field->col_name=field->org_col_name=field_name;
226
  field->charsetnr= charset()->number;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
227 228 229 230 231 232 233 234 235
  field->length=field_length;
  field->type=type();
  field->flags=table->maybe_null ? (flags & ~NOT_NULL_FLAG) : flags;
  field->decimals=dec;
}


void Field_str::make_field(Send_field *field)
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
236
  /* table_cache_key is not set for temp tables */
237 238
  field->db_name=table->table_cache_key ? table->table_cache_key : ""; 
  field->org_table_name=table->real_name;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
239
  field->table_name=table_name;
240
  field->col_name=field->org_col_name=field_name;
241
  field->charsetnr= charset()->number;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
242 243 244 245 246 247
  field->length=field_length;
  field->type=type();
  field->flags=table->maybe_null ? (flags & ~NOT_NULL_FLAG) : flags;
  field->decimals=0;
}

248

249 250
void Field_str::add_binary_or_charset(String &res) const
{
251
  if (charset() == &my_charset_bin)
252
    res.append(" binary");
253 254 255 256 257 258 259 260 261
  else  if (field_charset != table->table_charset &&
	    !(current_thd->variables.sql_mode & MODE_NO_FIELD_OPTIONS) &&
	    !(current_thd->variables.sql_mode & MODE_MYSQL323) &&
	    !(current_thd->variables.sql_mode & MODE_MYSQL40) &&
	    !(current_thd->variables.sql_mode & MODE_POSTGRESQL) &&
	    !(current_thd->variables.sql_mode & MODE_ORACLE) &&
	    !(current_thd->variables.sql_mode & MODE_MSSQL) &&
	    !(current_thd->variables.sql_mode & MODE_DB2) &&
	    !(current_thd->variables.sql_mode & MODE_SAPDB))
262
  {
263 264
    res.append(" character set ");
    res.append(field_charset->csname);
265 266 267
  }
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291

uint Field::fill_cache_field(CACHE_FIELD *copy)
{
  copy->str=ptr;
  copy->length=pack_length();
  copy->blob_field=0;
  if (flags & BLOB_FLAG)
  {
    copy->blob_field=(Field_blob*) this;
    copy->strip=0;
    copy->length-=table->blob_ptr_size;
    return copy->length;
  }
  else if (!zero_pack() && (type() == FIELD_TYPE_STRING && copy->length > 4 ||
			    type() == FIELD_TYPE_VAR_STRING))
    copy->strip=1;				/* Remove end space */
  else
    copy->strip=0;
  return copy->length+(int) copy->strip;
}

bool Field::get_date(TIME *ltime,bool fuzzydate)
{
  char buff[40];
292
  String tmp(buff,sizeof(buff),&my_charset_bin),tmp2,*res;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
293 294 295 296 297 298 299 300 301
  if (!(res=val_str(&tmp,&tmp2)) ||
      str_to_TIME(res->ptr(),res->length(),ltime,fuzzydate) == TIMESTAMP_NONE)
    return 1;
  return 0;
}

bool Field::get_time(TIME *ltime)
{
  char buff[40];
302
  String tmp(buff,sizeof(buff),&my_charset_bin),tmp2,*res;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
303
  if (!(res=val_str(&tmp,&tmp2)) ||
tim@cane.mysql.fi's avatar
tim@cane.mysql.fi committed
304
      str_to_time(res->ptr(),res->length(),ltime))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
305 306 307 308 309 310 311 312 313 314 315
    return 1;
  return 0;
}


/* This is called when storing a date in a string */
void Field::store_time(TIME *ltime,timestamp_type type)
{
  char buff[25];
  switch (type)  {
  case TIMESTAMP_NONE:
316
    store("",0,&my_charset_bin);	// Probably an error
bk@work.mysql.com's avatar
bk@work.mysql.com committed
317 318 319
    break;
  case TIMESTAMP_DATE:
    sprintf(buff,"%04d-%02d-%02d", ltime->year,ltime->month,ltime->day);
320
    store(buff,10,&my_charset_bin);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
321 322 323 324 325
    break;
  case TIMESTAMP_FULL:
    sprintf(buff,"%04d-%02d-%02d %02d:%02d:%02d",
	    ltime->year,ltime->month,ltime->day,
	    ltime->hour,ltime->minute,ltime->second);
326
    store(buff,19,&my_charset_bin);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
327 328
    break;
  case TIMESTAMP_TIME:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
329 330 331
  {
    ulong length= my_sprintf(buff, (buff, "%02d:%02d:%02d",
				    ltime->hour,ltime->minute,ltime->second));
332
    store(buff,(uint) length, &my_charset_bin);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
333 334
    break;
  }
335
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
336 337 338
}


339
bool Field::optimize_range(uint idx)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
340
{
341
  return test(table->file->index_flags(idx) & HA_READ_NEXT);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
342 343
}

344
/****************************************************************************
345
  Field_null, a field that always return NULL
346 347 348 349
****************************************************************************/

void Field_null::sql_type(String &res) const
{
350
  res.set_latin1("null", 4);
351 352 353
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
354
/****************************************************************************
355 356
  Functions for the Field_decimal class
  This is an number stored as a pre-space (or pre-zero) string
bk@work.mysql.com's avatar
bk@work.mysql.com committed
357 358 359 360 361
****************************************************************************/

void
Field_decimal::reset(void)
{
362
  Field_decimal::store("0",1,&my_charset_bin);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
363 364 365 366 367
}

void Field_decimal::overflow(bool negative)
{
  uint len=field_length;
368
  char *to=ptr, filler= '9';
369 370

  current_thd->cuted_fields++;
371
  if (negative)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
372
  {
373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395
    if (!unsigned_flag)
    {
      /* Put - sign as a first digit so we'll have -999..999 or 999..999 */
      *to++ = '-';
      len--;
    }
    else
    {
      filler= '0';				// Fill up with 0
      if (!zerofill)
      {
	/*
	  Handle unsigned integer without zerofill, in which case
	  the number should be of format '   0' or '   0.000'
	*/
	uint whole_part=field_length- (dec ? dec+2 : 1);
	// Fill with spaces up to the first digit
	bfill(to, whole_part, ' ');
	to+=  whole_part;
	len-= whole_part;
	// The main code will also handle the 0 before the decimal point
      }
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
396
  }
397
  bfill(to, len, filler);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
398 399 400 401 402 403
  if (dec)
    ptr[field_length-dec-1]='.';
  return;
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
404
int Field_decimal::store(const char *from, uint len, CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
405
{
406
  char buff[80];
407
  String tmp(buff,sizeof(buff), &my_charset_bin);
408

409 410 411
  /* Convert character set if the old one is multi byte */
  if (cs->mbmaxlen > 1)
  { 
412
    tmp.copy(from, len, cs, &my_charset_bin);
413 414 415
    from= tmp.ptr();
    len=  tmp.length();
  }
416

417 418 419 420 421 422 423 424 425
  const char *end= from+len;
  /* The pointer where the field value starts (i.e., "where to write") */
  char *to=ptr;
  uint tmp_dec, tmp_uint;
  /*
    The sign of the number : will be 0 (means positive but sign not
    specified), '+' or '-'
  */
  char sign_char=0;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
426
  /* The pointers where prezeros start and stop */
427
  const char *pre_zeros_from, *pre_zeros_end;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
428
  /* The pointers where digits at the left of '.' start and stop */
429
  const char *int_digits_from, *int_digits_end;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
430
  /* The pointers where digits at the right of '.' start and stop */
431
  const char *frac_digits_from, *frac_digits_end;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
432
  /* The sign of the exponent : will be 0 (means no exponent), '+' or '-' */
433
  char expo_sign_char=0;
peter@mysql.com's avatar
peter@mysql.com committed
434
  uint exponent=0;                                // value of the exponent
435 436 437 438 439 440 441
  /*
    Pointers used when digits move from the left of the '.' to the
    right of the '.' (explained below)
  */
  const char *int_digits_tail_from;
  /* Number of 0 that need to be added at the left of the '.' (1E3: 3 zeros) */
  uint int_digits_added_zeros;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
442 443 444 445
  /*
    Pointer used when digits move from the right of the '.' to the left
    of the '.'
  */
446
  const char *frac_digits_head_end;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
447
  /* Number of 0 that need to be added at the right of the '.' (for 1E-3) */
448 449 450 451 452
  uint frac_digits_added_zeros;
  char *pos,*tmp_left_pos,*tmp_right_pos;
  /* Pointers that are used as limits (begin and end of the field buffer) */
  char *left_wall,*right_wall;
  char tmp_char;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
453 454 455 456
  /*
    To remember if current_thd->cuted_fields has already been incremented,
    to do that only once
  */
457 458 459 460 461 462 463 464 465
  bool is_cuted_fields_incr=0;

  LINT_INIT(int_digits_tail_from);
  LINT_INIT(int_digits_added_zeros);
  LINT_INIT(frac_digits_head_end);
  LINT_INIT(frac_digits_added_zeros);

  /*
    There are three steps in this function :
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
466 467
    - parse the input string
    - modify the position of digits around the decimal dot '.' 
468
      according to the exponent value (if specified)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
469
    - write the formatted number
470 471 472 473 474
  */

  if ((tmp_dec=dec))
    tmp_dec++;

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
475
  /* skip pre-space */
476
  while (from != end && my_isspace(&my_charset_bin,*from))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
477
    from++;
478
  if (from == end)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
479
  {
480 481
    current_thd->cuted_fields++;
    is_cuted_fields_incr=1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
482
  }
483
  else if (*from == '+' || *from == '-')	// Found some sign ?
bk@work.mysql.com's avatar
bk@work.mysql.com committed
484
  {
485
    sign_char= *from++;
486
    /*
487 488 489
      We allow "+" for unsigned decimal unless defined different
      Both options allowed as one may wish not to have "+" for unsigned numbers
      because of data processing issues
490 491 492 493
    */ 
    if (unsigned_flag)  
    { 
      if (sign_char=='-')
494
      {
495
        Field_decimal::overflow(1);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
496
        return 1;
497
      }
498
      /* 
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
499 500
	 Defining this will not store "+" for unsigned decimal type even if
	 it is passed in numeric string. This will make some tests to fail
501 502
      */	 
#ifdef DONT_ALLOW_UNSIGNED_PLUS      
503 504
      else 
        sign_char=0;
505
#endif 	
bk@work.mysql.com's avatar
bk@work.mysql.com committed
506
    }
507
  }
508

509 510 511 512
  pre_zeros_from= from;
  for (; from!=end && *from == '0'; from++) ;	// Read prezeros
  pre_zeros_end=int_digits_from=from;      
  /* Read non zero digits at the left of '.'*/
513
  for (; from != end && my_isdigit(&my_charset_bin, *from) ; from++) ;
514 515 516 517 518
  int_digits_end=from;
  if (from!=end && *from == '.')		// Some '.' ?
    from++;
  frac_digits_from= from;
  /* Read digits at the right of '.' */
519
  for (;from!=end && my_isdigit(&my_charset_bin, *from); from++) ;
520 521 522 523 524 525 526 527 528 529
  frac_digits_end=from;
  // Some exponentiation symbol ?
  if (from != end && (*from == 'e' || *from == 'E'))
  {   
    from++;
    if (from != end && (*from == '+' || *from == '-'))  // Some exponent sign ?
      expo_sign_char= *from++;
    else
      expo_sign_char= '+';
    /*
530 531 532 533
      Read digits of the exponent and compute its value.  We must care about
      'exponent' overflow, because as unsigned arithmetic is "modulo", big 
      exponents will become small (e.g. 1e4294967296 will become 1e0, and the 
      field will finally contain 1 instead of its max possible value).
534
    */
535
    for (;from!=end && my_isdigit(&my_charset_bin, *from); from++)
536
    {
537
      exponent=10*exponent+(*from-'0');
peter@mysql.com's avatar
peter@mysql.com committed
538
      if (exponent>MAX_EXPONENT)
539 540
        break;
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
541
  }
542
  
bk@work.mysql.com's avatar
bk@work.mysql.com committed
543
  /*
544 545 546 547
    We only have to generate warnings if count_cuted_fields is set.
    This is to avoid extra checks of the number when they are not needed.
    Even if this flag is not set, it's ok to increment warnings, if
    it makes the code easer to read.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
548
  */
549 550

  if (current_thd->count_cuted_fields)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
551
  {
552
    // Skip end spaces
553
    for (;from != end && my_isspace(&my_charset_bin, *from); from++) ;
554
    if (from != end)                     // If still something left, warn
bk@work.mysql.com's avatar
bk@work.mysql.com committed
555
    {
556 557
      current_thd->cuted_fields++; 
      is_cuted_fields_incr=1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
558
    }
559 560 561 562 563 564
  }
  
  /*
    Now "move" digits around the decimal dot according to the exponent value,
    and add necessary zeros.
    Examples :
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
565 566 567
    - 1E+3 : needs 3 more zeros at the left of '.' (int_digits_added_zeros=3)
    - 1E-3 : '1' moves at the right of '.', and 2 more zeros are needed
    between '.' and '1'
568
    - 1234.5E-3 : '234' moves at the right of '.'
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
569 570
    These moves are implemented with pointers which point at the begin
    and end of each moved segment. Examples :
571
    - 1234.5E-3 : before the code below is executed, the int_digits part is
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
572 573 574
    from '1' to '4' and the frac_digits part from '5' to '5'. After the code
    below, the int_digits part is from '1' to '1', the frac_digits_head
    part is from '2' to '4', and the frac_digits part from '5' to '5'.
575
    - 1234.5E3 : before the code below is executed, the int_digits part is
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
576 577 578 579
    from '1' to '4' and the frac_digits part from '5' to '5'. After the code
    below, the int_digits part is from '1' to '4', the int_digits_tail
    part is from '5' to '5', the frac_digits part is empty, and
    int_digits_added_zeros=2 (to make 1234500).
580 581
  */
  
582
  /* 
peter@mysql.com's avatar
peter@mysql.com committed
583
     Below tmp_uint cannot overflow with small enough MAX_EXPONENT setting,
584
     as int_digits_added_zeros<=exponent<4G and 
585 586
     (int_digits_end-int_digits_from)<=max_allowed_packet<=2G and
     (frac_digits_from-int_digits_tail_from)<=max_allowed_packet<=2G
587 588
  */

589 590 591 592 593 594 595 596
  if (!expo_sign_char)
    tmp_uint=tmp_dec+(uint)(int_digits_end-int_digits_from);
  else if (expo_sign_char == '-') 
  {
    tmp_uint=min(exponent,(uint)(int_digits_end-int_digits_from));
    frac_digits_added_zeros=exponent-tmp_uint;
    int_digits_end -= tmp_uint;
    frac_digits_head_end=int_digits_end+tmp_uint;
peter@mysql.com's avatar
peter@mysql.com committed
597
    tmp_uint=tmp_dec+(uint)(int_digits_end-int_digits_from);     
598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622
  }
  else // (expo_sign_char=='+') 
  {
    tmp_uint=min(exponent,(uint)(frac_digits_end-frac_digits_from));
    int_digits_added_zeros=exponent-tmp_uint;
    int_digits_tail_from=frac_digits_from;
    frac_digits_from=frac_digits_from+tmp_uint;
    /*
      We "eat" the heading zeros of the 
      int_digits.int_digits_tail.int_digits_added_zeros concatenation
      (for example 0.003e3 must become 3 and not 0003)
    */
    if (int_digits_from == int_digits_end) 
    {
      /*
	There was nothing in the int_digits part, so continue
	eating int_digits_tail zeros
      */
      for (; int_digits_tail_from != frac_digits_from &&
	     *int_digits_tail_from == '0'; int_digits_tail_from++) ;
      if (int_digits_tail_from == frac_digits_from) 
      {
	// there were only zeros in int_digits_tail too
	int_digits_added_zeros=0;
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
623
    }
624 625 626
    tmp_uint= (tmp_dec+(int_digits_end-int_digits_from)+
               (uint)(frac_digits_from-int_digits_tail_from)+
               int_digits_added_zeros);
627 628 629 630 631 632 633 634 635 636
  }
  
  /*
    Now write the formated number
    
    First the digits of the int_% parts.
    Do we have enough room to write these digits ?
    If the sign is defined and '-', we need one position for it
  */

637
  if (field_length < tmp_uint + (int) (sign_char == '-')) 
638
  {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
639
    // too big number, change to max or min number
640
    Field_decimal::overflow(sign_char == '-');
641
    return 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
642
  }
643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659
 
  /*
    Tmp_left_pos is the position where the leftmost digit of
    the int_% parts will be written
  */
  tmp_left_pos=pos=to+(uint)(field_length-tmp_uint);
  
  // Write all digits of the int_% parts
  while (int_digits_from != int_digits_end)
    *pos++ = *int_digits_from++ ;

  if (expo_sign_char == '+')
  {    
    while (int_digits_tail_from != frac_digits_from)
      *pos++= *int_digits_tail_from++;
    while (int_digits_added_zeros-- >0)
      *pos++= '0';  
bk@work.mysql.com's avatar
bk@work.mysql.com committed
660
  }
661 662 663 664 665 666
  /*
    Note the position where the rightmost digit of the int_% parts has been
    written (this is to later check if the int_% parts contained nothing,
    meaning an extra 0 is needed).
  */
  tmp_right_pos=pos;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
667 668

  /*
669 670
    Step back to the position of the leftmost digit of the int_% parts,
    to write sign and fill with zeros or blanks or prezeros.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
671
  */
672 673 674 675 676 677 678 679 680
  pos=tmp_left_pos-1;
  if (zerofill)
  {
    left_wall=to-1;
    while (pos != left_wall)			// Fill with zeros
      *pos--='0';
  }
  else
  {
681
    left_wall=to+(sign_char != 0)-1;
682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699
    if (!expo_sign_char)	// If exponent was specified, ignore prezeros
    {
      for (;pos != left_wall && pre_zeros_from !=pre_zeros_end;
	   pre_zeros_from++)
	*pos--= '0';
    }
    if (pos == tmp_right_pos-1)
      *pos--= '0';		// no 0 has ever been written, so write one
    left_wall= to-1;
    if (sign_char && pos != left_wall)
    {
      /* Write sign if possible (it is if sign is '-') */
      *pos--= sign_char;
    }
    while (pos != left_wall)
      *pos--=' ';  //fill with blanks
  }
  
700 701 702 703 704 705 706 707
  /*
    Write digits of the frac_% parts ;
    Depending on current_thd->count_cutted_fields, we may also want
    to know if some non-zero tail of these parts will
    be truncated (for example, 0.002->0.00 will generate a warning,
    while 0.000->0.00 will not)
    (and 0E1000000000 will not, while 1E-1000000000 will)
  */
708
      
709 710 711
  pos=to+(uint)(field_length-tmp_dec);	// Calculate post to '.'
  right_wall=to+field_length;
  if (pos != right_wall) 
712 713
    *pos++='.';

714 715 716
  if (expo_sign_char == '-')
  {
    while (frac_digits_added_zeros-- > 0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
717
    {
718
      if (pos == right_wall) 
719
      {
720 721
        if (current_thd->count_cuted_fields && !is_cuted_fields_incr) 
          break; // Go on below to see if we lose non zero digits
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
722
        return 0;
723
      }
724 725 726 727 728 729
      *pos++='0';
    }
    while (int_digits_end != frac_digits_head_end)
    {
      tmp_char= *int_digits_end++;
      if (pos == right_wall)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
730
      {
731 732 733 734
        if (tmp_char != '0')			// Losing a non zero digit ?
        {
          if (!is_cuted_fields_incr)
            current_thd->cuted_fields++;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
735
          return 0;
736 737
        }
        continue;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
738
      }
739
      *pos++= tmp_char;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
740
    }
741
  }
742

743 744 745 746
  for (;frac_digits_from!=frac_digits_end;) 
  {
    tmp_char= *frac_digits_from++;
    if (pos == right_wall)
747
    {
748
      if (tmp_char != '0')			// Losing a non zero digit ?
749
      {
750 751
        if (!is_cuted_fields_incr)
	  current_thd->cuted_fields++;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
752
        return 0;
753
      }
754
      continue;
755
    }
756
    *pos++= tmp_char;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
757
  }
758 759 760
      
  while (pos != right_wall)
   *pos++='0';			// Fill with zeros at right of '.'
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
761
  return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
762 763 764
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
765
int Field_decimal::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
766 767 768 769
{
  if (unsigned_flag && nr < 0)
  {
    overflow(1);
770
    return 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
771
  }
772
  
773 774
#ifdef HAVE_FINITE
  if (!finite(nr)) // Handle infinity as special case
775 776
  {
    overflow(nr < 0.0);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
777
    return 1;
778
  }
779
#endif
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
780

bk@work.mysql.com's avatar
bk@work.mysql.com committed
781 782 783 784 785
  reg4 uint i,length;
  char fyllchar,*to;
  char buff[320];

  fyllchar = zerofill ? (char) '0' : (char) ' ';
786
#ifdef HAVE_SNPRINTF_
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
787 788
  buff[sizeof(buff)-1]=0;			// Safety
  snprintf(buff,sizeof(buff)-1, "%.*f",(int) dec,nr);
789
  length=(uint) strlen(buff);
790
#else
791
  length=(uint) my_sprintf(buff,(buff,"%.*f",dec,nr));
792
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
793 794 795 796

  if (length > field_length)
  {
    overflow(nr < 0.0);
797
    return 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
798 799 800 801 802 803 804
  }
  else
  {
    to=ptr;
    for (i=field_length-length ; i-- > 0 ;)
      *to++ = fyllchar;
    memcpy(to,buff,length);
805
    return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
806 807 808 809
  }
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
810
int Field_decimal::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
811 812 813 814
{
  if (unsigned_flag && nr < 0)
  {
    overflow(1);
815
    return 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
816 817 818 819 820 821 822 823
  }
  char buff[22];
  uint length=(uint) (longlong10_to_str(nr,buff,-10)-buff);
  uint int_part=field_length- (dec  ? dec+1 : 0);

  if (length > int_part)
  {
    overflow(test(nr < 0L));			/* purecov: inspected */
824
    return 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
825 826 827 828 829 830 831 832 833 834 835 836 837
  }
  else
  {
    char fyllchar = zerofill ? (char) '0' : (char) ' ';
    char *to=ptr;
    for (uint i=int_part-length ; i-- > 0 ;)
      *to++ = fyllchar;
    memcpy(to,buff,length);
    if (dec)
    {
      to[length]='.';
      bfill(to+length+1,dec,'0');
    }
838
    return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
839 840 841 842 843 844
  }
}


double Field_decimal::val_real(void)
{
845
  int not_used;
846
  return my_strntod(&my_charset_bin, ptr, field_length, NULL, &not_used);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
847 848 849 850
}

longlong Field_decimal::val_int(void)
{
851
  int not_used;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
852
  if (unsigned_flag)
853
    return my_strntoull(&my_charset_bin, ptr, field_length, 10, NULL,
854
			&not_used);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
855
  else
856
    return my_strntoll(&my_charset_bin, ptr, field_length, 10, NULL,
857
			&not_used);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
858 859
}

860

bk@work.mysql.com's avatar
bk@work.mysql.com committed
861 862 863 864 865 866
String *Field_decimal::val_str(String *val_buffer __attribute__((unused)),
			       String *val_ptr)
{
  char *str;
  for (str=ptr ; *str == ' ' ; str++) ;
  uint tmp_length=(uint) (str-ptr);
867
  val_ptr->set_charset(&my_charset_bin);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
868 869 870
  if (field_length < tmp_length)		// Error in data
    val_ptr->length(0);
  else
871
    val_ptr->set_latin1((const char*) str, field_length-tmp_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
872 873 874 875 876 877 878 879 880 881 882
  return val_ptr;
}

/*
** Should be able to handle at least the following fixed decimal formats:
** 5.00 , -1.0,  05,  -05, +5 with optional pre/end space
*/

int Field_decimal::cmp(const char *a_ptr,const char *b_ptr)
{
  const char *end;
883
  int swap=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
884 885 886 887
  /* First remove prefixes '0', ' ', and '-' */
  for (end=a_ptr+field_length;
       a_ptr != end &&
	 (*a_ptr == *b_ptr ||
888
	  ((my_isspace(&my_charset_bin,*a_ptr)  || *a_ptr == '+' || 
889
            *a_ptr == '0') &&
890
	   (my_isspace(&my_charset_bin,*b_ptr) || *b_ptr == '+' || 
891
            *b_ptr == '0')));
892 893 894 895 896
       a_ptr++,b_ptr++)
  {
    if (*a_ptr == '-')				// If both numbers are negative
      swap= -1 ^ 1;				// Swap result      
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
897 898 899
  if (a_ptr == end)
    return 0;
  if (*a_ptr == '-')
900 901
    return -1;
  else if (*b_ptr == '-')
bk@work.mysql.com's avatar
bk@work.mysql.com committed
902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917
    return 1;

  while (a_ptr != end)
  {
    if (*a_ptr++ != *b_ptr++)
      return swap ^ (a_ptr[-1] < b_ptr[-1] ? -1 : 1); // compare digits
  }
  return 0;
}


void Field_decimal::sort_string(char *to,uint length)
{
  char *str,*end;
  for (str=ptr,end=ptr+length;
       str != end &&
918
	 ((my_isspace(&my_charset_bin,*str) || *str == '+' ||
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
919
	   *str == '0')) ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
920 921 922 923 924 925 926 927 928 929
       str++)
    *to++=' ';
  if (str == end)
    return;					/* purecov: inspected */

  if (*str == '-')
  {
    *to++=1;					// Smaller than any number
    str++;
    while (str != end)
930
      if (my_isdigit(&my_charset_bin,*str))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
931 932 933 934 935 936 937
	*to++= (char) ('9' - *str++);
      else
	*to++= *str++;
  }
  else memcpy(to,str,(uint) (end-str));
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
938

bk@work.mysql.com's avatar
bk@work.mysql.com committed
939 940
void Field_decimal::sql_type(String &res) const
{
941
  CHARSET_INFO *cs=res.charset();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
942 943 944 945 946
  uint tmp=field_length;
  if (!unsigned_flag)
    tmp--;
  if (dec)
    tmp--;
947 948
  res.length(cs->snprintf(cs,(char*) res.ptr(),res.alloced_length(),
			  "decimal(%d,%d)",tmp,dec));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
949 950 951 952 953 954 955 956
  add_zerofill_and_unsigned(res);
}


/****************************************************************************
** tiny int
****************************************************************************/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
957
int Field_tiny::store(const char *from,uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
958
{
959
  int not_used;				// We can ignore result from str2int
960
  char *end;
961
  long tmp= my_strntol(cs, from, len, 10, &end, &not_used);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
962
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
963 964 965 966 967 968 969

  if (unsigned_flag)
  {
    if (tmp < 0)
    {
      tmp=0; /* purecov: inspected */
      current_thd->cuted_fields++; /* purecov: inspected */
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
970
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
971 972 973 974 975
    }
    else if (tmp > 255)
    {
      tmp= 255;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
976
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
977
    }
978
    else if (current_thd->count_cuted_fields && !test_if_int(from,len,end,cs))
979
    {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
980
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
981
      error= 1;
982
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
983 984 985 986 987 988 989
  }
  else
  {
    if (tmp < -128)
    {
      tmp= -128;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
990
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
991 992 993 994 995
    }
    else if (tmp >= 128)
    {
      tmp= 127;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
996
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
997
    }
998
    else if (current_thd->count_cuted_fields && !test_if_int(from,len,end,cs))
999
    {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1000
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1001
      error= 1;
1002
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1003 1004
  }
  ptr[0]= (char) tmp;
1005
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1006 1007 1008
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1009
int Field_tiny::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1010
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1011
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1012 1013 1014 1015 1016 1017 1018
  nr=rint(nr);
  if (unsigned_flag)
  {
    if (nr < 0.0)
    {
      *ptr=0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1019
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1020 1021 1022 1023 1024
    }
    else if (nr > 255.0)
    {
      *ptr=(char) 255;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1025
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1026 1027 1028 1029 1030 1031 1032 1033 1034 1035
    }
    else
      *ptr=(char) nr;
  }
  else
  {
    if (nr < -128.0)
    {
      *ptr= (char) -128;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1036
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1037 1038 1039 1040 1041
    }
    else if (nr > 127.0)
    {
      *ptr=127;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1042
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1043 1044 1045 1046
    }
    else
      *ptr=(char) nr;
  }
1047
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1048 1049
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1050
int Field_tiny::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1051
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1052
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1053 1054 1055 1056 1057 1058
  if (unsigned_flag)
  {
    if (nr < 0L)
    {
      *ptr=0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1059
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1060 1061 1062 1063 1064
    }
    else if (nr > 255L)
    {
      *ptr= (char) 255;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1065
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1066 1067 1068 1069 1070 1071 1072 1073 1074 1075
    }
    else
      *ptr=(char) nr;
  }
  else
  {
    if (nr < -128L)
    {
      *ptr= (char) -128;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1076
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1077 1078 1079 1080 1081
    }
    else if (nr > 127L)
    {
      *ptr=127;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1082
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1083 1084 1085 1086
    }
    else
      *ptr=(char) nr;
  }
1087
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107
}


double Field_tiny::val_real(void)
{
  int tmp= unsigned_flag ? (int) ((uchar*) ptr)[0] :
    (int) ((signed char*) ptr)[0];
  return (double) tmp;
}

longlong Field_tiny::val_int(void)
{
  int tmp= unsigned_flag ? (int) ((uchar*) ptr)[0] :
    (int) ((signed char*) ptr)[0];
  return (longlong) tmp;
}

String *Field_tiny::val_str(String *val_buffer,
			    String *val_ptr __attribute__((unused)))
{
1108
  CHARSET_INFO *cs= &my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1109
  uint length;
1110 1111
  uint mlength=max(field_length+1,5*cs->mbmaxlen);
  val_buffer->alloc(mlength);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1112
  char *to=(char*) val_buffer->ptr();
1113

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1114
  if (unsigned_flag)
1115
    length= (uint) cs->long10_to_str(cs,to,mlength, 10,(long) *((uchar*) ptr));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1116
  else
1117
    length= (uint) cs->long10_to_str(cs,to,mlength,-10,(long) *((signed char*) ptr));
1118
  
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1119 1120 1121 1122 1123 1124
  val_buffer->length(length);
  if (zerofill)
    prepend_zeros(val_buffer);
  return val_buffer;
}

1125 1126 1127 1128
bool Field_tiny::send_binary(Protocol *protocol)
{
  return protocol->store_tiny((longlong) (int8) ptr[0]);
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148

int Field_tiny::cmp(const char *a_ptr, const char *b_ptr)
{
  signed char a,b;
  a=(signed char) a_ptr[0]; b= (signed char) b_ptr[0];
  if (unsigned_flag)
    return ((uchar) a < (uchar) b) ? -1 : ((uchar) a > (uchar) b) ? 1 : 0;
  return (a < b) ? -1 : (a > b) ? 1 : 0;
}

void Field_tiny::sort_string(char *to,uint length __attribute__((unused)))
{
  if (unsigned_flag)
    *to= *ptr;
  else
    to[0] = (char) ((uchar) ptr[0] ^ (uchar) 128);	/* Revers signbit */
}

void Field_tiny::sql_type(String &res) const
{
1149
  CHARSET_INFO *cs=res.charset();
1150 1151
  res.length(cs->snprintf(cs,(char*) res.ptr(),res.alloced_length(),
			  "tinyint(%d)",(int) field_length));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1152 1153 1154 1155
  add_zerofill_and_unsigned(res);
}

/****************************************************************************
1156
 Field type short int (2 byte)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1157 1158
****************************************************************************/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1159
int Field_short::store(const char *from,uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1160
{
1161
  int not_used;				// We can ignore result from str2int
1162
  char *end;
1163
  long tmp= my_strntol(cs, from, len, 10, &end, &not_used);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1164
  int error= 0;
1165

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1166 1167 1168 1169 1170 1171
  if (unsigned_flag)
  {
    if (tmp < 0)
    {
      tmp=0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1172
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1173 1174 1175 1176 1177
    }
    else if (tmp > (uint16) ~0)
    {
      tmp=(uint16) ~0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1178
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1179
    }
1180
    else if (current_thd->count_cuted_fields && !test_if_int(from,len,end,cs))
1181
    {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1182
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1183
      error= 1;
1184
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1185 1186 1187 1188 1189 1190 1191
  }
  else
  {
    if (tmp < INT_MIN16)
    {
      tmp= INT_MIN16;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1192
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1193 1194 1195 1196 1197
    }
    else if (tmp > INT_MAX16)
    {
      tmp=INT_MAX16;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1198
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1199
    }
1200
    else if (current_thd->count_cuted_fields && !test_if_int(from,len,end,cs))
1201
    {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1202
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1203
      error= 1;
1204
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1205 1206 1207 1208 1209 1210 1211 1212 1213
  }
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int2store(ptr,tmp);
  }
  else
#endif
    shortstore(ptr,(short) tmp);
1214
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1215 1216 1217
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1218
int Field_short::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1219
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1220
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1221 1222 1223 1224 1225 1226 1227 1228
  int16 res;
  nr=rint(nr);
  if (unsigned_flag)
  {
    if (nr < 0)
    {
      res=0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1229
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1230 1231 1232 1233 1234
    }
    else if (nr > (double) (uint16) ~0)
    {
      res=(int16) (uint16) ~0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1235
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1236 1237 1238 1239 1240 1241 1242 1243 1244 1245
    }
    else
      res=(int16) (uint16) nr;
  }
  else
  {
    if (nr < (double) INT_MIN16)
    {
      res=INT_MIN16;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1246
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1247 1248 1249 1250 1251
    }
    else if (nr > (double) INT_MAX16)
    {
      res=INT_MAX16;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1252
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264
    }
    else
      res=(int16) nr;
  }
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int2store(ptr,res);
  }
  else
#endif
    shortstore(ptr,res);
1265
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1266 1267
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1268
int Field_short::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1269
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1270
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1271 1272 1273 1274 1275 1276 1277
  int16 res;
  if (unsigned_flag)
  {
    if (nr < 0L)
    {
      res=0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1278
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1279 1280 1281 1282 1283
    }
    else if (nr > (longlong) (uint16) ~0)
    {
      res=(int16) (uint16) ~0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1284
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1285 1286 1287 1288 1289 1290 1291 1292 1293 1294
    }
    else
      res=(int16) (uint16) nr;
  }
  else
  {
    if (nr < INT_MIN16)
    {
      res=INT_MIN16;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1295
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1296 1297 1298 1299 1300
    }
    else if (nr > INT_MAX16)
    {
      res=INT_MAX16;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1301
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313
    }
    else
      res=(int16) nr;
  }
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int2store(ptr,res);
  }
  else
#endif
    shortstore(ptr,res);
1314
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341
}


double Field_short::val_real(void)
{
  short j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    j=sint2korr(ptr);
  else
#endif
    shortget(j,ptr);
  return unsigned_flag ? (double) (unsigned short) j : (double) j;
}

longlong Field_short::val_int(void)
{
  short j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    j=sint2korr(ptr);
  else
#endif
    shortget(j,ptr);
  return unsigned_flag ? (longlong) (unsigned short) j : (longlong) j;
}

1342

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1343 1344 1345
String *Field_short::val_str(String *val_buffer,
			     String *val_ptr __attribute__((unused)))
{
1346
  CHARSET_INFO *cs= &my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1347
  uint length;
1348 1349
  uint mlength=max(field_length+1,7*cs->mbmaxlen);
  val_buffer->alloc(mlength);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1350 1351 1352 1353 1354 1355 1356 1357 1358 1359
  char *to=(char*) val_buffer->ptr();
  short j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    j=sint2korr(ptr);
  else
#endif
    shortget(j,ptr);

  if (unsigned_flag)
1360
    length=(uint) cs->long10_to_str(cs, to, mlength, 10, (long) (uint16) j);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1361
  else
1362
    length=(uint) cs->long10_to_str(cs, to, mlength,-10, (long) j);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1363 1364 1365 1366 1367 1368 1369
  val_buffer->length(length);
  if (zerofill)
    prepend_zeros(val_buffer);
  return val_buffer;
}


1370 1371 1372 1373 1374 1375
bool Field_short::send_binary(Protocol *protocol)
{
  return protocol->store_short(Field_short::val_int());
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405
int Field_short::cmp(const char *a_ptr, const char *b_ptr)
{
  short a,b;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    a=sint2korr(a_ptr);
    b=sint2korr(b_ptr);
  }
  else
#endif
  {
    shortget(a,a_ptr);
    shortget(b,b_ptr);
  }

  if (unsigned_flag)
    return ((unsigned short) a < (unsigned short) b) ? -1 :
    ((unsigned short) a > (unsigned short) b) ? 1 : 0;
  return (a < b) ? -1 : (a > b) ? 1 : 0;
}

void Field_short::sort_string(char *to,uint length __attribute__((unused)))
{
#ifdef WORDS_BIGENDIAN
  if (!table->db_low_byte_first)
  {
    if (unsigned_flag)
      to[0] = ptr[0];
    else
1406
      to[0] = (char) (ptr[0] ^ 128);		/* Revers signbit */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1407 1408 1409 1410 1411 1412 1413 1414
    to[1]   = ptr[1];
  }
  else
#endif
  {
    if (unsigned_flag)
      to[0] = ptr[1];
    else
1415
      to[0] = (char) (ptr[1] ^ 128);		/* Revers signbit */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1416 1417 1418 1419 1420 1421
    to[1]   = ptr[0];
  }
}

void Field_short::sql_type(String &res) const
{
1422
  CHARSET_INFO *cs=res.charset();
1423 1424
  res.length(cs->snprintf(cs,(char*) res.ptr(),res.alloced_length(),
			  "smallint(%d)",(int) field_length));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1425 1426 1427 1428 1429
  add_zerofill_and_unsigned(res);
}


/****************************************************************************
1430
  Field type medium int (3 byte)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1431 1432
****************************************************************************/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1433
int Field_medium::store(const char *from,uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1434
{
1435
  int not_used;				// We can ignore result from str2int
1436
  char *end;
1437
  long tmp= my_strntol(cs, from, len, 10, &end, &not_used);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1438
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1439 1440 1441 1442 1443 1444 1445

  if (unsigned_flag)
  {
    if (tmp < 0)
    {
      tmp=0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1446
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1447 1448 1449 1450 1451
    }
    else if (tmp >= (long) (1L << 24))
    {
      tmp=(long) (1L << 24)-1L;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1452
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1453
    }
1454
    else if (current_thd->count_cuted_fields && !test_if_int(from,len,end,cs))
1455
    {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1456
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1457
      error= 1;
1458
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1459 1460 1461 1462 1463 1464 1465
  }
  else
  {
    if (tmp < INT_MIN24)
    {
      tmp= INT_MIN24;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1466
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1467 1468 1469 1470 1471
    }
    else if (tmp > INT_MAX24)
    {
      tmp=INT_MAX24;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1472
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1473
    }
1474
    else if (current_thd->count_cuted_fields && !test_if_int(from,len,end,cs))
1475
    {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1476
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1477
      error= 1;
1478
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1479 1480 1481
  }

  int3store(ptr,tmp);
1482
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1483 1484 1485
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1486
int Field_medium::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1487
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1488
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1489 1490 1491 1492 1493 1494 1495
  nr=rint(nr);
  if (unsigned_flag)
  {
    if (nr < 0)
    {
      int3store(ptr,0);
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1496
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1497 1498 1499
    }
    else if (nr >= (double) (long) (1L << 24))
    {
1500
      uint32 tmp=(uint32) (1L << 24)-1L;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1501 1502
      int3store(ptr,tmp);
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1503
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1504 1505
    }
    else
1506
      int3store(ptr,(uint32) nr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1507 1508 1509 1510 1511 1512 1513 1514
  }
  else
  {
    if (nr < (double) INT_MIN24)
    {
      long tmp=(long) INT_MIN24;
      int3store(ptr,tmp);
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1515
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1516 1517 1518 1519 1520 1521
    }
    else if (nr > (double) INT_MAX24)
    {
      long tmp=(long) INT_MAX24;
      int3store(ptr,tmp);
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1522
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1523 1524 1525 1526
    }
    else
      int3store(ptr,(long) nr);
  }
1527
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1528 1529
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1530
int Field_medium::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1531
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1532
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1533 1534 1535 1536 1537 1538
  if (unsigned_flag)
  {
    if (nr < 0L)
    {
      int3store(ptr,0);
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1539
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1540 1541 1542 1543 1544 1545
    }
    else if (nr >= (longlong) (long) (1L << 24))
    {
      long tmp=(long) (1L << 24)-1L;;
      int3store(ptr,tmp);
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1546
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1547 1548
    }
    else
1549
      int3store(ptr,(uint32) nr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1550 1551 1552 1553 1554 1555 1556 1557
  }
  else
  {
    if (nr < (longlong) INT_MIN24)
    {
      long tmp=(long) INT_MIN24;
      int3store(ptr,tmp);
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1558
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1559 1560 1561 1562 1563 1564
    }
    else if (nr > (longlong) INT_MAX24)
    {
      long tmp=(long) INT_MAX24;
      int3store(ptr,tmp);
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1565
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1566 1567 1568 1569
    }
    else
      int3store(ptr,(long) nr);
  }
1570
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1571 1572 1573 1574 1575 1576 1577 1578 1579
}


double Field_medium::val_real(void)
{
  long j= unsigned_flag ? (long) uint3korr(ptr) : sint3korr(ptr);
  return (double) j;
}

1580

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1581 1582 1583 1584 1585 1586
longlong Field_medium::val_int(void)
{
  long j= unsigned_flag ? (long) uint3korr(ptr) : sint3korr(ptr);
  return (longlong) j;
}

1587

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1588 1589 1590
String *Field_medium::val_str(String *val_buffer,
			      String *val_ptr __attribute__((unused)))
{
1591
  CHARSET_INFO *cs= &my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1592
  uint length;
1593 1594
  uint mlength=max(field_length+1,10*cs->mbmaxlen);
  val_buffer->alloc(mlength);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1595 1596 1597
  char *to=(char*) val_buffer->ptr();
  long j= unsigned_flag ? (long) uint3korr(ptr) : sint3korr(ptr);

1598
  length=(uint) cs->long10_to_str(cs,to,mlength,-10,j);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1599 1600 1601 1602 1603 1604 1605
  val_buffer->length(length);
  if (zerofill)
    prepend_zeros(val_buffer); /* purecov: inspected */
  return val_buffer;
}


1606 1607 1608 1609 1610 1611
bool Field_medium::send_binary(Protocol *protocol)
{
  return protocol->store_long(Field_medium::val_int());
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640
int Field_medium::cmp(const char *a_ptr, const char *b_ptr)
{
  long a,b;
  if (unsigned_flag)
  {
    a=uint3korr(a_ptr);
    b=uint3korr(b_ptr);
  }
  else
  {
    a=sint3korr(a_ptr);
    b=sint3korr(b_ptr);
  }
  return (a < b) ? -1 : (a > b) ? 1 : 0;
}

void Field_medium::sort_string(char *to,uint length __attribute__((unused)))
{
  if (unsigned_flag)
    to[0] = ptr[2];
  else
    to[0] = (uchar) (ptr[2] ^ 128);		/* Revers signbit */
  to[1] = ptr[1];
  to[2] = ptr[0];
}


void Field_medium::sql_type(String &res) const
{
1641
  CHARSET_INFO *cs=res.charset();
1642 1643
  res.length(cs->snprintf(cs,(char*) res.ptr(),res.alloced_length(), 
			  "mediumint(%d)",(int) field_length));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1644 1645 1646 1647 1648 1649 1650 1651
  add_zerofill_and_unsigned(res);
}

/****************************************************************************
** long int
****************************************************************************/


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1652
int Field_long::store(const char *from,uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1653
{
1654 1655
  long tmp;
  int error= 0;
1656
  char *end;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1657 1658 1659 1660
  
  tmp= cs->scan(cs, from, from+len, MY_SEQ_SPACES);
  len-= tmp;
  from+= tmp;
1661
  my_errno=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1662 1663 1664 1665 1666
  if (unsigned_flag)
  {
    if (!len || *from == '-')
    {
      tmp=0;					// Set negative to 0
1667
      my_errno=ERANGE;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1668
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1669 1670
    }
    else
1671
      tmp=(long) my_strntoul(cs,from,len,10,&end,&error);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1672 1673
  }
  else
1674 1675
    tmp=my_strntol(cs,from,len,10,&end,&error);
  if (error ||
1676
      (from+len != end && current_thd->count_cuted_fields &&
1677
       !test_if_int(from,len,end,cs)))
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1678
  {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1679
    current_thd->cuted_fields++;
1680
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1681 1682 1683 1684 1685 1686 1687 1688
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int4store(ptr,tmp);
  }
  else
#endif
    longstore(ptr,tmp);
1689
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1690 1691 1692
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1693
int Field_long::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1694
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1695
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1696 1697 1698 1699 1700 1701 1702 1703
  int32 res;
  nr=rint(nr);
  if (unsigned_flag)
  {
    if (nr < 0)
    {
      res=0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1704
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1705 1706 1707 1708 1709
    }
    else if (nr > (double) (ulong) ~0L)
    {
      res=(int32) (uint32) ~0L;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1710
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1711 1712 1713 1714 1715 1716 1717 1718 1719 1720
    }
    else
      res=(int32) (ulong) nr;
  }
  else
  {
    if (nr < (double) INT_MIN32)
    {
      res=(int32) INT_MIN32;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1721
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1722 1723 1724 1725 1726
    }
    else if (nr > (double) INT_MAX32)
    {
      res=(int32) INT_MAX32;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1727
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739
    }
    else
      res=(int32) nr;
  }
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int4store(ptr,res);
  }
  else
#endif
    longstore(ptr,res);
1740
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1741 1742 1743
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1744
int Field_long::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1745
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1746
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1747 1748 1749 1750 1751 1752 1753
  int32 res;
  if (unsigned_flag)
  {
    if (nr < 0)
    {
      res=0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1754
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1755 1756 1757 1758 1759
    }
    else if (nr >= (LL(1) << 32))
    {
      res=(int32) (uint32) ~0L;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1760
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1761 1762 1763 1764 1765 1766 1767 1768 1769 1770
    }
    else
      res=(int32) (uint32) nr;
  }
  else
  {
    if (nr < (longlong) INT_MIN32)
    {
      res=(int32) INT_MIN32;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1771
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1772 1773 1774 1775 1776
    }
    else if (nr > (longlong) INT_MAX32)
    {
      res=(int32) INT_MAX32;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1777
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789
    }
    else
      res=(int32) nr;
  }
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int4store(ptr,res);
  }
  else
#endif
    longstore(ptr,res);
1790
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820
}


double Field_long::val_real(void)
{
  int32 j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    j=sint4korr(ptr);
  else
#endif
    longget(j,ptr);
  return unsigned_flag ? (double) (uint32) j : (double) j;
}

longlong Field_long::val_int(void)
{
  int32 j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    j=sint4korr(ptr);
  else
#endif
    longget(j,ptr);
  return unsigned_flag ? (longlong) (uint32) j : (longlong) j;
}

String *Field_long::val_str(String *val_buffer,
			    String *val_ptr __attribute__((unused)))
{
1821
  CHARSET_INFO *cs= &my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1822
  uint length;
1823 1824
  uint mlength=max(field_length+1,12*cs->mbmaxlen);
  val_buffer->alloc(mlength);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1825 1826 1827 1828 1829 1830 1831 1832 1833
  char *to=(char*) val_buffer->ptr();
  int32 j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    j=sint4korr(ptr);
  else
#endif
    longget(j,ptr);

1834
  if (unsigned_flag)
1835
    length=cs->long10_to_str(cs,to,mlength, 10,(long) (uint32)j);
1836
  else
1837
    length=cs->long10_to_str(cs,to,mlength,-10,(long) j);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1838 1839 1840 1841 1842 1843 1844
  val_buffer->length(length);
  if (zerofill)
    prepend_zeros(val_buffer);
  return val_buffer;
}


1845 1846 1847 1848 1849
bool Field_long::send_binary(Protocol *protocol)
{
  return protocol->store_long(Field_long::val_int());
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865
int Field_long::cmp(const char *a_ptr, const char *b_ptr)
{
  int32 a,b;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    a=sint4korr(a_ptr);
    b=sint4korr(b_ptr);
  }
  else
#endif
  {
    longget(a,a_ptr);
    longget(b,b_ptr);
  }
  if (unsigned_flag)
1866
    return ((uint32) a < (uint32) b) ? -1 : ((uint32) a > (uint32) b) ? 1 : 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877
  return (a < b) ? -1 : (a > b) ? 1 : 0;
}

void Field_long::sort_string(char *to,uint length __attribute__((unused)))
{
#ifdef WORDS_BIGENDIAN
  if (!table->db_low_byte_first)
  {
    if (unsigned_flag)
      to[0] = ptr[0];
    else
1878
      to[0] = (char) (ptr[0] ^ 128);		/* Revers signbit */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1879 1880 1881 1882 1883 1884 1885 1886 1887 1888
    to[1]   = ptr[1];
    to[2]   = ptr[2];
    to[3]   = ptr[3];
  }
  else
#endif
  {
    if (unsigned_flag)
      to[0] = ptr[3];
    else
1889
      to[0] = (char) (ptr[3] ^ 128);		/* Revers signbit */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1890 1891 1892 1893 1894 1895 1896 1897 1898
    to[1]   = ptr[2];
    to[2]   = ptr[1];
    to[3]   = ptr[0];
  }
}


void Field_long::sql_type(String &res) const
{
1899
  CHARSET_INFO *cs=res.charset();
1900 1901
  res.length(cs->snprintf(cs,(char*) res.ptr(),res.alloced_length(),
			  "int(%d)",(int) field_length));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1902 1903 1904 1905
  add_zerofill_and_unsigned(res);
}

/****************************************************************************
1906
 Field type longlong int (8 bytes)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1907 1908
****************************************************************************/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1909
int Field_longlong::store(const char *from,uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1910
{
1911 1912
  longlong tmp;
  int error= 0;
1913
  char *end;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1914 1915
  
  tmp= cs->scan(cs, from, from+len, MY_SEQ_SPACES);
1916
  len-= (uint)tmp;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1917
  from+= tmp;
1918
  my_errno=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1919 1920 1921 1922 1923
  if (unsigned_flag)
  {
    if (!len || *from == '-')
    {
      tmp=0;					// Set negative to 0
1924
      my_errno= ERANGE;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1925
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1926 1927
    }
    else
1928
      tmp=(longlong) my_strntoull(cs,from,len,10,&end,&error);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1929 1930
  }
  else
1931 1932
    tmp=my_strntoll(cs,from,len,10,&end,&error);
  if (error ||
1933
      (from+len != end && current_thd->count_cuted_fields &&
1934
       !test_if_int(from,len,end,cs)))
1935
      current_thd->cuted_fields++;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1936 1937 1938 1939 1940 1941 1942 1943
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int8store(ptr,tmp);
  }
  else
#endif
    longlongstore(ptr,tmp);
1944
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1945 1946 1947
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1948
int Field_longlong::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1949
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1950
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1951 1952 1953 1954 1955 1956 1957 1958
  longlong res;
  nr=rint(nr);
  if (unsigned_flag)
  {
    if (nr < 0)
    {
      res=0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1959
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1960 1961 1962 1963 1964
    }
    else if (nr >= (double) ~ (ulonglong) 0)
    {
      res= ~(longlong) 0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1965
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1966 1967 1968 1969 1970 1971 1972 1973 1974 1975
    }
    else
      res=(longlong) (ulonglong) nr;
  }
  else
  {
    if (nr <= (double) LONGLONG_MIN)
    {
      res=(longlong) LONGLONG_MIN;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1976
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1977 1978 1979 1980 1981
    }
    else if (nr >= (double) LONGLONG_MAX)
    {
      res=(longlong) LONGLONG_MAX;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1982
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994
    }
    else
      res=(longlong) nr;
  }
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int8store(ptr,res);
  }
  else
#endif
    longlongstore(ptr,res);
1995
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1996 1997 1998
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1999
int Field_longlong::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2000 2001 2002 2003 2004 2005 2006 2007 2008
{
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int8store(ptr,nr);
  }
  else
#endif
    longlongstore(ptr,nr);
2009
  return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
}


double Field_longlong::val_real(void)
{
  longlong j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    j=sint8korr(ptr);
  }
  else
#endif
    longlongget(j,ptr);
2024
  return unsigned_flag ? ulonglong2double((ulonglong) j) : (double) j;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042
}

longlong Field_longlong::val_int(void)
{
  longlong j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    j=sint8korr(ptr);
  else
#endif
    longlongget(j,ptr);
  return j;
}


String *Field_longlong::val_str(String *val_buffer,
				String *val_ptr __attribute__((unused)))
{
2043
  CHARSET_INFO *cs= &my_charset_bin;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2044
  uint length;
2045 2046
  uint mlength=max(field_length+1,22*cs->mbmaxlen);
  val_buffer->alloc(mlength);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2047 2048 2049 2050 2051 2052 2053 2054 2055
  char *to=(char*) val_buffer->ptr();
  longlong j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    j=sint8korr(ptr);
  else
#endif
    longlongget(j,ptr);

2056 2057
  length=(uint) (cs->longlong10_to_str)(cs,to,mlength,
					unsigned_flag ? 10 : -10, j);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2058 2059 2060 2061 2062 2063 2064
  val_buffer->length(length);
  if (zerofill)
    prepend_zeros(val_buffer);
  return val_buffer;
}


2065 2066 2067 2068 2069 2070
bool Field_longlong::send_binary(Protocol *protocol)
{
  return protocol->store_longlong(Field_longlong::val_int(), unsigned_flag);
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099
int Field_longlong::cmp(const char *a_ptr, const char *b_ptr)
{
  longlong a,b;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    a=sint8korr(a_ptr);
    b=sint8korr(b_ptr);
  }
  else
#endif
  {
    longlongget(a,a_ptr);
    longlongget(b,b_ptr);
  }
  if (unsigned_flag)
    return ((ulonglong) a < (ulonglong) b) ? -1 :
    ((ulonglong) a > (ulonglong) b) ? 1 : 0;
  return (a < b) ? -1 : (a > b) ? 1 : 0;
}

void Field_longlong::sort_string(char *to,uint length __attribute__((unused)))
{
#ifdef WORDS_BIGENDIAN
  if (!table->db_low_byte_first)
  {
    if (unsigned_flag)
      to[0] = ptr[0];
    else
2100
      to[0] = (char) (ptr[0] ^ 128);		/* Revers signbit */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114
    to[1]   = ptr[1];
    to[2]   = ptr[2];
    to[3]   = ptr[3];
    to[4]   = ptr[4];
    to[5]   = ptr[5];
    to[6]   = ptr[6];
    to[7]   = ptr[7];
  }
  else
#endif
  {
    if (unsigned_flag)
      to[0] = ptr[7];
    else
2115
      to[0] = (char) (ptr[7] ^ 128);		/* Revers signbit */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128
    to[1]   = ptr[6];
    to[2]   = ptr[5];
    to[3]   = ptr[4];
    to[4]   = ptr[3];
    to[5]   = ptr[2];
    to[6]   = ptr[1];
    to[7]   = ptr[0];
  }
}


void Field_longlong::sql_type(String &res) const
{
2129
  CHARSET_INFO *cs=res.charset();
2130 2131
  res.length(cs->snprintf(cs,(char*) res.ptr(),res.alloced_length(),
			  "bigint(%d)",(int) field_length));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2132 2133 2134 2135 2136 2137 2138
  add_zerofill_and_unsigned(res);
}

/****************************************************************************
** single precision float
****************************************************************************/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2139
int Field_float::store(const char *from,uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2140
{
2141
  int err;
2142 2143
  Field_float::store(my_strntod(cs,(char*) from,len,(char**)NULL,&err));
  if (err || current_thd->count_cuted_fields && !test_if_real(from,len,cs))
2144
  {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2145
    current_thd->cuted_fields++;
2146 2147
    return 1;
  }
2148
  return (err) ? 1 : 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2149 2150 2151
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2152
int Field_float::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2153 2154
{
  float j;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2155
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2156 2157
  if (dec < NOT_FIXED_DEC)
    nr=floor(nr*log_10[dec]+0.5)/log_10[dec]; // To fixed point
2158 2159 2160 2161
  if (unsigned_flag && nr < 0)
  {
    current_thd->cuted_fields++;
    nr=0;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2162
    error= 1;
2163
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2164 2165 2166 2167
  if (nr < -FLT_MAX)
  {
    j= -FLT_MAX;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2168
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2169 2170 2171 2172 2173
  }
  else if (nr > FLT_MAX)
  {
    j=FLT_MAX;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2174
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185
  }
  else
    j= (float) nr;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float4store(ptr,j);
  }
  else
#endif
    memcpy_fixed(ptr,(byte*) &j,sizeof(j));
2186
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2187 2188 2189
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2190
int Field_float::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2191
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2192
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2193
  float j= (float) nr;
2194 2195 2196 2197
  if (unsigned_flag && j < 0)
  {
    current_thd->cuted_fields++;
    j=0;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2198
    error= 1;
2199
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2200 2201 2202 2203 2204 2205 2206 2207
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float4store(ptr,j);
  }
  else
#endif
    memcpy_fixed(ptr,(byte*) &j,sizeof(j));
2208
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253
}


double Field_float::val_real(void)
{
  float j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float4get(j,ptr);
  }
  else
#endif
    memcpy_fixed((byte*) &j,ptr,sizeof(j));
  return ((double) j);
}

longlong Field_float::val_int(void)
{
  float j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float4get(j,ptr);
  }
  else
#endif
    memcpy_fixed((byte*) &j,ptr,sizeof(j));
  return ((longlong) j);
}


String *Field_float::val_str(String *val_buffer,
			     String *val_ptr __attribute__((unused)))
{
  float nr;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float4get(nr,ptr);
  }
  else
#endif
    memcpy_fixed((byte*) &nr,ptr,sizeof(nr));

2254 2255
  uint to_length=max(field_length,70);
  val_buffer->alloc(to_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266 2267 2268 2269 2270 2271 2272 2273 2274 2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286 2287 2288 2289 2290 2291 2292 2293 2294 2295 2296 2297 2298 2299 2300 2301 2302 2303
  char *to=(char*) val_buffer->ptr();

  if (dec >= NOT_FIXED_DEC)
  {
    sprintf(to,"%-*.*g",(int) field_length,FLT_DIG,nr);
    to=strcend(to,' ');
    *to=0;
  }
  else
  {
#ifdef HAVE_FCONVERT
    char buff[70],*pos=buff;
    int decpt,sign,tmp_dec=dec;

    VOID(sfconvert(&nr,tmp_dec,&decpt,&sign,buff));
    if (sign)
    {
      *to++='-';
    }
    if (decpt < 0)
    {					/* val_buffer is < 0 */
      *to++='0';
      if (!tmp_dec)
	goto end;
      *to++='.';
      if (-decpt > tmp_dec)
	decpt= - (int) tmp_dec;
      tmp_dec=(uint) ((int) tmp_dec+decpt);
      while (decpt++ < 0)
	*to++='0';
    }
    else if (decpt == 0)
    {
      *to++= '0';
      if (!tmp_dec)
	goto end;
      *to++='.';
    }
    else
    {
      while (decpt-- > 0)
	*to++= *pos++;
      if (!tmp_dec)
	goto end;
      *to++='.';
    }
    while (tmp_dec--)
      *to++= *pos++;
2304
#else
2305 2306 2307
#ifdef HAVE_SNPRINTF
    to[to_length-1]=0;			// Safety
    snprintf(to,to_length-1,"%.*f",dec,nr);
2308
    to=strend(to);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2309
#else
2310
    to+= my_sprintf(to,(to,"%.*f",dec,nr));
2311
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2326 2327 2328 2329 2330 2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2341 2342 2343 2344 2345 2346 2347 2348 2349 2350 2351 2352 2353 2354 2355 2356 2357 2358 2359 2360 2361 2362 2363 2364 2365 2366 2367 2368 2369 2370 2371 2372
#endif
  }
#ifdef HAVE_FCONVERT
 end:
#endif
  val_buffer->length((uint) (to-val_buffer->ptr()));
  if (zerofill)
    prepend_zeros(val_buffer);
  return val_buffer;
}


int Field_float::cmp(const char *a_ptr, const char *b_ptr)
{
  float a,b;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float4get(a,a_ptr);
    float4get(b,b_ptr);
  }
  else
#endif
  {
    memcpy_fixed(&a,a_ptr,sizeof(float));
    memcpy_fixed(&b,b_ptr,sizeof(float));
  }
  return (a < b) ? -1 : (a > b) ? 1 : 0;
}

#define FLT_EXP_DIG (sizeof(float)*8-FLT_MANT_DIG)

void Field_float::sort_string(char *to,uint length __attribute__((unused)))
{
  float nr;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float4get(nr,ptr);
  }
  else
#endif
    memcpy_fixed(&nr,ptr,sizeof(float));

  uchar *tmp= (uchar*) to;
  if (nr == (float) 0.0)
  {						/* Change to zero string */
    tmp[0]=(uchar) 128;
    bzero((char*) tmp+1,sizeof(nr)-1);
  }
  else
  {
#ifdef WORDS_BIGENDIAN
    memcpy_fixed(tmp,&nr,sizeof(nr));
#else
    tmp[0]= ptr[3]; tmp[1]=ptr[2]; tmp[2]= ptr[1]; tmp[3]=ptr[0];
#endif
    if (tmp[0] & 128)				/* Negative */
    {						/* make complement */
      uint i;
      for (i=0 ; i < sizeof(nr); i++)
2373
	tmp[i]= (uchar) (tmp[i] ^ (uchar) 255);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2374 2375 2376 2377 2378 2379 2380 2381 2382 2383 2384 2385 2386
    }
    else
    {
      ushort exp_part=(((ushort) tmp[0] << 8) | (ushort) tmp[1] |
		       (ushort) 32768);
      exp_part+= (ushort) 1 << (16-1-FLT_EXP_DIG);
      tmp[0]= (uchar) (exp_part >> 8);
      tmp[1]= (uchar) exp_part;
    }
  }
}


2387 2388 2389 2390 2391 2392
bool Field_float::send_binary(Protocol *protocol)
{
  return protocol->store((float) Field_float::val_real(), dec, (String*) 0);
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
2393 2394 2395
void Field_float::sql_type(String &res) const
{
  if (dec == NOT_FIXED_DEC)
2396
  {
2397
    res.set_latin1("float", 5);
2398
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2399
  else
2400
  {
2401 2402 2403
    CHARSET_INFO *cs= res.charset();
    res.length(cs->snprintf(cs,(char*) res.ptr(),res.alloced_length(),
			    "float(%d,%d)",(int) field_length,dec));
2404
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2405 2406 2407 2408 2409 2410 2411
  add_zerofill_and_unsigned(res);
}

/****************************************************************************
** double precision floating point numbers
****************************************************************************/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2412
int Field_double::store(const char *from,uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2413
{
2414
  int err;
2415 2416
  double j= my_strntod(cs,(char*) from,len,(char**)0,&err);
  if (err || current_thd->count_cuted_fields && !test_if_real(from,len,cs))
2417
  {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2418
    current_thd->cuted_fields++;
2419
  }
2420 2421 2422 2423
  if (unsigned_flag && j < 0)
  {
    current_thd->cuted_fields++;
    j=0;
2424
    err= 1;
2425
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2426 2427 2428 2429 2430 2431 2432 2433
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float8store(ptr,j);
  }
  else
#endif
    doublestore(ptr,j);
2434
  return err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2435 2436 2437
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2438
int Field_double::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2439
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2440
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2441 2442
  if (dec < NOT_FIXED_DEC)
    nr=floor(nr*log_10[dec]+0.5)/log_10[dec]; // To fixed point
2443 2444 2445 2446
  if (unsigned_flag && nr < 0)
  {
    current_thd->cuted_fields++;
    nr=0;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2447
    error= 1;
2448
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2449 2450 2451 2452 2453 2454 2455 2456
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float8store(ptr,nr);
  }
  else
#endif
    doublestore(ptr,nr);
2457
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2458 2459 2460
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2461
int Field_double::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2462 2463
{
  double j= (double) nr;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2464
  int error= 0;
2465 2466 2467
  if (unsigned_flag && j < 0)
  {
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2468
    error= 1;
2469 2470
    j=0;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2471 2472 2473 2474 2475 2476 2477 2478
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float8store(ptr,j);
  }
  else
#endif
    doublestore(ptr,j);
2479
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2480 2481 2482 2483 2484 2485 2486 2487 2488 2489 2490 2491 2492 2493 2494 2495 2496 2497 2498 2499 2500 2501 2502 2503 2504 2505 2506 2507 2508 2509 2510 2511 2512 2513 2514 2515 2516 2517 2518 2519 2520 2521 2522 2523 2524 2525 2526 2527 2528 2529 2530 2531 2532 2533 2534 2535 2536 2537 2538 2539 2540 2541 2542 2543 2544 2545 2546 2547 2548 2549 2550 2551 2552 2553 2554 2555 2556 2557 2558 2559 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575
}


double Field_double::val_real(void)
{
  double j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float8get(j,ptr);
  }
  else
#endif
    doubleget(j,ptr);
  return j;
}

longlong Field_double::val_int(void)
{
  double j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float8get(j,ptr);
  }
  else
#endif
    doubleget(j,ptr);
  return ((longlong) j);
}


String *Field_double::val_str(String *val_buffer,
			      String *val_ptr __attribute__((unused)))
{
  double nr;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float8get(nr,ptr);
  }
  else
#endif
    doubleget(nr,ptr);

  uint to_length=max(field_length,320);
  val_buffer->alloc(to_length);
  char *to=(char*) val_buffer->ptr();

  if (dec >= NOT_FIXED_DEC)
  {
    sprintf(to,"%-*.*g",(int) field_length,DBL_DIG,nr);
    to=strcend(to,' ');
  }
  else
  {
#ifdef HAVE_FCONVERT
    char buff[320],*pos=buff;
    int decpt,sign,tmp_dec=dec;

    VOID(fconvert(nr,tmp_dec,&decpt,&sign,buff));
    if (sign)
    {
      *to++='-';
    }
    if (decpt < 0)
    {					/* val_buffer is < 0 */
      *to++='0';
      if (!tmp_dec)
	goto end;
      *to++='.';
      if (-decpt > tmp_dec)
	decpt= - (int) tmp_dec;
      tmp_dec=(uint) ((int) tmp_dec+decpt);
      while (decpt++ < 0)
	*to++='0';
    }
    else if (decpt == 0)
    {
      *to++= '0';
      if (!tmp_dec)
	goto end;
      *to++='.';
    }
    else
    {
      while (decpt-- > 0)
	*to++= *pos++;
      if (!tmp_dec)
	goto end;
      *to++='.';
    }
    while (tmp_dec--)
      *to++= *pos++;
#else
#ifdef HAVE_SNPRINTF
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
2576
    to[to_length-1]=0;			// Safety
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
2577
    snprintf(to,to_length-1,"%.*f",dec,nr);
2578
    to=strend(to);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2579
#else
2580
    to+= my_sprintf(to,(to,"%.*f",dec,nr));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2581 2582 2583 2584 2585 2586 2587 2588 2589 2590 2591 2592 2593
#endif
#endif
  }
#ifdef HAVE_FCONVERT
 end:
#endif

  val_buffer->length((uint) (to-val_buffer->ptr()));
  if (zerofill)
    prepend_zeros(val_buffer);
  return val_buffer;
}

2594 2595
bool Field_double::send_binary(Protocol *protocol)
{
2596
  return protocol->store((double) Field_double::val_real(), dec, (String*) 0);
2597 2598
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2599 2600 2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611

int Field_double::cmp(const char *a_ptr, const char *b_ptr)
{
  double a,b;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float8get(a,a_ptr);
    float8get(b,b_ptr);
  }
  else
#endif
  {
2612
/* could this ALWAYS be 2 calls to doubleget() ?? */
2613
#if defined(__FLOAT_WORD_ORDER) && (__FLOAT_WORD_ORDER == __BIG_ENDIAN)
2614 2615 2616
    doubleget(a, a_ptr);
    doubleget(b, b_ptr);
#else
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2617 2618
    memcpy_fixed(&a,a_ptr,sizeof(double));
    memcpy_fixed(&b,b_ptr,sizeof(double));
2619
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638
  }
  return (a < b) ? -1 : (a > b) ? 1 : 0;
}


#define DBL_EXP_DIG (sizeof(double)*8-DBL_MANT_DIG)

/* The following should work for IEEE */

void Field_double::sort_string(char *to,uint length __attribute__((unused)))
{
  double nr;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    float8get(nr,ptr);
  }
  else
#endif
2639
/* could this ALWAYS be 2 calls to doubleget() ?? */
2640
#if defined(__FLOAT_WORD_ORDER) && (__FLOAT_WORD_ORDER == __BIG_ENDIAN)
2641 2642
    doubleget(nr,ptr);
#else
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2643
    memcpy_fixed(&nr,ptr,sizeof(nr));
2644
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2645 2646 2647 2648 2649 2650
  change_double_for_sort(nr, (byte*) to);
}


void Field_double::sql_type(String &res) const
{
2651
  CHARSET_INFO *cs=res.charset();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2652
  if (dec == NOT_FIXED_DEC)
2653
  {
2654
    res.set_latin1("double",6);
2655
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2656
  else
2657
  {
2658 2659
    res.length(cs->snprintf(cs,(char*) res.ptr(),res.alloced_length(),
			    "double(%d,%d)",(int) field_length,dec));
2660
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2661 2662 2663 2664 2665 2666 2667 2668 2669 2670 2671 2672 2673
  add_zerofill_and_unsigned(res);
}


/****************************************************************************
** timestamp
** The first timestamp in the table is automaticly updated
** by handler.cc.  The form->timestamp points at the automatic timestamp.
****************************************************************************/

Field_timestamp::Field_timestamp(char *ptr_arg, uint32 len_arg,
				 enum utype unireg_check_arg,
				 const char *field_name_arg,
2674 2675 2676 2677
				 struct st_table *table_arg,
				 CHARSET_INFO *cs)
  :Field_str(ptr_arg, 19, (uchar*) 0,0,
	     unireg_check_arg, field_name_arg, table_arg, cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2678 2679 2680 2681 2682 2683 2684 2685 2686 2687
{
  if (table && !table->timestamp_field)
  {
    table->timestamp_field= this;		// Automatic timestamp
    table->time_stamp=(ulong) (ptr_arg - (char*) table->record[0])+1;
    flags|=TIMESTAMP_FLAG;
  }
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2688
int Field_timestamp::store(const char *from,uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2689 2690 2691 2692 2693 2694 2695 2696 2697 2698
{
  long tmp=(long) str_to_timestamp(from,len);
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int4store(ptr,tmp);
  }
  else
#endif
    longstore(ptr,tmp);
2699
  return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2700 2701
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2702
int Field_timestamp::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2703
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2704
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2705 2706
  if (nr < 0 || nr > 99991231235959.0)
  {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2707
    nr= 0;					// Avoid overflow on buff
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2708
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2709
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2710
  }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2711
  error|= Field_timestamp::store((longlong) rint(nr));
2712
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2713 2714 2715 2716
}


/*
2717 2718 2719
  Convert a datetime of formats YYMMDD, YYYYMMDD or YYMMDDHHMSS to
  YYYYMMDDHHMMSS.  The high date '99991231235959' is checked before this
  function.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2720 2721 2722 2723 2724 2725 2726 2727 2728 2729 2730 2731 2732 2733 2734 2735 2736 2737 2738 2739 2740 2741 2742 2743 2744 2745 2746 2747 2748 2749 2750 2751 2752
*/

static longlong fix_datetime(longlong nr)
{
  if (nr == LL(0) || nr >= LL(10000101000000))
    return nr;					// Normal datetime >= Year 1000
  if (nr < 101)
    goto err;
  if (nr <= (YY_PART_YEAR-1)*10000L+1231L)
    return (nr+20000000L)*1000000L;		// YYMMDD, year: 2000-2069
  if (nr < (YY_PART_YEAR)*10000L+101L)
    goto err;
  if (nr <= 991231L)
    return (nr+19000000L)*1000000L;		// YYMMDD, year: 1970-1999
  if (nr < 10000101L)
    goto err;
  if (nr <= 99991231L)
    return nr*1000000L;
  if (nr < 101000000L)
    goto err;
  if (nr <= (YY_PART_YEAR-1)*LL(10000000000)+LL(1231235959))
    return nr+LL(20000000000000);		// YYMMDDHHMMSS, 2000-2069
  if (nr <  YY_PART_YEAR*LL(10000000000)+ LL(101000000))
    goto err;
  if (nr <= LL(991231235959))
    return nr+LL(19000000000000);		// YYMMDDHHMMSS, 1970-1999

 err:
  current_thd->cuted_fields++;
  return LL(0);
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2753
int Field_timestamp::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2754 2755 2756 2757 2758 2759 2760 2761 2762
{
  TIME l_time;
  time_t timestamp;
  long part1,part2;

  if ((nr=fix_datetime(nr)))
  {
    part1=(long) (nr/LL(1000000));
    part2=(long) (nr - (longlong) part1*LL(1000000));
2763
    l_time.year=  (int) (part1/10000L);  part1%=10000L;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2764
    l_time.month= (int) part1 / 100;
2765 2766
    l_time.day=	  (int) part1 % 100; 
    l_time.hour=  (int) (part2/10000L);  part2%=10000L;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2767 2768 2769 2770 2771 2772 2773 2774 2775 2776 2777 2778 2779
    l_time.minute=(int) part2 / 100;
    l_time.second=(int) part2 % 100; 
    timestamp=my_gmt_sec(&l_time);
  }
  else
    timestamp=0;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int4store(ptr,timestamp);
  }
  else
#endif
2780
    longstore(ptr,(uint32) timestamp);
2781
  return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2782 2783 2784 2785 2786 2787 2788 2789 2790 2791 2792 2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805 2806 2807 2808 2809 2810
}


double Field_timestamp::val_real(void)
{
  return (double) Field_timestamp::val_int();
}

longlong Field_timestamp::val_int(void)
{
  int part_time;
  uint32 temp;
  time_t time_arg;
  struct tm *l_time;
  longlong res;
  struct tm tm_tmp;

#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    temp=uint4korr(ptr);
  else
#endif
    longget(temp,ptr);

  if (temp == 0L)				// No time
    return(0);					/* purecov: inspected */
  time_arg=(time_t) temp;
  localtime_r(&time_arg,&tm_tmp);
  l_time=&tm_tmp;
2811 2812 2813 2814 2815 2816 2817 2818 2819 2820 2821 2822 2823 2824

  part_time= l_time->tm_year % 100;
  res= ((longlong) (part_time+ ((part_time < YY_PART_YEAR) ? 2000 : 1900))*
	LL(10000000000));
  part_time= l_time->tm_mon+1;
  res+= (longlong) part_time * LL(100000000);
  part_time=l_time->tm_mday;
  res+= (longlong) ((long) part_time * 1000000L);
  part_time=l_time->tm_hour;
  res+= (longlong) (part_time * 10000L);
  part_time=l_time->tm_min;
  res+= (longlong) (part_time * 100);
  part_time=l_time->tm_sec;
  return res+part_time;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2825 2826 2827 2828 2829 2830
}


String *Field_timestamp::val_str(String *val_buffer,
				 String *val_ptr __attribute__((unused)))
{
2831
  uint32 temp, temp2;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2832 2833 2834 2835 2836 2837
  time_t time_arg;
  struct tm *l_time;
  struct tm tm_tmp;

  val_buffer->alloc(field_length+1);
  char *to=(char*) val_buffer->ptr(),*end=to+field_length;
2838
  val_buffer->length(field_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2839 2840 2841 2842 2843 2844 2845 2846 2847 2848

#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    temp=uint4korr(ptr);
  else
#endif
    longget(temp,ptr);

  if (temp == 0L)
  {				      /* Zero time is "000000" */
2849
    val_ptr->set("0000-00-00 00:00:00", 19, &my_charset_bin);
2850
    return val_ptr;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2851
  }
2852
  val_buffer->set_charset(&my_charset_bin);	// Safety
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2853 2854 2855
  time_arg=(time_t) temp;
  localtime_r(&time_arg,&tm_tmp);
  l_time=&tm_tmp;
2856 2857 2858 2859 2860 2861 2862 2863 2864 2865 2866 2867 2868 2869 2870 2871 2872 2873 2874 2875 2876 2877 2878 2879 2880 2881 2882 2883 2884 2885 2886 2887 2888 2889 2890 2891 2892 2893 2894 2895 2896

  temp= l_time->tm_year % 100;
  if (temp < YY_PART_YEAR)
  {
    *to++= '2';
    *to++= '0';
  }
  else
  {
    *to++= '1';
    *to++= '9';
  }
  temp2=temp/10; temp=temp-temp2*10;
  *to++= (char) ('0'+(char) (temp2));
  *to++= (char) ('0'+(char) (temp));
  *to++= '-';
  temp=l_time->tm_mon+1;
  temp2=temp/10; temp=temp-temp2*10;
  *to++= (char) ('0'+(char) (temp2));
  *to++= (char) ('0'+(char) (temp));
  *to++= '-';
  temp=l_time->tm_mday;
  temp2=temp/10; temp=temp-temp2*10;
  *to++= (char) ('0'+(char) (temp2));
  *to++= (char) ('0'+(char) (temp));
  *to++= ' ';
  temp=l_time->tm_hour;
  temp2=temp/10; temp=temp-temp2*10;
  *to++= (char) ('0'+(char) (temp2));
  *to++= (char) ('0'+(char) (temp));
  *to++= ':';
  temp=l_time->tm_min;
  temp2=temp/10; temp=temp-temp2*10;
  *to++= (char) ('0'+(char) (temp2));
  *to++= (char) ('0'+(char) (temp));
  *to++= ':';
  temp=l_time->tm_sec;
  temp2=temp/10; temp=temp-temp2*10;
  *to++= (char) ('0'+(char) (temp2));
  *to++= (char) ('0'+(char) (temp));
  *to= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2897 2898 2899
  return val_buffer;
}

2900

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2901
bool Field_timestamp::get_date(TIME *ltime, bool fuzzydate)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2902 2903 2904 2905 2906 2907 2908 2909 2910 2911
{
  long temp;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    temp=uint4korr(ptr);
  else
#endif
    longget(temp,ptr);
  if (temp == 0L)
  {				      /* Zero time is "000000" */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2912 2913
    if (!fuzzydate)
      return 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2914 2915 2916 2917 2918 2919 2920 2921 2922 2923 2924 2925 2926 2927 2928 2929
    bzero((char*) ltime,sizeof(*ltime));
  }
  else
  {
    struct tm tm_tmp;
    time_t time_arg= (time_t) temp;
    localtime_r(&time_arg,&tm_tmp);
    struct tm *start= &tm_tmp;
    ltime->year=	start->tm_year+1900;
    ltime->month=	start->tm_mon+1;
    ltime->day=		start->tm_mday;
    ltime->hour=	start->tm_hour;
    ltime->minute=	start->tm_min;
    ltime->second=	start->tm_sec;
    ltime->second_part=	0;
    ltime->neg=		0;
2930
    ltime->time_type=TIMESTAMP_FULL;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2931 2932 2933 2934 2935 2936
  }
  return 0;
}

bool Field_timestamp::get_time(TIME *ltime)
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2937
  return Field_timestamp::get_date(ltime,0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2938 2939
}

2940 2941 2942 2943 2944 2945 2946 2947 2948

bool Field_timestamp::send_binary(Protocol *protocol)
{
  TIME tm;
  Field_timestamp::get_date(&tm, 1);
  return protocol->store(&tm);
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
2949 2950 2951 2952 2953 2954 2955 2956 2957 2958 2959 2960 2961 2962 2963 2964 2965 2966
int Field_timestamp::cmp(const char *a_ptr, const char *b_ptr)
{
  int32 a,b;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    a=sint4korr(a_ptr);
    b=sint4korr(b_ptr);
  }
  else
#endif
  {
  longget(a,a_ptr);
  longget(b,b_ptr);
  }
  return ((uint32) a < (uint32) b) ? -1 : ((uint32) a > (uint32) b) ? 1 : 0;
}

2967

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2968 2969 2970 2971 2972 2973 2974 2975 2976 2977 2978 2979 2980 2981 2982 2983 2984 2985 2986 2987 2988 2989 2990
void Field_timestamp::sort_string(char *to,uint length __attribute__((unused)))
{
#ifdef WORDS_BIGENDIAN
  if (!table->db_low_byte_first)
  {
    to[0] = ptr[0];
    to[1] = ptr[1];
    to[2] = ptr[2];
    to[3] = ptr[3];
  }
  else
#endif
  {
    to[0] = ptr[3];
    to[1] = ptr[2];
    to[2] = ptr[1];
    to[3] = ptr[0];
  }
}


void Field_timestamp::sql_type(String &res) const
{
2991
  res.set_latin1("timestamp", 9);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2992 2993 2994 2995 2996 2997 2998 2999 3000 3001 3002 3003 3004 3005 3006 3007 3008 3009 3010 3011 3012 3013 3014
}


void Field_timestamp::set_time()
{
  long tmp= (long) current_thd->query_start();
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int4store(ptr,tmp);
  }
  else
#endif
    longstore(ptr,tmp);
}

/****************************************************************************
** time type
** In string context: HH:MM:SS
** In number context: HHMMSS
** Stored as a 3 byte unsigned int
****************************************************************************/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3015
int Field_time::store(const char *from,uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3016 3017 3018
{
  TIME ltime;
  long tmp;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3019
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3020
  if (str_to_time(from,len,&ltime))
3021
  {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3022
    tmp=0L;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3023
    error= 1;
3024
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3025 3026 3027 3028 3029 3030 3031 3032 3033
  else
  {
    if (ltime.month)
      ltime.day=0;
    tmp=(ltime.day*24L+ltime.hour)*10000L+(ltime.minute*100+ltime.second);
    if (tmp > 8385959)
    {
      tmp=8385959;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3034
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3035 3036 3037 3038
    }
  }
  if (ltime.neg)
    tmp= -tmp;
3039 3040
  error |= Field_time::store((longlong) tmp);
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3041 3042 3043
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3044
int Field_time::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3045 3046
{
  long tmp;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3047
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3048 3049 3050 3051
  if (nr > 8385959.0)
  {
    tmp=8385959L;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3052
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3053 3054 3055 3056 3057
  }
  else if (nr < -8385959.0)
  {
    tmp= -8385959L;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3058
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3059 3060 3061 3062 3063 3064 3065 3066 3067 3068
  }
  else
  {
    tmp=(long) floor(fabs(nr));			// Remove fractions
    if (nr < 0)
      tmp= -tmp;
    if (tmp % 100 > 59 || tmp/100 % 100 > 59)
    {
      tmp=0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3069
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3070 3071 3072
    }
  }
  int3store(ptr,tmp);
3073
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3074 3075 3076
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3077
int Field_time::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3078 3079
{
  long tmp;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3080
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3081 3082 3083 3084
  if (nr > (longlong) 8385959L)
  {
    tmp=8385959L;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3085
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3086 3087 3088 3089 3090
  }
  else if (nr < (longlong) -8385959L)
  {
    tmp= -8385959L;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3091
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3092 3093 3094 3095 3096 3097 3098 3099
  }
  else
  {
    tmp=(long) nr;
    if (tmp % 100 > 59 || tmp/100 % 100 > 59)
    {
      tmp=0;
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3100
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3101 3102 3103
    }
  }
  int3store(ptr,tmp);
3104
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3105 3106 3107 3108 3109
}


double Field_time::val_real(void)
{
3110
  uint32 j= (uint32) uint3korr(ptr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3111 3112 3113 3114 3115 3116 3117 3118
  return (double) j;
}

longlong Field_time::val_int(void)
{
  return (longlong) sint3korr(ptr);
}

3119 3120 3121 3122 3123 3124

/*
  This function is multi-byte safe as the result string is always of type
  my_charset_bin
*/

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3125 3126 3127 3128 3129 3130 3131 3132 3133 3134 3135
String *Field_time::val_str(String *val_buffer,
			    String *val_ptr __attribute__((unused)))
{
  val_buffer->alloc(16);
  long tmp=(long) sint3korr(ptr);
  const char *sign="";
  if (tmp < 0)
  {
    tmp= -tmp;
    sign= "-";
  }
3136 3137 3138 3139 3140
  long length= my_sprintf((char*) val_buffer->ptr(),
			  ((char*) val_buffer->ptr(),"%s%02d:%02d:%02d",
			   sign,(int) (tmp/10000), (int) (tmp/100 % 100),
			   (int) (tmp % 100)));
  val_buffer->length(length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3141 3142 3143 3144 3145 3146 3147 3148 3149 3150 3151 3152
  return val_buffer;
}

bool Field_time::get_time(TIME *ltime)
{
  long tmp=(long) sint3korr(ptr);
  ltime->neg=0;
  if (tmp < 0)
  {
    ltime->neg= 1;
    tmp=-tmp;
  }
3153
  ltime->hour=   (int) (tmp/10000);
3154
  tmp-=ltime->hour*10000;
3155 3156
  ltime->minute= (int) tmp/100;
  ltime->second= (int) tmp % 100;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3157 3158 3159 3160
  ltime->second_part=0;
  return 0;
}

3161 3162 3163 3164 3165 3166 3167

bool Field_time::send_binary(Protocol *protocol)
{
  TIME tm;
  Field_time::get_time(&tm);
  tm.day= tm.hour/3600;				// Move hours to days
  tm.hour-= tm.day*3600;
3168
  return protocol->store_time(&tm);
3169 3170 3171
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
3172 3173
int Field_time::cmp(const char *a_ptr, const char *b_ptr)
{
3174 3175 3176
  int32 a,b;
  a=(int32) sint3korr(a_ptr);
  b=(int32) sint3korr(b_ptr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3177 3178 3179 3180 3181 3182 3183 3184 3185 3186 3187 3188
  return (a < b) ? -1 : (a > b) ? 1 : 0;
}

void Field_time::sort_string(char *to,uint length __attribute__((unused)))
{
  to[0] = (uchar) (ptr[2] ^ 128);
  to[1] = ptr[1];
  to[2] = ptr[0];
}

void Field_time::sql_type(String &res) const
{
3189
  res.set_latin1("time", 4);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3190 3191 3192 3193 3194 3195 3196 3197
}

/****************************************************************************
** year type
** Save in a byte the year 0, 1901->2155
** Can handle 2 byte or 4 byte years!
****************************************************************************/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3198
int Field_year::store(const char *from, uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3199
{
3200
  int not_used;				// We can ignore result from str2int
3201
  char *end;
3202
  long nr= my_strntol(cs, from, len, 10, &end, &not_used);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3203 3204 3205 3206 3207

  if (nr < 0 || nr >= 100 && nr <= 1900 || nr > 2155)
  {
    *ptr=0;
    current_thd->cuted_fields++;
3208
    return 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3209
  }
3210
  else if (current_thd->count_cuted_fields && !test_if_int(from,len,end,cs))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3211 3212 3213 3214 3215 3216 3217 3218 3219
    current_thd->cuted_fields++;
  if (nr != 0 || len != 4)
  {
    if (nr < YY_PART_YEAR)
      nr+=100;					// 2000 - 2069
    else if (nr > 1900)
      nr-= 1900;
  }
  *ptr= (char) (unsigned char) nr;
3220
  return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3221 3222
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3223
int Field_year::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3224 3225
{
  if (nr < 0.0 || nr >= 2155.0)
3226 3227 3228 3229
  {
    (void) Field_year::store((longlong) -1);
    return 1;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3230
  else
3231
    return Field_year::store((longlong) nr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3232 3233
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3234
int Field_year::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3235 3236 3237 3238 3239
{
  if (nr < 0 || nr >= 100 && nr <= 1900 || nr > 2155)
  {
    *ptr=0;
    current_thd->cuted_fields++;
3240
    return 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3241 3242 3243 3244 3245 3246 3247 3248 3249
  }
  if (nr != 0 || field_length != 4)		// 0000 -> 0; 00 -> 2000
  {
    if (nr < YY_PART_YEAR)
      nr+=100;					// 2000 - 2069
    else if (nr > 1900)
      nr-= 1900;
  }
  *ptr= (char) (unsigned char) nr;
3250
  return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3251 3252
}

3253 3254 3255
bool Field_year::send_binary(Protocol *protocol)
{
  ulonglong tmp= Field_year::val_int();
3256
  return protocol->store_short(tmp);
3257
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3258 3259 3260 3261 3262 3263 3264 3265 3266 3267 3268 3269 3270 3271 3272 3273 3274 3275 3276 3277 3278 3279 3280 3281 3282 3283 3284 3285

double Field_year::val_real(void)
{
  return (double) Field_year::val_int();
}

longlong Field_year::val_int(void)
{
  int tmp= (int) ((uchar*) ptr)[0];
  if (field_length != 4)
    tmp%=100;					// Return last 2 char
  else if (tmp)
    tmp+=1900;
  return (longlong) tmp;
}

String *Field_year::val_str(String *val_buffer,
			    String *val_ptr __attribute__((unused)))
{
  val_buffer->alloc(5);
  val_buffer->length(field_length);
  char *to=(char*) val_buffer->ptr();
  sprintf(to,field_length == 2 ? "%02d" : "%04d",(int) Field_year::val_int());
  return val_buffer;
}

void Field_year::sql_type(String &res) const
{
3286
  CHARSET_INFO *cs=res.charset();
3287 3288
  res.length(cs->snprintf(cs,(char*)res.ptr(),res.alloced_length(),
			  "year(%d)",(int) field_length));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3289 3290 3291 3292 3293 3294 3295 3296 3297 3298
}


/****************************************************************************
** date type
** In string context: YYYY-MM-DD
** In number context: YYYYMMDD
** Stored as a 4 byte unsigned int
****************************************************************************/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3299
int Field_date::store(const char *from, uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3300 3301
{
  TIME l_time;
3302
  uint32 tmp;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3303
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3304
  if (str_to_TIME(from,len,&l_time,1) == TIMESTAMP_NONE)
3305
  {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3306
    tmp=0;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3307
    error= 1;
3308
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3309
  else
3310
    tmp=(uint32) l_time.year*10000L + (uint32) (l_time.month*100+l_time.day);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3311 3312 3313 3314 3315 3316 3317 3318
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int4store(ptr,tmp);
  }
  else
#endif
    longstore(ptr,tmp);
3319
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3320 3321 3322
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3323
int Field_date::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3324 3325
{
  long tmp;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3326
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3327 3328 3329 3330 3331 3332
  if (nr >= 19000000000000.0 && nr <= 99991231235959.0)
    nr=floor(nr/1000000.0);			// Timestamp to date
  if (nr < 0.0 || nr > 99991231.0)
  {
    tmp=0L;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3333
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3334 3335 3336 3337 3338 3339 3340 3341 3342 3343 3344
  }
  else
    tmp=(long) rint(nr);
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int4store(ptr,tmp);
  }
  else
#endif
    longstore(ptr,tmp);
3345
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3346 3347 3348
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3349
int Field_date::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3350 3351
{
  long tmp;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3352
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3353 3354 3355 3356 3357 3358
  if (nr >= LL(19000000000000) && nr < LL(99991231235959))
    nr=nr/LL(1000000);			// Timestamp to date
  if (nr < 0 || nr > LL(99991231))
  {
    tmp=0L;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3359
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3360 3361 3362 3363 3364 3365 3366 3367 3368 3369 3370
  }
  else
    tmp=(long) nr;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int4store(ptr,tmp);
  }
  else
#endif
    longstore(ptr,tmp);
3371
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3372 3373 3374
}


3375 3376 3377 3378 3379 3380 3381 3382 3383 3384
bool Field_date::send_binary(Protocol *protocol)
{
  longlong tmp= Field_date::val_int();
  TIME tm;
  tm.year= (uint32) tmp/10000L % 10000;
  tm.month= (uint32) tmp/100 % 100;
  tm.day= (uint32) tmp % 100;
  return protocol->store_date(&tm);
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3385 3386 3387 3388 3389 3390 3391 3392 3393 3394 3395 3396 3397 3398 3399 3400 3401 3402 3403 3404 3405 3406 3407 3408 3409 3410 3411 3412 3413 3414 3415 3416 3417 3418 3419 3420 3421 3422 3423 3424 3425 3426 3427 3428 3429 3430 3431 3432 3433 3434 3435 3436 3437 3438 3439 3440 3441 3442 3443 3444 3445 3446 3447 3448 3449 3450 3451 3452 3453 3454 3455 3456 3457 3458 3459 3460 3461 3462 3463 3464 3465 3466 3467 3468

double Field_date::val_real(void)
{
  int32 j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    j=sint4korr(ptr);
  else
#endif
    longget(j,ptr);
  return (double) (uint32) j;
}

longlong Field_date::val_int(void)
{
  int32 j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    j=sint4korr(ptr);
  else
#endif
    longget(j,ptr);
  return (longlong) (uint32) j;
}

String *Field_date::val_str(String *val_buffer,
			    String *val_ptr __attribute__((unused)))
{
  val_buffer->alloc(field_length);
  val_buffer->length(field_length);
  int32 tmp;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    tmp=sint4korr(ptr);
  else
#endif
    longget(tmp,ptr);
  sprintf((char*) val_buffer->ptr(),"%04d-%02d-%02d",
	  (int) ((uint32) tmp/10000L % 10000), (int) ((uint32) tmp/100 % 100),
	  (int) ((uint32) tmp % 100));
  return val_buffer;
}

int Field_date::cmp(const char *a_ptr, const char *b_ptr)
{
  int32 a,b;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    a=sint4korr(a_ptr);
    b=sint4korr(b_ptr);
  }
  else
#endif
  {
    longget(a,a_ptr);
    longget(b,b_ptr);
  }
  return ((uint32) a < (uint32) b) ? -1 : ((uint32) a > (uint32) b) ? 1 : 0;
}


void Field_date::sort_string(char *to,uint length __attribute__((unused)))
{
#ifdef WORDS_BIGENDIAN
  if (!table->db_low_byte_first)
  {
    to[0] = ptr[0];
    to[1] = ptr[1];
    to[2] = ptr[2];
    to[3] = ptr[3];
  }
  else
#endif
  {
    to[0] = ptr[3];
    to[1] = ptr[2];
    to[2] = ptr[1];
    to[3] = ptr[0];
  }
}

void Field_date::sql_type(String &res) const
{
3469
  res.set_latin1("date", 4);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3470 3471 3472 3473 3474 3475 3476 3477
}

/****************************************************************************
** The new date type
** This is identical to the old date type, but stored on 3 bytes instead of 4
** In number context: YYYYMMDD
****************************************************************************/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3478
int Field_newdate::store(const char *from,uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3479 3480 3481
{
  TIME l_time;
  long tmp;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3482
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3483
  if (str_to_TIME(from,len,&l_time,1) == TIMESTAMP_NONE)
3484
  {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3485
    tmp=0L;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3486
    error= 1;
3487
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3488 3489 3490
  else
    tmp= l_time.day + l_time.month*32 + l_time.year*16*32;
  int3store(ptr,tmp);
3491
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3492 3493
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3494
int Field_newdate::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3495 3496
{
  if (nr < 0.0 || nr > 99991231235959.0)
3497 3498 3499 3500
  {
    (void) Field_newdate::store((longlong) -1);
    return 1;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3501
  else
3502
    return Field_newdate::store((longlong) rint(nr));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3503 3504 3505
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3506
int Field_newdate::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3507
{
3508
  int32 tmp;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3509
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3510 3511 3512 3513 3514 3515
  if (nr >= LL(100000000) && nr <= LL(99991231235959))
    nr=nr/LL(1000000);			// Timestamp to date
  if (nr < 0L || nr > 99991231L)
  {
    tmp=0;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3516
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3517 3518 3519
  }
  else
  {
3520
    tmp=(int32) nr;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3521 3522 3523
    if (tmp)
    {
      if (tmp < YY_PART_YEAR*10000L)			// Fix short dates
3524
	tmp+= (uint32) 20000000L;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3525
      else if (tmp < 999999L)
3526
	tmp+= (uint32) 19000000L;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3527
    }
3528 3529
    uint month= (uint) ((tmp/100) % 100);
    uint day=   (uint) (tmp%100);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3530 3531 3532 3533
    if (month > 12 || day > 31)
    {
      tmp=0L;					// Don't allow date to change
      current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3534
      error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3535 3536 3537 3538
    }
    else
      tmp= day + month*32 + (tmp/10000)*16*32;
  }
3539
  int3store(ptr,(int32) tmp);
3540
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3541 3542 3543 3544 3545 3546 3547 3548 3549 3550 3551 3552 3553 3554 3555
}

void Field_newdate::store_time(TIME *ltime,timestamp_type type)
{
  long tmp;
  if (type == TIMESTAMP_DATE || type == TIMESTAMP_FULL)
    tmp=ltime->year*16*32+ltime->month*32+ltime->day;
  else
  {
    tmp=0;
    current_thd->cuted_fields++;
  }
  int3store(ptr,tmp);
}

3556 3557 3558 3559 3560 3561
bool Field_newdate::send_binary(Protocol *protocol)
{
  TIME tm;
  Field_newdate::get_date(&tm,0);
  return protocol->store_date(&tm);
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3562 3563 3564 3565 3566 3567 3568 3569

double Field_newdate::val_real(void)
{
  return (double) Field_newdate::val_int();
}

longlong Field_newdate::val_int(void)
{
3570
  ulong j= uint3korr(ptr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3571 3572 3573 3574 3575 3576 3577 3578 3579
  j= (j % 32L)+(j / 32L % 16L)*100L + (j/(16L*32L))*10000L;
  return (longlong) j;
}

String *Field_newdate::val_str(String *val_buffer,
			       String *val_ptr __attribute__((unused)))
{
  val_buffer->alloc(field_length);
  val_buffer->length(field_length);
3580
  uint32 tmp=(uint32) uint3korr(ptr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3581 3582 3583 3584
  int part;
  char *pos=(char*) val_buffer->ptr()+10;

  /* Open coded to get more speed */
3585
  *pos--=0;					// End NULL
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3586
  part=(int) (tmp & 31);
3587 3588 3589
  *pos--= (char) ('0'+part%10);
  *pos--= (char) ('0'+part/10);
  *pos--= '-';
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3590
  part=(int) (tmp >> 5 & 15);
3591 3592 3593
  *pos--= (char) ('0'+part%10);
  *pos--= (char) ('0'+part/10);
  *pos--= '-';
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3594
  part=(int) (tmp >> 9);
3595 3596 3597 3598
  *pos--= (char) ('0'+part%10); part/=10;
  *pos--= (char) ('0'+part%10); part/=10;
  *pos--= (char) ('0'+part%10); part/=10;
  *pos=   (char) ('0'+part);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3599 3600 3601 3602 3603 3604 3605
  return val_buffer;
}

bool Field_newdate::get_date(TIME *ltime,bool fuzzydate)
{
  if (is_null())
    return 1;
3606
  uint32 tmp=(uint32) uint3korr(ptr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3607 3608 3609 3610
  bzero((char*) ltime,sizeof(*ltime));
  ltime->day=   tmp & 31;
  ltime->month= (tmp >> 5) & 15;
  ltime->year=  (tmp >> 9);
3611
  ltime->time_type=TIMESTAMP_DATE;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3612
  return (!fuzzydate && (!ltime->month || !ltime->day)) ? 1 : 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3613 3614 3615 3616
}

bool Field_newdate::get_time(TIME *ltime)
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3617
  return Field_newdate::get_date(ltime,0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3618 3619 3620 3621
}

int Field_newdate::cmp(const char *a_ptr, const char *b_ptr)
{
3622 3623 3624
  uint32 a,b;
  a=(uint32) uint3korr(a_ptr);
  b=(uint32) uint3korr(b_ptr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3625 3626 3627 3628 3629 3630 3631 3632 3633 3634 3635 3636
  return (a < b) ? -1 : (a > b) ? 1 : 0;
}

void Field_newdate::sort_string(char *to,uint length __attribute__((unused)))
{
  to[0] = ptr[2];
  to[1] = ptr[1];
  to[2] = ptr[0];
}

void Field_newdate::sql_type(String &res) const
{
3637
  res.set_latin1("date", 4);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3638 3639 3640 3641 3642 3643 3644 3645 3646 3647
}


/****************************************************************************
** datetime type
** In string context: YYYY-MM-DD HH:MM:DD
** In number context: YYYYMMDDHHMMDD
** Stored as a 8 byte unsigned int. Should sometimes be change to a 6 byte int.
****************************************************************************/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3648
int Field_datetime::store(const char *from,uint len,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3649 3650 3651 3652 3653 3654 3655 3656 3657 3658
{
  longlong tmp=str_to_datetime(from,len,1);
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int8store(ptr,tmp);
  }
  else
#endif
    longlongstore(ptr,tmp);
3659
  return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3660 3661 3662
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3663
int Field_datetime::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3664
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3665
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3666 3667 3668 3669
  if (nr < 0.0 || nr > 99991231235959.0)
  {
    nr=0.0;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3670
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3671
  }
3672 3673
  error |= Field_datetime::store((longlong) rint(nr));
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3674 3675 3676
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3677
int Field_datetime::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3678
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3679
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3680 3681 3682 3683
  if (nr < 0 || nr > LL(99991231235959))
  {
    nr=0;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3684
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3685 3686 3687 3688 3689 3690 3691 3692 3693 3694 3695
  }
  else
    nr=fix_datetime(nr);
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int8store(ptr,nr);
  }
  else
#endif
    longlongstore(ptr,nr);
3696
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3697 3698 3699 3700 3701 3702 3703 3704 3705 3706 3707 3708 3709 3710 3711 3712 3713 3714 3715 3716 3717 3718 3719
}

void Field_datetime::store_time(TIME *ltime,timestamp_type type)
{
  longlong tmp;
  if (type == TIMESTAMP_DATE || type == TIMESTAMP_FULL)
    tmp=((ltime->year*10000L+ltime->month*100+ltime->day)*LL(1000000)+
	 (ltime->hour*10000L+ltime->minute*100+ltime->second));
  else
  {
    tmp=0;
    current_thd->cuted_fields++;
  }
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int8store(ptr,tmp);
  }
  else
#endif
    longlongstore(ptr,tmp);
}

3720 3721 3722 3723 3724 3725 3726
bool Field_datetime::send_binary(Protocol *protocol)
{
  TIME tm;
  Field_datetime::get_date(&tm, 1);
  return protocol->store(&tm);
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3727 3728 3729 3730 3731 3732 3733 3734 3735 3736 3737 3738 3739 3740 3741 3742 3743 3744 3745 3746 3747 3748 3749 3750 3751 3752 3753 3754 3755 3756 3757 3758 3759 3760 3761 3762 3763 3764 3765 3766 3767 3768 3769 3770 3771

double Field_datetime::val_real(void)
{
  return (double) Field_datetime::val_int();
}

longlong Field_datetime::val_int(void)
{
  longlong j;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    j=sint8korr(ptr);
  else
#endif
    longlongget(j,ptr);
  return j;
}


String *Field_datetime::val_str(String *val_buffer,
				String *val_ptr __attribute__((unused)))
{
  val_buffer->alloc(field_length);
  val_buffer->length(field_length);
  ulonglong tmp;
  long part1,part2;
  char *pos;
  int part3;

#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
    tmp=sint8korr(ptr);
  else
#endif
    longlongget(tmp,ptr);

  /*
    Avoid problem with slow longlong aritmetic and sprintf
  */

  part1=(long) (tmp/LL(1000000));
  part2=(long) (tmp - (ulonglong) part1*LL(1000000));

  pos=(char*) val_buffer->ptr()+19;
  *pos--=0;
3772 3773 3774 3775 3776 3777 3778 3779 3780 3781 3782 3783 3784 3785 3786 3787 3788 3789 3790
  *pos--= (char) ('0'+(char) (part2%10)); part2/=10;
  *pos--= (char) ('0'+(char) (part2%10)); part3= (int) (part2 / 10);
  *pos--= ':';
  *pos--= (char) ('0'+(char) (part3%10)); part3/=10;
  *pos--= (char) ('0'+(char) (part3%10)); part3/=10;
  *pos--= ':';
  *pos--= (char) ('0'+(char) (part3%10)); part3/=10;
  *pos--= (char) ('0'+(char) part3);
  *pos--= ' ';
  *pos--= (char) ('0'+(char) (part1%10)); part1/=10;
  *pos--= (char) ('0'+(char) (part1%10)); part1/=10;
  *pos--= '-';
  *pos--= (char) ('0'+(char) (part1%10)); part1/=10;
  *pos--= (char) ('0'+(char) (part1%10)); part3= (int) (part1/10);
  *pos--= '-';
  *pos--= (char) ('0'+(char) (part3%10)); part3/=10;
  *pos--= (char) ('0'+(char) (part3%10)); part3/=10;
  *pos--= (char) ('0'+(char) (part3%10)); part3/=10;
  *pos=(char) ('0'+(char) part3);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3791 3792 3793 3794 3795 3796
  return val_buffer;
}

bool Field_datetime::get_date(TIME *ltime,bool fuzzydate)
{
  longlong tmp=Field_datetime::val_int();
3797 3798 3799
  uint32 part1,part2;
  part1=(uint32) (tmp/LL(1000000));
  part2=(uint32) (tmp - (ulonglong) part1*LL(1000000));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3800

3801
  ltime->time_type=	TIMESTAMP_FULL;
3802 3803 3804 3805 3806 3807 3808 3809
  ltime->neg=		0;
  ltime->second_part=	0;
  ltime->second=	(int) (part2%100);
  ltime->minute=	(int) (part2/100%100);
  ltime->hour=		(int) (part2/10000);
  ltime->day=		(int) (part1%100);
  ltime->month= 	(int) (part1/100%100);
  ltime->year= 		(int) (part1/10000);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3810
  return (!fuzzydate && (!ltime->month || !ltime->day)) ? 1 : 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3811 3812 3813 3814
}

bool Field_datetime::get_time(TIME *ltime)
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3815
  return Field_datetime::get_date(ltime,0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3816 3817 3818 3819 3820 3821 3822 3823 3824 3825 3826 3827 3828 3829 3830 3831 3832 3833 3834 3835 3836 3837 3838 3839 3840 3841 3842 3843 3844 3845 3846 3847 3848 3849 3850 3851 3852 3853 3854 3855 3856 3857 3858 3859 3860 3861 3862 3863 3864 3865 3866 3867
}

int Field_datetime::cmp(const char *a_ptr, const char *b_ptr)
{
  longlong a,b;
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    a=sint8korr(a_ptr);
    b=sint8korr(b_ptr);
  }
  else
#endif
  {
    longlongget(a,a_ptr);
    longlongget(b,b_ptr);
  }
  return ((ulonglong) a < (ulonglong) b) ? -1 :
    ((ulonglong) a > (ulonglong) b) ? 1 : 0;
}

void Field_datetime::sort_string(char *to,uint length __attribute__((unused)))
{
#ifdef WORDS_BIGENDIAN
  if (!table->db_low_byte_first)
  {
    to[0] = ptr[0];
    to[1] = ptr[1];
    to[2] = ptr[2];
    to[3] = ptr[3];
    to[4] = ptr[4];
    to[5] = ptr[5];
    to[6] = ptr[6];
    to[7] = ptr[7];
  }
  else
#endif
  {
    to[0] = ptr[7];
    to[1] = ptr[6];
    to[2] = ptr[5];
    to[3] = ptr[4];
    to[4] = ptr[3];
    to[5] = ptr[2];
    to[6] = ptr[1];
    to[7] = ptr[0];
  }
}


void Field_datetime::sql_type(String &res) const
{
3868
  res.set_latin1("datetime", 8);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3869 3870 3871 3872 3873 3874 3875 3876 3877
}

/****************************************************************************
** string type
** A string may be varchar or binary
****************************************************************************/

	/* Copy a string and fill with space */

3878 3879 3880 3881 3882
static bool use_conversion(CHARSET_INFO *cs1, CHARSET_INFO *cs2)
{
  return (cs1 != &my_charset_bin) && (cs2 != &my_charset_bin) && (cs1!=cs2);
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3883
int Field_string::store(const char *from,uint length,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3884
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3885
  int error= 0;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
3886 3887 3888
  char buff[80];
  String tmpstr(buff,sizeof(buff), &my_charset_bin);
  /* Convert character set if nesessary */
3889
  if (use_conversion(cs, field_charset))
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
3890 3891 3892 3893 3894
  { 
    tmpstr.copy(from, length, cs, field_charset);
    from= tmpstr.ptr();
    length=  tmpstr.length();
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3895 3896 3897 3898
  if (length <= field_length)
  {
    memcpy(ptr,from,length);
    if (length < field_length)
3899
      field_charset->fill(field_charset,ptr+length,field_length-length,' ');
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3900 3901 3902 3903 3904 3905 3906
  }
  else
  {
    memcpy(ptr,from,field_length);
    if (current_thd->count_cuted_fields)
    {						// Check if we loosed some info
      const char *end=from+length;
3907 3908 3909
      from+= field_length;
      from+= field_charset->scan(field_charset, from, end, MY_SEQ_SPACES);
      if (from != end)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3910
      {
3911 3912
        current_thd->cuted_fields++;
	error=1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3913 3914 3915
      }
    }
  }
3916
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3917 3918 3919
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3920
int Field_string::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3921 3922 3923 3924 3925
{
  char buff[MAX_FIELD_WIDTH],*end;
  int width=min(field_length,DBL_DIG+5);
  sprintf(buff,"%-*.*g",width,max(width-5,0),nr);
  end=strcend(buff,' ');
3926
  return Field_string::store(buff,(uint) (end - buff), &my_charset_bin);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3927 3928 3929
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3930
int Field_string::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3931
{
3932 3933 3934
  char buff[64];
  int  l;
  CHARSET_INFO *cs=charset();
3935
  l= (cs->longlong10_to_str)(cs,buff,sizeof(buff),-10,nr);
3936
  return Field_string::store(buff,(uint)l,cs);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3937 3938 3939 3940 3941
}


double Field_string::val_real(void)
{
3942
  int not_used;
3943
  CHARSET_INFO *cs=charset();
3944
  return my_strntod(cs,ptr,field_length,(char**)0,&not_used);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3945 3946 3947 3948 3949
}


longlong Field_string::val_int(void)
{
3950
  int not_used;
3951
  CHARSET_INFO *cs=charset();
3952
  return my_strntoll(cs,ptr,field_length,10,NULL,&not_used);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3953 3954 3955 3956 3957 3958 3959 3960 3961 3962 3963 3964
}


String *Field_string::val_str(String *val_buffer __attribute__((unused)),
			      String *val_ptr)
{
  char *end=ptr+field_length;
#ifdef WANT_TRUE_BINARY_STRINGS
  if (!binary)
#endif
    while (end > ptr && end[-1] == ' ')
      end--;
3965
  val_ptr->set((const char*) ptr,(uint) (end - ptr),field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3966 3967 3968 3969 3970 3971
  return val_ptr;
}


int Field_string::cmp(const char *a_ptr, const char *b_ptr)
{
3972 3973 3974
    return my_strnncoll(field_charset,
			(const uchar*)a_ptr,field_length,
			(const uchar*)b_ptr,field_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3975 3976 3977 3978
}

void Field_string::sort_string(char *to,uint length)
{
3979
  uint tmp=my_strnxfrm(field_charset,
3980 3981
                          (unsigned char *)to, length,
                          (unsigned char *) ptr, field_length);
3982 3983
  if (tmp < length)
    bzero(to + tmp, length - tmp);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3984 3985 3986 3987 3988
}


void Field_string::sql_type(String &res) const
{
3989 3990 3991
  CHARSET_INFO *cs=res.charset();
  ulong length= cs->snprintf(cs,(char*) res.ptr(),
			    res.alloced_length(), "%s(%d)",
3992 3993 3994 3995
			    (field_length > 3 &&
			     (table->db_options_in_use &
			      HA_OPTION_PACK_RECORD) ?
			     "varchar" : "char"),
3996
			    (int) field_length);
3997 3998
  res.length(length);
  add_binary_or_charset(res);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3999 4000 4001 4002 4003 4004 4005 4006 4007 4008 4009 4010 4011 4012 4013 4014 4015 4016 4017 4018 4019 4020 4021 4022 4023 4024 4025 4026
}


char *Field_string::pack(char *to, const char *from, uint max_length)
{
  const char *end=from+min(field_length,max_length);
  uchar length;
  while (end > from && end[-1] == ' ')
    end--;
  *to= length=(uchar) (end-from);
  memcpy(to+1, from, (int) length);
  return to+1+length;
}


const char *Field_string::unpack(char *to, const char *from)
{
  uint length= (uint) (uchar) *from++;
  memcpy(to, from, (int) length);
  bfill(to+length, field_length - length, ' ');
  return from+length;
}


int Field_string::pack_cmp(const char *a, const char *b, uint length)
{
  uint a_length= (uint) (uchar) *a++;
  uint b_length= (uint) (uchar) *b++;
4027 4028 4029
  return my_strnncoll(field_charset,
		      (const uchar*)a,a_length,
		      (const uchar*)b,b_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4030 4031 4032
}


4033 4034 4035 4036 4037 4038 4039
int Field_string::pack_cmp(const char *b, uint length)
{
  uint b_length= (uint) (uchar) *b++;
  char *end= ptr + field_length;
  while (end > ptr && end[-1] == ' ')
    end--;
  uint a_length = (uint) (end - ptr);
4040 4041 4042
  return my_strnncoll(field_charset,
		     (const uchar*)ptr,a_length,
		     (const uchar*)b, b_length);
4043 4044 4045
}


4046
uint Field_string::packed_col_length(const char *data_ptr, uint length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4047
{
4048
  if (length > 255)
4049
    return uint2korr(data_ptr)+2;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4050
  else
4051
    return (uint) ((uchar) *data_ptr)+1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4052 4053 4054 4055
}

uint Field_string::max_packed_col_length(uint max_length)
{
4056
  return (max_length > 255 ? 2 : 1)+max_length;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4057 4058 4059 4060 4061 4062 4063 4064
}


/****************************************************************************
** VARCHAR type  (Not available for the end user yet)
****************************************************************************/


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4065
int Field_varstring::store(const char *from,uint length,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4066
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4067
  int error= 0;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4068 4069 4070
  char buff[80];
  String tmpstr(buff,sizeof(buff), &my_charset_bin);
  /* Convert character set if nesessary */
4071
  if (use_conversion(cs, field_charset))
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4072 4073 4074 4075 4076
  { 
    tmpstr.copy(from, length, cs, field_charset);
    from= tmpstr.ptr();
    length=  tmpstr.length();
  }
4077
  if (length > field_length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4078 4079 4080
  {
    length=field_length;
    current_thd->cuted_fields++;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4081
    error= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4082
  }
4083 4084
  memcpy(ptr+2,from,length);
  int2store(ptr, length);
4085
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4086 4087 4088
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4089
int Field_varstring::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4090 4091 4092 4093 4094
{
  char buff[MAX_FIELD_WIDTH],*end;
  int width=min(field_length,DBL_DIG+5);
  sprintf(buff,"%-*.*g",width,max(width-5,0),nr);
  end=strcend(buff,' ');
4095
  return Field_varstring::store(buff,(uint) (end - buff), &my_charset_bin);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4096 4097 4098
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4099
int Field_varstring::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4100
{
4101 4102 4103
  char buff[64];
  int  l;
  CHARSET_INFO *cs=charset();
4104
  l= (cs->longlong10_to_str)(cs,buff,sizeof(buff),-10,nr);
4105
  return Field_varstring::store(buff,(uint)l,cs);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4106 4107 4108 4109 4110
}


double Field_varstring::val_real(void)
{
4111
  int not_used;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4112
  uint length=uint2korr(ptr)+2;
4113
  CHARSET_INFO *cs=charset();
4114
  return my_strntod(cs,ptr+2,length,(char**)0, &not_used);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4115 4116 4117 4118 4119
}


longlong Field_varstring::val_int(void)
{
4120
  int not_used;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4121
  uint length=uint2korr(ptr)+2;
4122
  CHARSET_INFO *cs=charset();
4123
  return my_strntoll(cs,ptr+2,length,10,NULL, &not_used);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4124 4125 4126 4127 4128 4129 4130
}


String *Field_varstring::val_str(String *val_buffer __attribute__((unused)),
				 String *val_ptr)
{
  uint length=uint2korr(ptr);
4131
  val_ptr->set((const char*) ptr+2,length,field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4132 4133 4134 4135 4136 4137 4138 4139 4140
  return val_ptr;
}


int Field_varstring::cmp(const char *a_ptr, const char *b_ptr)
{
  uint a_length=uint2korr(a_ptr);
  uint b_length=uint2korr(b_ptr);
  int diff;
4141
  diff=my_strnncoll(field_charset,
4142 4143
		      (const uchar*)a_ptr+2,min(a_length,b_length),
		      (const uchar*)b_ptr+2,min(a_length,b_length));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4144 4145 4146 4147 4148 4149
  return diff ? diff : (int) (a_length - b_length);
}

void Field_varstring::sort_string(char *to,uint length)
{
  uint tot_length=uint2korr(ptr);
4150
  tot_length=my_strnxfrm(field_charset,
4151 4152
                             (unsigned char *) to, length,
                             (unsigned char *)ptr+2, tot_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4153 4154 4155 4156 4157 4158 4159
  if (tot_length < length)
    bzero(to+tot_length,length-tot_length);
}


void Field_varstring::sql_type(String &res) const
{
4160 4161 4162 4163
  CHARSET_INFO *cs=res.charset();
  ulong length= cs->snprintf(cs,(char*) res.ptr(),
			     res.alloced_length(),"varchar(%u)",
			     field_length);
4164 4165
  res.length(length);
  add_binary_or_charset(res);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4166 4167 4168 4169
}

char *Field_varstring::pack(char *to, const char *from, uint max_length)
{
4170
  uint length=uint2korr(from);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4171 4172
  if (length > max_length)
    length=max_length;
4173
  *to++= (char) (length & 255);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4174
  if (max_length > 255)
4175
    *to++= (char) (length >> 8);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4176 4177 4178 4179 4180 4181 4182 4183 4184 4185 4186 4187 4188 4189 4190 4191 4192 4193 4194 4195 4196 4197 4198 4199 4200 4201 4202 4203 4204 4205 4206 4207 4208 4209 4210 4211 4212 4213 4214 4215
  if (length)
    memcpy(to, from+2, length);
  return to+length;
}


const char *Field_varstring::unpack(char *to, const char *from)
{
  uint length;
  if (field_length > 255)
  {
    length= (uint) (uchar) (*to= *from++);
    to[1]=0;
  }
  else
  {
    length=uint2korr(from);
    to[0] = *from++;
    to[1] = *from++;
  }
  if (length)
    memcpy(to+2, from, length);
  return from+length;
}


int Field_varstring::pack_cmp(const char *a, const char *b, uint key_length)
{
  uint a_length;
  uint b_length;
  if (key_length > 255)
  {
    a_length=uint2korr(a); a+=2;
    b_length=uint2korr(b); b+=2;
  }
  else
  {
    a_length= (uint) (uchar) *a++;
    b_length= (uint) (uchar) *b++;
  }
4216 4217 4218
  return my_strnncoll(field_charset,
		     (const uchar *)a,a_length,
		     (const uchar *)b,b_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4219 4220
}

4221 4222 4223 4224 4225 4226 4227 4228 4229 4230 4231 4232 4233
int Field_varstring::pack_cmp(const char *b, uint key_length)
{
  char *a=ptr+2;
  uint a_length=uint2korr(ptr);
  uint b_length;
  if (key_length > 255)
  {
    b_length=uint2korr(b); b+=2;
  }
  else
  {
    b_length= (uint) (uchar) *b++;
  }
4234 4235 4236
  return my_strnncoll(field_charset,
		     (const uchar *)a,a_length,
		     (const uchar *)b,b_length);
4237 4238
}

4239
uint Field_varstring::packed_col_length(const char *data_ptr, uint length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4240
{
4241
  if (length > 255)
4242
    return uint2korr(data_ptr)+2;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4243
  else
4244
    return (uint) ((uchar) *data_ptr)+1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4245 4246 4247 4248
}

uint Field_varstring::max_packed_col_length(uint max_length)
{
4249
  return (max_length > 255 ? 2 : 1)+max_length;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4250 4251
}

4252 4253
void Field_varstring::get_key_image(char *buff, uint length, CHARSET_INFO *cs,
				    imagetype type)
4254 4255 4256 4257 4258 4259 4260 4261 4262 4263 4264 4265 4266
{
  length-= HA_KEY_BLOB_LENGTH;
  uint f_length=uint2korr(ptr);
  if (f_length > length)
    f_length= length;
  int2store(buff,length);
  memcpy(buff+2,ptr+2,length);
#ifdef HAVE_purify
  if (f_length < length)
    bzero(buff+2+f_length, (length-f_length));
#endif
}

4267
void Field_varstring::set_key_image(char *buff,uint length, CHARSET_INFO *cs)
4268 4269
{
  length=uint2korr(buff);			// Real length is here
4270
  (void) Field_varstring::store(buff+2, length, cs);
4271 4272 4273 4274
}



bk@work.mysql.com's avatar
bk@work.mysql.com committed
4275 4276 4277 4278 4279 4280
/****************************************************************************
** blob type
** A blob is saved as a length and a pointer. The length is stored in the
** packlength slot and may be from 1-4.
****************************************************************************/

4281
Field_blob::Field_blob(char *ptr_arg, uchar *null_ptr_arg, uchar null_bit_arg,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4282 4283
		       enum utype unireg_check_arg, const char *field_name_arg,
		       struct st_table *table_arg,uint blob_pack_length,
4284
		       CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4285 4286
  :Field_str(ptr_arg, (1L << min(blob_pack_length,3)*8)-1L,
	     null_ptr_arg, null_bit_arg, unireg_check_arg, field_name_arg,
4287
	     table_arg, cs),
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
4288
   geom_flag(true), packlength(blob_pack_length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4289 4290 4291 4292 4293 4294 4295
{
  flags|= BLOB_FLAG;
  if (table)
    table->blob_fields++;
}


4296
void Field_blob::store_length(uint32 number)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4297 4298 4299 4300 4301 4302 4303 4304 4305 4306 4307 4308 4309 4310 4311 4312 4313 4314 4315 4316 4317 4318 4319 4320 4321 4322
{
  switch (packlength) {
  case 1:
    if (number > 255)
    {
      number=255;
      current_thd->cuted_fields++;
    }
    ptr[0]= (uchar) number;
    break;
  case 2:
    if (number > (uint16) ~0)
    {
      number= (uint16) ~0;
      current_thd->cuted_fields++;
    }
#ifdef WORDS_BIGENDIAN
    if (table->db_low_byte_first)
    {
      int2store(ptr,(unsigned short) number);
    }
    else
#endif
      shortstore(ptr,(unsigned short) number);
    break;
  case 3:
4323
    if (number > (uint32) (1L << 24))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4324
    {
4325
      number= (uint32) (1L << 24)-1L;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4326 4327 4328 4329 4330 4331 4332 4333 4334 4335 4336 4337 4338 4339 4340 4341 4342
      current_thd->cuted_fields++;
    }
    int3store(ptr,number);
    break;
  case 4:
#ifdef WORDS_BIGENDIAN
    if (table->db_low_byte_first)
    {
      int4store(ptr,number);
    }
    else
#endif
      longstore(ptr,number);
  }
}


4343
uint32 Field_blob::get_length(const char *pos)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4344 4345 4346
{
  switch (packlength) {
  case 1:
4347
    return (uint32) (uchar) pos[0];
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4348 4349 4350 4351 4352 4353 4354 4355 4356
  case 2:
    {
      uint16 tmp;
#ifdef WORDS_BIGENDIAN
      if (table->db_low_byte_first)
	tmp=sint2korr(pos);
      else
#endif
	shortget(tmp,pos);
4357
      return (uint32) tmp;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4358 4359
    }
  case 3:
4360
    return (uint32) uint3korr(pos);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4361 4362 4363 4364 4365 4366 4367 4368 4369
  case 4:
    {
      uint32 tmp;
#ifdef WORDS_BIGENDIAN
      if (table->db_low_byte_first)
	tmp=uint4korr(pos);
      else
#endif
	longget(tmp,pos);
4370
      return (uint32) tmp;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4371 4372 4373 4374 4375 4376
    }
  }
  return 0;					// Impossible
}


bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4377
int Field_blob::store(const char *from,uint length,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4378
{
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4379
  if (!length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4380 4381 4382 4383 4384
  {
    bzero(ptr,Field_blob::pack_length());
  }
  else
  {
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4385 4386 4387
    char buff[80];
    String tmpstr(buff,sizeof(buff), &my_charset_bin);
    /* Convert character set if nesessary */
4388
    if (use_conversion(cs, field_charset))
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4389 4390 4391 4392 4393
    { 
      tmpstr.copy(from, length, cs, field_charset);
      from= tmpstr.ptr();
      length=  tmpstr.length();
    }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4394 4395
    Field_blob::store_length(length);
    if (table->copy_blobs || length <= MAX_FIELD_WIDTH)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4396
    {						// Must make a copy
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4397
      value.copy(from,length,charset());
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4398 4399 4400 4401
      from=value.ptr();
    }
    bmove(ptr+packlength,(char*) &from,sizeof(char*));
  }
4402
  return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4403 4404 4405
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4406
int Field_blob::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4407
{
4408 4409 4410
  CHARSET_INFO *cs=charset();
  value.set(nr, 2, cs);
  return Field_blob::store(value.ptr(),(uint) value.length(), cs);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4411 4412 4413
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4414
int Field_blob::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4415
{
4416 4417 4418
  CHARSET_INFO *cs=charset();
  value.set(nr, cs);
  return Field_blob::store(value.ptr(), (uint) value.length(), cs);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4419 4420 4421 4422 4423
}


double Field_blob::val_real(void)
{
4424
  int not_used;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4425 4426 4427 4428
  char *blob;
  memcpy_fixed(&blob,ptr+packlength,sizeof(char*));
  if (!blob)
    return 0.0;
4429
  uint32 length=get_length(ptr);
4430
  CHARSET_INFO *cs=charset();
4431
  return my_strntod(cs,blob,length,(char**)0, &not_used);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4432 4433 4434 4435 4436
}


longlong Field_blob::val_int(void)
{
4437
  int not_used;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4438 4439 4440 4441
  char *blob;
  memcpy_fixed(&blob,ptr+packlength,sizeof(char*));
  if (!blob)
    return 0;
4442
  uint32 length=get_length(ptr);
4443
  return my_strntoll(charset(),blob,length,10,NULL,&not_used);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4444 4445 4446 4447 4448 4449 4450 4451 4452
}


String *Field_blob::val_str(String *val_buffer __attribute__((unused)),
			    String *val_ptr)
{
  char *blob;
  memcpy_fixed(&blob,ptr+packlength,sizeof(char*));
  if (!blob)
4453
    val_ptr->set("",0,charset());	// A bit safer than ->length(0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4454
  else
4455
    val_ptr->set((const char*) blob,get_length(ptr),charset());
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4456 4457 4458 4459
  return val_ptr;
}


4460 4461
int Field_blob::cmp(const char *a,uint32 a_length, const char *b,
		    uint32 b_length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4462
{
4463 4464 4465
  int diff=my_strnncoll(field_charset,
			(const uchar*)a,min(a_length,b_length),
			(const uchar*)b,min(a_length,b_length));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4466 4467 4468 4469 4470 4471 4472 4473 4474 4475 4476 4477 4478 4479 4480 4481 4482 4483 4484 4485 4486 4487 4488 4489 4490 4491 4492
  return diff ? diff : (int) (a_length - b_length);
}


int Field_blob::cmp(const char *a_ptr, const char *b_ptr)
{
  char *blob1,*blob2;
  memcpy_fixed(&blob1,a_ptr+packlength,sizeof(char*));
  memcpy_fixed(&blob2,b_ptr+packlength,sizeof(char*));
  return Field_blob::cmp(blob1,get_length(a_ptr),
			 blob2,get_length(b_ptr));
}


int Field_blob::cmp_offset(uint row_offset)
{
  return Field_blob::cmp(ptr,ptr+row_offset);
}


int Field_blob::cmp_binary_offset(uint row_offset)
{
  return cmp_binary(ptr, ptr+row_offset);
}


int Field_blob::cmp_binary(const char *a_ptr, const char *b_ptr,
4493
			   uint32 max_length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4494 4495 4496
{
  char *a,*b;
  uint diff;
4497
  uint32 a_length,b_length;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4498 4499 4500 4501 4502 4503 4504 4505 4506 4507 4508 4509 4510 4511 4512
  memcpy_fixed(&a,a_ptr+packlength,sizeof(char*));
  memcpy_fixed(&b,b_ptr+packlength,sizeof(char*));
  a_length=get_length(a_ptr);
  if (a_length > max_length)
    a_length=max_length;
  b_length=get_length(b_ptr);
  if (b_length > max_length)
    b_length=max_length;
  diff=memcmp(a,b,min(a_length,b_length));
  return diff ? diff : (int) (a_length - b_length);
}


/* The following is used only when comparing a key */

4513
void Field_blob::get_key_image(char *buff,uint length,
4514
			       CHARSET_INFO *cs, imagetype type)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4515
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4516 4517
  length-= HA_KEY_BLOB_LENGTH;
  uint32 blob_length= get_length(ptr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4518
  char *blob;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4519 4520

  if (type == itMBR)
4521
  {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4522
    if (!blob_length)
4523
      return;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4524
    get_ptr(&blob);
4525 4526 4527

    MBR mbr;
    Geometry gobj;
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
4528
    gobj.create_from_wkb(blob + SRID_SIZE, blob_length - SRID_SIZE);
4529 4530 4531 4532 4533 4534 4535 4536
    gobj.get_mbr(&mbr);
    float8store(buff,    mbr.xmin);
    float8store(buff+8,  mbr.xmax);
    float8store(buff+16, mbr.ymin);
    float8store(buff+24, mbr.ymax);
    return;
  }

4537
  if ((uint32) length > blob_length)
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4538
  {
4539 4540 4541 4542
    /*
      Must clear this as we do a memcmp in opt_range.cc to detect
      identical keys
    */
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4543
    bzero(buff+2+blob_length, (length-blob_length));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4544
    length=(uint) blob_length;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4545
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4546 4547 4548 4549 4550
  int2store(buff,length);
  get_ptr(&blob);
  memcpy(buff+2,blob,length);
}

4551
void Field_blob::set_key_image(char *buff,uint length, CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4552 4553
{
  length=uint2korr(buff);
4554
  (void) Field_blob::store(buff+2,length,cs);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4555 4556
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4557

bk@work.mysql.com's avatar
bk@work.mysql.com committed
4558 4559 4560 4561 4562 4563 4564 4565 4566 4567 4568 4569 4570 4571 4572 4573 4574 4575 4576 4577 4578
int Field_blob::key_cmp(const byte *key_ptr, uint max_key_length)
{
  char *blob1;
  uint blob_length=get_length(ptr);
  max_key_length-=2;
  memcpy_fixed(&blob1,ptr+packlength,sizeof(char*));
  return Field_blob::cmp(blob1,min(blob_length, max_key_length),
			 (char*) key_ptr+2,uint2korr(key_ptr));
}

int Field_blob::key_cmp(const byte *a,const byte *b)
{
  return Field_blob::cmp((char*) a+2,uint2korr(a),
			 (char*) b+2,uint2korr(b));
}


void Field_blob::sort_string(char *to,uint length)
{
  char *blob;
  uint blob_length=get_length();
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4579

bk@work.mysql.com's avatar
bk@work.mysql.com committed
4580 4581 4582 4583 4584
  if (!blob_length)
    bzero(to,length);
  else
  {
    memcpy_fixed(&blob,ptr+packlength,sizeof(char*));
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4585 4586 4587 4588
    
    blob_length=my_strnxfrm(field_charset,
                            (unsigned char *)to, length, 
                            (unsigned char *)blob, blob_length);
4589 4590
    if (blob_length < length)
      bzero(to+blob_length, length-blob_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4591 4592 4593 4594 4595 4596 4597
  }
}


void Field_blob::sql_type(String &res) const
{
  const char *str;
4598
  uint length;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4599
  switch (packlength) {
4600 4601 4602 4603 4604 4605
  default: str="tiny"; length=4; break;
  case 2:  str="";     length=0; break;
  case 3:  str="medium"; length= 6; break;
  case 4:  str="long";  length=4; break;
  }
  res.set_latin1(str,length);
4606
  if (charset() == &my_charset_bin)
4607 4608 4609 4610 4611 4612 4613 4614 4615
    res.append("blob");
  else
  {
    res.append("text");
    if (field_charset != table->table_charset)
    {
      res.append(" character set ");
      res.append(field_charset->csname);
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4616 4617 4618 4619
  }
}


4620 4621 4622 4623
char *Field_blob::pack(char *to, const char *from, uint max_length)
{
  char *save=ptr;
  ptr=(char*) from;
4624
  uint32 length=get_length();			// Length of from string
4625 4626 4627 4628 4629 4630 4631 4632 4633 4634 4635 4636 4637 4638 4639 4640 4641 4642 4643 4644 4645 4646
  if (length > max_length)
  {
    ptr=to;
    length=max_length;
    store_length(length);			// Store max length
    ptr=(char*) from;
  }
  else
    memcpy(to,from,packlength);			// Copy length
  if (length)
  {
    get_ptr((char**) &from);
    memcpy(to+packlength, from,length);
  }
  ptr=save;					// Restore org row pointer
  return to+packlength+length;
}


const char *Field_blob::unpack(char *to, const char *from)
{
  memcpy(to,from,packlength);
4647
  uint32 length=get_length(from);
4648 4649 4650 4651 4652 4653 4654 4655
  from+=packlength;
  if (length)
    memcpy_fixed(to+packlength, &from, sizeof(from));
  else
    bzero(to+packlength,sizeof(from));
  return from+length;
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
4656 4657 4658 4659 4660 4661 4662 4663 4664 4665 4666 4667 4668 4669 4670 4671
/* Keys for blobs are like keys on varchars */

int Field_blob::pack_cmp(const char *a, const char *b, uint key_length)
{
  uint a_length;
  uint b_length;
  if (key_length > 255)
  {
    a_length=uint2korr(a); a+=2;
    b_length=uint2korr(b); b+=2;
  }
  else
  {
    a_length= (uint) (uchar) *a++;
    b_length= (uint) (uchar) *b++;
  }
4672 4673 4674
  return my_strnncoll(field_charset,
		     (const uchar *)a,a_length,
		     (const uchar *)b,b_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4675 4676
}

4677 4678 4679 4680 4681 4682 4683 4684 4685 4686 4687 4688 4689 4690 4691 4692 4693 4694

int Field_blob::pack_cmp(const char *b, uint key_length)
{
  char *a;
  memcpy_fixed(&a,ptr+packlength,sizeof(char*));
  if (!a)
    return key_length > 0 ? -1 : 0;
  uint a_length=get_length(ptr);
  uint b_length;

  if (key_length > 255)
  {
    b_length=uint2korr(b); b+=2;
  }
  else
  {
    b_length= (uint) (uchar) *b++;
  }
4695 4696 4697
  return my_strnncoll(field_charset,
		     (const uchar *)a,a_length,
		     (const uchar *)b,b_length);
4698 4699
}

4700
/* Create a packed key that will be used for storage from a MySQL row */
4701

bk@work.mysql.com's avatar
bk@work.mysql.com committed
4702 4703
char *Field_blob::pack_key(char *to, const char *from, uint max_length)
{
4704 4705
  char *save=ptr;
  ptr=(char*) from;
4706
  uint32 length=get_length();			// Length of from string
4707 4708 4709 4710 4711 4712 4713 4714 4715 4716 4717 4718 4719 4720 4721 4722 4723 4724 4725 4726
  if (length > max_length)
    length=max_length;
  *to++= (uchar) length;
  if (max_length > 255)				// 2 byte length
    *to++= (uchar) (length >> 8);
  if (length)
  {
    get_ptr((char**) &from);
    memcpy(to, from, length);
  }
  ptr=save;					// Restore org row pointer
  return to+length;
}

/* Create a packed key that will be used for storage from a MySQL key */

char *Field_blob::pack_key_from_key_image(char *to, const char *from,
					  uint max_length)
{
  uint length=uint2korr(from);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4727 4728
  if (length > max_length)
    length=max_length;
4729
  *to++= (char) (length & 255);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4730
  if (max_length > 255)
4731
    *to++= (char) (length >> 8);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4732 4733 4734 4735 4736
  if (length)
    memcpy(to, from+2, length);
  return to+length;
}

4737
uint Field_blob::packed_col_length(const char *data_ptr, uint length)
4738 4739
{
  if (length > 255)
4740
    return uint2korr(data_ptr)+2;
4741
  else
4742
    return (uint) ((uchar) *data_ptr)+1;
4743 4744 4745 4746 4747 4748
}

uint Field_blob::max_packed_col_length(uint max_length)
{
  return (max_length > 255 ? 2 : 1)+max_length;
}
4749

ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
4750 4751 4752 4753 4754 4755 4756 4757 4758 4759 4760 4761 4762 4763 4764 4765 4766 4767 4768 4769 4770 4771 4772 4773 4774 4775 4776 4777

void Field_geom::get_key_image(char *buff, uint length, CHARSET_INFO *cs,
			       imagetype type)
{
  length-= HA_KEY_BLOB_LENGTH;
  ulong blob_length= get_length(ptr);
  char *blob;
  get_ptr(&blob);

  MBR mbr;
  Geometry gobj;
  gobj.create_from_wkb(blob + SRID_SIZE, blob_length - SRID_SIZE);
  gobj.get_mbr(&mbr);
  float8store(buff, mbr.xmin);
  float8store(buff + 8, mbr.xmax);
  float8store(buff + 16, mbr.ymin);
  float8store(buff + 24, mbr.ymax);
  return;
}


void Field_geom::set_key_image(char *buff, uint length, CHARSET_INFO *cs)
{
  Field_blob::set_key_image(buff, length, cs);
}

void Field_geom::sql_type(String &res) const
{
4778 4779 4780 4781 4782 4783 4784 4785 4786 4787 4788 4789 4790 4791 4792 4793 4794 4795 4796 4797 4798 4799 4800 4801 4802 4803 4804
  CHARSET_INFO *cs= &my_charset_latin1;
  switch (geom_type)
  {
    case GEOM_POINT:
     res.set("point", 5, cs);
     break;
    case GEOM_LINESTRING:
     res.set("linestring", 10, cs);
     break;
    case GEOM_POLYGON:
     res.set("polygon", 7, cs);
     break;
    case GEOM_MULTIPOINT:
     res.set("multipoint", 10, cs);
     break;
    case GEOM_MULTILINESTRING:
     res.set("multilinestring", 15, cs);
     break;
    case GEOM_MULTIPOLYGON:
     res.set("multipolygon", 12, cs);
     break;
    case GEOM_GEOMETRYCOLLECTION:
     res.set("geometrycollection", 18, cs);
     break;
    default:
     res.set("geometry", 8, cs);
  }
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
4805 4806 4807 4808 4809 4810 4811 4812 4813 4814 4815 4816 4817 4818 4819 4820 4821 4822 4823 4824 4825 4826 4827 4828 4829 4830 4831 4832 4833
}


int Field_geom::store(const char *from, uint length, CHARSET_INFO *cs)
{
  if (!length)
  {
    bzero(ptr, Field_blob::pack_length());
  }
  else
  {
    // Should check given WKB
    if (length < 4 + 1 + 4 + 8 + 8)		// SRID + WKB_HEADER + X + Y
      return 1;
    uint32 wkb_type= uint4korr(from + 5);
    if (wkb_type < 1 || wkb_type > 7)
      return 1;
    Field_blob::store_length(length);
    if (table->copy_blobs || length <= MAX_FIELD_WIDTH)
    {						// Must make a copy
      value.copy(from, length, cs);
      from= value.ptr();
    }
    bmove(ptr + packlength, (char*) &from, sizeof(char*));
  }
  return 0;
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
4834 4835 4836 4837 4838 4839 4840 4841 4842 4843 4844 4845 4846 4847 4848 4849 4850 4851 4852 4853 4854 4855 4856 4857 4858 4859 4860 4861 4862 4863 4864 4865 4866 4867 4868 4869 4870 4871 4872 4873 4874 4875 4876 4877 4878 4879 4880 4881 4882 4883 4884 4885 4886 4887 4888 4889 4890 4891
/****************************************************************************
** enum type.
** This is a string which only can have a selection of different values.
** If one uses this string in a number context one gets the type number.
****************************************************************************/

enum ha_base_keytype Field_enum::key_type() const
{
  switch (packlength) {
  default: return HA_KEYTYPE_BINARY;
  case 2: return HA_KEYTYPE_USHORT_INT;
  case 3: return HA_KEYTYPE_UINT24;
  case 4: return HA_KEYTYPE_ULONG_INT;
  case 8: return HA_KEYTYPE_ULONGLONG;
  }
}

void Field_enum::store_type(ulonglong value)
{
  switch (packlength) {
  case 1: ptr[0]= (uchar) value;  break;
  case 2:
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int2store(ptr,(unsigned short) value);
  }
  else
#endif
    shortstore(ptr,(unsigned short) value);
  break;
  case 3: int3store(ptr,(long) value); break;
  case 4:
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int4store(ptr,value);
  }
  else
#endif
    longstore(ptr,(long) value);
  break;
  case 8:
#ifdef WORDS_BIGENDIAN
  if (table->db_low_byte_first)
  {
    int8store(ptr,value);
  }
  else
#endif
    longlongstore(ptr,value); break;
  }
}


uint find_enum(TYPELIB *lib,const char *x, uint length)
{
  const char *end=x+length;
4892
  while (end > x && my_isspace(system_charset_info,end[-1]))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4893 4894 4895 4896 4897 4898
    end--;

  const char *i;
  const char *j;
  for (uint pos=0 ; (j=lib->type_names[pos]) ; pos++)
  {
4899 4900 4901
    for (i=x ; i != end && 
               my_toupper(system_charset_info,*i) == 
               my_toupper(system_charset_info,*j) ; i++, j++) ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4902 4903 4904 4905 4906 4907 4908 4909 4910 4911 4912 4913
    if (i == end && ! *j)
      return(pos+1);
  }
  return(0);
}


/*
** Note. Storing a empty string in a enum field gives a warning
** (if there isn't a empty value in the enum)
*/

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4914
int Field_enum::store(const char *from,uint length,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4915
{
4916
  int err= 0;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4917 4918 4919
  char buff[80];
  String tmpstr(buff,sizeof(buff), &my_charset_bin);
  /* Convert character set if nesessary */
4920
  if (use_conversion(cs, field_charset))
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
4921 4922 4923 4924 4925
  { 
    tmpstr.copy(from, length, cs, field_charset);
    from= tmpstr.ptr();
    length=  tmpstr.length();
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4926
  uint tmp=find_enum(typelib,from,length);
4927
  if (!tmp)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4928
  {
4929
    if (length < 6)			// Can't be more than 99999 enums
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4930
    {
4931
      /* This is for reading numbers with LOAD DATA INFILE */
4932
      char *end;
4933 4934
      tmp=(uint) my_strntoul(cs,from,length,10,&end,&err);
      if (err || end != from+length || tmp > typelib->count)
4935 4936 4937 4938
      {
	tmp=0;
	current_thd->cuted_fields++;
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4939 4940
    }
    else
4941
      current_thd->cuted_fields++;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4942
  }
4943
  store_type((ulonglong) tmp);
4944
  return err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4945 4946 4947
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4948
int Field_enum::store(double nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4949
{
4950
  return Field_enum::store((longlong) nr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4951 4952 4953
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4954
int Field_enum::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4955
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4956
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4957 4958 4959 4960
  if ((uint) nr > typelib->count || nr == 0)
  {
    current_thd->cuted_fields++;
    nr=0;
4961
    error=1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4962 4963
  }
  store_type((ulonglong) (uint) nr);
4964
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
4965 4966 4967 4968 4969 4970 4971 4972 4973 4974 4975 4976 4977 4978 4979 4980 4981 4982 4983 4984 4985 4986 4987 4988 4989 4990 4991 4992 4993 4994 4995 4996 4997 4998 4999 5000 5001 5002 5003 5004 5005 5006 5007 5008 5009 5010 5011 5012 5013 5014 5015 5016 5017 5018 5019 5020 5021 5022 5023 5024 5025 5026
}


double Field_enum::val_real(void)
{
  return (double) Field_enum::val_int();
}


longlong Field_enum::val_int(void)
{
  switch (packlength) {
  case 1:
    return (longlong) (uchar) ptr[0];
  case 2:
    {
      uint16 tmp;
#ifdef WORDS_BIGENDIAN
      if (table->db_low_byte_first)
	tmp=sint2korr(ptr);
      else
#endif
	shortget(tmp,ptr);
      return (longlong) tmp;
    }
  case 3:
    return (longlong) uint3korr(ptr);
  case 4:
    {
      uint32 tmp;
#ifdef WORDS_BIGENDIAN
      if (table->db_low_byte_first)
	tmp=uint4korr(ptr);
      else
#endif
	longget(tmp,ptr);
      return (longlong) tmp;
    }
  case 8:
    {
      longlong tmp;
#ifdef WORDS_BIGENDIAN
      if (table->db_low_byte_first)
	tmp=sint8korr(ptr);
      else
#endif
	longlongget(tmp,ptr);
      return tmp;
    }
  }
  return 0;					// impossible
}


String *Field_enum::val_str(String *val_buffer __attribute__((unused)),
			    String *val_ptr)
{
  uint tmp=(uint) Field_enum::val_int();
  if (!tmp || tmp > typelib->count)
    val_ptr->length(0);
  else
    val_ptr->set((const char*) typelib->type_names[tmp-1],
5027
		 (uint) strlen(typelib->type_names[tmp-1]),
5028
		 field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5029 5030 5031 5032 5033 5034 5035 5036 5037 5038 5039 5040 5041 5042 5043 5044 5045 5046 5047 5048 5049 5050 5051 5052 5053 5054 5055 5056 5057 5058 5059 5060 5061 5062 5063 5064
  return val_ptr;
}

int Field_enum::cmp(const char *a_ptr, const char *b_ptr)
{
  char *old=ptr;
  ptr=(char*) a_ptr;
  ulonglong a=Field_enum::val_int();
  ptr=(char*) b_ptr;
  ulonglong b=Field_enum::val_int();
  ptr=old;
  return (a < b) ? -1 : (a > b) ? 1 : 0;
}

void Field_enum::sort_string(char *to,uint length __attribute__((unused)))
{
  ulonglong value=Field_enum::val_int();
  to+=packlength-1;
  for (uint i=0 ; i < packlength ; i++)
  {
    *to-- = (uchar) (value & 255);
    value>>=8;
  }
}


void Field_enum::sql_type(String &res) const
{
  res.length(0);
  res.append("enum(");

  bool flag=0;
  for (const char **pos=typelib->type_names; *pos ; pos++)
  {
    if (flag)
      res.append(',');
5065
    append_unescaped(&res, *pos, strlen(*pos));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5066 5067 5068
    flag=1;
  }
  res.append(')');
5069
  add_binary_or_charset(res);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5070 5071 5072
}


5073 5074 5075 5076 5077 5078 5079 5080 5081 5082 5083 5084
/*
   set type.
   This is a string which can have a collection of different values.
   Each string value is separated with a ','.
   For example "One,two,five"
   If one uses this string in a number context one gets the bits as a longlong
   number.

   If there was a value in string that wasn't in set, the 'err_pos' points to
   the last invalid value found. 'err_len' will be set to length of the
   error string.
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5085

5086 5087
ulonglong find_set(TYPELIB *lib, const char *x, uint length, char **err_pos,
                   uint *err_len)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5088
{
5089 5090
  const char *end= x + length;
  *err_pos= 0;                  // No error yet
5091
  while (end > x && my_isspace(system_charset_info, end[-1]))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5092 5093
    end--;

5094 5095
  *err_len= 0;
  ulonglong found= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5096 5097
  if (x != end)
  {
5098
    const char *start= x;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5099
    bool error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5100 5101
    for (;;)
    {
5102 5103 5104 5105 5106 5107
      const char *pos= start;
      uint var_len;

      for (; pos != end && *pos != field_separator; pos++) ;
      var_len= (uint) (pos - start);
      uint find= find_enum(lib, start, var_len);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5108
      if (!find)
5109 5110 5111 5112 5113
      {
        *err_pos= (char*) start;
        *err_len= var_len;
        error= 1;
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5114
      else
5115
        found|= ((longlong) 1 << (find - 1));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5116
      if (pos == end)
5117 5118
        break;
      start= pos + 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5119 5120 5121 5122 5123 5124 5125 5126
    }
    if (error)
      current_thd->cuted_fields++;
  }
  return found;
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5127
int Field_set::store(const char *from,uint length,CHARSET_INFO *cs)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5128
{
5129
  int err= 0;
5130 5131
  char *not_used;
  uint not_used2;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
5132 5133 5134
  char buff[80];
  String tmpstr(buff,sizeof(buff), &my_charset_bin);
  /* Convert character set if nesessary */
5135
  if (use_conversion(cs, field_charset))
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
5136 5137 5138 5139 5140
  { 
    tmpstr.copy(from, length, cs, field_charset);
    from= tmpstr.ptr();
    length=  tmpstr.length();
  }
5141
  ulonglong tmp= find_set(typelib, from, length, &not_used, &not_used2);
5142 5143 5144
  if (!tmp && length && length < 22)
  {
    /* This is for reading numbers with LOAD DATA INFILE */
5145
    char *end;
5146 5147
    tmp=my_strntoull(cs,from,length,10,&end,&err);
    if (err || end != from+length ||
5148
	tmp > (ulonglong) (((longlong) 1 << typelib->count) - (longlong) 1))
5149
    {
5150
      tmp=0;
5151
    }
5152 5153 5154 5155
    else
      current_thd->cuted_fields--;		// Remove warning from find_set
  }
  store_type(tmp);
5156
  return err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5157 5158 5159
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5160
int Field_set::store(longlong nr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5161
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5162
  int error= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5163 5164 5165 5166 5167
  if ((ulonglong) nr > (ulonglong) (((longlong) 1 << typelib->count) -
				    (longlong) 1))
  {
    nr&= (longlong) (((longlong) 1 << typelib->count) - (longlong) 1);
    current_thd->cuted_fields++;
5168
    error=1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5169 5170
  }
  store_type((ulonglong) nr);
5171
  return error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5172 5173 5174 5175 5176 5177 5178 5179 5180 5181 5182 5183 5184 5185 5186 5187 5188
}


String *Field_set::val_str(String *val_buffer,
			   String *val_ptr __attribute__((unused)))
{
  ulonglong tmp=(ulonglong) Field_enum::val_int();
  uint bitnr=0;

  val_buffer->length(0);
  while (tmp && bitnr < (uint) typelib->count)
  {
    if (tmp & 1)
    {
      if (val_buffer->length())
	val_buffer->append(field_separator);
      String str(typelib->type_names[bitnr],
5189
		 (uint) strlen(typelib->type_names[bitnr]),
5190
		 field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5191 5192 5193 5194 5195 5196 5197 5198 5199 5200 5201 5202 5203 5204 5205 5206 5207 5208 5209
      val_buffer->append(str);
    }
    tmp>>=1;
    bitnr++;
  }
  return val_buffer;
}


void Field_set::sql_type(String &res) const
{
  res.length(0);
  res.append("set(");

  bool flag=0;
  for (const char **pos=typelib->type_names; *pos ; pos++)
  {
    if (flag)
      res.append(',');
5210
    append_unescaped(&res, *pos, strlen(*pos));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5211 5212 5213
    flag=1;
  }
  res.append(')');
5214
  add_binary_or_charset(res);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5215 5216 5217 5218 5219 5220
}

/* returns 1 if the fields are equally defined */

bool Field::eq_def(Field *field)
{
5221
  if (real_type() != field->real_type() || charset() != field->charset() ||
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5222 5223 5224 5225 5226 5227 5228 5229 5230 5231
      pack_length() != field->pack_length())
    return 0;
  return 1;
}

bool Field_enum::eq_def(Field *field)
{
  if (!Field::eq_def(field))
    return 0;
  TYPELIB *from_lib=((Field_enum*) field)->typelib;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
5232

bk@work.mysql.com's avatar
bk@work.mysql.com committed
5233 5234 5235
  if (typelib->count < from_lib->count)
    return 0;
  for (uint i=0 ; i < from_lib->count ; i++)
5236 5237
    if (my_strcasecmp(field_charset,
                      typelib->type_names[i],from_lib->type_names[i]))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5238 5239 5240 5241 5242
      return 0;
  return 1;
}

bool Field_num::eq_def(Field *field)
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
5243
{
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5244 5245 5246 5247 5248 5249 5250 5251 5252 5253 5254 5255 5256 5257 5258 5259 5260
  if (!Field::eq_def(field))
    return 0;
  Field_num *from_num= (Field_num*) field;

  if (unsigned_flag != from_num->unsigned_flag ||
      zerofill && !from_num->zerofill && !zero_pack() ||
      dec != from_num->dec)
    return 0;
  return 1;
}


/*****************************************************************************
** Handling of field and create_field
*****************************************************************************/

/*
5261
  Make a field from the .frm file info
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5262 5263 5264 5265 5266 5267 5268 5269 5270 5271 5272 5273 5274 5275 5276 5277 5278 5279 5280 5281 5282 5283 5284
*/

uint32 calc_pack_length(enum_field_types type,uint32 length)
{
  switch (type) {
  case FIELD_TYPE_STRING:
  case FIELD_TYPE_DECIMAL: return (length);
  case FIELD_TYPE_VAR_STRING: return (length+2);
  case FIELD_TYPE_YEAR:
  case FIELD_TYPE_TINY	: return 1;
  case FIELD_TYPE_SHORT : return 2;
  case FIELD_TYPE_INT24:
  case FIELD_TYPE_NEWDATE:
  case FIELD_TYPE_TIME:   return 3;
  case FIELD_TYPE_TIMESTAMP:
  case FIELD_TYPE_DATE:
  case FIELD_TYPE_LONG	: return 4;
  case FIELD_TYPE_FLOAT : return sizeof(float);
  case FIELD_TYPE_DOUBLE: return sizeof(double);
  case FIELD_TYPE_DATETIME:
  case FIELD_TYPE_LONGLONG: return 8;	/* Don't crash if no longlong */
  case FIELD_TYPE_NULL	: return 0;
  case FIELD_TYPE_TINY_BLOB:	return 1+portable_sizeof_char_ptr;
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
5285 5286
  case FIELD_TYPE_BLOB:
  case FIELD_TYPE_GEOMETRY:	return 2+portable_sizeof_char_ptr;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5287 5288 5289 5290
  case FIELD_TYPE_MEDIUM_BLOB:	return 3+portable_sizeof_char_ptr;
  case FIELD_TYPE_LONG_BLOB:	return 4+portable_sizeof_char_ptr;
  case FIELD_TYPE_SET:
  case FIELD_TYPE_ENUM: abort(); return 0;	// This shouldn't happen
5291
  default: return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5292 5293 5294 5295 5296 5297 5298 5299 5300 5301 5302 5303 5304 5305 5306 5307 5308 5309 5310
  }
  return 0;					// This shouldn't happen
}


uint pack_length_to_packflag(uint type)
{
  switch (type) {
    case 1: return f_settype((uint) FIELD_TYPE_TINY);
    case 2: return f_settype((uint) FIELD_TYPE_SHORT);
    case 3: return f_settype((uint) FIELD_TYPE_INT24);
    case 4: return f_settype((uint) FIELD_TYPE_LONG);
    case 8: return f_settype((uint) FIELD_TYPE_LONGLONG);
  }
  return 0;					// This shouldn't happen
}


Field *make_field(char *ptr, uint32 field_length,
5311
		  uchar *null_pos, uchar null_bit,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5312
		  uint pack_flag,
5313
		  enum_field_types field_type,
5314
		  CHARSET_INFO *field_charset,
5315
		  Field::geometry_type geom_type,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5316 5317 5318 5319 5320 5321 5322 5323 5324 5325 5326 5327 5328 5329
		  Field::utype unireg_check,
		  TYPELIB *interval,
		  const char *field_name,
		  struct st_table *table)
{
  if (!f_maybe_null(pack_flag))
  {
    null_pos=0;
    null_bit=0;
  }
  if (f_is_alpha(pack_flag))
  {
    if (!f_is_packed(pack_flag))
      return new Field_string(ptr,field_length,null_pos,null_bit,
5330
			      unireg_check, field_name, table, field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5331 5332 5333 5334 5335

    uint pack_length=calc_pack_length((enum_field_types)
				      f_packtype(pack_flag),
				      field_length);

5336 5337
    if (f_is_geom(pack_flag))
      return new Field_geom(ptr,null_pos,null_bit,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5338
			    unireg_check, field_name, table,
5339
			    pack_length, geom_type);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5340 5341 5342
    if (f_is_blob(pack_flag))
      return new Field_blob(ptr,null_pos,null_bit,
			    unireg_check, field_name, table,
hf@deer.mysql.r18.ru's avatar
hf@deer.mysql.r18.ru committed
5343
			    pack_length, field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5344 5345 5346 5347 5348
    if (interval)
    {
      if (f_is_enum(pack_flag))
	return new Field_enum(ptr,field_length,null_pos,null_bit,
				  unireg_check, field_name, table,
5349
				  pack_length, interval, field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5350 5351 5352
      else
	return new Field_set(ptr,field_length,null_pos,null_bit,
			     unireg_check, field_name, table,
5353
			     pack_length, interval, field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5354 5355 5356
    }
  }

5357
  switch (field_type) {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5358 5359 5360 5361 5362 5363 5364 5365 5366 5367 5368 5369 5370 5371 5372 5373 5374 5375 5376 5377 5378 5379 5380 5381 5382 5383 5384 5385 5386 5387 5388 5389 5390 5391 5392 5393 5394 5395 5396 5397 5398 5399 5400 5401 5402
  case FIELD_TYPE_DECIMAL:
    return new Field_decimal(ptr,field_length,null_pos,null_bit,
			     unireg_check, field_name, table,
			     f_decimals(pack_flag),
			     f_is_zerofill(pack_flag) != 0,
			     f_is_dec(pack_flag) == 0);
  case FIELD_TYPE_FLOAT:
    return new Field_float(ptr,field_length,null_pos,null_bit,
			   unireg_check, field_name, table,
			   f_decimals(pack_flag),
			   f_is_zerofill(pack_flag) != 0,
			   f_is_dec(pack_flag)== 0);
  case FIELD_TYPE_DOUBLE:
    return new Field_double(ptr,field_length,null_pos,null_bit,
			    unireg_check, field_name, table,
			    f_decimals(pack_flag),
			    f_is_zerofill(pack_flag) != 0,
			    f_is_dec(pack_flag)== 0);
  case FIELD_TYPE_TINY:
    return new Field_tiny(ptr,field_length,null_pos,null_bit,
			  unireg_check, field_name, table,
			  f_is_zerofill(pack_flag) != 0,
			  f_is_dec(pack_flag) == 0);
  case FIELD_TYPE_SHORT:
    return new Field_short(ptr,field_length,null_pos,null_bit,
			   unireg_check, field_name, table,
			   f_is_zerofill(pack_flag) != 0,
			   f_is_dec(pack_flag) == 0);
  case FIELD_TYPE_INT24:
    return new Field_medium(ptr,field_length,null_pos,null_bit,
			    unireg_check, field_name, table,
			    f_is_zerofill(pack_flag) != 0,
			    f_is_dec(pack_flag) == 0);
  case FIELD_TYPE_LONG:
    return new Field_long(ptr,field_length,null_pos,null_bit,
			   unireg_check, field_name, table,
			   f_is_zerofill(pack_flag) != 0,
			   f_is_dec(pack_flag) == 0);
  case FIELD_TYPE_LONGLONG:
    return new Field_longlong(ptr,field_length,null_pos,null_bit,
			      unireg_check, field_name, table,
			      f_is_zerofill(pack_flag) != 0,
			      f_is_dec(pack_flag) == 0);
  case FIELD_TYPE_TIMESTAMP:
    return new Field_timestamp(ptr,field_length,
5403
			       unireg_check, field_name, table, field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5404 5405 5406 5407 5408
  case FIELD_TYPE_YEAR:
    return new Field_year(ptr,field_length,null_pos,null_bit,
			  unireg_check, field_name, table);
  case FIELD_TYPE_DATE:
    return new Field_date(ptr,null_pos,null_bit,
5409
			  unireg_check, field_name, table, field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5410 5411
  case FIELD_TYPE_NEWDATE:
    return new Field_newdate(ptr,null_pos,null_bit,
5412
			     unireg_check, field_name, table, field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5413 5414
  case FIELD_TYPE_TIME:
    return new Field_time(ptr,null_pos,null_bit,
5415
			  unireg_check, field_name, table, field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5416 5417
  case FIELD_TYPE_DATETIME:
    return new Field_datetime(ptr,null_pos,null_bit,
5418
			      unireg_check, field_name, table, field_charset);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5419
  case FIELD_TYPE_NULL:
5420
    return new Field_null(ptr,field_length,unireg_check,field_name,table, field_charset);
5421 5422
  default:					// Impossible (Wrong version)
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5423
  }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
5424
  return 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5425 5426 5427 5428 5429
}


/* Create a field suitable for create of table */

5430
create_field::create_field(Field *old_field,Field *orig_field)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5431 5432 5433 5434 5435 5436 5437 5438
{
  field=      old_field;
  field_name=change=old_field->field_name;
  length=     old_field->field_length;
  flags=      old_field->flags;
  unireg_check=old_field->unireg_check;
  pack_length=old_field->pack_length();
  sql_type=   old_field->real_type();
5439 5440
  charset=    old_field->charset();		// May be NULL ptr
  comment=    old_field->comment;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5441 5442 5443 5444 5445 5446 5447 5448

  /* Fix if the original table had 4 byte pointer blobs */
  if (flags & BLOB_FLAG)
    pack_length= (pack_length- old_field->table->blob_ptr_size +
		  portable_sizeof_char_ptr);
  decimals= old_field->decimals();
  if (sql_type == FIELD_TYPE_STRING)
  {
5449
    /* Change CHAR -> VARCHAR if dynamic record length */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5450 5451 5452 5453 5454 5455 5456
    sql_type=old_field->type();
    decimals=0;
  }
  if (flags & (ENUM_FLAG | SET_FLAG))
    interval= ((Field_enum*) old_field)->typelib;
  else
    interval=0;
5457
  def=0;
5458 5459 5460
  if (!old_field->is_real_null() && ! (flags & BLOB_FLAG) &&
      old_field->type() != FIELD_TYPE_TIMESTAMP && old_field->ptr &&
      orig_field)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5461 5462
  {
    char buff[MAX_FIELD_WIDTH],*pos;
5463
    String tmp(buff,sizeof(buff), charset);
5464 5465 5466 5467

    /* Get the value from record[2] (the default value row) */
    my_ptrdiff_t diff= (my_ptrdiff_t) (orig_field->table->rec_buff_length*2);
    orig_field->move_field(diff);		// Points now at record[2]
5468
    bool is_null=orig_field->is_real_null();
5469
    orig_field->val_str(&tmp,&tmp);
5470
    orig_field->move_field(-diff);		// Back to record[0]
5471
    if (!is_null)
5472 5473 5474
    {
      pos= (char*) sql_memdup(tmp.ptr(),tmp.length()+1);
      pos[tmp.length()]=0;
5475
      def=new Item_string(pos,tmp.length(), charset);
5476
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5477
  }
5478 5479 5480 5481
  if (sql_type == FIELD_TYPE_GEOMETRY)
  {
    geom_type= ((Field_geom*)old_field)->geom_type;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
5482
}