drizzle
C++ MySQL-protocol-compatible database server
Loading...
Searching...
No Matches
drizzled::Item_func_case Class Reference
Inheritance diagram for drizzled::Item_func_case:
[legend]
Collaboration diagram for drizzled::Item_func_case:
[legend]

Public Member Functions

 Item_func_case (List< Item > &list, Item *first_expr_arg, Item *else_expr_arg)
double val_real ()
int64_t val_int ()
String * val_str (String *)
type::Decimal * val_decimal (type::Decimal *)
bool fix_fields (Session *session, Item **ref)
void fix_length_and_dec ()
uint32_t decimal_precision () const
table_map not_null_tables () const
enum Item_result result_type () const
enum_field_types field_type () const
const char * func_name () const
virtual void print (String *str)
Item * find_item (String *str)
const charset_info_st * compare_collation ()
void cleanup ()
void agg_str_lengths (Item *arg)
void agg_num_lengths (Item *arg)
Public Member Functions inherited from drizzled::Item_func
enum Type type () const
virtual enum Functype functype () const
 Item_func (Item *a)
 Item_func (Item *a, Item *b)
 Item_func (Item *a, Item *b, Item *c)
 Item_func (Item *a, Item *b, Item *c, Item *d)
 Item_func (Item *a, Item *b, Item *c, Item *d, Item *e)
 Item_func (List< Item > &list)
 Item_func (Session *session, Item_func *item)
void fix_after_pullout (Select_Lex *new_parent, Item **ref)
table_map used_tables () const
void update_used_tables ()
bool eq (const Item *item, bool binary_cmp) const
virtual optimize_type select_optimize () const
virtual bool have_rev_func () const
virtual Item * key_item () const
virtual bool const_item () const
Item ** arguments () const
void set_arguments (List< Item > &list)
uint32_t argument_count () const
void remove_arguments ()
virtual bool check_argument_count (int)
virtual void split_sum_func (Session *session, Item **ref_pointer_array, List< Item > &fields)
void print_op (String *str)
void print_args (String *str, uint32_t from)
virtual void fix_num_length_and_dec ()
void count_only_length ()
void count_real_length ()
void count_decimal_length ()
bool get_arg0_date (type::Time &ltime, uint32_t fuzzy_date)
bool get_arg0_time (type::Time &ltime)
bool is_null ()
virtual bool deterministic () const
void signal_divide_by_null ()
virtual Field * tmp_table_field ()
virtual Field * tmp_table_field (Table *t_arg)
Item * get_tmp_table_item (Session *session)
bool agg_arg_collations (DTCollation &c, Item **items, uint32_t nitems, uint32_t flags)
bool agg_arg_collations_for_comparison (DTCollation &c, Item **items, uint32_t nitems, uint32_t flags)
bool agg_arg_charsets (DTCollation &c, Item **items, uint32_t nitems, uint32_t flags, int item_sep)
bool walk (Item_processor processor, bool walk_subquery, unsigned char *arg)
Item * transform (Item_transformer transformer, unsigned char *arg)
Item * compile (Item_analyzer analyzer, unsigned char **arg_p, Item_transformer transformer, unsigned char *arg_t)
void traverse_cond (Cond_traverser traverser, void *arg, traverse_order order)
double fix_result (double value)
void split_sum_func (Session *session, Item **ref_pointer_array, List< Item > &fields, Item **ref, bool skip_registered)
Public Member Functions inherited from drizzled::Item_result_field
 Item_result_field (Session *session, Item_result_field *item)
Field * get_tmp_table_field ()
Field * tmp_table_field (Table *)
table_map used_tables () const
void set_result_field (Field *field)
bool is_result_field ()
void save_in_result_field (bool no_conversions)
void cleanup ()
Public Member Functions inherited from drizzled::Item
bool is_unsigned () const
virtual bool negative () const
 Item ()
 Item (Session *session, Item *item)
