~drizzle-trunk/drizzle/development

489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
3
 *
4
 *  Copyright (C) 2008 Sun Microsystems
5
 *
6
 *  This program is free software; you can redistribute it and/or modify
7
 *  it under the terms of the GNU General Public License as published by
8
 *  the Free Software Foundation; version 2 of the License.
9
 *
10
 *  This program is distributed in the hope that it will be useful,
11
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
12
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
13
 *  GNU General Public License for more details.
14
 *
15
 *  You should have received a copy of the GNU General Public License
16
 *  along with this program; if not, write to the Free Software
17
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
18
 */
19
670.1.20 by Monty Taylor
Renamed functions to function... everything else is singular.
20
#ifndef DRIZZLED_FUNCTION_FUNC_H
21
#define DRIZZLED_FUNCTION_FUNC_H
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
22
23
/// TODO: Rename this file - func.h is stupid.
24
25
#include <drizzled/item.h>
26
#include <drizzled/sql_list.h>
642.1.62 by Lee
more header file cleanup
27
#include <drizzled/item/bin_string.h>
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
28
1280.1.10 by Monty Taylor
Put everything in drizzled into drizzled namespace.
29
namespace drizzled
30
{
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
31
32
class Item_func :public Item_result_field
33
{
34
protected:
35
  Item **args, *tmp_arg[2];
36
  /*
37
    Allowed numbers of columns in result (usually 1, which means scalar value)
38
    0 means get this number from first argument
39
  */
40
  uint32_t allowed_arg_cols;
41
public:
779.3.18 by Monty Taylor
Cleaned up warnings up through innodb.
42
43
  using Item::split_sum_func;
44
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
45
  uint32_t arg_count;
46
  table_map used_tables_cache, not_null_tables_cache;
47
  bool const_item_cache;
48
  enum Functype { UNKNOWN_FUNC,EQ_FUNC,EQUAL_FUNC,NE_FUNC,LT_FUNC,LE_FUNC,
49
                  GE_FUNC,GT_FUNC,
50
                  LIKE_FUNC,ISNULL_FUNC,ISNOTNULL_FUNC,
51
                  COND_AND_FUNC, COND_OR_FUNC, COND_XOR_FUNC,
52
                  BETWEEN, IN_FUNC, MULT_EQUAL_FUNC,
53
                  INTERVAL_FUNC, ISNOTNULLTEST_FUNC,
54
                  NOT_FUNC, NOT_ALL_FUNC,
55
                  NOW_FUNC, TRIG_COND_FUNC,
56
                  SUSERVAR_FUNC, GUSERVAR_FUNC, COLLATE_FUNC,
57
                  EXTRACT_FUNC, CHAR_TYPECAST_FUNC, FUNC_SP,
58
                  NEG_FUNC };
59
  enum optimize_type { OPTIMIZE_NONE,OPTIMIZE_KEY,OPTIMIZE_OP, OPTIMIZE_NULL,
60
                       OPTIMIZE_EQUAL };
61
  enum Type type() const { return FUNC_ITEM; }
62
  virtual enum Functype functype() const   { return UNKNOWN_FUNC; }
1022.2.29 by Monty Taylor
Fixed some no-inline warnings.
63
  virtual ~Item_func() {}
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
64
  Item_func(void):
65
    allowed_arg_cols(1), arg_count(0)
66
  {
67
    with_sum_func= 0;
68
  }
69
  Item_func(Item *a):
70
    allowed_arg_cols(1), arg_count(1)
71
  {
72
    args= tmp_arg;
73
    args[0]= a;
74
    with_sum_func= a->with_sum_func;
75
  }
76
  Item_func(Item *a,Item *b):
77
    allowed_arg_cols(1), arg_count(2)
78
  {
79
    args= tmp_arg;
80
    args[0]= a; args[1]= b;
81
    with_sum_func= a->with_sum_func || b->with_sum_func;
82
  }
83
  Item_func(Item *a,Item *b,Item *c):
84
    allowed_arg_cols(1)
85
  {
86
    arg_count= 0;
1280.1.10 by Monty Taylor
Put everything in drizzled into drizzled namespace.
87
    if ((args= (Item**) memory::sql_alloc(sizeof(Item*)*3)))
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
88
    {
89
      arg_count= 3;
90
      args[0]= a; args[1]= b; args[2]= c;
91
      with_sum_func= a->with_sum_func || b->with_sum_func || c->with_sum_func;
92
    }
93
  }
94
  Item_func(Item *a,Item *b,Item *c,Item *d):
95
    allowed_arg_cols(1)
96
  {
97
    arg_count= 0;
1280.1.10 by Monty Taylor
Put everything in drizzled into drizzled namespace.
98
    if ((args= (Item**) memory::sql_alloc(sizeof(Item*)*4)))
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
99
    {
100
      arg_count= 4;
101
      args[0]= a; args[1]= b; args[2]= c; args[3]= d;
102
      with_sum_func= a->with_sum_func || b->with_sum_func ||
103
        c->with_sum_func || d->with_sum_func;
104
    }
105
  }
106
  Item_func(Item *a,Item *b,Item *c,Item *d,Item* e):
107
    allowed_arg_cols(1)
108
  {
109
    arg_count= 5;
1280.1.10 by Monty Taylor
Put everything in drizzled into drizzled namespace.
110
    if ((args= (Item**) memory::sql_alloc(sizeof(Item*)*5)))
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
111
    {
112
      args[0]= a; args[1]= b; args[2]= c; args[3]= d; args[4]= e;
113
      with_sum_func= a->with_sum_func || b->with_sum_func ||
114
        c->with_sum_func || d->with_sum_func || e->with_sum_func ;
115
    }
116
  }
117
  Item_func(List<Item> &list);
118
  // Constructor used for Item_cond_and/or (see Item comment)
520.1.22 by Brian Aker
Second pass of thd cleanup
119
  Item_func(Session *session, Item_func *item);
520.1.21 by Brian Aker
THD -> Session rename
120
  bool fix_fields(Session *, Item **ref);
846 by Brian Aker
Removing on typedeffed class.
121
  void fix_after_pullout(Select_Lex *new_parent, Item **ref);
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
122
  table_map used_tables() const;
123
  table_map not_null_tables() const;
124
  void update_used_tables();
125
  bool eq(const Item *item, bool binary_cmp) const;
126
  virtual optimize_type select_optimize() const { return OPTIMIZE_NONE; }
127
  virtual bool have_rev_func() const { return 0; }
128
  virtual Item *key_item() const { return args[0]; }
129
  /*
130
    This method is used for debug purposes to print the name of an
131
    item to the debug log. The second use of this method is as
132
    a helper function of print(), where it is applicable.
133
    To suit both goals it should return a meaningful,
134
    distinguishable and sintactically correct string.  This method
135
    should not be used for runtime type identification, use enum
136
    {Sum}Functype and Item_func::functype()/Item_sum::sum_func()
137
    instead.
138
  */
139
  virtual const char *func_name() const { return NULL; };
140
  virtual bool const_item() const { return const_item_cache; }
141
  Item **arguments() const { return args; }
142
  void set_arguments(List<Item> &list);
143
  uint32_t argument_count() const { return arg_count; }
144
  void remove_arguments() { arg_count=0; }
1005.1.2 by Monty Taylor
Merged Stewart from lp:~stewart-flamingspork/drizzle/fix-function-arguments
145
146
  /**
147
   * Check if the UDF supports the number of arguments passed in
148
   * @param number of args
149
   */
150
  virtual bool check_argument_count(int) { return true ; }
779.3.16 by Monty Taylor
Some Sun warning fixes.
151
  virtual void split_sum_func(Session *session, Item **ref_pointer_array,
152
                              List<Item> &fields);
153
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
154
  virtual void print(String *str, enum_query_type query_type);
155
  void print_op(String *str, enum_query_type query_type);
156
  void print_args(String *str, uint32_t from, enum_query_type query_type);
157
  virtual void fix_num_length_and_dec();
158
  void count_only_length();
159
  void count_real_length();
160
  void count_decimal_length();
161
162
  bool get_arg0_date(DRIZZLE_TIME *ltime, uint32_t fuzzy_date);
163
  bool get_arg0_time(DRIZZLE_TIME *ltime);
164
165
  bool is_null();
166
167
  void signal_divide_by_null();
168
779.3.16 by Monty Taylor
Some Sun warning fixes.
169
  virtual Field *tmp_table_field() { return result_field; }
170
  virtual Field *tmp_table_field(Table *t_arg);
171
520.1.22 by Brian Aker
Second pass of thd cleanup
172
  Item *get_tmp_table_item(Session *session);
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
173
174
  my_decimal *val_decimal(my_decimal *);
175
176
  bool agg_arg_collations(DTCollation &c, Item **items, uint32_t nitems,
177
                          uint32_t flags);
178
  bool agg_arg_collations_for_comparison(DTCollation &c,
179
                                         Item **items, uint32_t nitems,
180
                                         uint32_t flags);
181
  bool agg_arg_charsets(DTCollation &c, Item **items, uint32_t nitems,
182
                        uint32_t flags, int item_sep);
183
  bool walk(Item_processor processor, bool walk_subquery, unsigned char *arg);
184
  Item *transform(Item_transformer transformer, unsigned char *arg);
185
  Item* compile(Item_analyzer analyzer, unsigned char **arg_p,
186
                Item_transformer transformer, unsigned char *arg_t);
187
  void traverse_cond(Cond_traverser traverser,
188
                     void * arg, traverse_order order);
189
  double fix_result(double value);
190
191
};
192
1280.1.10 by Monty Taylor
Put everything in drizzled into drizzled namespace.
193
} /* namespace drizzled */
194
489.1.8 by Monty Taylor
Split out Item_int_func and Item_func from Item_func. (don't think too hard about the second one)
195
670.1.20 by Monty Taylor
Renamed functions to function... everything else is singular.
196
#endif /* DRIZZLED_FUNCTION_FUNC_H */