MySQL  8.0.27
Source Code Documentation
Item_sum_hybrid Class Referenceabstract

Abstract base class for the MIN and MAX aggregate functions. More...

#include <item_sum.h>

Inheritance diagram for Item_sum_hybrid:
Item_sum Item_func Item_result_field Item Parse_tree_node_tmpl< Context > Item_sum_max Item_sum_min

Public Member Functions

bool fix_fields (THD *, Item **) override
 
void clear () override
 
void update_after_wf_arguments_changed (THD *thd) override
 Signal to the function that its arguments may have changed, and that any internal caches etc. More...
 
void split_sum_func (THD *thd, Ref_item_array ref_item_array, mem_root_deque< Item * > *fields) override
 See comments in Item_cmp_func::split_sum_func() More...
 
double val_real () override
 
longlong val_int () override
 
longlong val_time_temporal () override
 Return time value of item in packed longlong format. More...
 
longlong val_date_temporal () override
 Return date value of item in packed longlong format. More...
 
my_decimalval_decimal (my_decimal *) override
 
bool get_date (MYSQL_TIME *ltime, my_time_flags_t fuzzydate) override
 
bool get_time (MYSQL_TIME *ltime) override
 
void reset_field () override
 
Stringval_str (String *) override
 
bool val_json (Json_wrapper *wr) override
 
bool keep_field_type () const override
 
enum Item_result result_type () const override
 
TYPELIBget_typelib () const override
 Get the typelib information for an item of type set or enum. More...
 
void update_field () override
 
void cleanup () override
 Called for every Item after use (preparation and execution). More...
 
bool any_value ()
 
void no_rows_in_result () override
 Mark an aggregate as having no rows. More...
 
Fieldcreate_tmp_field (bool group, TABLE *table) override
 
bool uses_only_one_row () const override
 Only for framing window functions. More...
 
bool add () override
 
Itemcopy_or_same (THD *thd) override
 
bool check_wf_semantics1 (THD *thd, Query_block *select, Window_evaluation_requirements *r) override
 Only relevant for aggregates qua window functions. More...
 
- Public Member Functions inherited from Item_sum
bool has_force_copy_fields () const
 
bool has_with_distinct () const
 
void mark_as_sum_func ()
 
void mark_as_sum_func (Query_block *)
 
 Item_sum (const POS &pos, PT_window *w)
 
 Item_sum (Item *a)
 
 Item_sum (const POS &pos, Item *a, PT_window *w)
 
 Item_sum (const POS &pos, Item *a, Item *b, PT_window *w)
 
 Item_sum (const POS &pos, PT_item_list *opt_list, PT_window *w)
 
 Item_sum (THD *thd, const Item_sum *item)
 Copy constructor, need to perform subqueries with temporary tables. More...
 
bool itemize (Parse_context *pc, Item **res) override
 The same as contextualize() but with additional parameter. More...
 
Type type () const override
 
virtual enum Sumfunctype sum_func () const =0
 
virtual enum Sumfunctype real_sum_func () const
 
bool reset_and_add ()
 Resets the aggregate value to its default and aggregates the current value of its attribute(s). More...
 
bool resolve_type (THD *) override
 Resolve type-related information for this item, such as result field type, maximum size, precision, signedness, character set and collation. More...
 
virtual Itemresult_item (Field *field)
 
table_map used_tables () const override
 
table_map not_null_tables () const override
 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). More...
 
void update_used_tables () override
 Updates used tables, not null tables information and accumulates properties up the item tree, cf. More...
 
void fix_after_pullout (Query_block *parent_query_block, Query_block *removed_query_block) override
 
void add_used_tables_for_aggr_func ()
 Add used_tables information for aggregate function, based on its aggregated query block. More...
 
bool is_null () override
 The method allows to determine nullness of a complex expression without fully evaluating it, instead of calling val*() then checking null_value. More...
 
void make_const ()
 
void print (const THD *thd, String *str, enum_query_type query_type) const override
 This method is used for to: More...
 
bool eq (const Item *item, bool binary_cmp) const override
 
virtual void make_unique ()
 
bool collect_grouped_aggregates (uchar *) override
 
Itemreplace_aggregate (uchar *) override
 
bool collect_scalar_subqueries (uchar *) override
 
bool collect_item_field_or_view_ref_processor (uchar *) override
 Collects fields and view references that have the qualifying table in the specified query block. More...
 
bool clean_up_after_removal (uchar *arg) override
 Remove the item from the list of inner aggregation functions in the Query_block it was moved to by Item_sum::check_sum_func(). More...
 
bool aggregate_check_group (uchar *arg) override
 
bool aggregate_check_distinct (uchar *arg) override
 
bool has_aggregate_ref_in_group_by (uchar *arg) override
 Check if an aggregate is referenced from within the GROUP BY clause of the query block in which it is aggregated. More...
 
bool init_sum_func_check (THD *thd)
 Prepare an aggregate function for checking of context. More...
 
bool check_sum_func (THD *thd, Item **ref)
 Validate the semantic requirements of a set function. More...
 
Itemset_arg (THD *thd, uint i, Item *new_val) override
 
Item ** get_arg_ptr (uint i)
 
virtual bool aggregator_setup (THD *thd)
 Called to initialize the aggregator. More...
 
void aggregator_clear ()
 Called to cleanup the aggregator. More...
 
bool aggregator_add ()
 Called to add value to the aggregator. More...
 
void set_distinct (bool distinct)
 
virtual int set_aggregator (Aggregator::Aggregator_type aggregator)
 
virtual bool setup (THD *)
 
virtual bool check_wf_semantics2 (Window_evaluation_requirements *reqs[[maybe_unused]])
 Like check_wf_semantics1. More...
 
Windowwindow ()
 
const Windowwindow () const
 
bool reset_wf_state (uchar *arg) override
 
virtual bool framing () const
 All aggregates are framing, i.e. More...
 
virtual bool needs_partition_cardinality () const
 Return true if we need to make two passes over the rows in the partition - either because we need the cardinality of it (and we need to read all rows to detect the next partition), or we need to have all partition rows available to evaluate the window function for some other reason, e.g. More...
 
bool wf_common_init ()
 Common initial actions for window functions. More...
 
- Public Member Functions inherited from Item_func
virtual void set_arg_resolve (THD *, uint i, Item *arg)
 Changes argument and maintains any necessary invariants. More...
 
virtual uint argument_count () const
 
Item ** arguments () const
 
virtual enum Functype functype () const
 
 Item_func ()
 
 Item_func (const POS &pos)
 
 Item_func (Item *a)
 
 Item_func (const POS &pos, Item *a)
 
 Item_func (Item *a, Item *b)
 
 Item_func (const POS &pos, Item *a, Item *b)
 
 Item_func (Item *a, Item *b, Item *c)
 
 Item_func (const POS &pos, Item *a, Item *b, Item *c)
 
 Item_func (Item *a, Item *b, Item *c, Item *d)
 
 Item_func (const POS &pos, Item *a, Item *b, Item *c, Item *d)
 
 Item_func (Item *a, Item *b, Item *c, Item *d, Item *e)
 
 Item_func (const POS &pos, Item *a, Item *b, Item *c, Item *d, Item *e)
 
 Item_func (mem_root_deque< Item * > *list)
 
 Item_func (const POS &pos, PT_item_list *opt_list)
 
 Item_func (THD *thd, const Item_func *item)
 
virtual Itemget_arg (uint i)
 
bool fix_func_arg (THD *, Item **arg)
 
void fix_after_pullout (Query_block *parent_query_block, Query_block *removed_query_block) override
 