void set_name (str_ref arg)
void set_name (const char *arg)
void set_name (const char *str, uint32_t length, const charset_info_st *cs=system_charset_info)
void init_make_field (SendField *tmp_field, enum_field_types type)
virtual void make_field (SendField *field)
Field * make_string_field (Table *table)
void quick_fix_field ()
virtual int save_in_field (Field *field, bool no_conversions)
virtual void save_org_in_field (Field *field)
virtual int save_safe_in_field (Field *field)
virtual void send (plugin::Client *client, String *str)
virtual Item_result cast_to_int_type () const
virtual enum_field_types string_field_type () const
virtual int64_t val_int_endpoint (bool left_endp, bool *incl_endp)
uint64_t val_uint ()
virtual bool val_bool ()
String * val_string_from_real (String *str)
String * val_string_from_int (String *str)
String * val_string_from_decimal (String *str)
type::Decimal * val_decimal_from_real (type::Decimal *decimal_value)
type::Decimal * val_decimal_from_int (type::Decimal *decimal_value)
type::Decimal * val_decimal_from_string (type::Decimal *decimal_value)
type::Decimal * val_decimal_from_date (type::Decimal *decimal_value)
type::Decimal * val_decimal_from_time (type::Decimal *decimal_value)
int64_t val_int_from_decimal ()
double val_real_from_decimal ()
bool save_time_in_field (Field *field)
bool save_date_in_field (Field *field)
int save_str_value_in_field (Field *field, String *result)
virtual const char * full_name (void) const
virtual double val_result ()
virtual int64_t val_int_result ()
virtual String * str_result (String *tmp)
virtual type::Decimal * val_decimal_result (type::Decimal *val)
virtual bool val_bool_result ()
virtual bool basic_const_item () const
virtual Item * clone_item ()
virtual cond_result eq_cmp_result () const
uint32_t float_length (uint32_t decimals_par) const
int decimal_int_part () const
virtual bool const_during_execution () const
void print_item_w_name (String *)
void split_sum_func (Session *session, Item **ref_pointer_array, List< Item > &fields, Item **ref, bool skip_registered)
virtual bool get_date (type::Time &ltime, uint32_t fuzzydate)
virtual bool get_time (type::Time &ltime)
virtual bool get_date_result (type::Time &ltime, uint32_t fuzzydate)
virtual void update_null_value ()
virtual void top_level_item (void)
virtual bool is_bool_func (void)
virtual void no_rows_in_result (void)
virtual Item * copy_or_same (Session *session)
virtual Item * copy_andor_structure (Session *session)
virtual Item * real_item (void)
virtual const Item * real_item (void) const
virtual bool remove_dependence_processor (unsigned char *arg)
virtual bool collect_item_field_processor (unsigned char *arg)
virtual bool find_item_in_field_list_processor (unsigned char *arg)
virtual bool change_context_processor (unsigned char *context)
virtual bool register_field_in_read_map (unsigned char *arg)
virtual bool subst_argument_checker (unsigned char **arg)
virtual bool cache_const_expr_analyzer (unsigned char **arg)
virtual Item * cache_const_expr_transformer (unsigned char *arg)
virtual Item * equal_fields_propagator (unsigned char *arg)
virtual bool set_no_const_sub (unsigned char *arg)
virtual Item * replace_equal_field (unsigned char *arg)
virtual uint32_t cols ()
virtual Item * element_index (uint32_t i)
virtual Item ** addr (uint32_t i)
virtual bool check_cols (uint32_t c)
virtual bool null_inside ()
virtual void bring_value ()
Field * tmp_table_field_from_field_type (Table *table, bool fixed_length)
virtual Item * neg_transformer (Session *session)
virtual Item * update_value_transformer (unsigned char *select_arg)
virtual Item * safe_charset_converter (const charset_info_st *const tocs)
void delete_self ()
virtual bool result_as_int64_t ()
bool is_datetime ()
virtual bool is_expensive ()
String * check_well_formed_result (String *str, bool send_error=0)
bool eq_by_collation (Item *item, bool binary_cmp, const charset_info_st *const cs)
uint32_t char_to_byte_length_safe (uint32_t char_length_arg, uint32_t mbmaxlen_arg)
uint32_t max_char_length () const
void fix_char_length (uint32_t max_char_length_arg)

