 |
MySQL 8.4.2
Source Code Documentation
|
|
MySQL 8.4.2
Source Code Documentation
|
Class that represents a quantified comparison predicate. More...
#include <item_subselect.h>
Public Member Functions | |
| Item_allany_subselect (Item *left_expr, chooser_compare_func_creator fc, Query_block *select, bool all) | |
| Subquery_type | subquery_type () const override |
| bool | transformer (THD *thd, Item **transformed) override |
| void | print (const THD *thd, String *str, enum_query_type query_type) const override |
| This method is used for to: More... | |
 Public Member Functions inherited from Item_in_subselect | |
| Item_in_subselect (Item *left_expr, Query_block *query_block) | |
| Item_in_subselect (const POS &pos, Item *left_expr, PT_subquery *pt_subquery_arg) | |
| Item_in_subselect () | |
| bool | do_itemize (Parse_context *pc, Item **res) override |
| The core function that does the actual itemization. More... | |
| void | cleanup () override |
| Called for every Item after use (preparation and execution). More... | |
| void | reset () override |
| Reset state after a single execution of a subquery, useful when a dependent subquery must be evaluated multiple times for varying values of the outer references. More... | |
| bool | quantified_comp_transformer (THD *thd, Comp_creator *func, Item **transformed) |
| Perform transformation of quantified comparison predicates (ie. More... | |
| bool | single_value_transformer (THD *thd, Comp_creator *func, Item **transformed) |
| Transform a single-column IN/ALL/ANY subquery predicate. More... | |
| bool | row_value_transformer (THD *thd, Item **transformed) |
| Transform a multi-column IN/ALL/ANY subquery predicate. More... | |
| bool | single_value_in_to_exists_transformer (THD *thd, Query_block *select, Comp_creator *func) |
| Transform an IN predicate into EXISTS via predicate injection. More... | |
| bool | row_value_in_to_exists_transformer (THD *thd, Query_block *select, Item_in_optimizer *optimizer) |
| Transform a (possibly non-correlated) IN subquery into a correlated EXISTS. More... | |
| bool | subquery_allows_materialization (THD *thd, Query_block *query_block, const Query_block *outer) |
| Check if the subquery predicate can be executed via materialization. More... | |
| bool | walk (Item_processor processor, enum_walk walk, uchar *arg) override |
| Traverses a tree of Items in prefix and/or postfix order. More... | |
| Item * | transform (Item_transformer transformer, uchar *arg) override |
| Perform a generic transformation of the Item tree, by adding zero or more additional Item objects to it. More... | |
| Item * | compile (Item_analyzer analyzer, uchar **arg_p, Item_transformer transformer, uchar *arg_t) override |
| Perform a generic "compilation" of the Item tree, ie transform the Item tree by adding zero or more Item objects to it. More... | |
| bool | exec (THD *thd) override |
| longlong | val_int () override |
| double | val_real () override |
| String * | val_str (String *) override |
| Return the result of EXISTS as a string value. More... | |
| my_decimal * | val_decimal (my_decimal *) override |
| Return the result of EXISTS as a decimal value. More... | |
| bool | val_bool () override |
| bool | test_limit () |
| void | fix_after_pullout (Query_block *parent_query_block, Query_block *removed_query_block) override |
| void | update_used_tables () override |
| Updates used tables, not null tables information and accumulates properties up the item tree, cf. More... | |
| bool | init_left_expr_cache (THD *thd) |
| Initialize the cache of the left operand of the IN predicate. More... | |
| bool | finalize_exists_transform (THD *thd, Query_block *select) |
| Once the decision to use IN->EXISTS has been taken, performs some last steps of this transformation. More... | |
| bool | finalize_materialization_transform (THD *thd, JOIN *join) |
| Once the decision to use materialization has been taken, performs some last steps of this transformation. More... | |
| AccessPath * | root_access_path () const override |
| std::optional< ContainedSubquery > | get_contained_subquery (const Query_block *outer_query_block) override |
| If this item represents a IN/ALL/ANY/comparison_operator subquery, return that (along with data on how it will be executed). More... | |
| bool | in2exists_added_to_where () const |
| bool | dependent_before_in2exists () const |
| Is reliable only if IN->EXISTS has been done. More... | |
| bool * | get_cond_guard (int i) const |
| void | set_cond_guard_var (int i, bool v) const |
| Public Member Functions inherited from Item_exists_subselect | |
| Item_exists_subselect (Query_block *query_block) | |
| Create an Item that represents an EXISTS subquery predicate, or any quantified comparison predicate that uses the same base class. More... | |
| Item_exists_subselect () | |
| Item_exists_subselect (const POS &pos) | |
| void | notify_removal () override |
| 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... | |
| bool | is_bool_func () const override |
| enum Item_result | result_type () const override |
| bool | with_is_op () const |
| Item * | truth_transformer (THD *, enum Bool_test test) override |
| 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... | |
| bool | translate (bool &null_v, bool v) |
| Translates the value of the naked EXISTS to a value taking into account the optional NULL and IS [NOT] TRUE/FALSE. More... | |
| void | apply_is_true () override |
| Apply the IS TRUE truth property, meaning that an UNKNOWN result and a FALSE result are treated the same. More... | |
| bool | choose_semijoin_or_antijoin () |
| Helper for is_semijoin_candidate() and is_derived_candidate(). More... | |
| bool | fix_fields (THD *thd, Item **ref) override |
| An object of class Item_in_subselect is always substituted with another object of class Item_in_optimizer, and the substitution object contains a pointer to the original Item_in_subselect. More... | |
| bool | get_date (MYSQL_TIME *ltime, my_time_flags_t fuzzydate) override |
| bool | get_time (MYSQL_TIME *ltime) override |
| bool | resolve_type (THD *thd) override |
| Resolve type-related information for this item, such as result field type, maximum size, precision, signedness, character set and collation. More... | |
| Public Member Functions inherited from Item_subselect | |
| Query_expression * | query_expr () const |
| enum_engine_type | engine_type () const |
| const TABLE * | get_table () const |
| const Index_lookup & | index_lookup () const |
| join_type | get_join_type () const |
| void | create_iterators (THD *thd) |
| void | accumulate_used_tables (table_map add_tables) |
| Accumulate used tables. More... | |
| virtual bool | is_single_column_scalar_subquery () const |
| bool | is_value_assigned () const |
| void | set_value_assigned () |
| void | reset_value_assigned () |
| enum Type | type () const override |
| 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... | |
| 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... | |
| table_map | subquery_used_tables () const |
| Item * | get_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... | |
| void | set_indexsubquery_engine (subselect_indexsubquery_engine *eng) |
| bool | is_evaluated () const |
| bool | is_uncacheable () const |
| virtual void | reset_has_values () |
| Used by max/min subquery to initialize value presence registration mechanism. More... | |
| enum_parsing_context | place () |
| bool | explain_subquery_checker (uchar **arg) override |
| Register subquery to the table where it is used within a condition. More... | |
| bool | inform_item_in_cond_of_tab (uchar *arg) override |
| Tells an Item that it is in the condition of a JOIN_TAB of a query block. More... | |
| bool | clean_up_after_removal (uchar *arg) override |
| Clean up after removing the subquery from the item tree. More... | |
| const char * | func_name () const override |
| bool | check_function_as_value_generator (uchar *args) override |
| Check if this item is allowed for a virtual column or inside a default expression. More... | |
| bool | collect_subqueries (uchar *) override |
| Item * | replace_item_field (uchar *arg) override |
| Transform processor. More... | |
| Item * | replace_item_view_ref (uchar *arg) override |
| Transform processor. 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) | |
| Field * | get_tmp_table_field () override |
| If this Item is being materialized into a temporary table, returns the field that is being materialized into. More... | |
| Field * | tmp_table_field (TABLE *) override |
| void | set_result_field (Field *field) override |
| bool | is_result_field () const override |
| Field * | get_result_field () const override |
| bool | mark_field_in_map (uchar *arg) override |
| Mark underlying field in read or write map of a table. More... | |
| 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 | |
| virtual bool | itemize (Parse_context *pc, Item **res) final |
| The same as contextualize() but with additional parameter. More... | |
| 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 | make_field (Send_field *field) |
| virtual Field * | make_string_field (TABLE *table) const |
| Create a field to hold a string value from an item. More... | |
| void | quick_fix_field () |
| virtual void | set_can_use_prefix_key () |
| virtual bool | propagate_type (THD *thd, const Type_properties &type) |
| 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 scalar item, possibly using the supplied buffer. More... | |
| virtual bool | eq (const Item *, bool binary_cmp) const |
| 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_null () |
| void | set_data_type_bool () |
| void | set_data_type_int (enum_field_types type, bool unsigned_prop, uint32 max_width) |
| Set the data type of the Item to be a specific integer type. More... | |
| 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 (enum_field_types type, 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 (uint32 max_bits) |
| 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 TYPELIB * | get_typelib () const |
| Get the typelib information for an item of type set or enum. More... | |
| virtual Item_result | cast_to_int_type () const |
| bool | aggregate_type (const char *name, Item **items, uint count) |
| 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, bool *incl_endp) |
| virtual longlong | val_date_temporal () |
| Return date value of item in packed longlong format. More... | |
| virtual longlong | val_time_temporal () |
| Return time value of item in packed longlong format. More... | |
| 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 String * | val_str_ascii (String *str) |
| virtual bool | val_json (Json_wrapper *result) |
| Get a JSON value from an Item. More... | |
| virtual float | get_filtering_effect (THD *thd, table_map filter_for_table, table_map read_tables, const MY_BITMAP *fields_to_ignore, double rows_in_table) |
| 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_decimal * | error_decimal (my_decimal *decimal_value) |
| Get the value to return from val_decimal() in case of errors. More... | |
| String * | error_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 Item * | clone_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, const char *used_alias) const |
| Prints the item when it's part of ORDER BY and GROUP BY. More... | |
| virtual bool | split_sum_func (THD *, Ref_item_array, mem_root_deque< Item * > *) |
| bool | 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 (my_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 | no_rows_in_result () |
| virtual Item * | copy_or_same (THD *) |
| virtual Item * | copy_andor_structure (THD *) |
| virtual Item * | real_item () |
| virtual const Item * | real_item () const |
| virtual const CHARSET_INFO * | compare_collation () const |
| virtual const CHARSET_INFO * | charset_for_protocol () |
| template<class T > | |
| auto | walk_helper_thunk (uchar *arg) |
| template<class T > | |
| auto | analyze_helper_thunk (uchar **arg) |
| See CompileItem. More... | |
| virtual void | traverse_cond (Cond_traverser traverser, void *arg, traverse_order) |
| 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 | collect_item_field_or_view_ref_processor (uchar *) |
| Collects fields and view references that have the qualifying table in the specified query block. More... | |
| 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) |
| 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 | is_non_const_over_literals (uchar *) |
| 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 | reset_wf_state (uchar *arg) |
| Reset execution state for such window function types as determined by arg. More... | |
| virtual bool | used_tables_for_level (uchar *arg) |
| Return used table information for the specified query block (level). More... | |
| virtual bool | check_column_privileges (uchar *thd) |
| Check privileges. More... | |
| virtual void | bind_fields () |
| Bind objects from the current execution context to field objects in item trees. More... | |
| virtual bool | aggregate_check_distinct (uchar *) |
| virtual bool | aggregate_check_group (uchar *) |
| 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_scalar_subqueries (uchar *) |
| virtual bool | collect_grouped_aggregates (uchar *) |
| virtual bool | update_depended_from (uchar *) |
| virtual bool | has_aggregate_ref_in_group_by (uchar *) |
| Check if an aggregate is referenced from within the GROUP BY clause of the query block in which it is aggregated. More... | |
| 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... | |
| Item * | cache_const_expr_transformer (uchar *item) |
| Cache item if needed. More... | |
| virtual bool | equality_substitution_analyzer (uchar **) |
| virtual Item * | equality_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 Item * | explain_subquery_propagator (uchar *) |
| virtual Item * | equal_fields_propagator (uchar *) |
| virtual bool | disable_constant_propagation (uchar *) |
| virtual Item * | replace_equal_field (uchar *) |
| virtual bool | replace_equal_field_checker (uchar **) |
| virtual bool | check_valid_arguments_processor (uchar *) |
| virtual bool | check_gcol_depend_default_processor (uchar *args) |
| Check if a generated expression depends on DEFAULT function with specific column name as argument. More... | |
| virtual bool | is_valid_for_pushdown (uchar *arg) |
| Check if all the columns present in this expression are from the derived table. More... | |
| virtual bool | check_column_in_window_functions (uchar *arg) |
| 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) |
| Check if all the columns present in this expression are present in GROUP BY clause of the derived table. More... | |
| virtual Item * | replace_with_derived_expr (uchar *arg) |
| 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 Item * | replace_with_derived_expr_ref (uchar *arg) |
| 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 Item * | replace_view_refs_with_clone (uchar *arg) |
| 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 Item * | this_item () |
| virtual const Item * | this_item () const |
| virtual Item ** | this_item_addr (THD *, Item **addr_arg) |
| virtual uint | cols () const |
| virtual Item * | element_index (uint) |
| virtual Item ** | addr (uint) |
| virtual bool | check_cols (uint c) |
| virtual bool | null_inside () |
| virtual void | bring_value () |
| Field * | tmp_table_field_from_field_type (TABLE *table, bool fixed_length) const |
| Create a field based on field_type of argument. More... | |
| virtual Item_field * | field_for_view_update () |
| virtual Item * | update_value_transformer (uchar *) |
| virtual Item * | replace_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 Item * | replace_func_call (uchar *) |
| virtual Item * | replace_aggregate (uchar *) |
| virtual Item * | replace_outer_ref (uchar *) |
| virtual bool | update_aggr_refs (uchar *) |
| A walker processor overridden by Item_aggregate_ref, q.v. More... | |
| virtual Item * | safe_charset_converter (THD *thd, const CHARSET_INFO *tocs) |
| void | delete_self () |
| Delete this item. More... | |
| virtual bool | is_splocal () const |
| virtual Settable_routine_parameter * | get_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 |
| String * | check_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) |
| CostOfItem | cost () const |
| 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... | |
| uint | reference_count () const |
| void | increment_ref_count () |
| Increment reference count. More... | |
| uint | decrement_ref_count () |
| Decrement reference count. 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_grouping_set_dep () const |
| void | set_group_by_modifier () |
| Set the property: this item (tree) contains a reference to a GROUP BY modifier (such as ROLLUP) 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... | |
| void | mark_subqueries_optimized_away () |
| virtual bool | gc_subst_analyzer (uchar **) |
| Analyzer function for GC substitution. More... | |
| virtual Item * | gc_subst_transformer (uchar *) |
| Transformer 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_float_properties (enum_field_types type, Item **items, 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_decimal_properties (Item **items, uint nitems) |
| Set data type, precision and scale of item of type decimal from list of items. More... | |
| uint32 | aggregate_char_width (Item **items, uint nitems) |
| Calculate the maximum number of characters required by any of the items. More... | |
| void | aggregate_temporal_properties (enum_field_types type, Item **items, uint nitems) |
| Set data type and fractional seconds precision for temporal functions. More... | |
| bool | aggregate_string_properties (enum_field_types type, const char *name, Item **items, uint nitems) |
| Aggregate string properties (character set, collation and maximum length) for string function. More... | |
| void | aggregate_bit_properties (Item **items, uint nitems) |
| Set data type and properties of a BIT column. More... | |
| virtual bool | repoint_const_outer_ref (uchar *arg) |
| 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 *) |
| virtual void | compute_cost (CostOfItem *root_cost) const |
| Compute the cost of evaluating this Item. More... | |
| bool | is_abandoned () const |
| bool | is_nullable () const |
| void | set_nullable (bool nullable) |
| virtual bool | supports_partial_update (const Field_json *field) 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 function 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) final |
| 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... | |
Public Attributes | |
| chooser_compare_func_creator | m_func_creator |
| Comp_creator * | m_func |
| bool | m_all |
| Public Attributes inherited from Item_in_subselect | |
| bool * | m_pushed_cond_guards {nullptr} |
| Used to trigger on/off conditions that were pushed down to subquery. More... | |
| Item_func_not_all * | m_upper_item {nullptr} |
| Point on NOT/NOP before ALL/SOME subquery. More... | |
| Public Attributes inherited from Item_exists_subselect | |
| Item * | left_expr {nullptr} |
| int | sj_convert_priority {0} |
| Priority of this predicate in the convert-to-semi-join-nest process. More... | |
| Subquery_strategy | strategy {Subquery_strategy::UNSPECIFIED} |
| Execution strategy chosen for this Item. More... | |
| enum_condition_context | outer_condition_context {enum_condition_context::ANDS} |
| Used by the transformation to derived table. More... | |
| Table_ref * | embedding_join_nest {nullptr} |
| Used by subquery optimizations to keep track about where this subquery predicate is located, and whether it is a candidate for transformation. More... | |
| enum Bool_test | value_transform = BOOL_IDENTITY |
| bool | implicit_is_op = false |
| True if the IS TRUE/FALSE wasn't explicit in the query. More... | |
| bool | can_do_aj = false |
| True if the Item has decided that it can do antijoin. More... | |
| Public Attributes inherited from Item_subselect | |
| int | in_cond_of_tab {NO_PLAN_IDX} |
| If !=NO_PLAN_IDX: this Item is in the condition attached to the JOIN_TAB having this index in the parent JOIN. More... | |
| Public Attributes inherited from Item | |
| Item * | next_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... | |
| Public Attributes inherited from Parse_tree_node_tmpl< Context > | |
| POS | m_pos |
Additional Inherited Members | |
| Public Types inherited from Item_subselect | |
| enum | enum_engine_type { OTHER_ENGINE , INDEXSUBQUERY_ENGINE , HASH_SJ_ENGINE } |
| enum | Subquery_type { SCALAR_SUBQUERY , EXISTS_SUBQUERY , IN_SUBQUERY , ALL_SUBQUERY , ANY_SUBQUERY } |
| Public Types inherited from Item | |
| enum | Type { INVALID_ITEM , FIELD_ITEM , FUNC_ITEM , SUM_FUNC_ITEM , AGGR_FIELD_ITEM , STRING_ITEM , INT_ITEM , DECIMAL_ITEM , REAL_ITEM , NULL_ITEM , HEX_BIN_ITEM , DEFAULT_VALUE_ITEM , COND_ITEM , REF_ITEM , INSERT_VALUE_ITEM , SUBQUERY_ITEM , ROW_ITEM , CACHE_ITEM , TYPE_HOLDER_ITEM , PARAM_ITEM , ROUTINE_FIELD_ITEM , TRIGGER_FIELD_ITEM , XPATH_NODESET_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_TRAVERSAL = 8 , 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=std::nothrow) noexcept |
| static void | operator delete (void *ptr, size_t size) |
| 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_INFO * | default_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=std::nothrow) noexcept |
| static void | operator delete (void *ptr, size_t size) |
| static void | operator delete (void *, MEM_ROOT *, const std::nothrow_t &) noexcept |
| Protected Member Functions inherited from Item_exists_subselect | |
| bool | is_semijoin_candidate (THD *thd) |
| bool | is_derived_candidate (THD *thd) |
| Protected Member Functions inherited from Item_subselect | |
| Item_subselect () | |
| Item_subselect (const POS &pos) | |
| void | bind (Query_expression *qe) |
| Bind this subquery object with the supplied query expression. More... | |
| Protected Member Functions inherited from Item | |
| String * | make_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... | |
| String * | val_string_from_real (String *str) |
| String * | val_string_from_int (String *str) |
| String * | val_string_from_decimal (String *str) |
| String * | val_string_from_date (String *str) |
| String * | val_string_from_datetime (String *str) |
| String * | val_string_from_time (String *str) |
| my_decimal * | val_decimal_from_real (my_decimal *decimal_value) |
| my_decimal * | val_decimal_from_int (my_decimal *decimal_value) |
| my_decimal * | val_decimal_from_string (my_decimal *decimal_value) |
| my_decimal * | val_decimal_from_date (my_decimal *decimal_value) |
| my_decimal * | val_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... | |
| bool | error_date () |
| Get the value to return from get_date() in case of errors. More... | |
| bool | error_time () |
| Get the value to return from get_time() in case of errors. More... | |
| String * | null_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 ()=delete | |
| Parse_tree_node_tmpl (const POS &pos) | |
| Parse_tree_node_tmpl (const POS &start_pos, const POS &end_pos) | |
| bool | begin_parse_tree (Show_parse_tree *tree) |
| bool | end_parse_tree (Show_parse_tree *tree) |
| virtual bool | do_contextualize (Context *pc) |
| Do all context-sensitive things and mark the node as contextualized. More... | |
| virtual void | add_json_info (Json_object *json_obj) |
| Add all the node-specific json fields. 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_in_subselect | |
| List< Cached_item > * | m_left_expr_cache {nullptr} |
| Cache of the left operand of the subquery predicate. More... | |
| bool | m_left_expr_cache_filled {false} |
| Whether m_left_expr_cache holds a value. More... | |
| bool | need_expr_cache {true} |
| The need for expr cache may be optimized away,. More... | |
| Protected Attributes inherited from Item_exists_subselect | |
| bool | m_value {false} |
| value of this item (boolean: exists/not-exists) More... | |
| bool | abort_on_null {false} |
| True if naked IN is allowed to exchange FALSE for UNKNOWN. More... | |
| Protected Attributes inherited from Item_subselect | |
| Query_expression * | m_query_expr {nullptr} |
| The query expression of the subquery. More... | |
| Query_result_interceptor * | m_query_result {nullptr} |
| The query result object associated with the query expression. More... | |
| subselect_indexsubquery_engine * | indexsubquery_engine {nullptr} |
| Only relevant for Item_in_subselect; optimized structure used for execution in place of running the entire subquery. More... | |
| table_map | m_used_tables_cache {0} |
| cache of used tables More... | |
| table_map | m_subquery_used_tables {0} |
| cache of used tables from subquery only (not including LHS of IN subquery) More... | |
| uint | m_max_columns {0} |
| allowed number of columns (1 for scalar subqueries) More... | |
| enum_parsing_context | m_parsing_place {CTX_NONE} |
| where subquery is placed More... | |
| Protected Attributes inherited from Item_result_field | |
| Field * | result_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_HAS_GROUPING_SET_DEP = 0x10 |
| Set if the item or one or more of the underlying items contains a GROUP BY modifier (such as ROLLUP). 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... | |
Class that represents a quantified comparison predicate.
expression comp-op ANY ( subquery ) expression comp-op ALL ( subquery )
Note that the special cases = ANY (aka IN) and <> ALL (aka NOT IN) are handled by the base class Item_in_subselect.
| Item_allany_subselect::Item_allany_subselect | ( | Item * | left_expr, |
| chooser_compare_func_creator | fc, | ||
| Query_block * | select, | ||
| bool | all | ||
| ) |
|
overridevirtual |
This method is used for to:
For more information about view definition query, INFORMATION_SCHEMA query and why they should be generated from the Item-tree,
Reimplemented from Item_in_subselect.
|
inlineoverridevirtual |
Reimplemented from Item_in_subselect.
Reimplemented from Item_in_subselect.
| bool Item_allany_subselect::m_all |
| Comp_creator* Item_allany_subselect::m_func |
| chooser_compare_func_creator Item_allany_subselect::m_func_creator |
1.9.2