My Project
Public Member Functions | Public Attributes
Item_func_not_all Class Reference
Inheritance diagram for Item_func_not_all:
Item_func_not Item_bool_func Item_int_func Item_func Item_result_field Item Item_func_nop_all

List of all members.

Public Member Functions

 Item_func_not_all (Item *a)
virtual void top_level_item ()
bool top_level ()
longlong val_int ()
enum Functype functype () const
const char * func_name () const
virtual void print (String *str, enum_query_type query_type)
void set_sum_test (Item_sum_hybrid *item)
void set_sub_test (Item_maxmin_subselect *item)
void set_subselect (Item_subselect *item)
table_map not_null_tables () const
bool empty_underlying_subquery ()
Itemneg_transformer (THD *thd)

Public Attributes

bool show

Member Function Documentation

Item * Item_func_not_all::neg_transformer ( THD *  thd) [virtual]

Apply NOT transformation to the item and return a new one.

Transform the item using next rules:

       a AND b AND ...    -> NOT(a) OR NOT(b) OR ...
       a OR b OR ...      -> NOT(a) AND NOT(b) AND ...
       NOT(a)             -> a
       a = b              -> a != b
       a != b             -> a = b
       a < b              -> a >= b
       a >= b             -> a < b
       a > b              -> a <= b
       a <= b             -> a > b
       IS NULL(a)         -> IS NOT NULL(a)
       IS NOT NULL(a)     -> IS NULL(a)
    
Parameters:
thdthread handler
Returns:
New item or NULL if we cannot apply NOT transformation (see Item::neg_transformer()).

Reimplemented from Item_func_not.

Reimplemented in Item_func_nop_all.

void Item_func_not_all::print ( String str,
enum_query_type  query_type 
) [virtual]

This method is used for to:

  • to generate a view definition query (SELECT-statement);
  • to generate a SQL-query for EXPLAIN EXTENDED;
  • to generate a SQL-query to be shown in INFORMATION_SCHEMA;
  • debug.

For more information about view definition query, INFORMATION_SCHEMA query and why they should be generated from the Item-tree,

See also:
mysql_register_view().

Reimplemented from Item_func_not.

longlong Item_func_not_all::val_int ( void  ) [virtual]

special NOT for ALL subquery.

Reimplemented from Item_func_not.

Reimplemented in Item_func_nop_all.


The documentation for this class was generated from the following files:
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Defines