virtual bool resolve_type_inner (THD *)
 Resolve type of function after all arguments have had their data types resolved. More...
 
bool propagate_type (THD *thd, const Type_properties &type) override
 Default implementation for all functions: Propagate base_item's type into all arguments. More...
 
virtual table_map get_initial_pseudo_tables () const
 Returns the pseudo tables depended upon in order to evaluate this function expression. More...
 
void set_used_tables (table_map map)
 
virtual optimize_type select_optimize (const THD *)
 
virtual bool have_rev_func () const
 
virtual Itemkey_item () const
 
bool set_arguments (mem_root_deque< Item * > *list, bool context_free)
 Copy arguments from list to args array. More...
 
void print_op (const THD *thd, String *str, enum_query_type query_type) const
 
void print_args (const THD *thd, String *str, uint from, enum_query_type query_type) const
 
virtual void fix_num_length_and_dec ()
 
virtual bool is_deprecated () const
 
bool get_arg0_date (MYSQL_TIME *ltime, my_time_flags_t fuzzy_date)
 
bool get_arg0_time (MYSQL_TIME *ltime)
 
void signal_divide_by_null ()
 
void signal_invalid_argument_for_log ()
 
Fieldtmp_table_field (TABLE *t_arg) override
 
Itemget_tmp_table_item (THD *thd) override
 If an Item is materialized in a temporary table, a different Item may have to be used in the part of the query that runs after the materialization. More...
 
bool agg_arg_charsets (DTCollation &c, Item **items, uint nitems, uint flags, int item_sep)
 
bool agg_arg_charsets_for_string_result (DTCollation &c, Item **items, uint nitems, int item_sep=1)
 
bool agg_arg_charsets_for_comparison (DTCollation &c, Item **items, uint nitems, int item_sep=1)
 
bool walk (Item_processor processor, enum_walk walk, uchar *arg) override
 
Itemtransform (Item_transformer transformer, uchar *arg) override
 Transform an Item_func object with a transformer callback function. More...
 
Itemcompile (Item_analyzer analyzer, uchar **arg_p, Item_transformer transformer, uchar *arg_t) override
 Compile Item_func object with a processor and a transformer callback functions. More...
 
void traverse_cond (Cond_traverser traverser, void *arg, traverse_order order) override
 
double check_float_overflow (double value)
 Throw an error if the input double number is not finite, i.e. More...
 
longlong check_integer_overflow (longlong value, bool val_unsigned)
 Throw an error if the input BIGINT value represented by the (longlong value, bool unsigned flag) pair cannot be returned by the function, i.e. More...
 
int check_decimal_overflow (int error)
 Throw an error if the error code of a DECIMAL operation is E_DEC_OVERFLOW. More...
 
bool has_timestamp_args ()
 
bool has_date_args ()
 
bool has_time_args ()
 
bool has_datetime_args ()
 
bool check_valid_arguments_processor (uchar *) override
 
Itemgc_subst_transformer (uchar *arg) override
 Transformer function for GC substitution. More...
 
virtual enum_const_item_cache can_cache_json_arg (Item *arg[[maybe_unused]])
 Whether an arg of a JSON function can be cached to avoid repetitive string->JSON conversion. More...
 
virtual bool contains_only_equi_join_condition () const
 Whether this Item is an equi-join condition. More...
 
bool ensure_multi_equality_fields_are_available_walker (uchar *) override
 Traverse the item tree and replace fields that are outside of reach with fields that are within reach. More...
 
- Public Member Functions inherited from Item_result_field
 Item_result_field ()=default
 
 Item_result_field (const POS &pos)
 
 Item_result_field (THD *thd, const Item_result_field *item)
 
Fieldget_tmp_table_field () override
 If this Item is being materialized into a temporary table, returns the field that is being materialized into. More...
 
void set_result_field (Field *field) override
 
bool is_result_field () const override
 
Fieldget_result_field () const override
 
virtual const char * func_name () const =0
 
bool mark_field_in_map (uchar *arg) override
 
longlong llrint_with_overflow_check (double realval)
 
void raise_numeric_overflow (const char *type_name)
 
double raise_float_overflow ()
 
longlong raise_integer_overflow ()
 
int raise_decimal_overflow ()
 
- Public Member Functions inherited from Item
 Item (const Item &)=delete
 
void operator= (Item &)=delete
 
 Item ()
 Item constructor for general use. More...
 
 Item (THD *thd, const Item *item)
 Constructor used by Item_field, Item_ref & aggregate functions. More...
 
 Item (const POS &)
 Parse-time context-independent constructor. More...
 
 ~Item () override=default
 
void rename (char *new_name)
 rename item (used for views, cleanup() return original name). More...
 
void init_make_field (Send_field *tmp_field, enum enum_field_types type)
 
virtual void notify_removal ()
 Called when an item has been removed, can be used to notify external objects about the removal, e.g subquery predicates that are part of the sj_candidates container. More...
 
virtual void make_field (Send_field *field)
 
virtual Fieldmake_string_field (TABLE *table) const
 Create a field to hold a string value from an item. More...
 
virtual void fix_after_pullout (Query_block *parent_query_block[[maybe_unused]], Query_block *removed_query_block[[maybe_unused]])
 Fix after tables have been moved from one query_block level to the parent level, e.g by semijoin conversion. More...
 
void quick_fix_field ()
 
virtual void set_can_use_prefix_key ()
 
virtual bool propagate_type (THD *thd[[maybe_unused]], const Type_properties &type[[maybe_unused]])
 Propagate data type specifications into parameters and user variables. More...
 
bool propagate_type (THD *thd, enum_field_types def=MYSQL_TYPE_VARCHAR, bool pin=false, bool inherit=false)
 Wrapper for easier calling of propagate_type(const Type_properties &). More...
 
virtual void mark_json_as_scalar ()
 For Items with data type JSON, mark that a string argument is treated as a scalar JSON value. More...
 
type_conversion_status save_in_field_no_warnings (Field *field, bool no_conversions)
 Save the item into a field but do not emit any warnings. More...
 
type_conversion_status save_in_field (Field *field, bool no_conversions)
 Save a temporal value in packed longlong format into a Field. More...
 
void save_in_field_no_error_check (Field *field, bool no_conversions)
 A slightly faster value of save_in_field() that returns no error value (you will need to check thd->is_error() yourself), and does not support saving into hidden fields for functional indexes. More...
 
virtual void save_org_in_field (Field *field)
 
virtual bool send (Protocol *protocol, String *str)
 This is only called from items that is not of type item_field. More...
 
bool evaluate (THD *thd, String *str)
 Evaluate item, possibly using the supplied buffer. More...
 
virtual Item_result numeric_context_result_type () const
 Result type when an item appear in a numeric context. More...
 
Item_result temporal_with_date_as_number_result_type () const
 Similar to result_type() but makes DATE, DATETIME, TIMESTAMP pretend to be numbers rather than strings. More...
 
virtual void set_data_type_inherited ()
 Set data type for item as inherited. More...
 
virtual void pin_data_type ()
 Pin the data type for the item. More...
 
enum_field_types data_type () const
 Retrieve the derived data type of the Item. More...
 
virtual enum_field_types actual_data_type () const
 Retrieve actual data type for an item. More...
 
virtual enum_field_types default_data_type () const
 Get the default data (output) type for the specific item. More...
 
void set_data_type (enum_field_types data_type)
 Set the data type of the current Item. More...
 
void set_data_type_bool ()
 
void set_data_type_longlong ()
 Set the data type of the Item to be longlong. More...
 