Private Attributes

int first_expr_num
int else_expr_num
enum Item_result cached_result_type left_result_type
String tmp_value
uint32_t ncases
Item_result cmp_type
DTCollation cmp_collation
enum_field_types cached_field_type
cmp_item * cmp_items [DECIMAL_RESULT+1]
cmp_item * case_item

Additional Inherited Members

Public Types inherited from drizzled::Item_func
enum  Functype {
  UNKNOWN_FUNC , EQ_FUNC , EQUAL_FUNC , NE_FUNC ,
  LT_FUNC , LE_FUNC , GE_FUNC , GT_FUNC ,
  LIKE_FUNC , ISNULL_FUNC , ISNOTNULL_FUNC , COND_AND_FUNC ,
  COND_OR_FUNC , COND_XOR_FUNC , BETWEEN , IN_FUNC ,
  MULT_EQUAL_FUNC , INTERVAL_FUNC , ISNOTNULLTEST_FUNC , NOT_FUNC ,
  NOT_ALL_FUNC , NOW_FUNC , TRIG_COND_FUNC , SUSERVAR_FUNC ,
  GUSERVAR_FUNC , COLLATE_FUNC , EXTRACT_FUNC , CHAR_TYPECAST_FUNC ,
  FUNC_SP , NEG_FUNC
}
enum  optimize_type {
  OPTIMIZE_NONE , OPTIMIZE_KEY , OPTIMIZE_OP , OPTIMIZE_NULL ,
  OPTIMIZE_EQUAL
}
Public Types inherited from drizzled::Item
enum  Type {
  FIELD_ITEM = 0 , FUNC_ITEM , SUM_FUNC_ITEM , STRING_ITEM ,
  INT_ITEM , REAL_ITEM , NULL_ITEM , VARBIN_ITEM ,
  COPY_STR_ITEM , FIELD_AVG_ITEM , DEFAULT_VALUE_ITEM , PROC_ITEM ,
  COND_ITEM , REF_ITEM , FIELD_STD_ITEM , FIELD_VARIANCE_ITEM ,
  INSERT_VALUE_ITEM , SUBSELECT_ITEM , ROW_ITEM , CACHE_ITEM ,
  TYPE_HOLDER , PARAM_ITEM , BOOLEAN_ITEM , DECIMAL_ITEM
}
enum  traverse_order { T_POSTFIX , T_PREFIX }
enum  cond_result { COND_UNDEF , COND_OK , COND_TRUE , COND_FALSE }
Static Public Member Functions inherited from drizzled::Item
static const charset_info_st * default_charset ()
Static Public Member Functions inherited from drizzled::memory::SqlAlloc
static void * operator new (size_t size)
static void * operator new[] (size_t size)
static void * operator new (size_t size, Root &root)
static void * operator new[] (size_t size, Root &root)
static void * operator new (size_t size, Root *root)
static void * operator new[] (size_t size, Root *root)
static void operator delete (void *)
static void operator delete[] (void *)
static void operator delete (void *, Root &)
static void operator delete[] (void *, Root &)
static void operator delete (void *, Root *)
static void operator delete[] (void *, Root *)
Public Attributes inherited from drizzled::Item_func
uint32_t arg_count
table_map used_tables_cache
table_map not_null_tables_cache
bool const_item_cache
Public Attributes inherited from drizzled::Item_result_field
Field * result_field
Public Attributes inherited from drizzled::Item
String str_value
const char * name
uint32_t name_length
Item * next
uint32_t max_length
int8_t marker
uint8_t decimals
bool fixed
bool maybe_null
bool null_value
bool unsigned_flag
bool with_sum_func
bool is_autogenerated_name
bool with_subselect
DTCollation collation
Item_result cmp_context
Protected Member Functions inherited from drizzled::Item
Session & getSession ()
Protected Attributes inherited from drizzled::Item_func
Item ** args
Item * tmp_arg [2]
uint32_t allowed_arg_cols

