item_func.h 38.4 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
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.
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.
12

bk@work.mysql.com's avatar
bk@work.mysql.com committed
13 14 15 16 17 18 19
   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 */


/* Function items used by mysql */

20
#ifdef USE_PRAGMA_INTERFACE
bk@work.mysql.com's avatar
bk@work.mysql.com committed
21 22 23 24 25 26 27 28 29 30 31 32 33
#pragma interface			/* gcc class implementation */
#endif

#ifdef HAVE_IEEEFP_H
extern "C"				/* Bug in BSDI include file */
{
#include <ieeefp.h>
}
#endif

class Item_func :public Item_result_field
{
protected:
34
  Item **args, *tmp_arg[2];
35 36 37 38
  /*
    Allowed numbers of columns in result (usually 1, which means scalar value)
    0 means get this number from first argument
  */
39
  uint allowed_arg_cols;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
40 41
public:
  uint arg_count;
42
  table_map used_tables_cache, not_null_tables_cache;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
43 44 45
  bool const_item_cache;
  enum Functype { UNKNOWN_FUNC,EQ_FUNC,EQUAL_FUNC,NE_FUNC,LT_FUNC,LE_FUNC,
		  GE_FUNC,GT_FUNC,FT_FUNC,
46
		  LIKE_FUNC,ISNULL_FUNC,ISNOTNULL_FUNC,
47 48
		  COND_AND_FUNC, COND_OR_FUNC, COND_XOR_FUNC,
                  BETWEEN, IN_FUNC, MULT_EQUAL_FUNC,
49
		  INTERVAL_FUNC, ISNOTNULLTEST_FUNC,
50 51 52 53
		  SP_EQUALS_FUNC, SP_DISJOINT_FUNC,SP_INTERSECTS_FUNC,
		  SP_TOUCHES_FUNC,SP_CROSSES_FUNC,SP_WITHIN_FUNC,
		  SP_CONTAINS_FUNC,SP_OVERLAPS_FUNC,
		  SP_STARTPOINT,SP_ENDPOINT,SP_EXTERIORRING,
54
		  SP_POINTN,SP_GEOMETRYN,SP_INTERIORRINGN,
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
55 56
                  NOT_FUNC, NOT_ALL_FUNC,
                  NOW_FUNC, TRIG_COND_FUNC,
57
                  GUSERVAR_FUNC, COLLATE_FUNC,
58
                  EXTRACT_FUNC, CHAR_TYPECAST_FUNC, FUNC_SP };
59 60
  enum optimize_type { OPTIMIZE_NONE,OPTIMIZE_KEY,OPTIMIZE_OP, OPTIMIZE_NULL,
                       OPTIMIZE_EQUAL };
bk@work.mysql.com's avatar
bk@work.mysql.com committed
61 62
  enum Type type() const { return FUNC_ITEM; }
  virtual enum Functype functype() const   { return UNKNOWN_FUNC; }
63 64
  Item_func(void):
    allowed_arg_cols(1), arg_count(0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
65
  {
66
    with_sum_func= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
67
  }
68 69
  Item_func(Item *a):
    allowed_arg_cols(1), arg_count(1)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
70
  {
71
    args= tmp_arg;
72 73
    args[0]= a;
    with_sum_func= a->with_sum_func;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
74
  }
75 76
  Item_func(Item *a,Item *b):
    allowed_arg_cols(1), arg_count(2)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
77
  {
78
    args= tmp_arg;
79 80
    args[0]= a; args[1]= b;
    with_sum_func= a->with_sum_func || b->with_sum_func;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
81
  }
82 83
  Item_func(Item *a,Item *b,Item *c):
    allowed_arg_cols(1)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
84
  {
85 86
    arg_count= 0;
    if ((args= (Item**) sql_alloc(sizeof(Item*)*3)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
87
    {
88 89 90
      arg_count= 3;
      args[0]= a; args[1]= b; args[2]= c;
      with_sum_func= a->with_sum_func || b->with_sum_func || c->with_sum_func;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
91 92
    }
  }
93 94
  Item_func(Item *a,Item *b,Item *c,Item *d):
    allowed_arg_cols(1)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
95
  {
96 97
    arg_count= 0;
    if ((args= (Item**) sql_alloc(sizeof(Item*)*4)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
98
    {
99 100 101 102
      arg_count= 4;
      args[0]= a; args[1]= b; args[2]= c; args[3]= d;
      with_sum_func= a->with_sum_func || b->with_sum_func ||
	c->with_sum_func || d->with_sum_func;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
103 104
    }
  }
105 106
  Item_func(Item *a,Item *b,Item *c,Item *d,Item* e):
    allowed_arg_cols(1)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
107
  {
108 109
    arg_count= 5;
    if ((args= (Item**) sql_alloc(sizeof(Item*)*5)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
110
    {
111 112 113
      args[0]= a; args[1]= b; args[2]= c; args[3]= d; args[4]= e;
      with_sum_func= a->with_sum_func || b->with_sum_func ||
	c->with_sum_func || d->with_sum_func || e->with_sum_func ;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
114 115 116
    }
  }
  Item_func(List<Item> &list);
117
  // Constructor used for Item_cond_and/or (see Item comment)
118
  Item_func(THD *thd, Item_func *item);
119
  bool fix_fields(THD *, Item **ref);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
120
  table_map used_tables() const;
121
  table_map not_null_tables() const;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
122
  void update_used_tables();
123
  bool eq(const Item *item, bool binary_cmp) const;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
124 125 126
  virtual optimize_type select_optimize() const { return OPTIMIZE_NONE; }
  virtual bool have_rev_func() const { return 0; }
  virtual Item *key_item() const { return args[0]; }
127 128 129 130 131 132 133 134 135 136 137
  /*
    This method is used for debug purposes to print the name of an
    item to the debug log. The second use of this method is as
    a helper function of print(), where it is applicable.
    To suit both goals it should return a meaningful,
    distinguishable and sintactically correct string.  This method
    should not be used for runtime type identification, use enum
    {Sum}Functype and Item_func::functype()/Item_sum::sum_func()
    instead.
  */
  virtual const char *func_name() const= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
138 139
  virtual bool const_item() const { return const_item_cache; }
  inline Item **arguments() const { return args; }
140
  void set_arguments(List<Item> &list);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
141 142
  inline uint argument_count() const { return arg_count; }
  inline void remove_arguments() { arg_count=0; }
143
  void split_sum_func(THD *thd, Item **ref_pointer_array, List<Item> &fields);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
144 145
  void print(String *str);
  void print_op(String *str);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
146
  void print_args(String *str, uint from);
147 148 149 150
  virtual void fix_num_length_and_dec();
  void count_only_length();
  void count_real_length();
  void count_decimal_length();
151
  inline bool get_arg0_date(TIME *ltime, uint fuzzy_date)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
152
  {
153
    return (null_value=args[0]->get_date(ltime, fuzzy_date));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
154 155 156 157 158
  }
  inline bool get_arg0_time(TIME *ltime)
  {
    return (null_value=args[0]->get_time(ltime));
  }
159
  bool is_null() { (void) val_int(); return null_value; }
160
  void signal_divide_by_null();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
161
  friend class udf_handler;
162
  Field *tmp_table_field() { return result_field; }
163
  Field *tmp_table_field(TABLE *t_arg);
164
  Item *get_tmp_table_item(THD *thd);
165 166 167

  my_decimal *val_decimal(my_decimal *);

168
  bool agg_arg_collations(DTCollation &c, Item **items, uint nitems,
169 170 171 172
                          uint flags= 0)
  {
    return agg_item_collations(c, func_name(), items, nitems, flags);
  }
173 174
  bool agg_arg_collations_for_comparison(DTCollation &c,
                                         Item **items, uint nitems,
175 176 177 178 179
                                         uint flags= 0)
  {
    return agg_item_collations_for_comparison(c, func_name(),
                                              items, nitems, flags);
  }
bar@mysql.com's avatar
bar@mysql.com committed
180
  bool agg_arg_charsets(DTCollation &c, Item **items, uint nitems,
181 182 183 184
                        uint flags= 0)
  {
    return agg_item_charsets(c, func_name(), items, nitems, flags);
  }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
185
  bool walk(Item_processor processor, byte *arg);
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
186
  Item *transform(Item_transformer transformer, byte *arg);
187 188
  void traverse_cond(Cond_traverser traverser,
                     void * arg, traverse_order order);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
189 190 191 192 193 194 195 196 197 198 199
};


class Item_real_func :public Item_func
{
public:
  Item_real_func() :Item_func() {}
  Item_real_func(Item *a) :Item_func(a) {}
  Item_real_func(Item *a,Item *b) :Item_func(a,b) {}
  Item_real_func(List<Item> &list) :Item_func(list) {}
  String *val_str(String*str);
200
  my_decimal *val_decimal(my_decimal *decimal_value);
201
  longlong val_int()
202
    { DBUG_ASSERT(fixed == 1); return (longlong) rint(val_real()); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
203
  enum Item_result result_type () const { return REAL_RESULT; }
204 205
  void fix_length_and_dec()
  { decimals= NOT_FIXED_DEC; max_length= float_length(decimals); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
206 207
};

208

209
class Item_func_numhybrid: public Item_func
bk@work.mysql.com's avatar
bk@work.mysql.com committed
210
{
211
protected:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
212 213
  Item_result hybrid_type;
public:
214
  Item_func_numhybrid(Item *a) :Item_func(a), hybrid_type(REAL_RESULT)
215 216
  {}
  Item_func_numhybrid(Item *a,Item *b)
217
    :Item_func(a,b), hybrid_type(REAL_RESULT)
218
  {}
219
  Item_func_numhybrid(List<Item> &list)
220
    :Item_func(list), hybrid_type(REAL_RESULT)
221
  {}
222

bk@work.mysql.com's avatar
bk@work.mysql.com committed
223
  enum Item_result result_type () const { return hybrid_type; }
224 225 226 227 228 229 230 231 232 233 234 235
  void fix_length_and_dec();
  void fix_num_length_and_dec();
  virtual void find_num_type()= 0; /* To be called from fix_length_and_dec */

  double val_real();
  longlong val_int();
  my_decimal *val_decimal(my_decimal *);
  String *val_str(String*str);

  virtual longlong int_op()= 0;
  virtual double real_op()= 0;
  virtual my_decimal *decimal_op(my_decimal *)= 0;
236
  virtual String *str_op(String *)= 0;
237
  bool is_null() { (void) val_real(); return null_value; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
238 239
};

240 241 242 243 244 245
/* function where type of result detected by first argument */
class Item_func_num1: public Item_func_numhybrid
{
public:
  Item_func_num1(Item *a) :Item_func_numhybrid(a) {}
  Item_func_num1(Item *a, Item *b) :Item_func_numhybrid(a, b) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
246

247 248
  void fix_num_length_and_dec();
  void find_num_type();
249
  String *str_op(String *str) { DBUG_ASSERT(0); return 0; }
250
};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
251

252 253 254

/* Base class for operations like '+', '-', '*' */
class Item_num_op :public Item_func_numhybrid
bk@work.mysql.com's avatar
bk@work.mysql.com committed
255 256
{
 public:
257 258
  Item_num_op(Item *a,Item *b) :Item_func_numhybrid(a, b) {}
  virtual void result_precision()= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
259
  void print(String *str) { print_op(str); }
260
  void find_num_type();
261
  String *str_op(String *str) { DBUG_ASSERT(0); return 0; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
262 263 264 265 266 267
};


class Item_int_func :public Item_func
{
public:
268 269 270 271 272 273
  Item_int_func() :Item_func() { max_length= 21; }
  Item_int_func(Item *a) :Item_func(a) { max_length= 21; }
  Item_int_func(Item *a,Item *b) :Item_func(a,b) { max_length= 21; }
  Item_int_func(Item *a,Item *b,Item *c) :Item_func(a,b,c)
  { max_length= 21; }
  Item_int_func(List<Item> &list) :Item_func(list) { max_length= 21; }
274
  Item_int_func(THD *thd, Item_int_func *item) :Item_func(thd, item) {}
275
  double val_real() { DBUG_ASSERT(fixed == 1); return (double) val_int(); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
276 277
  String *val_str(String*str);
  enum Item_result result_type () const { return INT_RESULT; }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
278
  void fix_length_and_dec() {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
279 280
};

281

282 283 284 285
class Item_func_signed :public Item_int_func
{
public:
  Item_func_signed(Item *a) :Item_int_func(a) {}
286
  const char *func_name() const { return "cast_as_signed"; }
287
  double val_real()
288
  {
289
    double tmp= args[0]->val_real();
290 291 292
    null_value= args[0]->null_value;
    return tmp;
  }
293 294
  longlong val_int();
  longlong val_int_from_str(int *error);
295
  void fix_length_and_dec()
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
296
  { max_length=args[0]->max_length; unsigned_flag=0; }
297
  void print(String *str);
298 299
  uint decimal_precision() const { return args[0]->decimal_precision(); }

300 301
};

302

303
class Item_func_unsigned :public Item_func_signed
304 305
{
public:
306
  Item_func_unsigned(Item *a) :Item_func_signed(a) {}
307
  const char *func_name() const { return "cast_as_unsigned"; }
308
  void fix_length_and_dec()
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
309
  { max_length=args[0]->max_length; unsigned_flag=1; }
310
  longlong val_int();
311
  void print(String *str);
312 313 314
};


315
class Item_decimal_typecast :public Item_func
bk@work.mysql.com's avatar
bk@work.mysql.com committed
316
{
317
  my_decimal decimal_value;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
318
public:
319 320 321 322 323 324
  Item_decimal_typecast(Item *a, int len, int dec) :Item_func(a)
  {
    max_length= len + 2;
    decimals= dec;
  }
  String *val_str(String *str);
325
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
326
  longlong val_int();
327 328
  my_decimal *val_decimal(my_decimal*);
  enum Item_result result_type () const { return DECIMAL_RESULT; }
329
  enum_field_types field_type() const { return MYSQL_TYPE_NEWDECIMAL; }
330
  void fix_length_and_dec() {};
331 332
  const char *func_name() const { return "decimal_typecast"; }
  void print(String *);
333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351
};


class Item_func_additive_op :public Item_num_op
{
public:
  Item_func_additive_op(Item *a,Item *b) :Item_num_op(a,b) {}
  void result_precision();
};


class Item_func_plus :public Item_func_additive_op
{
public:
  Item_func_plus(Item *a,Item *b) :Item_func_additive_op(a,b) {}
  const char *func_name() const { return "+"; }
  longlong int_op();
  double real_op();
  my_decimal *decimal_op(my_decimal *);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
352 353
};

354
class Item_func_minus :public Item_func_additive_op
bk@work.mysql.com's avatar
bk@work.mysql.com committed
355 356
{
public:
357
  Item_func_minus(Item *a,Item *b) :Item_func_additive_op(a,b) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
358
  const char *func_name() const { return "-"; }
359 360 361
  longlong int_op();
  double real_op();
  my_decimal *decimal_op(my_decimal *);
362
  void fix_length_and_dec();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
363 364
};

365

bk@work.mysql.com's avatar
bk@work.mysql.com committed
366 367 368 369 370
class Item_func_mul :public Item_num_op
{
public:
  Item_func_mul(Item *a,Item *b) :Item_num_op(a,b) {}
  const char *func_name() const { return "*"; }
371 372 373 374
  longlong int_op();
  double real_op();
  my_decimal *decimal_op(my_decimal *);
  void result_precision();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
375 376 377 378 379 380
};


class Item_func_div :public Item_num_op
{
public:
381
  uint prec_increment;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
382
  Item_func_div(Item *a,Item *b) :Item_num_op(a,b) {}
383
  longlong int_op() { DBUG_ASSERT(0); return 0; }
384 385
  double real_op();
  my_decimal *decimal_op(my_decimal *);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
386 387
  const char *func_name() const { return "/"; }
  void fix_length_and_dec();
388
  void result_precision();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
389 390 391
};


392
class Item_func_int_div :public Item_int_func
393 394
{
public:
395
  Item_func_int_div(Item *a,Item *b) :Item_int_func(a,b)
396
  {}
397 398 399
  longlong val_int();
  const char *func_name() const { return "DIV"; }
  void fix_length_and_dec();
400
  void print(String *str) { print_op(str); }
401 402 403
};


bk@work.mysql.com's avatar
bk@work.mysql.com committed
404 405 406 407
class Item_func_mod :public Item_num_op
{
public:
  Item_func_mod(Item *a,Item *b) :Item_num_op(a,b) {}
408 409 410
  longlong int_op();
  double real_op();
  my_decimal *decimal_op(my_decimal *);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
411
  const char *func_name() const { return "%"; }
412 413 414 415
  void result_precision();
};


416
class Item_func_neg :public Item_func_num1
bk@work.mysql.com's avatar
bk@work.mysql.com committed
417 418
{
public:
419
  Item_func_neg(Item *a) :Item_func_num1(a) {}
420 421 422
  double real_op();
  longlong int_op();
  my_decimal *decimal_op(my_decimal *);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
423
  const char *func_name() const { return "-"; }
424
  void fix_length_and_dec();
425
  void fix_num_length_and_dec();
426
  uint decimal_precision() const { return args[0]->decimal_precision(); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
427 428 429
};


430
class Item_func_abs :public Item_func_num1
bk@work.mysql.com's avatar
bk@work.mysql.com committed
431 432
{
public:
433 434 435 436
  Item_func_abs(Item *a) :Item_func_num1(a) {}
  double real_op();
  longlong int_op();
  my_decimal *decimal_op(my_decimal *);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
437 438 439 440
  const char *func_name() const { return "abs"; }
  void fix_length_and_dec();
};

441
// A class to handle logarithmic and trigonometric functions
bk@work.mysql.com's avatar
bk@work.mysql.com committed
442 443 444 445 446 447 448 449

class Item_dec_func :public Item_real_func
{
 public:
  Item_dec_func(Item *a) :Item_real_func(a) {}
  Item_dec_func(Item *a,Item *b) :Item_real_func(a,b) {}
  void fix_length_and_dec()
  {
450
    decimals=NOT_FIXED_DEC; max_length=float_length(decimals);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
451 452 453 454 455 456 457
    maybe_null=1;
  }
  inline double fix_result(double value)
  {
#ifndef HAVE_FINITE
    return value;
#else
458
    /* The following should be safe, even if we compare doubles */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
459 460 461 462 463 464 465 466 467 468 469 470
    if (finite(value) && value != POSTFIX_ERROR)
      return value;
    null_value=1;
    return 0.0;
#endif
  }
};

class Item_func_exp :public Item_dec_func
{
public:
  Item_func_exp(Item *a) :Item_dec_func(a) {}
471
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
472 473 474
  const char *func_name() const { return "exp"; }
};

475 476 477 478 479

class Item_func_ln :public Item_dec_func
{
public:
  Item_func_ln(Item *a) :Item_dec_func(a) {}
480
  double val_real();
481 482 483 484
  const char *func_name() const { return "ln"; }
};


bk@work.mysql.com's avatar
bk@work.mysql.com committed
485 486 487 488
class Item_func_log :public Item_dec_func
{
public:
  Item_func_log(Item *a) :Item_dec_func(a) {}
489
  Item_func_log(Item *a,Item *b) :Item_dec_func(a,b) {}
490
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
491 492 493 494
  const char *func_name() const { return "log"; }
};


495 496 497 498
class Item_func_log2 :public Item_dec_func
{
public:
  Item_func_log2(Item *a) :Item_dec_func(a) {}
499
  double val_real();
500 501 502 503
  const char *func_name() const { return "log2"; }
};


bk@work.mysql.com's avatar
bk@work.mysql.com committed
504 505 506 507
class Item_func_log10 :public Item_dec_func
{
public:
  Item_func_log10(Item *a) :Item_dec_func(a) {}
508
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
509 510 511 512 513 514 515 516
  const char *func_name() const { return "log10"; }
};


class Item_func_sqrt :public Item_dec_func
{
public:
  Item_func_sqrt(Item *a) :Item_dec_func(a) {}
517
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
518 519 520 521 522 523 524 525
  const char *func_name() const { return "sqrt"; }
};


class Item_func_pow :public Item_dec_func
{
public:
  Item_func_pow(Item *a,Item *b) :Item_dec_func(a,b) {}
526
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
527 528 529 530 531 532
  const char *func_name() const { return "pow"; }
};


class Item_func_acos :public Item_dec_func
{
533
public:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
534
  Item_func_acos(Item *a) :Item_dec_func(a) {}
535
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
536 537 538 539 540
  const char *func_name() const { return "acos"; }
};

class Item_func_asin :public Item_dec_func
{
541
public:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
542
  Item_func_asin(Item *a) :Item_dec_func(a) {}
543
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
544 545 546 547 548
  const char *func_name() const { return "asin"; }
};

class Item_func_atan :public Item_dec_func
{
549
public:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
550 551
  Item_func_atan(Item *a) :Item_dec_func(a) {}
  Item_func_atan(Item *a,Item *b) :Item_dec_func(a,b) {}
552
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
553 554 555 556 557
  const char *func_name() const { return "atan"; }
};

class Item_func_cos :public Item_dec_func
{
558
public:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
559
  Item_func_cos(Item *a) :Item_dec_func(a) {}
560
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
561 562 563 564 565
  const char *func_name() const { return "cos"; }
};

class Item_func_sin :public Item_dec_func
{
566
public:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
567
  Item_func_sin(Item *a) :Item_dec_func(a) {}
568
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
569 570 571 572 573
  const char *func_name() const { return "sin"; }
};

class Item_func_tan :public Item_dec_func
{
574
public:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
575
  Item_func_tan(Item *a) :Item_dec_func(a) {}
576
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
577 578 579 580 581 582 583 584 585 586 587
  const char *func_name() const { return "tan"; }
};

class Item_func_integer :public Item_int_func
{
public:
  inline Item_func_integer(Item *a) :Item_int_func(a) {}
  void fix_length_and_dec();
};


588 589 590 591 592 593 594 595 596 597
class Item_func_int_val :public Item_func_num1
{
public:
  Item_func_int_val(Item *a) :Item_func_num1(a) {}
  void fix_num_length_and_dec();
  void find_num_type();
};


class Item_func_ceiling :public Item_func_int_val
bk@work.mysql.com's avatar
bk@work.mysql.com committed
598 599
{
public:
600
  Item_func_ceiling(Item *a) :Item_func_int_val(a) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
601
  const char *func_name() const { return "ceiling"; }
602 603 604
  longlong int_op();
  double real_op();
  my_decimal *decimal_op(my_decimal *);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
605 606
};

607 608

class Item_func_floor :public Item_func_int_val
bk@work.mysql.com's avatar
bk@work.mysql.com committed
609 610
{
public:
611
  Item_func_floor(Item *a) :Item_func_int_val(a) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
612
  const char *func_name() const { return "floor"; }
613 614 615
  longlong int_op();
  double real_op();
  my_decimal *decimal_op(my_decimal *);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
616 617 618 619
};

/* This handles round and truncate */

620
class Item_func_round :public Item_func_num1
bk@work.mysql.com's avatar
bk@work.mysql.com committed
621 622 623
{
  bool truncate;
public:
624 625
  Item_func_round(Item *a, Item *b, bool trunc_arg)
    :Item_func_num1(a,b), truncate(trunc_arg) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
626
  const char *func_name() const { return truncate ? "truncate" : "round"; }
627 628 629
  double real_op();
  longlong int_op();
  my_decimal *decimal_op(my_decimal *);
630
  void fix_length_and_dec();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
631 632 633 634 635
};


class Item_func_rand :public Item_real_func
{
636
  struct rand_struct *rand;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
637
public:
638 639
  Item_func_rand(Item *a) :Item_real_func(a), rand(0) {}
  Item_func_rand()	  :Item_real_func() {}
640
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
641 642
  const char *func_name() const { return "rand"; }
  bool const_item() const { return 0; }
643
  void update_used_tables();
644
  bool fix_fields(THD *thd, Item **ref);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660
};


class Item_func_sign :public Item_int_func
{
public:
  Item_func_sign(Item *a) :Item_int_func(a) {}
  const char *func_name() const { return "sign"; }
  longlong val_int();
};


class Item_func_units :public Item_real_func
{
  char *name;
  double mul,add;
661
public:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
662 663
  Item_func_units(char *name_arg,Item *a,double mul_arg,double add_arg)
    :Item_real_func(a),name(name_arg),mul(mul_arg),add(add_arg) {}
664
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
665
  const char *func_name() const { return name; }
666 667
  void fix_length_and_dec()
  { decimals= NOT_FIXED_DEC; max_length= float_length(decimals); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
668 669 670 671 672 673 674 675 676 677
};


class Item_func_min_max :public Item_func
{
  Item_result cmp_type;
  String tmp_value;
  int cmp_sign;
public:
  Item_func_min_max(List<Item> &list,int cmp_sign_arg) :Item_func(list),
678
    cmp_type(INT_RESULT), cmp_sign(cmp_sign_arg) {}
679
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
680 681
  longlong val_int();
  String *val_str(String *);
682
  my_decimal *val_decimal(my_decimal *);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700
  void fix_length_and_dec();
  enum Item_result result_type () const { return cmp_type; }
};

class Item_func_min :public Item_func_min_max
{
public:
  Item_func_min(List<Item> &list) :Item_func_min_max(list,1) {}
  const char *func_name() const { return "least"; }
};

class Item_func_max :public Item_func_min_max
{
public:
  Item_func_max(List<Item> &list) :Item_func_min_max(list,-1) {}
  const char *func_name() const { return "greatest"; }
};

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

bk@work.mysql.com's avatar
bk@work.mysql.com committed
702 703 704 705 706 707 708 709 710 711
class Item_func_length :public Item_int_func
{
  String value;
public:
  Item_func_length(Item *a) :Item_int_func(a) {}
  longlong val_int();
  const char *func_name() const { return "length"; }
  void fix_length_and_dec() { max_length=10; }
};

712 713 714 715
class Item_func_bit_length :public Item_func_length
{
public:
  Item_func_bit_length(Item *a) :Item_func_length(a) {}
716 717
  longlong val_int()
    { DBUG_ASSERT(fixed == 1); return Item_func_length::val_int()*8; }
718 719 720
  const char *func_name() const { return "bit_length"; }
};

bk@work.mysql.com's avatar
bk@work.mysql.com committed
721 722 723 724 725 726 727 728 729 730
class Item_func_char_length :public Item_int_func
{
  String value;
public:
  Item_func_char_length(Item *a) :Item_int_func(a) {}
  longlong val_int();
  const char *func_name() const { return "char_length"; }
  void fix_length_and_dec() { max_length=10; }
};

bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
731 732 733 734 735 736
class Item_func_coercibility :public Item_int_func
{
public:
  Item_func_coercibility(Item *a) :Item_int_func(a) {}
  longlong val_int();
  const char *func_name() const { return "coercibility"; }
737 738
  void fix_length_and_dec() { max_length=10; maybe_null= 0; }
  table_map not_null_tables() const { return 0; }
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
739 740
};

bk@work.mysql.com's avatar
bk@work.mysql.com committed
741 742 743
class Item_func_locate :public Item_int_func
{
  String value1,value2;
744
  DTCollation cmp_collation;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
745 746 747 748 749
public:
  Item_func_locate(Item *a,Item *b) :Item_int_func(a,b) {}
  Item_func_locate(Item *a,Item *b,Item *c) :Item_int_func(a,b,c) {}
  const char *func_name() const { return "locate"; }
  longlong val_int();
750
  void fix_length_and_dec();
751
  void print(String *str);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
752 753 754 755 756 757
};


class Item_func_field :public Item_int_func
{
  String value,tmp;
758 759
  Item_result cmp_type;
  DTCollation cmp_collation;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
760
public:
761
  Item_func_field(List<Item> &list) :Item_int_func(list) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
762 763
  longlong val_int();
  const char *func_name() const { return "field"; }
764
  void fix_length_and_dec();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791
};


class Item_func_ascii :public Item_int_func
{
  String value;
public:
  Item_func_ascii(Item *a) :Item_int_func(a) {}
  longlong val_int();
  const char *func_name() const { return "ascii"; }
  void fix_length_and_dec() { max_length=3; }
};

class Item_func_ord :public Item_int_func
{
  String value;
public:
  Item_func_ord(Item *a) :Item_int_func(a) {}
  longlong val_int();
  const char *func_name() const { return "ord"; }
};

class Item_func_find_in_set :public Item_int_func
{
  String value,value2;
  uint enum_value;
  ulonglong enum_bit;
792
  DTCollation cmp_collation;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
793 794 795 796 797 798 799
public:
  Item_func_find_in_set(Item *a,Item *b) :Item_int_func(a,b),enum_value(0) {}
  longlong val_int();
  const char *func_name() const { return "find_in_set"; }
  void fix_length_and_dec();
};

800
/* Base class for all bit functions: '~', '|', '^', '&', '>>', '<<' */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
801

802
class Item_func_bit: public Item_int_func
bk@work.mysql.com's avatar
bk@work.mysql.com committed
803 804
{
public:
805 806 807
  Item_func_bit(Item *a, Item *b) :Item_int_func(a, b) {}
  Item_func_bit(Item *a) :Item_int_func(a) {}
  void fix_length_and_dec() { unsigned_flag= 1; }
monty@mysql.com's avatar
monty@mysql.com committed
808
  void print(String *str) { print_op(str); }
809 810 811 812 813 814
};

class Item_func_bit_or :public Item_func_bit
{
public:
  Item_func_bit_or(Item *a, Item *b) :Item_func_bit(a, b) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
815 816 817 818
  longlong val_int();
  const char *func_name() const { return "|"; }
};

819
class Item_func_bit_and :public Item_func_bit
bk@work.mysql.com's avatar
bk@work.mysql.com committed
820 821
{
public:
822
  Item_func_bit_and(Item *a, Item *b) :Item_func_bit(a, b) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
823 824 825 826 827 828 829 830 831 832
  longlong val_int();
  const char *func_name() const { return "&"; }
};

class Item_func_bit_count :public Item_int_func
{
public:
  Item_func_bit_count(Item *a) :Item_int_func(a) {}
  longlong val_int();
  const char *func_name() const { return "bit_count"; }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
833
  void fix_length_and_dec() { max_length=2; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
834 835
};

836
class Item_func_shift_left :public Item_func_bit
bk@work.mysql.com's avatar
bk@work.mysql.com committed
837 838
{
public:
839
  Item_func_shift_left(Item *a, Item *b) :Item_func_bit(a, b) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
840 841 842 843
  longlong val_int();
  const char *func_name() const { return "<<"; }
};

844
class Item_func_shift_right :public Item_func_bit
bk@work.mysql.com's avatar
bk@work.mysql.com committed
845 846
{
public:
847
  Item_func_shift_right(Item *a, Item *b) :Item_func_bit(a, b) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
848 849 850 851
  longlong val_int();
  const char *func_name() const { return ">>"; }
};

852
class Item_func_bit_neg :public Item_func_bit
bk@work.mysql.com's avatar
bk@work.mysql.com committed
853 854
{
public:
855
  Item_func_bit_neg(Item *a) :Item_func_bit(a) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
856 857
  longlong val_int();
  const char *func_name() const { return "~"; }
monty@mysql.com's avatar
monty@mysql.com committed
858
  void print(String *str) { Item_func::print(str); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
859 860
};

monty@mysql.com's avatar
monty@mysql.com committed
861

862
class Item_func_last_insert_id :public Item_int_func
bk@work.mysql.com's avatar
bk@work.mysql.com committed
863 864
{
public:
865 866
  Item_func_last_insert_id() :Item_int_func() {}
  Item_func_last_insert_id(Item *a) :Item_int_func(a) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
867 868
  longlong val_int();
  const char *func_name() const { return "last_insert_id"; }
869 870 871 872 873
  void fix_length_and_dec()
  {
    if (arg_count)
      max_length= args[0]->max_length;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
874 875
};

876

bk@work.mysql.com's avatar
bk@work.mysql.com committed
877 878 879
class Item_func_benchmark :public Item_int_func
{
  ulong loop_count;
880
public:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
881 882 883 884 885
  Item_func_benchmark(ulong loop_count_arg,Item *expr)
    :Item_int_func(expr), loop_count(loop_count_arg)
  {}
  longlong val_int();
  const char *func_name() const { return "benchmark"; }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
886
  void fix_length_and_dec() { max_length=1; maybe_null=0; }
887
  void print(String *str);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
888 889 890
};


891 892 893 894
class Item_func_sleep :public Item_int_func
{
public:
  Item_func_sleep(Item *a) :Item_int_func(a) {}
895
  bool const_item() const { return 0; }
896
  const char *func_name() const { return "sleep"; }
897 898 899 900 901
  void update_used_tables()
  {
    Item_int_func::update_used_tables();
    used_tables_cache|= RAND_TABLE_BIT;
  }
902 903 904 905 906
  longlong val_int();
};



bk@work.mysql.com's avatar
bk@work.mysql.com committed
907 908 909 910
#ifdef HAVE_DLOPEN

class Item_udf_func :public Item_func
{
911
protected:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
912 913 914
  udf_handler udf;

public:
915 916
  Item_udf_func(udf_func *udf_arg)
    :Item_func(), udf(udf_arg) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
917 918 919
  Item_udf_func(udf_func *udf_arg, List<Item> &list)
    :Item_func(list), udf(udf_arg) {}
  const char *func_name() const { return udf.name(); }
920
  bool fix_fields(THD *thd, Item **ref)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
921
  {
922
    DBUG_ASSERT(fixed == 0);
923
    bool res= udf.fix_fields(thd, this, arg_count, args);
924 925
    used_tables_cache= udf.used_tables_cache;
    const_item_cache= udf.const_item_cache;
926
    fixed= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
927 928
    return res;
  }
929
  void cleanup();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
930
  Item_result result_type () const { return udf.result_type(); }
931
  table_map not_null_tables() const { return 0; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
932 933 934 935 936 937
};


class Item_func_udf_float :public Item_udf_func
{
 public:
938 939 940 941 942
  Item_func_udf_float(udf_func *udf_arg)
    :Item_udf_func(udf_arg) {}
  Item_func_udf_float(udf_func *udf_arg,
                      List<Item> &list)
    :Item_udf_func(udf_arg, list) {}
943
  longlong val_int()
944 945
  {
    DBUG_ASSERT(fixed == 1);
946
    return (longlong) rint(Item_func_udf_float::val_real());
947
  }
948 949 950 951 952 953 954 955
  my_decimal *val_decimal(my_decimal *dec_buf)
  {
    double res=val_real();
    if (null_value)
      return NULL;
    double2my_decimal(E_DEC_FATAL_ERROR, res, dec_buf);
    return dec_buf;
  }
956
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
957 958 959 960 961 962 963 964
  String *val_str(String *str);
  void fix_length_and_dec() { fix_num_length_and_dec(); }
};


class Item_func_udf_int :public Item_udf_func
{
public:
965 966 967 968 969
  Item_func_udf_int(udf_func *udf_arg)
    :Item_udf_func(udf_arg) {}
  Item_func_udf_int(udf_func *udf_arg,
                    List<Item> &list)
    :Item_udf_func(udf_arg, list) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
970
  longlong val_int();
971
  double val_real() { return (double) Item_func_udf_int::val_int(); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
972 973
  String *val_str(String *str);
  enum Item_result result_type () const { return INT_RESULT; }
974 975 976 977 978 979 980
  void fix_length_and_dec() { decimals= 0; max_length= 21; }
};


class Item_func_udf_decimal :public Item_udf_func
{
public:
981 982
  Item_func_udf_decimal(udf_func *udf_arg)
    :Item_udf_func(udf_arg) {}
983
  Item_func_udf_decimal(udf_func *udf_arg, List<Item> &list)
984
    :Item_udf_func(udf_arg, list) {}
985 986 987 988 989 990
  longlong val_int();
  double val_real();
  my_decimal *val_decimal(my_decimal *);
  String *val_str(String *str);
  enum Item_result result_type () const { return DECIMAL_RESULT; }
  void fix_length_and_dec();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
991 992 993 994 995 996
};


class Item_func_udf_str :public Item_udf_func
{
public:
997 998
  Item_func_udf_str(udf_func *udf_arg)
    :Item_udf_func(udf_arg) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
999
  Item_func_udf_str(udf_func *udf_arg, List<Item> &list)
1000
    :Item_udf_func(udf_arg, list) {}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1001
  String *val_str(String *);
1002
  double val_real()
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1003
  {
monty@mysql.com's avatar
monty@mysql.com committed
1004 1005 1006 1007 1008 1009
    int err_not_used;
    char *end_not_used;
    String *res;
    res= val_str(&str_value);
    return res ? my_strntod(res->charset(),(char*) res->ptr(), 
                            res->length(), &end_not_used, &err_not_used) : 0.0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1010 1011 1012
  }
  longlong val_int()
  {
monty@mysql.com's avatar
monty@mysql.com committed
1013
    int err_not_used;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1014
    String *res;  res=val_str(&str_value);
monty@mysql.com's avatar
monty@mysql.com committed
1015 1016
    return res ? my_strntoll(res->charset(),res->ptr(),res->length(),10,
                             (char**) 0, &err_not_used) : (longlong) 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1017
  }
1018 1019 1020 1021 1022 1023 1024 1025
  my_decimal *val_decimal(my_decimal *dec_buf)
  {
    String *res=val_str(&str_value);
    if (!res)
      return NULL;
    string2my_decimal(E_DEC_FATAL_ERROR, res, dec_buf);
    return dec_buf;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1026 1027 1028 1029 1030 1031 1032 1033 1034
  enum Item_result result_type () const { return STRING_RESULT; }
  void fix_length_and_dec();
};

#else /* Dummy functions to get sql_yacc.cc compiled */

class Item_func_udf_float :public Item_real_func
{
 public:
1035 1036 1037 1038
  Item_func_udf_float(udf_func *udf_arg)
    :Item_real_func() {}
  Item_func_udf_float(udf_func *udf_arg, List<Item> &list)
    :Item_real_func(list) {}
1039
  double val_real() { DBUG_ASSERT(fixed == 1); return 0.0; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1040 1041 1042 1043 1044 1045
};


class Item_func_udf_int :public Item_int_func
{
public:
1046 1047 1048 1049
  Item_func_udf_int(udf_func *udf_arg)
    :Item_int_func() {}
  Item_func_udf_int(udf_func *udf_arg, List<Item> &list)
    :Item_int_func(list) {}
1050
  longlong val_int() { DBUG_ASSERT(fixed == 1); return 0; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1051 1052 1053
};


1054 1055 1056
class Item_func_udf_decimal :public Item_int_func
{
public:
1057 1058 1059 1060
  Item_func_udf_decimal(udf_func *udf_arg)
    :Item_int_func() {}
  Item_func_udf_decimal(udf_func *udf_arg, List<Item> &list)
    :Item_int_func(list) {}
1061 1062 1063 1064
  my_decimal *val_decimal(my_decimal *) { DBUG_ASSERT(fixed == 1); return 0; }
};


bk@work.mysql.com's avatar
bk@work.mysql.com committed
1065 1066 1067
class Item_func_udf_str :public Item_func
{
public:
1068 1069 1070 1071
  Item_func_udf_str(udf_func *udf_arg)
    :Item_func() {}
  Item_func_udf_str(udf_func *udf_arg, List<Item> &list)
    :Item_func(list) {}
1072 1073
  String *val_str(String *)
    { DBUG_ASSERT(fixed == 1); null_value=1; return 0; }
1074
  double val_real() { DBUG_ASSERT(fixed == 1); null_value= 1; return 0.0; }
1075
  longlong val_int() { DBUG_ASSERT(fixed == 1); null_value=1; return 0; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1076 1077 1078 1079 1080 1081 1082 1083 1084 1085
  enum Item_result result_type () const { return STRING_RESULT; }
  void fix_length_and_dec() { maybe_null=1; max_length=0; }
};

#endif /* HAVE_DLOPEN */

/*
** User level locks
*/

1086
class User_level_lock;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1087
void item_user_lock_init(void);
1088
void item_user_lock_release(User_level_lock *ull);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1089 1090 1091 1092 1093 1094 1095 1096 1097
void item_user_lock_free(void);

class Item_func_get_lock :public Item_int_func
{
  String value;
 public:
  Item_func_get_lock(Item *a,Item *b) :Item_int_func(a,b) {}
  longlong val_int();
  const char *func_name() const { return "get_lock"; }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1098
  void fix_length_and_dec() { max_length=1; maybe_null=1;}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1099 1100 1101 1102 1103
};

class Item_func_release_lock :public Item_int_func
{
  String value;
1104
public:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1105 1106 1107
  Item_func_release_lock(Item *a) :Item_int_func(a) {}
  longlong val_int();
  const char *func_name() const { return "release_lock"; }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1108
  void fix_length_and_dec() { max_length=1; maybe_null=1;}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1109 1110
};

1111 1112 1113 1114 1115
/* replication functions */

class Item_master_pos_wait :public Item_int_func
{
  String value;
1116
public:
1117
  Item_master_pos_wait(Item *a,Item *b) :Item_int_func(a,b) {}
1118
  Item_master_pos_wait(Item *a,Item *b,Item *c) :Item_int_func(a,b,c) {}
1119 1120
  longlong val_int();
  const char *func_name() const { return "master_pos_wait"; }
1121
  void fix_length_and_dec() { max_length=21; maybe_null=1;}
1122 1123
};

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1124

1125
/* Handling of user definable variables */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1126 1127 1128 1129 1130 1131 1132

class user_var_entry;

class Item_func_set_user_var :public Item_func
{
  enum Item_result cached_result_type;
  user_var_entry *entry;
1133 1134
  char buffer[MAX_FIELD_WIDTH];
  String value;
1135
  my_decimal decimal_buff;
1136
  bool null_item;
1137 1138 1139 1140 1141
  union
  {
    longlong vint;
    double vreal;
    String *vstr;
1142
    my_decimal *vdec;
1143 1144 1145
  } save_result;
  String save_buff;
  
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1146 1147

public:
1148
  LEX_STRING name; // keep it public
1149 1150 1151
  Item_func_set_user_var(LEX_STRING a,Item *b)
    :Item_func(b), cached_result_type(INT_RESULT), name(a)
  {}
1152
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1153 1154
  longlong val_int();
  String *val_str(String *str);
1155
  my_decimal *val_decimal(my_decimal *);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1156
  bool update_hash(void *ptr, uint length, enum Item_result type, 
1157
  		   CHARSET_INFO *cs, Derivation dv);
1158
  bool check();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1159 1160
  bool update();
  enum Item_result result_type () const { return cached_result_type; }
1161
  bool fix_fields(THD *thd, Item **ref);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1162
  void fix_length_and_dec();
1163
  void print(String *str);
1164
  void print_as_stmt(String *str);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1165 1166 1167 1168 1169 1170
  const char *func_name() const { return "set_user_var"; }
};


class Item_func_get_user_var :public Item_func
{
1171
  user_var_entry *var_entry;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1172 1173

public:
1174
  LEX_STRING name; // keep it public
1175
  Item_func_get_user_var(LEX_STRING a):
1176
    Item_func(), name(a) {}
1177 1178
  enum Functype functype() const { return GUSERVAR_FUNC; }
  LEX_STRING get_name() { return name; }
1179
  double val_real();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1180
  longlong val_int();
1181
  my_decimal *val_decimal(my_decimal*);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1182 1183
  String *val_str(String* str);
  void fix_length_and_dec();
1184
  void print(String *str);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1185
  enum Item_result result_type() const;
1186 1187 1188 1189
  /*
    We must always return variables as strings to guard against selects of type
    select @t1:=1,@t1,@t:="hello",@t from foo where (@t1:= t2.b)
  */
1190
  enum_field_types field_type() const  { return MYSQL_TYPE_VARCHAR; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1191
  const char *func_name() const { return "get_user_var"; }
1192
  bool const_item() const;
1193
  table_map used_tables() const
1194
  { return const_item() ? 0 : RAND_TABLE_BIT; }
1195
  bool eq(const Item *item, bool binary_cmp) const;
1196
};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1197

1198

1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220
/*
  This item represents user variable used as out parameter (e.g in LOAD DATA),
  and it is supposed to be used only for this purprose. So it is simplified
  a lot. Actually you should never obtain its value.

  The only two reasons for this thing being an Item is possibility to store it
  in List<Item> and desire to place this code somewhere near other functions
  working with user variables.
*/
class Item_user_var_as_out_param :public Item
{
  LEX_STRING name;
  user_var_entry *entry;
public:
  Item_user_var_as_out_param(LEX_STRING a) : name(a) {}
  /* We should return something different from FIELD_ITEM here */
  enum Type type() const { return STRING_ITEM;}
  double val_real();
  longlong val_int();
  String *val_str(String *str);
  my_decimal *val_decimal(my_decimal *decimal_buffer);
  /* fix_fields() binds variable name with its entry structure */
1221
  bool fix_fields(THD *thd, Item **ref);
1222 1223 1224 1225 1226 1227
  void print(String *str);
  void set_null_value(CHARSET_INFO* cs);
  void set_value(const char *str, uint length, CHARSET_INFO* cs);
};


1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238
/* A system variable */

class Item_func_get_system_var :public Item_func
{
  sys_var *var;
  enum_var_type var_type;
  LEX_STRING component;
public:
  Item_func_get_system_var(sys_var *var_arg, enum_var_type var_type_arg,
                           LEX_STRING *component_arg, const char *name_arg,
                           size_t name_len_arg);
1239
  bool fix_fields(THD *thd, Item **ref);
1240 1241 1242 1243
  /*
    Stubs for pure virtual methods. Should never be called: this
    item is always substituted with a constant in fix_fields().
  */
1244
  double val_real()         { DBUG_ASSERT(0); return 0.0; }
1245 1246 1247
  longlong val_int()        { DBUG_ASSERT(0); return 0; }
  String* val_str(String*)  { DBUG_ASSERT(0); return 0; }
  void fix_length_and_dec() { DBUG_ASSERT(0); }
1248 1249
  /* TODO: fix to support views */
  const char *func_name() const { return "get_system_var"; }
1250 1251 1252
};


bk@work.mysql.com's avatar
bk@work.mysql.com committed
1253 1254 1255 1256 1257 1258 1259 1260 1261 1262
class Item_func_inet_aton : public Item_int_func
{
public:
   Item_func_inet_aton(Item *a) :Item_int_func(a) {}
   longlong val_int();
   const char *func_name() const { return "inet_aton"; }
   void fix_length_and_dec() { decimals = 0; max_length = 21; maybe_null=1;}
};


1263
/* for fulltext search */
1264
#include <ft_global.h>
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1265 1266 1267 1268

class Item_func_match :public Item_real_func
{
public:
1269
  uint key, flags;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1270
  bool join_key;
1271 1272 1273 1274 1275 1276 1277
  DTCollation cmp_collation;
  FT_INFO *ft_handler;
  TABLE *table;
  Item_func_match *master;   // for master-slave optimization
  Item *concat;              // Item_func_concat_ws
  String value;              // value of concat
  String search_value;       // key_item()'s value converted to cmp_collation
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1278

serg@serg.mylan's avatar
serg@serg.mylan committed
1279 1280
  Item_func_match(List<Item> &a, uint b): Item_real_func(a), key(0), flags(b),
       join_key(0), ft_handler(0), table(0), master(0), concat(0) { }
hf@deer.(none)'s avatar
hf@deer.(none) committed
1281
  void cleanup()
1282
  {
1283
    DBUG_ENTER("Item_func_match");
1284
    Item_real_func::cleanup();
1285
    if (!master && ft_handler)
1286
    {
1287 1288
      ft_handler->please->close_search(ft_handler);
      ft_handler=0;
1289
    }
1290
    concat= 0;
1291
    DBUG_VOID_RETURN;
1292
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1293
  enum Functype functype() const { return FT_FUNC; }
1294
  const char *func_name() const { return "match"; }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1295
  void update_used_tables() {}
1296
  table_map not_null_tables() const { return 0; }
1297
  bool fix_fields(THD *thd, Item **ref);
1298
  bool eq(const Item *, bool binary_cmp) const;
1299
  /* The following should be safe, even if we compare doubles */
1300 1301
  longlong val_int() { DBUG_ASSERT(fixed == 1); return val_real() != 0.0; }
  double val_real();
1302
  void print(String *str);
1303 1304

  bool fix_index();
1305
  void init_search(bool no_order);
1306
};
1307

1308

1309
class Item_func_bit_xor : public Item_func_bit
1310 1311
{
public:
1312
  Item_func_bit_xor(Item *a, Item *b) :Item_func_bit(a, b) {}
1313 1314 1315 1316
  longlong val_int();
  const char *func_name() const { return "^"; }
};

1317
class Item_func_is_free_lock :public Item_int_func
1318 1319 1320
{
  String value;
public:
1321
  Item_func_is_free_lock(Item *a) :Item_int_func(a) {}
1322
  longlong val_int();
1323
  const char *func_name() const { return "is_free_lock"; }
1324
  void fix_length_and_dec() { decimals=0; max_length=1; maybe_null=1;}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1325 1326
};

hf@genie.(none)'s avatar
SCRUM  
hf@genie.(none) committed
1327 1328 1329 1330 1331 1332 1333 1334 1335 1336
class Item_func_is_used_lock :public Item_int_func
{
  String value;
public:
  Item_func_is_used_lock(Item *a) :Item_int_func(a) {}
  longlong val_int();
  const char *func_name() const { return "is_used_lock"; }
  void fix_length_and_dec() { decimals=0; max_length=10; maybe_null=1;}
};

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1337 1338
/* For type casts */

1339
enum Cast_target
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1340 1341
{
  ITEM_CAST_BINARY, ITEM_CAST_SIGNED_INT, ITEM_CAST_UNSIGNED_INT,
1342 1343
  ITEM_CAST_DATE, ITEM_CAST_TIME, ITEM_CAST_DATETIME, ITEM_CAST_CHAR,
  ITEM_CAST_DECIMAL
1344
};
1345 1346


1347 1348 1349 1350 1351 1352 1353 1354 1355 1356
class Item_func_row_count :public Item_int_func
{
public:
  Item_func_row_count() :Item_int_func() {}
  longlong val_int();
  const char *func_name() const { return "row_count"; }
  void fix_length_and_dec() { decimals= 0; maybe_null=0; }
};


1357 1358 1359 1360 1361 1362 1363
/*
 *
 * Stored FUNCTIONs
 *
 */

class sp_head;
1364
class sp_name;
1365
struct st_sp_security_context;
1366 1367 1368 1369

class Item_func_sp :public Item_func
{
private:
1370
  Name_resolution_context *context;
1371
  sp_name *m_name;
1372
  mutable sp_head *m_sp;
1373
  TABLE *dummy_table;
1374 1375
  Field *result_field;
  char result_buf[64];
1376 1377

  int execute(Item **itp);
1378
  int execute(Field **flp);
1379
  Field *sp_result_field(void) const;
1380 1381 1382

public:

1383
  Item_func_sp(Name_resolution_context *context_arg, sp_name *name);
1384

1385 1386
  Item_func_sp(Name_resolution_context *context_arg,
               sp_name *name, List<Item> &list);
1387 1388 1389 1390

  virtual ~Item_func_sp()
  {}

1391
  void cleanup();
1392

1393
  const char *func_name() const;
1394

1395 1396
  enum enum_field_types field_type() const;

1397 1398 1399 1400
  Field *tmp_table_field(TABLE *t_arg);

  void make_field(Send_field *tmp_field);

1401 1402 1403 1404
  Item_result result_type() const;

  longlong val_int()
  {
1405
    if (execute(&result_field))
1406
      return (longlong) 0;
1407
    return result_field->val_int();
1408 1409
  }

1410
  double val_real()
1411
  {
1412
    if (execute(&result_field))
1413
      return 0.0;
1414
    return result_field->val_real();
1415 1416
  }

1417 1418
  my_decimal *val_decimal(my_decimal *dec_buf)
  {
1419
    if (execute(&result_field))
1420
      return NULL;
1421
    return result_field->val_decimal(dec_buf);
1422 1423
  }

1424 1425
  String *val_str(String *str)
  {
1426
    if (execute(&result_field))
1427
      return NULL;
1428
    return result_field->val_str(str);
1429 1430
  }

1431 1432 1433
  virtual bool change_context_processor(byte *cntx)
    { context= (Name_resolution_context *)cntx; return FALSE; }

1434
  void fix_length_and_dec();
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
1435 1436
  bool find_and_check_access(THD * thd, ulong want_access,
                             Security_context **backup);
1437
  virtual enum Functype functype() const { return FUNC_SP; }
1438

1439
  bool fix_fields(THD *thd, Item **ref);
1440
};
monty@mysql.com's avatar
monty@mysql.com committed
1441 1442


1443 1444 1445 1446 1447 1448 1449 1450
class Item_func_found_rows :public Item_int_func
{
public:
  Item_func_found_rows() :Item_int_func() {}
  longlong val_int();
  const char *func_name() const { return "found_rows"; }
  void fix_length_and_dec() { decimals= 0; maybe_null=0; }
};