void set_data_type_decimal (uint8 precision, uint8 scale)
 Set the data type of the Item to be decimal. More...
 
void set_data_type_double ()
 Set the data type of the Item to be double precision floating point. More...
 
void set_data_type_float ()
 Set the data type of the Item to be single precision floating point. More...
 
void set_data_type_string (uint32 max_l)
 Set the Item to be variable length string. More...
 
void set_data_type_string (ulonglong max_char_length_arg)
 Set the Item to be variable length string. More...
 
void set_data_type_string (uint32 max_l, const CHARSET_INFO *cs)
 Set the Item to be variable length string. More...
 
void set_data_type_string (uint32 max_l, const DTCollation &coll)
 Set the Item to be variable length string. More...
 
void set_data_type_char (uint32 max_l)
 Set the Item to be fixed length string. More...
 
void set_data_type_char (uint32 max_l, const CHARSET_INFO *cs)
 Set the Item to be fixed length string. More...
 
void set_data_type_blob (uint32 max_l)
 Set the Item to be of BLOB type. More...
 
void set_data_type_date ()
 Set all type properties for Item of DATE type. More...
 
void set_data_type_time (uint8 fsp)
 Set all type properties for Item of TIME type. More...
 
void set_data_type_datetime (uint8 fsp)
 Set all properties for Item of DATETIME type. More...
 
void set_data_type_timestamp (uint8 fsp)
 Set all properties for Item of TIMESTAMP type. More...
 
void set_data_type_geometry ()
 Set the data type of the Item to be GEOMETRY. More...
 
void set_data_type_json ()
 Set the data type of the Item to be JSON. More...
 
void set_data_type_year ()
 Set the data type of the Item to be YEAR. More...
 
void set_data_type_bit ()
 Set the data type of the Item to be bit. More...
 
void set_data_type_from_item (const Item *item)
 Set data type properties of the item from the properties of another item. More...
 
virtual Item_result cast_to_int_type () const
 
void aggregate_type (Bounds_checked_array< Item * > items)
 Aggregates data types from array of items into current item. More...
 
virtual enum_monotonicity_info get_monotonicity_info () const
 
virtual longlong val_int_endpoint (bool left_endp[[maybe_unused]], bool *incl_endp[[maybe_unused]])
 
longlong val_temporal_by_field_type ()
 Return date or time value of item in packed longlong format, depending on item field type. More...
 
longlong int_sort_key ()
 Produces a key suitable for filesort. More...
 
longlong val_temporal_with_round (enum_field_types type, uint8 dec)
 Get date or time value in packed longlong format. More...
 
ulonglong val_uint ()
 
virtual Stringval_str_ascii (String *str)
 
virtual bool val_bool ()
 
virtual bool val_json (Json_wrapper *result[[maybe_unused]])
 Get a JSON value from an Item. More...
 
virtual float get_filtering_effect (THD *thd[[maybe_unused]], table_map filter_for_table[[maybe_unused]], table_map read_tables[[maybe_unused]], const MY_BITMAP *fields_to_ignore[[maybe_unused]], double rows_in_table[[maybe_unused]])
 Calculate the filter contribution that is relevant for table 'filter_for_table' for this item. More...
 
bool error_json ()
 Get the value to return from val_json() in case of errors. More...
 
bool get_date_from_non_temporal (MYSQL_TIME *ltime, my_time_flags_t fuzzydate)
 Convert a non-temporal type to date. More...
 
bool get_time_from_non_temporal (MYSQL_TIME *ltime)
 Convert a non-temporal type to time. More...
 
my_decimalerror_decimal (my_decimal *decimal_value)
 Get the value to return from val_decimal() in case of errors. More...
 
Stringerror_str ()
 Get the value to return from val_str() in case of errors. More...
 
type_conversion_status save_time_in_field (Field *field)
 
type_conversion_status save_date_in_field (Field *field)
 
type_conversion_status save_str_value_in_field (Field *field, String *result)
 
virtual const char * full_name () const
 
virtual bool basic_const_item () const
 Returns true if this is a simple constant item like an integer, not a constant expression. More...
 
bool may_eval_const_item (const THD *thd) const
 
virtual Itemclone_item () const
 
virtual cond_result eq_cmp_result () const
 
uint float_length (uint decimals_par) const
 
virtual uint decimal_precision () const
 
int decimal_int_part () const
 
virtual uint time_precision ()
 TIME precision of the item: 0..6. More...
 
virtual uint datetime_precision ()
 DATETIME precision of the item: 0..6. More...
 
bool const_item () const
 Returns true if item is constant, regardless of query evaluation state. More...
 
bool const_for_execution () const
 Returns true if item is constant during one query execution. More...
 
bool may_evaluate_const (const THD *thd) const
 Return true if this is a const item that may be evaluated in the current phase of statement processing. More...
 
bool is_non_deterministic () const
 
bool is_outer_reference () const
 
void print_item_w_name (const THD *thd, String *, enum_query_type query_type) const
 
void print_for_order (const THD *thd, String *str, enum_query_type query_type, bool used_alias) const
 Prints the item when it's part of ORDER BY and GROUP BY. More...
 
void split_sum_func2 (THD *thd, Ref_item_array ref_item_array, mem_root_deque< Item * > *fields, Item **ref, bool skip_registered)
 
virtual bool get_timeval (struct timeval *tm, int *warnings)
 Get timestamp in "struct timeval" format. More...
 
bool update_null_value ()
 Make sure the null_value member has a correct value. More...
 
virtual void apply_is_true ()
 Apply the IS TRUE truth property, meaning that an UNKNOWN result and a FALSE result are treated the same. More...
 
virtual bool is_bool_func () const
 
virtual Itemcopy_andor_structure (THD *)
 
virtual Itemreal_item ()
 
virtual const Itemreal_item () const
 
virtual const CHARSET_INFOcompare_collation () const
 
virtual const CHARSET_INFOcharset_for_protocol ()
 
virtual bool walk (Item_processor processor, enum_walk walk[[maybe_unused]], uchar *arg)
 Traverses a tree of Items in prefix and/or postfix order. More...
 
template<class T >
auto walk_helper_thunk (uchar *arg)
 
template<class T >
auto analyze_helper_thunk (uchar **arg)
 See CompileItem. More...
 
virtual bool intro_version (uchar *)
 
bool cleanup_processor (uchar *)
 cleanup() item if it is resolved ('fixed'). More...
 
virtual bool collect_item_field_processor (uchar *)
 
virtual bool collect_item_field_or_ref_processor (uchar *)
 
virtual bool add_field_to_set_processor (uchar *)
 Item::walk function. More...
 
virtual bool visitor_processor (uchar *arg)
 A processor to handle the select lex visitor framework. More...
 
virtual bool add_field_to_cond_set_processor (uchar *)
 Item::walk function. More...
 
virtual bool remove_column_from_bitmap (uchar *arg[[maybe_unused]])
 Visitor interface for removing all column expressions (Item_field) in this expression tree from a bitmap. More...
 
virtual bool find_item_in_field_list_processor (uchar *)
 
virtual bool change_context_processor (uchar *)
 
virtual bool find_item_processor (uchar *arg)
 
virtual bool find_field_processor (uchar *)
 Is this an Item_field which references the given Field argument? More...
 
virtual bool cast_incompatible_args (uchar *)
 Wrap incompatible arguments in CAST nodes to the expected data types. More...
 
virtual bool mark_field_in_map (uchar *arg[[maybe_unused]])
 Mark underlying field in read or write map of a table. More...
 