Detailed Description

Definition at line 1113 of file cmpfunc.h.

Constructor & Destructor Documentation

◆ Item_func_case()

drizzled::Item_func_case::Item_func_case ( List< Item > & list,
Item * first_expr_arg,
Item * else_expr_arg )
inline

Definition at line 1125 of file cmpfunc.h.

Member Function Documentation

◆ agg_num_lengths()

void drizzled::Item_func_case::agg_num_lengths ( Item * arg)

Definition at line 2746 of file cmpfunc.cc.

◆ agg_str_lengths()

void drizzled::Item_func_case::agg_str_lengths ( Item * arg)

Definition at line 2738 of file cmpfunc.cc.

◆ cleanup()

void drizzled::Item_func_case::cleanup ( )
virtual

Reimplemented from drizzled::Item.

Definition at line 2880 of file cmpfunc.cc.

◆ compare_collation()

const charset_info_st * drizzled::Item_func_case::compare_collation ( )
inlinevirtual

Reimplemented from drizzled::Item.

Definition at line 1156 of file cmpfunc.h.

◆ decimal_precision()

uint32_t drizzled::Item_func_case::decimal_precision ( ) const
virtual

Reimplemented from drizzled::Item.

Definition at line 2837 of file cmpfunc.cc.

◆ field_type()

enum_field_types drizzled::Item_func_case::field_type ( ) const
inlinevirtual

Reimplemented from drizzled::Item.

Definition at line 1152 of file cmpfunc.h.

◆ find_item()

Item * drizzled::Item_func_case::find_item ( String * str)

Find and return matching items for CASE or ELSE item if all compares are failed or NULL if ELSE item isn't defined.

IMPLEMENTATION In order to do correct comparisons of the CASE expression (the expression between CASE and the first WHEN) with each WHEN expression several comparators are used. One for each result type. CASE expression can be evaluated up to # of different result types are used. To check whether the CASE expression already was evaluated for a particular result type a bit mapped variable value_added_map is used. Result types are mapped to it according to their int values i.e. STRING_RESULT is mapped to bit 0, REAL_RESULT to bit 1, so on.

Return values
NULLNothing found and there is no ELSE expression defined
itemFound item or ELSE item if defined and all comparisons are failed

Definition at line 2606 of file cmpfunc.cc.

◆ fix_fields()

bool drizzled::Item_func_case::fix_fields ( Session * session,
Item ** ref )
virtual

Reimplemented from drizzled::Item_func.

Definition at line 2719 of file cmpfunc.cc.

◆ fix_length_and_dec()

void drizzled::Item_func_case::fix_length_and_dec ( )
virtual

Implements drizzled::Item_result_field.

Definition at line 2756 of file cmpfunc.cc.

◆ func_name()

const char * drizzled::Item_func_case::func_name ( ) const
inlinevirtual

Reimplemented from drizzled::Item_func.

Definition at line 1153 of file cmpfunc.h.

◆ not_null_tables()

table_map drizzled::Item_func_case::not_null_tables ( ) const
inlinevirtual

Return table map of tables that can't be NULL tables (tables that are used in a context where if they would contain a NULL row generated by a LEFT or RIGHT join, the item would not be true). This expression is used on WHERE item to determinate if a LEFT JOIN can be converted to a normal join. Generally this function should return used_tables() if the function would return null if any of the arguments are null As this is only used in the beginning of optimization, the value don't have to be updated in update_used_tables()

Reimplemented from drizzled::Item_func.

Definition at line 1150 of file cmpfunc.h.

◆ print()

void drizzled::Item_func_case::print ( String * str)
virtual
Todo
Fix this so that it prints the whole CASE expression

Reimplemented from drizzled::Item_func.

Definition at line 2854 of file cmpfunc.cc.

◆ result_type()

enum Item_result drizzled::Item_func_case::result_type ( ) const
inlinevirtual