virtual bool reset_wf_state (uchar *arg[[maybe_unused]])
 Reset execution state for such window function types as determined by arg. More...
 
virtual bool used_tables_for_level (uchar *arg[[maybe_unused]])
 Return used table information for the specified query block (level). More...
 
virtual bool check_column_privileges (uchar *thd[[maybe_unused]])
 Check privileges. More...
 
virtual bool inform_item_in_cond_of_tab (uchar *)
 
virtual void bind_fields ()
 Bind objects from the current execution context to field objects in item trees. More...
 
bool propagate_derived_used (uchar *)
 Propagate components that use referenced columns from derived tables. More...
 
bool propagate_set_derived_used (uchar *)
 Called by Item::walk() to set all the referenced items' derived_used flag. More...
 
virtual bool is_strong_side_column_not_in_fd (uchar *)
 
virtual bool is_column_not_in_fd (uchar *)
 
virtual Bool3 local_column (const Query_block *) const
 
virtual bool collect_subqueries (uchar *)
 
virtual bool update_depended_from (uchar *)
 
bool visit_all_analyzer (uchar **)
 
virtual bool cache_const_expr_analyzer (uchar **cache_item)
 Check if an item is a constant one and can be cached. More...
 
Itemcache_const_expr_transformer (uchar *item)
 Cache item if needed. More...
 
virtual bool equality_substitution_analyzer (uchar **)
 
virtual Itemequality_substitution_transformer (uchar *)
 
virtual bool check_partition_func_processor (uchar *)
 Check if a partition function is allowed. More...
 
virtual bool subst_argument_checker (uchar **arg)
 
virtual bool explain_subquery_checker (uchar **)
 
virtual Itemexplain_subquery_propagator (uchar *)
 
virtual Itemequal_fields_propagator (uchar *)
 
virtual bool disable_constant_propagation (uchar *)
 
virtual Itemreplace_equal_field (uchar *)
 
virtual bool check_gcol_depend_default_processor (uchar *args[[maybe_unused]])
 Check if a generated expression depends on DEFAULT function with specific column name as argument. More...
 
virtual bool check_column_in_window_functions (uchar *arg[[maybe_unused]])
 Check if all the columns present in this expression are present in PARTITION clause of window functions of the derived table. More...
 
virtual bool check_column_in_group_by (uchar *arg[[maybe_unused]])
 Check if all the columns present in this expression are present in GROUP BY clause of the derived table. More...
 
virtual Itemreplace_with_derived_expr (uchar *arg[[maybe_unused]])
 Assuming this expression is part of a condition that would be pushed to the WHERE clause of a materialized derived table, replace, in this expression, each derived table's column with a clone of the expression lying under it in the derived table's definition. More...
 
virtual Itemreplace_with_derived_expr_ref (uchar *arg[[maybe_unused]])
 Assuming this expression is part of a condition that would be pushed to the HAVING clause of a materialized derived table, replace, in this expression, each derived table's column with a reference to the expression lying under it in the derived table's definition. More...
 
virtual Itemreplace_view_refs_with_clone (uchar *arg[[maybe_unused]])
 Assuming this expression is part of a condition that would be pushed to a materialized derived table, replace, in this expression, each view reference with a clone of the expression in merged derived table's definition. More...
 
virtual Itemthis_item ()
 
virtual const Itemthis_item () const
 
virtual Item ** this_item_addr (THD *, Item **addr_arg)
 
virtual uint cols () const
 
virtual Itemelement_index (uint)
 
virtual Item ** addr (uint)
 
virtual bool check_cols (uint c)
 
virtual bool null_inside ()
 
virtual void bring_value ()
 
Fieldtmp_table_field_from_field_type (TABLE *table, bool fixed_length) const
 Create a field based on field_type of argument. More...
 
virtual Item_fieldfield_for_view_update ()
 
virtual Itemtruth_transformer (THD *thd[[maybe_unused]], Bool_test test[[maybe_unused]])
 Informs an item that it is wrapped in a truth test, in case it wants to transforms itself to implement this test by itself. More...
 
virtual Itemupdate_value_transformer (uchar *)
 
virtual Itemreplace_scalar_subquery (uchar *)
 When walking the item tree seeing an Item_singlerow_subselect matching a target, replace it with a substitute field used when transforming scalar subqueries into derived tables. More...
 
virtual Itemreplace_item_field (uchar *)
 Transform processor used by Query_block::transform_grouped_to_derived to replace fields which used to be at the transformed query block with corresponding fields in the new derived table containing the grouping operation of the original transformed query block. More...
 
virtual Itemreplace_item_view_ref (uchar *)
 
virtual Itemreplace_outer_ref (uchar *)
 
virtual bool update_aggr_refs (uchar *)
 A walker processor overridden by Item_aggregate_ref, q.v. More...
 
virtual Itemsafe_charset_converter (THD *thd, const CHARSET_INFO *tocs)
 
void delete_self ()
 Delete this item. More...
 
virtual bool is_splocal () const
 
virtual Settable_routine_parameterget_settable_routine_parameter ()
 
bool is_temporal_with_date () const
 
bool is_temporal_with_date_and_time () const
 
bool is_temporal_with_time () const
 
bool is_temporal () const
 
bool has_compatible_context (Item *item) const
 Check whether this and the given item has compatible comparison context. More...
 
virtual Field::geometry_type get_geometry_type () const
 
Stringcheck_well_formed_result (String *str, bool send_error, bool truncate)
 Verifies that the input string is well-formed according to its character set. More...
 
bool eq_by_collation (Item *item, bool binary_cmp, const CHARSET_INFO *cs)
 
virtual bool is_expensive ()
 
uint32 max_char_length () const
 
uint32 max_char_length (const CHARSET_INFO *cs) const
 
void fix_char_length (uint32 max_char_length_arg)
 
virtual bool is_outer_field () const
 
bool is_blob_field () const
 Check if an item either is a blob field, or will be represented as a BLOB field if a field is created based on this item. More...
 
bool has_subquery () const
 
bool has_stored_program () const
 
bool has_aggregation () const
 
void set_aggregation ()
 Set the "has aggregation" property. More...
 
void reset_aggregation ()
 Reset the "has aggregation" property. More...
 
bool has_wf () const
 
void set_wf ()
 Set the "has window function" property. More...
 
bool has_rollup_expr () const
 
void set_rollup_expr ()
 Set the property: this item (tree) contains a reference to a ROLLUP expr. More...
 
bool has_grouping_func () const
 
void set_grouping_func ()
 Set the property: this item is a call to GROUPING. More...
 
virtual bool created_by_in2exists () const
 Whether this Item was created by the IN->EXISTS subquery transformation. More...
 
bool is_derived_used () const
 
void mark_subqueries_optimized_away ()
 
virtual bool gc_subst_analyzer (uchar **)
 Analyzer function for GC substitution. More...
 
virtual bool replace_field_processor (uchar *)
 A processor that replaces any Fields with a Create_field_wrapper. More...
 
bool can_be_substituted_for_gc (bool array=false) const
 Check if this item is of a type that is eligible for GC substitution. More...
 
void aggregate_decimal_properties (Item **item, uint nitems)
 Set precision and decimals of function when this depends on arguments' values for these quantities. More...
 
void aggregate_float_properties (Item **item, uint nitems)
 Set max_length and decimals of function if function is floating point and result length/precision depends on argument ones. More...
 
void aggregate_char_length (Item **args, uint nitems)
 Set the maximum number of characters required by any of the items in args. More...
 
void aggregate_temporal_properties (Item **item, uint nitems)
 Set fractional seconds precision for temporal functions. More...
 
bool aggregate_string_properties (const char *name, Item **item, uint nitems)
 Aggregate string properties (character set, collation and maximum length) for string function. More...
 
void aggregate_num_type (Item_result result_type, Item **item, uint nitems)
 This function is used to resolve type for numeric result type of CASE, COALESCE, IF and LEAD/LAG. More...
 
virtual bool repoint_const_outer_ref (uchar *arg[[maybe_unused]])
 This function applies only to Item_field objects referred to by an Item_ref object that has been marked as a const_item. More...
 
virtual bool strip_db_table_name_processor (uchar *)
 
bool is_nullable () const
 
void set_nullable (bool nullable)
 
virtual bool supports_partial_update (const Field_json *field[[maybe_unused]]) const
 Check if this expression can be used for partial update of a given JSON column. More...
 
virtual bool returns_array () const
 Whether the item returns array of its data type. More...
 
virtual void allow_array_cast ()
 A helper funciton to ensure proper usage of CAST(. More...
 
- Public Member Functions inherited from Parse_tree_node_tmpl< Context >
virtual ~Parse_tree_node_tmpl ()=default
 
bool is_contextualized () const
 
virtual bool contextualize (Context *pc)
 Do all context-sensitive things and mark the node as contextualized. More...
 
void error (Context *pc, const POS &pos) const
 syntax_error() function replacement for deferred reporting of syntax errors More...
 
void error (Context *pc, const POS &pos, const char *msg) const
 syntax_error() function replacement for deferred reporting of syntax errors More...
 
void errorf (Context *pc, const POS &pos, const char *format,...) const
 syntax_error() function replacement for deferred reporting of syntax errors More...
 

Protected Member Functions

 Item_sum_hybrid (Item *item_par, bool is_min)
 
 Item_sum_hybrid (const POS &pos, Item *item_par, bool is_min, PT_window *w)
 
 Item_sum_hybrid (THD *thd, const Item_sum_hybrid *item)
 
- Protected Member Functions inherited from Item_sum
void unsupported_as_wf ()
 
- Protected Member Functions inherited from Item_func
bool param_type_uses_non_param (THD *thd, enum_field_types def=MYSQL_TYPE_VARCHAR)
 
bool param_type_is_default (THD *thd, uint start, uint end, uint step, enum_field_types def)
 For arguments of this Item_func ("args" array), in range [start, start+step, start+2*step,...,end[ : if they're a PS parameter with invalid (not known) type, give them default type "def". More...
 
bool param_type_is_default (THD *thd, uint start, uint end, enum_field_types def=MYSQL_TYPE_VARCHAR)
 
bool param_type_is_rejected (uint start, uint end)
 For arguments of this Item_func ("args" array), in range [start,end[ : sends error if they're a dynamic parameter. More...
 
const Item_fieldcontributes_to_filter (table_map read_tables, table_map filter_for_table, const MY_BITMAP *fields_to_ignore) const
 Whether or not an item should contribute to the filtering effect (. More...
 
virtual bool may_have_named_parameters () const
 Named parameters are allowed in a parameter list. More...
 
bool is_non_const_over_literals (uchar *) override
 
bool check_function_as_value_generator (uchar *checker_args) override
 Check if this item is allowed for a virtual column or inside a default expression. More...
 
bool check_column_from_derived_table (uchar *arg[[maybe_unused]]) override
 Check if all the columns present in this expression are from the derived table. More...
 
bool check_column_in_window_functions (uchar *arg) override
 
bool check_column_in_group_by (uchar *arg) override
 
longlong val_int_from_real ()
 
- Protected Member Functions inherited from Item
Stringmake_empty_result ()
 Sets the result value of the function an empty string, using the current character set. More...
 
bool skip_itemize (Item **res)
 Helper function to skip itemize() for grammar-allocated items. More...
 
virtual type_conversion_status save_in_field_inner (Field *field, bool no_conversions)
 Helper function which does all of the work for save_in_field(Field*, bool), except some error checking common to all subclasses, which is performed by save_in_field() itself. More...
 
Stringval_string_from_real (String *str)
 
Stringval_string_from_int (String *str)
 
Stringval_string_from_decimal (String *str)
 
Stringval_string_from_date (String *str)
 
Stringval_string_from_datetime (String *str)
 
Stringval_string_from_time (String *str)
 
my_decimalval_decimal_from_real (my_decimal *decimal_value)
 
my_decimalval_decimal_from_int (my_decimal *decimal_value)
 
my_decimalval_decimal_from_string (my_decimal *decimal_value)
 
my_decimalval_decimal_from_date (my_decimal *decimal_value)
 
my_decimalval_decimal_from_time (my_decimal *decimal_value)
 
longlong val_int_from_decimal ()
 
longlong val_int_from_date ()
 
longlong val_int_from_time ()
 
longlong val_int_from_datetime ()
 
longlong val_int_from_string ()
 
double val_real_from_decimal ()
 
double val_real_from_string ()
 
bool error_bool ()
 Get the value to return from val_bool() in case of errors. More...
 
int error_int ()
 Get the value to return from val_int() in case of errors. More...
 
double error_real ()
 Get the value to return from val_real() in case of errors. More...
 
Stringnull_return_str ()
 Gets the value to return from val_str() when returning a NULL value. More...
 
bool get_date_from_string (MYSQL_TIME *ltime, my_time_flags_t flags)
 Convert val_str() to date in MYSQL_TIME. More...
 
bool get_date_from_real (MYSQL_TIME *ltime, my_time_flags_t flags)
 Convert val_real() to date in MYSQL_TIME. More...
 
bool get_date_from_decimal (MYSQL_TIME *ltime, my_time_flags_t flags)
 Convert val_decimal() to date in MYSQL_TIME. More...
 
bool get_date_from_int (MYSQL_TIME *ltime, my_time_flags_t flags)
 Convert val_int() to date in MYSQL_TIME. More...
 
bool get_date_from_time (MYSQL_TIME *ltime)
 Convert get_time() from time to date in MYSQL_TIME. More...
 
bool get_date_from_numeric (MYSQL_TIME *ltime, my_time_flags_t fuzzydate)
 Convert a numeric type to date. More...
 
bool get_time_from_string (MYSQL_TIME *ltime)
 Convert val_str() to time in MYSQL_TIME. More...
 
bool get_time_from_real (MYSQL_TIME *ltime)
 Convert val_real() to time in MYSQL_TIME. More...
 
bool get_time_from_decimal (MYSQL_TIME *ltime)
 Convert val_decimal() to time in MYSQL_TIME. More...
 
bool get_time_from_int (MYSQL_TIME *ltime)
 Convert val_int() to time in MYSQL_TIME. More...
 
bool get_time_from_date (MYSQL_TIME *ltime)
 Convert date to time. More...
 
bool get_time_from_datetime (MYSQL_TIME *ltime)
 Convert datetime to time. More...
 
bool get_time_from_numeric (MYSQL_TIME *ltime)
 Convert a numeric type to time. More...
 
virtual longlong val_date_temporal_at_utc ()
 
virtual longlong val_time_temporal_at_utc ()
 
void set_accum_properties (const Item *item)
 Set accumulated properties for an Item. More...
 
void add_accum_properties (const Item *item)
 Add more accumulated properties to an Item. More...
 
void set_subquery ()
 Set the "has subquery" property. More...
 
void set_stored_program ()
 Set the "has stored program" property. More...
 
- Protected Member Functions inherited from Parse_tree_node_tmpl< Context >
 Parse_tree_node_tmpl ()
 

Private Types

typedef Item_sum super
 

Private Member Functions

bool compute ()
 This function implements the optimized version of retrieving min/max value. More...
 
bool setup_hybrid (Item *item, Item *value_arg)
 MIN/MAX function setup. More...
 
virtual Item_sum_hybridclone_hybrid (THD *thd) const =0
 Create a clone of this object. More...
 
void min_max_update_str_field ()
 
void min_max_update_temporal_field ()
 
void min_max_update_json_field ()
 
void min_max_update_real_field ()
 
void min_max_update_int_field ()
 
void min_max_update_decimal_field ()
 

Private Attributes

const bool m_is_min
 Tells if this is the MIN function (true) or the MAX function (false). More...
 
Item_cachevalue
 
Item_cachearg_cache
 
Arg_comparatorcmp
 
Item_result hybrid_type
 
bool was_values
 
bool m_nulls_first
 Set to true if the window is ordered ascending. More...
 
bool m_optimize
 Set to true when min/max can be optimized using window's ordering. More...
 
bool m_want_first
 For min() - Set to true when results are ordered in ascending and false when descending. More...
 
int64 m_cnt
 Execution state: keeps track if this is the first row in the frame when buffering is not needed. More...
 
int64 m_saved_last_value_at
 Execution state: keeps track of at which row we saved a non-null last value. More...
 

Additional Inherited Members

- Public Types inherited from Item_sum
enum  Sumfunctype {
  COUNT_FUNC , COUNT_DISTINCT_FUNC , SUM_FUNC , SUM_DISTINCT_FUNC ,
  AVG_FUNC , AVG_DISTINCT_FUNC , MIN_FUNC , MAX_FUNC ,
  STD_FUNC , VARIANCE_FUNC , SUM_BIT_FUNC , UDF_SUM_FUNC ,
  GROUP_CONCAT_FUNC , JSON_AGG_FUNC , ROW_NUMBER_FUNC , RANK_FUNC ,
  DENSE_RANK_FUNC , CUME_DIST_FUNC , PERCENT_RANK_FUNC , NTILE_FUNC ,
  LEAD_LAG_FUNC , FIRST_LAST_VALUE_FUNC , NTH_VALUE_FUNC , ROLLUP_SUM_SWITCHER_FUNC ,
  GEOMETRY_AGGREGATE_FUNC
}
 
- Public Types inherited from Item_func
enum  Functype {
  UNKNOWN_FUNC , EQ_FUNC , EQUAL_FUNC , NE_FUNC ,
  LT_FUNC , LE_FUNC , GE_FUNC , GT_FUNC ,
  FT_FUNC , MATCH_FUNC , LIKE_FUNC , ISNULL_FUNC ,
  ISNOTNULL_FUNC , ISTRUTH_FUNC , COND_AND_FUNC , COND_OR_FUNC ,
  XOR_FUNC , BETWEEN , IN_FUNC , MULT_EQUAL_FUNC ,
  INTERVAL_FUNC , ISNOTNULLTEST_FUNC , SP_EQUALS_FUNC , SP_DISJOINT_FUNC ,
  SP_INTERSECTS_FUNC , SP_TOUCHES_FUNC , SP_CROSSES_FUNC , SP_WITHIN_FUNC ,
  SP_CONTAINS_FUNC , SP_COVEREDBY_FUNC , SP_COVERS_FUNC , SP_OVERLAPS_FUNC ,
  SP_STARTPOINT , SP_ENDPOINT , SP_EXTERIORRING , SP_POINTN ,
  SP_GEOMETRYN , SP_INTERIORRINGN , NOT_FUNC , NOT_ALL_FUNC ,
  NOW_FUNC , TRIG_COND_FUNC , SUSERVAR_FUNC , GUSERVAR_FUNC ,
  COLLATE_FUNC , EXTRACT_FUNC , TYPECAST_FUNC , FUNC_SP ,
  UDF_FUNC , NEG_FUNC , GSYSVAR_FUNC , GROUPING_FUNC ,
  ROLLUP_GROUP_ITEM_FUNC , TABLE_FUNC , DD_INTERNAL_FUNC , PLUS_FUNC ,
  MINUS_FUNC , MUL_FUNC , DIV_FUNC , CEILING_FUNC ,
  ROUND_FUNC , TRUNCATE_FUNC , SQRT_FUNC , ABS_FUNC ,
  FLOOR_FUNC , LOG_FUNC , LN_FUNC , LOG10_FUNC ,
  SIN_FUNC , TAN_FUNC , COS_FUNC , COT_FUNC ,
  DEGREES_FUNC , RADIANS_FUNC , EXP_FUNC , ASIN_FUNC ,
  ATAN_FUNC , ACOS_FUNC , MOD_FUNC , IF_FUNC ,
  NULLIF_FUNC , CASE_FUNC , YEAR_FUNC , YEARWEEK_FUNC ,
  MAKEDATE_FUNC , MONTH_FUNC , MONTHNAME_FUNC , DAY_FUNC ,
  DAYNAME_FUNC , TO_DAYS_FUNC , TO_SECONDS_FUNC , DATE_FUNC ,
  HOUR_FUNC , MINUTE_FUNC , SECOND_FUNC , MICROSECOND_FUNC ,
  DAYOFYEAR_FUNC , ADDTIME_FUNC , QUARTER_FUNC , WEEK_FUNC ,
  WEEKDAY_FUNC , DATEADD_FUNC , FROM_UNIXTIME_FUNC , CONVERT_TZ_FUNC ,
  UNIX_TIMESTAMP_FUNC , TIME_TO_SEC_FUNC , TIMESTAMPDIFF_FUNC , DATETIME_LITERAL ,
  GREATEST_FUNC , COALESCE_FUNC , LEAST_FUNC , JSON_CONTAINS ,
  JSON_OVERLAPS , JSON_UNQUOTE_FUNC , MEMBER_OF_FUNC , STRCMP_FUNC ,
  TRUE_FUNC
}
 
enum  optimize_type {
  OPTIMIZE_NONE , OPTIMIZE_KEY , OPTIMIZE_OP , OPTIMIZE_NULL ,
  OPTIMIZE_EQUAL
}
 
- Public Types inherited from Item
enum  Type {
  INVALID_ITEM = 0 , FIELD_ITEM , FUNC_ITEM , SUM_FUNC_ITEM ,
  STRING_ITEM , INT_ITEM , REAL_ITEM , NULL_ITEM ,
  VARBIN_ITEM , METADATA_COPY_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 , TRIGGER_FIELD_ITEM ,
  DECIMAL_ITEM , XPATH_NODESET , XPATH_NODESET_CMP , VIEW_FIXER_ITEM ,
  FIELD_BIT_ITEM , VALUES_COLUMN_ITEM
}
 
enum  cond_result { COND_UNDEF , COND_OK , COND_TRUE , COND_FALSE }
 
enum  traverse_order { POSTFIX , PREFIX }
 
enum  enum_const_item_cache { CACHE_NONE = 0 , CACHE_JSON_VALUE , CACHE_JSON_ATOM }
 How to cache constant JSON data. More...
 
enum  Bool_test {
  BOOL_IS_TRUE = 0x00 , BOOL_IS_FALSE = 0x01 , BOOL_IS_UNKNOWN = 0x02 , BOOL_NOT_TRUE = 0x03 ,
  BOOL_NOT_FALSE = 0x04 , BOOL_NOT_UNKNOWN = 0x05 , BOOL_IDENTITY = 0x06 , BOOL_NEGATED = 0x07 ,
  BOOL_ALWAYS_TRUE = 0x08 , BOOL_ALWAYS_FALSE = 0x09
}
 < Modifier for result transformation More...
 
enum  item_marker {
  MARKER_NONE = 0 , MARKER_IMPLICIT_NE_ZERO = 1 , MARKER_CONST_PROPAG = 2 , MARKER_BIT = 4 ,
  MARKER_FUNC_DEP_NOT_NULL = 5 , MARKER_DISTINCT_GROUP = 6 , MARKER_COND_DERIVED_TABLE = 7 , MARKER_ICP_COND_USES_INDEX_ONLY = 10
}
 < Values for member 'marker' More...
 
- Public Types inherited from Parse_tree_node_tmpl< Context >
typedef Context context_t
 
- Static Public Member Functions inherited from Item
static void * operator new (size_t size) noexcept
 
static void * operator new (size_t size, MEM_ROOT *mem_root, const std::nothrow_t &arg[[maybe_unused]]=std::nothrow) noexcept
 
static void operator delete (void *ptr[[maybe_unused]], size_t size[[maybe_unused]])
 
static void operator delete (void *, MEM_ROOT *, const std::nothrow_t &) noexcept
 
static enum_field_types result_to_type (Item_result result)
 
static Item_result type_to_result (enum_field_types type)
 
static enum_field_types type_for_variable (enum_field_types src_type)
 Provide data type for a user or system variable, based on the type of the item that is assigned to the variable. More...
 
static enum_field_types string_field_type (uint32 max_bytes)
 Determine correct string field type, based on string length. More...
 
static const CHARSET_INFOdefault_charset ()
 
- Static Public Member Functions inherited from Parse_tree_node_tmpl< Context >
static void * operator new (size_t size, MEM_ROOT *mem_root, const std::nothrow_t &arg[[maybe_unused]]=std::nothrow) noexcept
 
static void operator delete (void *ptr[[maybe_unused]], size_t size[[maybe_unused]])
 
static void operator delete (void *, MEM_ROOT *, const std::nothrow_t &) noexcept
 
- Public Attributes inherited from Item_sum
Item ** referenced_by [2]
 For a group aggregate which is aggregated into an outer query block; none, or just the first or both cells may be non-zero. More...
 
Item_sumnext_sum {nullptr}
 next in the circular chain of registered objects More...
 
Item_sumin_sum_func
 the containing set function if any More...
 
Query_blockbase_query_block
 query block where function is placed More...
 
Query_blockaggr_query_block
 For a group aggregate, query block where function is aggregated. More...
 
int8 max_aggr_level
 max level of unbound column references More...
 
int8 max_sum_func_level
 max level of aggregation for contained functions More...
 
bool allow_group_via_temp_table
 If incremental update of fields is supported. More...
 
nesting_map save_deny_window_func
 WFs are forbidden when resolving Item_sum; this member is used to restore WF allowance status afterwards. More...
 
- Public Attributes inherited from Item_func
uint arg_count
 How many arguments in 'args'. More...
 
- Public Attributes inherited from Item
Itemnext_free
 Intrusive list pointer for free list. More...
 
DTCollation collation
 Character set and collation properties assigned for this Item. More...
 
Item_name_string item_name
 Name from query. More...
 
Item_name_string orig_name
 Original item name (if it was renamed) More...
 
uint32 max_length
 Maximum length of result of evaluating this item, in number of bytes. More...
 
item_marker marker
 This member has several successive meanings, depending on the phase we're in (. More...
 
Item_result cmp_context
 Comparison context. More...
 
bool fixed
 True if item has been resolved. More...
 
uint8 decimals
 Number of decimals in result when evaluating this item. More...
 
bool null_value
 True if item is null. More...
 
bool unsigned_flag
 
bool m_is_window_function
 True if item represents window func. More...
 
bool hidden {false}
 If the item is in a SELECT list (Query_block::fields) and hidden is true, the item wasn't actually in the list as given by the user (it was added by the optimizer, to e.g. More...
 
bool m_in_check_constraint_exec_ctx {false}
 True if item is a top most element in the expression being evaluated for a check constraint. More...
 
- Static Protected Member Functions inherited from Item_sum
static ulonglong ram_limitation (THD *thd)
 Calculate the affordable RAM limit for structures like TREE or Unique used in Item_sum_*. More...
 
- Static Protected Member Functions inherited from Item
static bool bit_func_returns_binary (const Item *a, const Item *b)
 
static bool mark_field_in_map (Mark_field *mark_field, Field *field)
 Helper function for mark_field_in_map(uchar *arg). More...
 
- Protected Attributes inherited from Item_sum
Aggregatoraggr {nullptr}
 Aggregator class instance. More...
 
PT_windowm_window {nullptr}
 If sum is a window function, this field contains the window. More...
 
bool m_window_resolved {false}
 True if we have already resolved this window functions window reference. More...
 
bool forced_const {false}
 True means that this field has been evaluated during optimization. More...
 
- Protected Attributes inherited from Item_func
Item ** args
 Array of pointers to arguments. More...
 
bool null_on_null {true}
 Affects how to determine that NULL argument implies a NULL function return. More...
 
uint allowed_arg_cols {1}
 
table_map used_tables_cache {0}
 Value used in calculation of result of used_tables() More...
 
table_map not_null_tables_cache {0}
 Value used in calculation of result of not_null_tables() More...
 
- Protected Attributes inherited from Item_result_field
Fieldresult_field {nullptr}
 
- Protected Attributes inherited from Item
String str_value
 str_values's main purpose is to cache the value in save_in_field More...
 
uint8 m_accum_properties
 
- Static Protected Attributes inherited from Item
static constexpr uint8 PROP_SUBQUERY = 0x01
 Set of properties that are calculated by accumulation from underlying items. More...
 
static constexpr uint8 PROP_STORED_PROGRAM = 0x02
 
static constexpr uint8 PROP_AGGREGATION = 0x04
 
static constexpr uint8 PROP_WINDOW_FUNCTION = 0x08
 
static constexpr uint8 PROP_ROLLUP_EXPR = 0x10
 Set if the item or one or more of the underlying items contains a ROLLUP expression. More...
 
static constexpr uint8 PROP_GROUPING_FUNC = 0x20
 Set if the item or one or more of the underlying items is a GROUPING function. More...
 

Detailed Description

Abstract base class for the MIN and MAX aggregate functions.

Member Typedef Documentation

◆ super

Constructor & Destructor Documentation

◆ Item_sum_hybrid() [1/3]

Item_sum_hybrid::Item_sum_hybrid ( Item item_par,
bool  is_min 
)
inlineprotected

◆ Item_sum_hybrid() [2/3]

Item_sum_hybrid::Item_sum_hybrid ( const POS pos,
Item item_par,
bool  is_min,
PT_window w 
)
inlineprotected

◆ Item_sum_hybrid() [3/3]

Item_sum_hybrid::Item_sum_hybrid ( THD thd,
const Item_sum_hybrid item 
)
inlineprotected

Member Function Documentation

◆ add()

bool Item_sum_hybrid::add ( )
overridevirtual

Implements Item_sum.

◆ any_value()

bool Item_sum_hybrid::any_value ( )
inline

◆ check_wf_semantics1()

bool Item_sum_hybrid::check_wf_semantics1 ( THD thd,
Query_block select,
Window_evaluation_requirements reqs 
)
overridevirtual

Only relevant for aggregates qua window functions.

Checks semantics after windows have been set up and checked. Window functions have specific requirements on the window specifications. Used at resolution time.

Parameters
thdCurrent thread
selectThe current select
[out]reqsHolds collected requirements from this wf
Returns
true if error

Reimplemented from Item_sum.

◆ cleanup()

void Item_sum_hybrid::cleanup ( )
overridevirtual

Called for every Item after use (preparation and execution).

Release all allocated resources, such as dynamic memory. Prepare for new execution by clearing cached values. Do not remove values allocated during preparation, destructor handles this.

Reimplemented from Item_sum.

◆ clear()

void Item_sum_hybrid::clear ( )
overridevirtual

Implements Item_sum.

◆ clone_hybrid()

virtual Item_sum_hybrid* Item_sum_hybrid::clone_hybrid ( THD thd) const
privatepure virtual

Create a clone of this object.

Implemented in Item_sum_max, and Item_sum_min.

◆ compute()

bool Item_sum_hybrid::compute ( )
private

This function implements the optimized version of retrieving min/max value.

When we have "ordered ASC" results in a window, min will always be the first value in the result set (neglecting the NULL's) and max will always be the last value (or the other way around, if ordered DESC). It is based on the implementation of FIRST_VALUE/LAST_VALUE, except for the NULL handling.

Returns
true if computation yielded a NULL or error

◆ copy_or_same()

Item * Item_sum_hybrid::copy_or_same ( THD thd)
overridevirtual

Reimplemented from Item.

◆ create_tmp_field()

Field * Item_sum_hybrid::create_tmp_field ( bool  group,
TABLE table 
)
overridevirtual

Reimplemented from Item_sum.

◆ fix_fields()

bool Item_sum_hybrid::fix_fields ( THD thd,
Item **  ref 
)
overridevirtual

Reimplemented from Item_sum.

◆ get_date()

bool Item_sum_hybrid::get_date ( MYSQL_TIME ltime,
my_time_flags_t  fuzzydate 
)
overridevirtual

Implements Item.

◆ get_time()

bool Item_sum_hybrid::get_time ( MYSQL_TIME ltime)
overridevirtual

Implements Item.

◆ get_typelib()

TYPELIB* Item_sum_hybrid::get_typelib ( ) const
inlineoverridevirtual

Get the typelib information for an item of type set or enum.

Reimplemented from Item.

◆ keep_field_type()

bool Item_sum_hybrid::keep_field_type ( ) const
inlineoverridevirtual

Reimplemented from Item_sum.

◆ min_max_update_decimal_field()

void Item_sum_hybrid::min_max_update_decimal_field ( )
private

◆ min_max_update_int_field()

void Item_sum_hybrid::min_max_update_int_field ( )
private

◆ min_max_update_json_field()

void Item_sum_hybrid::min_max_update_json_field ( )
private

◆ min_max_update_real_field()

void Item_sum_hybrid::min_max_update_real_field ( )
private

◆ min_max_update_str_field()

void Item_sum_hybrid::min_max_update_str_field ( )
private

◆ min_max_update_temporal_field()

void Item_sum_hybrid::min_max_update_temporal_field ( )
private

◆ no_rows_in_result()

void Item_sum_hybrid::no_rows_in_result ( )
overridevirtual

Mark an aggregate as having no rows.

This function is called by the execution engine to assign 'NO ROWS FOUND' value to an aggregate item, when the underlying result set has no rows. Such value, in a general case, may be different from the default value of the item after 'clear()': e.g. a numeric item may be initialized to 0 by clear() and to NULL by no_rows_in_result().

Reimplemented from Item_sum.

◆ reset_field()

void Item_sum_hybrid::reset_field ( )
overridevirtual

Implements Item_sum.

◆ result_type()

enum Item_result Item_sum_hybrid::result_type ( ) const
inlineoverridevirtual

Reimplemented from Item.

◆ setup_hybrid()

bool Item_sum_hybrid::setup_hybrid ( Item item,
Item value_arg 
)
private

MIN/MAX function setup.

Setup cache/comparator of MIN/MAX functions. When called by the copy_or_same() function, the value_arg parameter contains the calculated value of the original MIN/MAX object, and it is saved in this object's cache.

Parameters
itemthe argument of the MIN/MAX function
value_argthe calculated value of the MIN/MAX function
Returns
false on success, true on error

◆ split_sum_func()

void Item_sum_hybrid::split_sum_func ( THD thd,
Ref_item_array  ref_item_array,
mem_root_deque< Item * > *  fields 
)
overridevirtual

See comments in Item_cmp_func::split_sum_func()

Reimplemented from Item_sum.

◆ update_after_wf_arguments_changed()

void Item_sum_hybrid::update_after_wf_arguments_changed ( THD )
overridevirtual

Signal to the function that its arguments may have changed, and that any internal caches etc.

based on those arguments must be updated accordingly.

This is used by the hypergraph optimizer when it rewrites arguments to window functions to take into account that they have been materialized into temporary tables, or that they should read their values from the framebuffer.

Reimplemented from Item_sum.

◆ update_field()

void Item_sum_hybrid::update_field ( )
overridevirtual

Implements Item_sum.

◆ uses_only_one_row()

bool Item_sum_hybrid::uses_only_one_row ( ) const
inlineoverridevirtual

Only for framing window functions.

True if this function only needs to read one row per frame.

Reimplemented from Item_sum.

◆ val_date_temporal()

longlong Item_sum_hybrid::val_date_temporal ( )
overridevirtual

Return date value of item in packed longlong format.

Reimplemented from Item.

◆ val_decimal()

my_decimal * Item_sum_hybrid::val_decimal ( my_decimal val)
overridevirtual

Reimplemented from Item_func.

◆ val_int()

longlong Item_sum_hybrid::val_int ( void  )
overridevirtual

Implements Item.

◆ val_json()

bool Item_sum_hybrid::val_json ( Json_wrapper wr)
override

◆ val_real()

double Item_sum_hybrid::val_real ( void  )
overridevirtual

Implements Item.

◆ val_str()

String * Item_sum_hybrid::val_str ( String str)
overridevirtual

Implements Item.

◆ val_time_temporal()

longlong Item_sum_hybrid::val_time_temporal ( )
overridevirtual

Return time value of item in packed longlong format.

Reimplemented from Item.

Member Data Documentation

◆ arg_cache

Item_cache * Item_sum_hybrid::arg_cache
private

◆ cmp

Arg_comparator* Item_sum_hybrid::cmp
private

◆ hybrid_type

Item_result Item_sum_hybrid::hybrid_type
private

◆ m_cnt

int64 Item_sum_hybrid::m_cnt
private

Execution state: keeps track if this is the first row in the frame when buffering is not needed.

Valid only when m_optimize is true.

◆ m_is_min

const bool Item_sum_hybrid::m_is_min
private

Tells if this is the MIN function (true) or the MAX function (false).

◆ m_nulls_first

bool Item_sum_hybrid::m_nulls_first
private

Set to true if the window is ordered ascending.

◆ m_optimize

bool Item_sum_hybrid::m_optimize
private

Set to true when min/max can be optimized using window's ordering.

◆ m_saved_last_value_at

int64 Item_sum_hybrid::m_saved_last_value_at
private

Execution state: keeps track of at which row we saved a non-null last value.

◆ m_want_first

bool Item_sum_hybrid::m_want_first
private

For min() - Set to true when results are ordered in ascending and false when descending.

For max() - Set to true when results are ordered in descending and false when ascending. Valid only when m_optimize is true. Want first non-null value, else last non_null value

◆ value

Item_cache* Item_sum_hybrid::value
private

◆ was_values

bool Item_sum_hybrid::was_values
private

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