Reimplemented from drizzled::Item.

Definition at line 1151 of file cmpfunc.h.

◆ val_decimal()

type::Decimal * drizzled::Item_func_case::val_decimal ( type::Decimal * decimal_buffer)
virtual

Return decimal representation of item with fixed point.

Parameters
bufferwhich can be used by Item for returning value (but can be not)
Note

Returned value should not be changed if it is not the same which was passed via argument.

Return values
Returnpointer on type::Decimal (it can be other then passed via argument) if value is not NULL (null_value flag will be reset to false). In case of NULL value it return 0 pointer and set null_value flag to true.

Reimplemented from drizzled::Item_func.

Definition at line 2699 of file cmpfunc.cc.

◆ val_int()

int64_t drizzled::Item_func_case::val_int ( )
virtual

Returns integer representation of item.

Return values
Incase of NULL value return 0 and set null_value flag to true. If value is not null null_value flag will be reset to false.

Implements drizzled::Item.

Definition at line 2662 of file cmpfunc.cc.

◆ val_real()

double drizzled::Item_func_case::val_real ( )
virtual

Returns double precision floating point representation of item.

Return values
Incase of NULL value return 0.0 and set null_value flag to true. If value is not null null_value flag will be reset to false.

Implements drizzled::Item.

Definition at line 2680 of file cmpfunc.cc.

◆ val_str()

String * drizzled::Item_func_case::val_str ( String * str)
virtual

Return string representation of this item object.

Parameters
anallocated buffer this or any nested Item object can use to store return value of this method.
Note

Buffer passed via argument should only be used if the item itself doesn't have an own String buffer. In case when the item maintains it's own string buffer, it's preferable to return it instead to minimize number of mallocs/memcpys.

The caller of this method can modify returned string, but only in case when it was allocated on heap, (is_alloced() is true). This allows the caller to efficiently use a buffer allocated by a child without having to allocate a buffer of it's own. The buffer, given to val_str() as argument, belongs to the caller and is later used by the caller at it's own choosing.

A few implications from the above:

  • unless you return a string object which only points to your buffer but doesn't manages it you should be ready that it will be modified.
  • even for not allocated strings (is_alloced() == false) the caller can change charset (see Item_func_{typecast/binary}. XXX: is this a bug?
  • still you should try to minimize data copying and return internal object whenever possible.
Return values
Incase of NULL value return 0 (NULL pointer) and set null_value flag to true. If value is not null null_value flag will be reset to false.

Implements drizzled::Item.

Definition at line 2644 of file cmpfunc.cc.

Member Data Documentation

◆ cached_field_type

enum_field_types drizzled::Item_func_case::cached_field_type
private

Definition at line 1121 of file cmpfunc.h.

◆ case_item

cmp_item* drizzled::Item_func_case::case_item
private

Definition at line 1123 of file cmpfunc.h.

◆ cmp_collation

DTCollation drizzled::Item_func_case::cmp_collation
private

Definition at line 1120 of file cmpfunc.h.

◆ cmp_items

cmp_item* drizzled::Item_func_case::cmp_items[DECIMAL_RESULT+1]
private

Definition at line 1122 of file cmpfunc.h.

◆ cmp_type

Item_result drizzled::Item_func_case::cmp_type
private

Definition at line 1119 of file cmpfunc.h.

◆ else_expr_num

int drizzled::Item_func_case::else_expr_num
private

Definition at line 1115 of file cmpfunc.h.

◆ first_expr_num

int drizzled::Item_func_case::first_expr_num
private

Definition at line 1115 of file cmpfunc.h.

◆ left_result_type

enum Item_result cached_result_type drizzled::Item_func_case::left_result_type
private

Definition at line 1116 of file cmpfunc.h.

◆ ncases

uint32_t drizzled::Item_func_case::ncases
private

Definition at line 1118 of file cmpfunc.h.

◆ tmp_value

String drizzled::Item_func_case::tmp_value
private

Definition at line 1117 of file cmpfunc.h.


The documentation for this class was generated from the following files: