1#ifndef ITEM_CMPFUNC_INCLUDED
2#define ITEM_CMPFUNC_INCLUDED
238 if ((*left)->is_temporal()) (*left)->cmp_context =
INT_RESULT;
239 if ((*right)->is_temporal()) (*right)->cmp_context =
INT_RESULT;
261 bool *is_null)
const;
282 const Item *warn_item,
bool *is_null){
nullptr};
287 const Item *warn_item,
bool *is_null){
nullptr};
382 const char *
func_name()
const override {
return "true"; }
397 const char *
func_name()
const override {
return "false"; }
401 str->append(
"false");
518 const char *
func_name()
const override {
return "<in_optimizer>"; }
530 virtual const char *
symbol(
bool invert)
const = 0;
539 bool eqne_op()
const override {
return true; }
540 bool l_op()
const override {
return false; }
556 const char *
symbol(
bool invert)
const override {
return invert ?
"<>" :
"="; }
565 const char *
symbol(
bool invert [[maybe_unused]])
const override {
578 const char *
symbol(
bool invert)
const override {
return invert ?
"=" :
"<>"; }
588 const char *
symbol(
bool invert)
const override {
return invert ?
"<=" :
">"; }
589 bool eqne_op()
const override {
return false; }
590 bool l_op()
const override {
return false; }
596 const char *
symbol(
bool invert)
const override {
return invert ?
">=" :
"<"; }
597 bool eqne_op()
const override {
return false; }
598 bool l_op()
const override {
return true; }
604 const char *
symbol(
bool invert)
const override {
return invert ?
"<" :
">="; }
605 bool eqne_op()
const override {
return false; }
606 bool l_op()
const override {
return false; }
612 const char *
symbol(
bool invert)
const override {
return invert ?
">" :
"<="; }
613 bool eqne_op()
const override {
return false; }
614 bool l_op()
const override {
return true; }
727 const char *
func_name()
const override {
return "xor"; }
736 double rows_in_table)
override;
746 const char *
func_name()
const override {
return "not"; }
754 double rows_in_table)
override;
775 const char *
func_name()
const override {
return "match"; }
784 double rows_in_table)
override {
786 fields_to_ignore, rows_in_table);
880 const char *
func_name()
const override {
return "<if>"; }
892 assert(
m_join !=
nullptr);
941 const char *
func_name()
const override {
return "<not>"; }
978 const char *
func_name()
const override {
return "<nop>"; }
1016 bool is_multi_column_key,
1017 String *join_key_buffer) const;
1072 double rows_in_table)
override;
1142 double rows_in_table)
override;
1153 double rows_in_table)
override;
1210 const char *
func_name()
const override {
return "reject_if"; }
1218 double rows_in_table)
override;
1252 static constexpr double kMinSelectivityForUnknownValue = 0.2;
1266 double rows_in_table)
override;
1284 :
Item_int_func(pos, a, b, c), negated(false), pred_level(false) {
1285 if (is_negation) negate();
1289 if (is_negation) negate();
1310 bool eq(
const Item *item,
bool binary_cmp)
const override;
1315 obj->
add_alias(
"negated", create_dom_ptr<Json_boolean>(negated));
1334 compare_as_dates_with_strings(false),
1335 compare_as_temporal_dates(false),
1336 compare_as_temporal_times(false) {}
1340 const char *
func_name()
const override {
return "between"; }
1357 double rows_in_table)
override;
1362 if (pred_level && !negated)
return;
1410 :
super(pos, alloc_row(pos,
mem_root, expr1, expr2, opt_expr_list)),
1419 const char *
func_name()
const override {
return "interval"; }
1454 double real_op()
override;
1469 const char *
func_name()
const override {
return "coalesce"; }
1480 double real_op()
override;
1500 const char *
func_name()
const override {
return "any_value"; }
1507 bool m_phase_post{
false};
1597 uint m_used_size{0};
1652 bool fill(
Item **items, uint item_count);
1678 bool find_item(
Item *item)
override;
1679 bool compare_elems(uint pos1, uint pos2)
const override;
1683 void set(uint pos,
Item *item)
override;
1684 void sort_array()
override;
1708 down_cast<Item_int *>(item)->value = base[pos].val;
1711 bool find_item(
Item *item)
override;
1712 bool compare_elems(uint pos1, uint pos2)
const override;
1715 void set(uint pos,
Item *item)
override { val_item(item, &base[pos]); }
1716 void sort_array()
override;
1717 virtual void val_item(
Item *item, packed_longlong *
result);
1729 void val_item(
Item *item, packed_longlong *
result)
override;
1741 void val_item(
Item *item, packed_longlong *
result)
override;
1760 void set(uint pos,
Item *item)
override;
1761 void val_item(
Item *item, packed_longlong *
result)
override;
1774 down_cast<Item_float *>(item)->value = base[pos];
1776 bool find_item(
Item *item)
override;
1777 bool compare_elems(uint pos1, uint pos2)
const override;
1780 void set(uint pos,
Item *item)
override;
1781 void sort_array()
override;
1794 down_cast<Item_decimal *>(item)->set_decimal_value(&base[pos]);
1796 bool find_item(
Item *item)
override;
1797 bool compare_elems(uint pos1, uint pos2)
const override;
1800 void set(uint pos,
Item *item)
override;
1801 void sort_array()
override;
1868 const cmp_item_string *l_cmp = down_cast<const cmp_item_string *>(ci);
1874 if (res && (res != &value || !res->
is_alloced())) {
1907 void store_value(
Item *item)
override;
1921 const bool rc = value != arg->
val_int();
1925 const cmp_item_int *l_cmp = down_cast<const cmp_item_int *>(ci);
1926 return (value < l_cmp->value) ? -1 : ((value == l_cmp->
value) ? 0 : 1);
1946 void store_value(
Item *item)
override;
1961 const bool rc = value != arg->
val_real();
1965 const cmp_item_real *l_cmp = down_cast<const cmp_item_real *>(ci);
1966 return (value < l_cmp->value) ? -1 : ((value == l_cmp->
value) ? 0 : 1);
1975 void store_value(
Item *item)
override;
2013 create_dom_ptr<Json_boolean>(get_first_expr_num() != -1));
2018 Item *first_expr_arg,
Item *else_expr_arg)
2026 ncases =
list->size();
2027 if (first_expr_arg) {
2028 first_expr_num =
list->size();
2029 list->push_back(first_expr_arg);
2031 if (else_expr_arg) {
2032 else_expr_num =
list->size();
2033 list->push_back(else_expr_arg);
2036 memset(&cmp_items, 0,
sizeof(cmp_items));
2087 bool have_null{
false};
2089 bool m_populated{
false};
2093 bool m_values_are_const{
true};
2095 bool m_need_populate{
false};
2101 bool dep_subq_in_list{
false};
2103 bool first_resolve_call{
true};
2112 memset(&cmp_items, 0,
sizeof(cmp_items));
2132 bool populate_bisection(
THD *thd);
2148 double rows_in_table)
override;
2152 if (pred_level && negated)
return;
2158 for (
Item **arg =
args + 1; arg != arg_end; arg++)
2169 bool list_contains_null();
2191 float get_single_col_filtering_effect(
Item_ident *fieldref,
2194 double rows_in_table);
2195 void cleanup_arrays();
2209 allocate_template_comparators(thd, item);
2214 : comparators(other.comparators),
n(other.
n) {
2215 other.comparators =
nullptr;
2220 Item *arg)
override;
2221 void store_value(
Item *item)
override;
2225 void store_value_by_template(
cmp_item *tmpl,
Item *)
override;
2237 bool allocate_template_comparators(
THD *thd,
Item *item);
2259 bool find_item(
Item *item)
override;
2260 bool compare_elems(uint pos1, uint pos2)
const override;
2271 void set(uint pos,
Item *item)
override;
2272 void sort_array()
override;
2280 bool cache_used =
false;
2298 double rows_in_table)
override;
2324 const char *
func_name()
const override {
return "<is_not_null_test>"; }
2354 const char *
func_name()
const override {
return "isnotnull"; }
2368 double rows_in_table)
override;
2373 bool escape_is_const =
false;
2375 bool escape_evaluated =
false;
2376 bool eval_escape_clause(
THD *thd);
2384 assert(escape_arg !=
nullptr);
2388 assert(escape_arg !=
nullptr);
2415 assert(escape_is_evaluated());
2430 double rows_in_table)
override;
2442 bool check_covering_prefix_keys(
THD *thd);
2470 return list.push_back(item);
2474 return list.push_front(item);
2478 list.prepend(nlist);
2489 bool eq(
const Item *item,
bool binary_cmp)
const override;
2501 bool truth_transform_arguments(
THD *thd,
Bool_test test);
2505 bool remove_const_conds(
THD *thd,
Item *item,
Item **new_item);
2595 bool cond_false{
false};
2597 bool compare_as_dates{
false};
2608 bool compare_const(
THD *thd,
Item *c);
2622 bool update_const(
THD *thd);
2625 const char *
func_name()
const override {
return "multiple equal"; }
2635 return const_arg() ==
nullptr;
2653 template <
typename Node_cmp_func>
2665 return m_fields->cbegin();
2669 return m_fields->cbegin();
2672 return m_fields->cend();
2681 : m_fields(&item->fields) {}
2683 return m_fields->cbegin();
2687 return m_fields->cbegin();
2690 return m_fields->cend();
2692 size_t size()
const {
return m_fields->size(); }
2706 bool eq(
const Item *item,
bool binary_cmp)
const override;
2708 return fields.
head()->collation.collation;
2718 double rows_in_table)
override;
2762 double rows_in_table)
override;
2791 double rows_in_table)
override;
2800 if (item ==
nullptr)
return nullptr;
2839 down_cast<const Item_cond *>(item)->functype() ==
2849template <
class Func>
2851 if (condition ==
nullptr) {
2853 }
else if (
IsAnd(condition)) {
2854 for (
Item &item : *down_cast<Item_cond_and *>(condition)->argument_list()) {
2861 return func(condition);
Kerberos Client Authentication nullptr
Definition: auth_kerberos_client_plugin.cc:250
Definition: item_cmpfunc.h:139
bool inject_cast_nodes()
Comparison function are expected to operate on arguments having the same data types.
Definition: item_cmpfunc.cc:1440
int compare_time_packed()
Compare arguments using numeric packed temporal representation.
Definition: item_cmpfunc.cc:1978
void cleanup()
Definition: item_cmpfunc.cc:865
uint get_child_comparator_count() const
Definition: item_cmpfunc.h:244
int compare_int_signed_unsigned()
Compare signed (*left) with unsigned (*B)
Definition: item_cmpfunc.cc:2041
String value1
Definition: item_cmpfunc.h:167
void set_datetime_cmp_func(Item_result_field *owner_arg, Item **a1, Item **b1)
Definition: item_cmpfunc.cc:1598
Item * left_cache
Definition: item_cmpfunc.h:148
longlong(* get_value_a_func)(THD *thd, Item ***item_arg, Item **cache_arg, const Item *warn_item, bool *is_null)
A function pointer that is used for retrieving the value from argument "left".
Definition: item_cmpfunc.h:281
int compare_int_unsigned_signed()
Compare unsigned (*left) with signed (*B)
Definition: item_cmpfunc.cc:2062
Arg_comparator * comparators
Definition: item_cmpfunc.h:144
Item_result m_compare_type
Definition: item_cmpfunc.h:291
Arg_comparator * get_child_comparators() const
Definition: item_cmpfunc.h:246
static bool can_compare_as_dates(const Item *a, const Item *b)
Checks whether compare_datetime() can be used to compare items.
Definition: item_cmpfunc.cc:1181
double precision
Definition: item_cmpfunc.h:146
int compare_datetime()
Compare item values as dates.
Definition: item_cmpfunc.cc:1722
uint16 comparator_count
Definition: item_cmpfunc.h:145
Item ** right
Definition: item_cmpfunc.h:141
arg_cmp_func func
Definition: item_cmpfunc.h:142
String value2
Definition: item_cmpfunc.h:167
Item ** left
Definition: item_cmpfunc.h:140
Item ** get_left_ptr() const
Definition: item_cmpfunc.h:263
Json_scalar_holder * json_scalar
Only used by compare_json() in the case where a JSON value is compared to an SQL value.
Definition: item_cmpfunc.h:162
void set_cmp_context_for_datetime()
Definition: item_cmpfunc.h:236
bool set_cmp_func(Item_result_field *owner_arg, Item **left, Item **right, Item_result type)
Sets compare functions for various datatypes.
Definition: item_cmpfunc.cc:1251
static arg_cmp_func comparator_matrix[5]
Definition: item_cmpfunc.h:231
bool use_custom_value_extractors() const
Definition: item_cmpfunc.h:252
int compare()
Definition: item_cmpfunc.h:210
Item_result get_compare_type() const
Definition: item_cmpfunc.h:242
int compare_int_signed()
Definition: item_cmpfunc.cc:1952
int compare_binary_string()
Compare strings byte by byte.
Definition: item_cmpfunc.cc:1881
bool compare_as_json() const
Definition: item_cmpfunc.h:248
Item * get_right() const
Definition: item_cmpfunc.h:264
int compare_json()
Compare two Item objects as JSON.
Definition: item_cmpfunc.cc:1814
int compare_real()
Definition: item_cmpfunc.cc:1899
bool set_null
Definition: item_cmpfunc.h:150
static bool get_date_from_const(Item *date_arg, Item *str_arg, ulonglong *const_value)
Check if str_arg is a constant and convert it to datetime packed value.
Definition: item_cmpfunc.cc:1106
bool try_year_cmp_func(Item_result type)
Definition: item_cmpfunc.cc:1541
Item * right_cache
Definition: item_cmpfunc.h:149
Item_result_field * owner
Definition: item_cmpfunc.h:143
longlong(* get_value_b_func)(THD *thd, Item ***item_arg, Item **cache_arg, const Item *warn_item, bool *is_null)
Definition: item_cmpfunc.h:286
int compare_real_fixed()
Definition: item_cmpfunc.cc:1934
longlong extract_value_from_argument(THD *thd, Item *item, bool left_argument, bool *is_null) const
Definition: item_cmpfunc.cc:8055
int compare_string()
Definition: item_cmpfunc.cc:1849
int compare_decimal()
Definition: item_cmpfunc.cc:1917
int compare_row()
Definition: item_cmpfunc.cc:2080
bool compare_null_values()
Compare NULL values for two arguments.
Definition: item_cmpfunc.cc:2172
bool set_compare_func(Item_result_field *owner, Item_result type)
Definition: item_cmpfunc.cc:883
DTCollation cmp_collation
Definition: item_cmpfunc.h:165
Arg_comparator(Item **left, Item **right)
Definition: item_cmpfunc.h:171
int compare_int_unsigned()
Compare values as BIGINT UNSIGNED.
Definition: item_cmpfunc.cc:2014
Definition: item_cmpfunc.h:2725
uint max_members
Definition: item_cmpfunc.h:2727
COND_EQUAL * upper_levels
Definition: item_cmpfunc.h:2729
List< Item_equal > current_level
Definition: item_cmpfunc.h:2730
COND_EQUAL()
Definition: item_cmpfunc.h:2732
Abstract factory interface for creating comparison predicates.
Definition: item_cmpfunc.h:524
virtual ~Comp_creator()=default
virtual bool l_op() const =0
virtual bool eqne_op() const =0
virtual Item_bool_func * create(Item *a, Item *b) const =0
virtual const char * symbol(bool invert) const =0
This interface is only used by Item_allany_subselect.
const CHARSET_INFO * collation
Definition: item.h:179
Definition: item_cmpfunc.h:554
Item_bool_func * create_scalar_predicate(Item *a, Item *b) const override
Creates only an item tree node, without attempting to rewrite row constructors.
Definition: item_cmpfunc.cc:396
const char * symbol(bool invert) const override
This interface is only used by Item_allany_subselect.
Definition: item_cmpfunc.h:556
Item_bool_func * combine(List< Item > list) const override
Combines a list of conditions exp op exp.
Definition: item_cmpfunc.cc:401
Definition: item_cmpfunc.h:563
const char * symbol(bool invert) const override
This interface is only used by Item_allany_subselect.
Definition: item_cmpfunc.h:565
Item_bool_func * create_scalar_predicate(Item *a, Item *b) const override
Creates only an item tree node, without attempting to rewrite row constructors.
Definition: item_cmpfunc.cc:405
Item_bool_func * combine(List< Item > list) const override
Combines a list of conditions exp op exp.
Definition: item_cmpfunc.cc:410
Definition: item_cmpfunc.h:601
Item_bool_func * create(Item *a, Item *b) const override
Definition: item_cmpfunc.cc:431
bool l_op() const override
Definition: item_cmpfunc.h:606
bool eqne_op() const override
Definition: item_cmpfunc.h:605
const char * symbol(bool invert) const override
This interface is only used by Item_allany_subselect.
Definition: item_cmpfunc.h:604
Definition: item_cmpfunc.h:585
bool l_op() const override
Definition: item_cmpfunc.h:590
Item_bool_func * create(Item *a, Item *b) const override
Definition: item_cmpfunc.cc:423
bool eqne_op() const override
Definition: item_cmpfunc.h:589
const char * symbol(bool invert) const override
This interface is only used by Item_allany_subselect.
Definition: item_cmpfunc.h:588
A class that represents a join condition in a hash join.
Definition: item_cmpfunc.h:86
const size_t m_max_character_length
Definition: item_cmpfunc.h:125
const table_map m_right_used_tables
Definition: item_cmpfunc.h:119
Item_eq_base * m_join_condition
Definition: item_cmpfunc.h:111
Item * right_extractor() const
Definition: item_cmpfunc.h:93
HashJoinCondition(Item_eq_base *join_condition, MEM_ROOT *mem_root)
Definition: item_cmpfunc.cc:8020
const table_map m_left_used_tables
Definition: item_cmpfunc.h:118
bool store_full_sort_key() const
Definition: item_cmpfunc.h:104
bool left_uses_any_table(table_map tables) const
Definition: item_cmpfunc.h:94
bool m_store_full_sort_key
Definition: item_cmpfunc.h:133
Item * left_extractor() const
Definition: item_cmpfunc.h:92
Item_eq_base * join_condition() const
Definition: item_cmpfunc.h:90
bool m_null_equals_null
Definition: item_cmpfunc.h:136
Item * m_right_extractor
Definition: item_cmpfunc.h:113
bool right_uses_any_table(table_map tables) const
Definition: item_cmpfunc.h:98
Item * m_left_extractor
Definition: item_cmpfunc.h:112
size_t max_character_length() const
Definition: item_cmpfunc.h:102
bool null_equals_null() const
Returns true if this join condition evaluates to TRUE if both operands are NULL.
Definition: item_cmpfunc.h:108
void set_str_value(String *str)
Definition: item.h:3812
Base class for functions that usually take two arguments, which are possibly strings,...
Definition: item_cmpfunc.h:623
bool allow_replacement(Item_field *const original, Item_field *const subst) override
Check whether a function allows replacement of a field with another: In particular,...
Definition: item_cmpfunc.h:679
bool have_rev_func() const override
Definition: item_cmpfunc.h:657
optimize_type select_optimize(const THD *) override
Definition: item_cmpfunc.h:653
bool abort_on_null
Definition: item_cmpfunc.h:630
void apply_is_true() override
Apply the IS TRUE truth property, meaning that an UNKNOWN result and a FALSE result are treated the s...
Definition: item_cmpfunc.h:669
bool convert_constant_arg(THD *thd, Item *field, Item **item, bool *converted)
Definition: item_cmpfunc.cc:723
Item_result compare_type() const
Definition: item_cmpfunc.h:668
Arg_comparator cmp
Definition: item_cmpfunc.h:629
Item_bool_func2(const POS &pos, Item *a, Item *b, Item *c)
Definition: item_cmpfunc.h:641
bool resolve_type(THD *) override
Resolve type-related information for this item, such as result field type, maximum size,...
Definition: item_cmpfunc.cc:741
Item_bool_func2(Item *a, Item *b, Item *c)
Definition: item_cmpfunc.h:635
Item_bool_func2(Item *a, Item *b)
Definition: item_cmpfunc.h:632
virtual bool set_cmp_func()
Sets up a comparator of the correct type based on the type of the function's arguments.
Definition: item_cmpfunc.h:650
const CHARSET_INFO * compare_collation() const override
Definition: item_cmpfunc.h:665
bool is_null() override
The method allows to determine nullness of a complex expression without fully evaluating it,...
Definition: item_cmpfunc.h:664
Item_bool_func2(const POS &pos, Item *a, Item *b)
Definition: item_cmpfunc.h:638
virtual enum Functype rev_functype() const
Definition: item_cmpfunc.h:656
bool ignore_unknown() const
Treat UNKNOWN result like FALSE because callers see no difference.
Definition: item_cmpfunc.h:671
const Arg_comparator * get_comparator() const
Definition: item_cmpfunc.h:676
void print(const THD *thd, String *str, enum_query_type query_type) const override
This method is used for to:
Definition: item_cmpfunc.h:659
Item * replace_scalar_subquery(uchar *) override
When walking the item tree seeing an Item_singlerow_subselect matching a target, replace it with a su...
Definition: item_cmpfunc.cc:858
void cleanup() override
Called for every Item after use (preparation and execution).
Definition: item_cmpfunc.h:672
Definition: item_cmpfunc.h:294
Item_bool_func(Item *a)
Definition: item_cmpfunc.h:301
Item_bool_func(Item *a, Item *b, Item *c)
Definition: item_cmpfunc.h:306
Item_bool_func(const POS &pos, Item *a, Item *b)
Definition: item_cmpfunc.h:312
bool m_created_by_in2exists
True <=> this item was added by IN->EXISTS subquery transformation, and should thus be deleted if we ...
Definition: item_cmpfunc.h:348
void set_created_by_in2exists()
Definition: item_cmpfunc.cc:2178
bool created_by_in2exists() const override
Whether this Item was created by the IN->EXISTS subquery transformation.
Definition: item_cmpfunc.h:333
Item_bool_func(const POS &pos)
Definition: item_cmpfunc.h:297
Item_bool_func(THD *thd, Item_bool_func *item)
Definition: item_cmpfunc.h:320
Item_bool_func(Item *a, Item *b)
Definition: item_cmpfunc.h:309
Item_bool_func(const POS &pos, Item *a, Item *b, Item *c)
Definition: item_cmpfunc.h:315
uint decimal_precision() const override
Definition: item_cmpfunc.h:332
bool resolve_type(THD *thd) override
Resolve type-related information for this item, such as result field type, maximum size,...
Definition: item_cmpfunc.h:328
Item_bool_func(const POS &pos, Item *a)
Definition: item_cmpfunc.h:302
bool is_bool_func() const override
Definition: item_cmpfunc.h:327
Item_bool_func()
Definition: item_cmpfunc.h:296
static const Bool_test bool_transform[10][8]
Array that transforms a boolean test according to another.
Definition: item_cmpfunc.h:341
static const char * bool_transform_names[10]
Definition: item_cmpfunc.h:336
Definition: item_cmpfunc.h:2735
Item * copy_andor_structure(THD *thd) override
Definition: item_cmpfunc.h:2750
Item_cond_and(List< Item > &list_arg)
Definition: item_cmpfunc.h:2746
COND_EQUAL cond_equal
Definition: item_cmpfunc.h:2737
const char * func_name() const override
Definition: item_cmpfunc.h:2749
enum Functype functype() const override
Definition: item_cmpfunc.h:2747
Item_cond_and()
Definition: item_cmpfunc.h:2740
Item_cond_and(const POS &pos, Item *i1, Item *i2)
Definition: item_cmpfunc.h:2743
Item_cond_and(Item *i1, Item *i2)
Definition: item_cmpfunc.h:2742
bool gc_subst_analyzer(uchar **) override
Analyzer function for GC substitution.
Definition: item_cmpfunc.h:2757
Item_cond_and(THD *thd, Item_cond_and *item)
Definition: item_cmpfunc.h:2745
Definition: item_cmpfunc.h:2767
bool gc_subst_analyzer(uchar **) override
Analyzer function for GC substitution.
Definition: item_cmpfunc.h:2786
enum Functype functype() const override
Definition: item_cmpfunc.h:2776
Item_cond_or(Item *i1, Item *i2)
Definition: item_cmpfunc.h:2771
Item * copy_andor_structure(THD *thd) override
Definition: item_cmpfunc.h:2779
Item_cond_or(List< Item > &list_arg)
Definition: item_cmpfunc.h:2775
Item_cond_or(const POS &pos, Item *i1, Item *i2)
Definition: item_cmpfunc.h:2772
Item_cond_or()
Definition: item_cmpfunc.h:2769
const char * func_name() const override
Definition: item_cmpfunc.h:2778
Item_cond_or(THD *thd, Item_cond_or *item)
Definition: item_cmpfunc.h:2774
Definition: item_cmpfunc.h:2445
void add_at_head(List< Item > *nlist)
Definition: item_cmpfunc.h:2476
bool add_at_head(Item *item)
Definition: item_cmpfunc.h:2472
void apply_is_true() override
Apply the IS TRUE truth property, meaning that an UNKNOWN result and a FALSE result are treated the s...
Definition: item_cmpfunc.h:2496
Item_cond(Item *i1, Item *i2)
Definition: item_cmpfunc.h:2455
Item_bool_func super
Definition: item_cmpfunc.h:2446
bool ignore_unknown() const
Treat UNKNOWN result like FALSE because callers see no difference.
Definition: item_cmpfunc.h:2507
void copy_andor_arguments(THD *thd, Item_cond *item)
Definition: item_cmpfunc.cc:5658
table_map used_tables() const override
Definition: item_cmpfunc.h:2490
Item_cond(const POS &pos, Item *i1, Item *i2)
Definition: item_cmpfunc.h:2459
Item_cond(List< Item > &nlist)
Definition: item_cmpfunc.h:2466
bool subst_argument_checker(uchar **) override
Definition: item_cmpfunc.h:2502
List< Item > * argument_list()
Definition: item_cmpfunc.h:2488
Type type() const override
Definition: item_cmpfunc.h:2487
Item_cond()
Definition: item_cmpfunc.h:2454
List< Item > list
Definition: item_cmpfunc.h:2449
bool equality_substitution_analyzer(uchar **) override
Definition: item_cmpfunc.h:2508
bool add(Item *item)
Definition: item_cmpfunc.h:2468
bool abort_on_null
Definition: item_cmpfunc.h:2450
Base class for the equality comparison operators = and <=>.
Definition: item_cmpfunc.h:990
Item_eq_base(Item *a, Item *b)
Definition: item_cmpfunc.h:992
Item_equal * source_multiple_equality
If this equality originally came from a multi-equality, this documents which one it came from (otherw...
Definition: item_cmpfunc.h:1049
bool contains_only_equi_join_condition() const final
Whether this Item is an equi-join condition.
Definition: item_cmpfunc.cc:7606
Item_eq_base(const POS &pos, Item *a, Item *b)
Definition: item_cmpfunc.h:993
Item * create_cast_if_needed(MEM_ROOT *mem_root, Item *argument) const
Wrap the argument in a typecast, if needed.
Definition: item_cmpfunc.cc:7992
bool append_join_key_for_hash_join(THD *thd, table_map tables, const HashJoinCondition &join_condition, bool is_multi_column_key, String *join_key_buffer) const
Read the value from the join condition, and append it to the output vector "join_key_buffer".
Definition: item_cmpfunc.cc:7966
Definition: item_cmpfunc.h:2678
ConstFieldProxy(const Item_equal *item)
Definition: item_cmpfunc.h:2680
List_STL_Iterator< const Item_field > cbegin() const
Definition: item_cmpfunc.h:2686
List_STL_Iterator< const Item_field > cend() const
Definition: item_cmpfunc.h:2689
List_STL_Iterator< const Item_field > begin() const
Definition: item_cmpfunc.h:2682
size_t size() const
Definition: item_cmpfunc.h:2692
const List< Item_field > * m_fields
Definition: item_cmpfunc.h:2695
List_STL_Iterator< const Item_field > end() const
Definition: item_cmpfunc.h:2685
Definition: item_cmpfunc.h:2659
List_STL_Iterator< Item_field > begin()
Definition: item_cmpfunc.h:2662
List_STL_Iterator< Item_field > end()
Definition: item_cmpfunc.h:2663
List< Item_field > * m_fields
Definition: item_cmpfunc.h:2676
List_STL_Iterator< const Item_field > begin() const
Definition: item_cmpfunc.h:2664
List_STL_Iterator< const Item_field > cbegin() const
Definition: item_cmpfunc.h:2668
List_STL_Iterator< const Item_field > cend() const
Definition: item_cmpfunc.h:2671
List_STL_Iterator< const Item_field > end() const
Definition: item_cmpfunc.h:2667
FieldProxy(Item_equal *item)
Definition: item_cmpfunc.h:2661
Definition: item_cmpfunc.h:2585
ConstFieldProxy get_fields() const
Definition: item_cmpfunc.h:2698
bool contains_only_equi_join_condition() const override
Whether this Item is an equi-join condition.
Definition: item_cmpfunc.h:2634
void set_const_arg(Item *c)
Definition: item_cmpfunc.h:2607
void check_covering_prefix_keys()
bool cast_incompatible_args(uchar *) override
Wrap incompatible arguments in CAST nodes to the expected data types.
Definition: item_cmpfunc.h:2627
Item * const_arg() const
Definition: item_cmpfunc.h:2606
const CHARSET_INFO * compare_collation() const override
Definition: item_cmpfunc.h:2707
void sort(Node_cmp_func compare)
Order field items in multiple equality according to a sorting criteria.
Definition: item_cmpfunc.h:2654
Arg_comparator cmp
Helper for comparing constants.
Definition: item_cmpfunc.h:2593
Item_field * get_first()
Get the first field of multiple equality, use for semantic checking.
Definition: item_cmpfunc.h:2619
const char * func_name() const override
Definition: item_cmpfunc.h:2625
optimize_type select_optimize(const THD *) override
Definition: item_cmpfunc.h:2626
List< Item_field > fields
List of equal field items.
Definition: item_cmpfunc.h:2587
FieldProxy get_fields()
Definition: item_cmpfunc.h:2697
enum Functype functype() const override
Definition: item_cmpfunc.h:2623
bool equality_substitution_analyzer(uchar **) override
Definition: item_cmpfunc.h:2711
ANY_VALUE(expr) is like expr except that it is not checked by aggregate_check logic.
Definition: item_cmpfunc.h:1496
const char * func_name() const override
Definition: item_cmpfunc.h:1500
Item_func_any_value(const POS &pos, Item *a)
Definition: item_cmpfunc.h:1498
Item_func_any_value(Item *a)
Definition: item_cmpfunc.h:1499
Definition: item_cmpfunc.h:1319
Arg_comparator ge_cmp
Definition: item_cmpfunc.h:1331
optimize_type select_optimize(const THD *) override
Definition: item_cmpfunc.h:1338
bool compare_as_dates_with_strings
Definition: item_cmpfunc.h:1326
bool is_bool_func() const override
Definition: item_cmpfunc.h:1347
Item_func_between(const POS &pos, Item *a, Item *b, Item *c, bool is_negation)
Definition: item_cmpfunc.h:1332
Item_result cmp_type
Definition: item_cmpfunc.h:1323
bool compare_as_temporal_dates
Definition: item_cmpfunc.h:1327
const CHARSET_INFO * compare_collation() const override
Definition: item_cmpfunc.h:1348
String value0
Definition: item_cmpfunc.h:1324
const char * func_name() const override
Definition: item_cmpfunc.h:1340
void update_not_null_tables()
Definition: item_cmpfunc.h:1360
uint decimal_precision() const override
Definition: item_cmpfunc.h:1351
DTCollation cmp_collation
Definition: item_cmpfunc.h:1320
bool gc_subst_analyzer(uchar **) override
Analyzer function for GC substitution.
Definition: item_cmpfunc.h:1352
bool compare_as_temporal_times
Definition: item_cmpfunc.h:1328
enum Functype functype() const override
Definition: item_cmpfunc.h:1339
A predicate that is "always true" or "always false".
Definition: item_cmpfunc.h:357
Item_func_bool_const(const POS &pos)
Definition: item_cmpfunc.h:365
Item_func_bool_const()
Definition: item_cmpfunc.h:359
bool fix_fields(THD *, Item **) override
Definition: item_cmpfunc.h:371
void cleanup() override
Called for every Item after use (preparation and execution).
Definition: item_cmpfunc.h:373
bool basic_const_item() const override
Returns true if this is a simple constant item like an integer, not a constant expression.
Definition: item_cmpfunc.h:372
CASE ... WHEN ... THEN ... END function implementation.
Definition: item_cmpfunc.h:1998
Item_result cmp_type
Definition: item_cmpfunc.h:2005
enum_field_types default_data_type() const override
Get the default data (output) type for the specific item.
Definition: item_cmpfunc.h:2049
const CHARSET_INFO * compare_collation() const override
Definition: item_cmpfunc.h:2060
cmp_item * case_item
Definition: item_cmpfunc.h:2008
int else_expr_num
Definition: item_cmpfunc.h:2001
DTCollation cmp_collation
Definition: item_cmpfunc.h:2006
Item_func super
Definition: item_cmpfunc.h:1999
Item_func_case(const POS &pos, mem_root_deque< Item * > *list, Item *first_expr_arg, Item *else_expr_arg)
Definition: item_cmpfunc.h:2017
int get_first_expr_num() const
Definition: item_cmpfunc.h:2039
const char * func_name() const override
Definition: item_cmpfunc.h:2056
enum Item_result result_type() const override
Definition: item_cmpfunc.h:2055
enum Item_result cached_result_type left_result_type
Definition: item_cmpfunc.h:2002
uint ncases
Definition: item_cmpfunc.h:2004
void add_json_info(Json_object *obj) override
Add all the node-specific json fields.
Definition: item_cmpfunc.h:2011
String tmp_value
Definition: item_cmpfunc.h:2003
enum Functype functype() const override
Definition: item_cmpfunc.h:2063
int get_else_expr_num() const
Definition: item_cmpfunc.h:2040
Definition: item_cmpfunc.h:1431
Item_func_coalesce(const POS &pos, Item *a)
Definition: item_cmpfunc.h:1437
Item_func_coalesce(const POS &pos, Item *a, Item *b)
Definition: item_cmpfunc.h:1433
enum Item_result result_type() const override
Definition: item_cmpfunc.h:1468
Item_func_coalesce(Item *a, Item *b)
Definition: item_cmpfunc.h:1450
const char * func_name() const override
Definition: item_cmpfunc.h:1469
enum_field_types default_data_type() const override
Get the default data (output) type for the specific item.
Definition: item_cmpfunc.h:1447
Item_func_coalesce(Item *a)
Definition: item_cmpfunc.h:1440
Item_func_coalesce(const POS &pos, PT_item_list *list)
Definition: item_cmpfunc.h:1443
enum Functype functype() const override
Definition: item_cmpfunc.h:1470
void set_numeric_type() override
Definition: item_cmpfunc.h:1467
Item_func_comparison is a class for comparison functions that take two arguments and return a boolean...
Definition: item_cmpfunc.h:695
bool subst_argument_checker(uchar **) override
Definition: item_cmpfunc.h:707
Item_func_comparison(Item *a, Item *b)
Definition: item_cmpfunc.h:697
Item_func_comparison(const POS &pos, Item *a, Item *b)
Definition: item_cmpfunc.h:700
bool is_null() override
The method allows to determine nullness of a complex expression without fully evaluating it,...
Definition: item_cmpfunc.cc:6866
Item * truth_transformer(THD *, Bool_test) override
Informs an item that it is wrapped in a truth test, in case it wants to transforms itself to implemen...
Definition: item_cmpfunc.cc:6741
virtual Item * negated_item()
just fake method, should never be called.
Definition: item_cmpfunc.cc:6861
bool cast_incompatible_args(uchar *) override
Wrap incompatible arguments in CAST nodes to the expected data types.
Definition: item_cmpfunc.cc:6881
Implements the comparison operator equals (=)
Definition: item_cmpfunc.h:1055
enum Functype functype() const override
Definition: item_cmpfunc.h:1060
bool gc_subst_analyzer(uchar **) override
Analyzer function for GC substitution.
Definition: item_cmpfunc.h:1067
cond_result eq_cmp_result() const override
Definition: item_cmpfunc.h:1062
Item_func_eq(Item *a, Item *b)
Definition: item_cmpfunc.h:1057
Item_func_eq(const POS &pos, Item *a, Item *b)
Definition: item_cmpfunc.h:1058
enum Functype rev_functype() const override
Definition: item_cmpfunc.h:1061
const char * func_name() const override
Definition: item_cmpfunc.h:1063
bool equality_substitution_analyzer(uchar **) override
Definition: item_cmpfunc.h:1065
The <=> operator evaluates the same as.
Definition: item_cmpfunc.h:1118
Item * truth_transformer(THD *, Bool_test) override
Informs an item that it is wrapped in a truth test, in case it wants to transforms itself to implemen...
Definition: item_cmpfunc.h:1136
bool set_cmp_func() override
Sets up a comparator of the correct type based on the type of the function's arguments.
Definition: item_cmpfunc.h:1127
cond_result eq_cmp_result() const override
Definition: item_cmpfunc.h:1134
enum Functype functype() const override
Definition: item_cmpfunc.h:1132
enum Functype rev_functype() const override
Definition: item_cmpfunc.h:1133
const char * func_name() const override
Definition: item_cmpfunc.h:1135
Item_func_equal(Item *a, Item *b)
Definition: item_cmpfunc.h:1120
bool is_null() override
The method allows to determine nullness of a complex expression without fully evaluating it,...
Definition: item_cmpfunc.h:1137
Item_func_equal(const POS &pos, Item *a, Item *b)
Definition: item_cmpfunc.h:1123
A predicate that is "always false".
Definition: item_cmpfunc.h:393
longlong val_int() override
Definition: item_cmpfunc.h:399
Item_func_false()
Definition: item_cmpfunc.h:395
const char * func_name() const override
Definition: item_cmpfunc.h:397
Item_func_false(const POS &pos)
Definition: item_cmpfunc.h:396
enum Functype functype() const override
Definition: item_cmpfunc.h:403
bool val_bool() override
Definition: item_cmpfunc.h:398
void print(const THD *, String *str, enum_query_type) const override
This method is used for to:
Definition: item_cmpfunc.h:400
Implements the comparison operator greater than or equals (>=)
Definition: item_cmpfunc.h:1161
enum Functype rev_functype() const override
Definition: item_cmpfunc.h:1166
cond_result eq_cmp_result() const override
Definition: item_cmpfunc.h:1167
Item_func_ge(Item *a, Item *b)
Definition: item_cmpfunc.h:1163
const char * func_name() const override
Definition: item_cmpfunc.h:1168
enum Functype functype() const override
Definition: item_cmpfunc.h:1165
Implements the comparison operator greater than (>)
Definition: item_cmpfunc.h:1175
Item_func_gt(Item *a, Item *b)
Definition: item_cmpfunc.h:1177
cond_result eq_cmp_result() const override
Definition: item_cmpfunc.h:1181
enum Functype rev_functype() const override
Definition: item_cmpfunc.h:1180
const char * func_name() const override
Definition: item_cmpfunc.h:1182
enum Functype functype() const override
Definition: item_cmpfunc.h:1179
Definition: item_cmpfunc.h:1510
Item_func_if(Item *a, Item *b, Item *c)
Definition: item_cmpfunc.h:1514
enum Functype functype() const override
Definition: item_cmpfunc.h:1541
enum Item_result result_type() const override
Definition: item_cmpfunc.h:1530
enum_field_types default_data_type() const override
Get the default data (output) type for the specific item.
Definition: item_cmpfunc.h:1532
const char * func_name() const override
Definition: item_cmpfunc.h:1540
void update_not_null_tables()
Definition: item_cmpfunc.h:1545
enum Item_result cached_result_type
Definition: item_cmpfunc.h:1511
Item_func_if(const POS &pos, Item *a, Item *b, Item *c)
Definition: item_cmpfunc.h:1518
Definition: item_cmpfunc.h:1473
bool field_type_defined
Definition: item_cmpfunc.h:1475
Item_func_ifnull(const POS &pos, Item *a, Item *b)
Definition: item_cmpfunc.h:1478
const char * func_name() const override
Definition: item_cmpfunc.h:1487
in_expr [NOT] IN (in_value_list).
Definition: item_cmpfunc.h:2077
DTCollation cmp_collation
Definition: item_cmpfunc.h:2107
Item_func_in(const POS &pos, PT_item_list *list, bool is_negation)
Definition: item_cmpfunc.h:2110
enum Functype functype() const override
Definition: item_cmpfunc.h:2137
const char * func_name() const override
Definition: item_cmpfunc.h:2138
Item_result left_result_type
Definition: item_cmpfunc.h:2105
bool is_bool_func() const override
Definition: item_cmpfunc.h:2139
uint decimal_precision() const override
Definition: item_cmpfunc.h:2122
const CHARSET_INFO * compare_collation() const override
Definition: item_cmpfunc.h:2140
void update_not_null_tables()
Definition: item_cmpfunc.h:2150
optimize_type select_optimize(const THD *) override
Definition: item_cmpfunc.h:2134
bool gc_subst_analyzer(uchar **) override
Analyzer function for GC substitution.
Definition: item_cmpfunc.h:2143
'<,>,=<,=>' operators.
Definition: item_cmpfunc.h:1146
bool gc_subst_analyzer(uchar **) override
Analyzer function for GC substitution.
Definition: item_cmpfunc.h:1155
Item_func_inequality(Item *a, Item *b)
Definition: item_cmpfunc.h:1148
Definition: item_cmpfunc.h:1400
Item_row * row
Definition: item_cmpfunc.h:1403
bool use_decimal_comparison
Definition: item_cmpfunc.h:1404
const char * func_name() const override
Definition: item_cmpfunc.h:1419
interval_range * intervals
Definition: item_cmpfunc.h:1405
uint decimal_precision() const override
Definition: item_cmpfunc.h:1420
Item_int_func super
Definition: item_cmpfunc.h:1401
Item_func_interval(const POS &pos, MEM_ROOT *mem_root, Item *expr1, Item *expr2, class PT_item_list *opt_expr_list=nullptr)
Definition: item_cmpfunc.h:1408
Definition: item_cmpfunc.h:2341
const CHARSET_INFO * compare_collation() const override
Definition: item_cmpfunc.h:2359
void apply_is_true() override
Apply the IS TRUE truth property, meaning that an UNKNOWN result and a FALSE result are treated the s...
Definition: item_cmpfunc.h:2362
const char * func_name() const override
Definition: item_cmpfunc.h:2354
optimize_type select_optimize(const THD *) override
Definition: item_cmpfunc.h:2355
Item_func_isnotnull(Item *a)
Definition: item_cmpfunc.h:2343
enum Functype functype() const override
Definition: item_cmpfunc.h:2349
Item_func_isnotnull(const POS &pos, Item *a)
Definition: item_cmpfunc.h:2344
bool resolve_type(THD *thd) override
Resolve type-related information for this item, such as result field type, maximum size,...
Definition: item_cmpfunc.h:2350
Definition: item_cmpfunc.h:2277
Item_func_isnull(Item *a)
Definition: item_cmpfunc.h:2284
Item_func_isnull(const POS &pos, Item *a)
Definition: item_cmpfunc.h:2285
const char * func_name() const override
Definition: item_cmpfunc.h:2291
Item_bool_func super
Definition: item_cmpfunc.h:2278
enum Functype functype() const override
Definition: item_cmpfunc.h:2289
bool cached_value
Definition: item_cmpfunc.h:2281
const CHARSET_INFO * compare_collation() const override
Definition: item_cmpfunc.h:2303
optimize_type select_optimize(const THD *) override
Definition: item_cmpfunc.h:2299
Implements the comparison operator less than or equals (<=)
Definition: item_cmpfunc.h:1189
cond_result eq_cmp_result() const override
Definition: item_cmpfunc.h:1195
enum Functype rev_functype() const override
Definition: item_cmpfunc.h:1194
Item_func_le(Item *a, Item *b)
Definition: item_cmpfunc.h:1191
const char * func_name() const override
Definition: item_cmpfunc.h:1196
enum Functype functype() const override
Definition: item_cmpfunc.h:1193
Definition: item_cmpfunc.h:2371
Item_func_like(const POS &pos, Item *a, Item *b)
Definition: item_cmpfunc.h:2390
int escape() const
Returns the escape character.
Definition: item_cmpfunc.h:2414
int m_escape
The escape character (0 if no escape character).
Definition: item_cmpfunc.h:2378
enum Functype functype() const override
Definition: item_cmpfunc.h:2394
bool escape_was_used_in_parsing() const
Definition: item_cmpfunc.h:2411
Item_func_like(Item *a, Item *b, Item *escape_arg)
Definition: item_cmpfunc.h:2382
Item_func_like(Item *a, Item *b)
Definition: item_cmpfunc.h:2381
cond_result eq_cmp_result() const override
Result may be not equal with equal inputs if ESCAPE character is present.
Definition: item_cmpfunc.h:2397
const char * func_name() const override
Definition: item_cmpfunc.h:2398
bool escape_is_evaluated() const
Has the escape clause been evaluated? It only needs to be evaluated once per execution,...
Definition: item_cmpfunc.h:2425
Item_func_like(const POS &pos, Item *a, Item *b, Item *escape_arg)
Definition: item_cmpfunc.h:2386
Implements the comparison operator less than (<)
Definition: item_cmpfunc.h:1235
Item_func_lt(Item *a, Item *b)
Definition: item_cmpfunc.h:1237
cond_result eq_cmp_result() const override
Definition: item_cmpfunc.h:1241
enum Functype functype() const override
Definition: item_cmpfunc.h:1239
enum Functype rev_functype() const override
Definition: item_cmpfunc.h:1240
const char * func_name() const override
Definition: item_cmpfunc.h:1242
Wrapper class when MATCH function is used in WHERE clause.
Definition: item_cmpfunc.h:769
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) override
Calculate the filter contribution that is relevant for table 'filter_for_table' for this item.
Definition: item_cmpfunc.h:781
Item_func_match_predicate(Item *a)
Definition: item_cmpfunc.h:771
const char * func_name() const override
Definition: item_cmpfunc.h:775
longlong val_int() override
Definition: item_cmpfunc.cc:7280
enum Functype functype() const override
Definition: item_cmpfunc.h:774
void print(const THD *thd, String *str, enum_query_type query_type) const override
This method is used for to:
Definition: item_cmpfunc.h:776
Implements the comparison operator not equals (<>)
Definition: item_cmpfunc.h:1249
enum Functype rev_functype() const override
Definition: item_cmpfunc.h:1257
cond_result eq_cmp_result() const override
Definition: item_cmpfunc.h:1258
const char * func_name() const override
Definition: item_cmpfunc.h:1260
optimize_type select_optimize(const THD *) override
Definition: item_cmpfunc.h:1259
Item_func_ne(Item *a, Item *b)
Definition: item_cmpfunc.h:1254
enum Functype functype() const override
Definition: item_cmpfunc.h:1256
Definition: item_cmpfunc.h:974
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...
Definition: item_cmpfunc.h:979
Item * truth_transformer(THD *, Bool_test) override
Apply NOT transformation to the item and return a new one.
Definition: item_cmpfunc.cc:6802
Item_func_nop_all(Item *a)
Definition: item_cmpfunc.h:976
const char * func_name() const override
Definition: item_cmpfunc.h:978
longlong val_int() override
Special NOP (No OPeration) for ALL subquery.
Definition: item_cmpfunc.cc:549
Definition: item_cmpfunc.h:919
bool empty_underlying_subquery()
Definition: item_cmpfunc.cc:511
bool abort_on_null
Definition: item_cmpfunc.h:924
void print(const THD *thd, String *str, enum_query_type query_type) const override
This method is used for to:
Definition: item_cmpfunc.cc:532
const char * func_name() const override
Definition: item_cmpfunc.h:941
Item_subselect * subselect
Definition: item_cmpfunc.h:923
Item * truth_transformer(THD *, Bool_test) override
Apply NOT transformation to the item and return a new one.
Definition: item_cmpfunc.cc:6813
longlong val_int() override
special NOT for ALL subquery.
Definition: item_cmpfunc.cc:497
void set_subselect(Item_subselect *item)
Definition: item_cmpfunc.h:946
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...
Definition: item_cmpfunc.h:947
void set_sum_test(Item_sum_hybrid *item)
Definition: item_cmpfunc.h:944
bool show
Definition: item_cmpfunc.h:927
void apply_is_true() override
Apply the IS TRUE truth property, meaning that an UNKNOWN result and a FALSE result are treated the s...
Definition: item_cmpfunc.h:936
enum Functype functype() const override
Definition: item_cmpfunc.h:940
void set_sub_test(Item_maxmin_subselect *item)
Definition: item_cmpfunc.h:945
bool ignore_unknown() const
Treat UNKNOWN result like FALSE because callers see no difference.
Definition: item_cmpfunc.h:938
Item_sum_hybrid * test_sum_item
Definition: item_cmpfunc.h:921
Item_func_not_all(Item *a)
Definition: item_cmpfunc.h:929
Item_maxmin_subselect * test_sub_item
Definition: item_cmpfunc.h:922
Definition: item_cmpfunc.h:739
Item * truth_transformer(THD *, Bool_test) override
Apply NOT transformation to the item and return a new one.
Definition: item_cmpfunc.cc:6735
enum Functype functype() const override
Definition: item_cmpfunc.h:745
const char * func_name() const override
Definition: item_cmpfunc.h:746
longlong val_int() override
Definition: item_cmpfunc.cc:465
Item_func_not(Item *a)
Definition: item_cmpfunc.h:741
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) override
Calculate the filter contribution that is relevant for table 'filter_for_table' for this item.
Definition: item_cmpfunc.cc:439
void print(const THD *thd, String *str, enum_query_type query_type) const override
This method is used for to:
Definition: item_cmpfunc.cc:486
Item_func_not(const POS &pos, Item *a)
Definition: item_cmpfunc.h:742
Definition: item_cmpfunc.h:1551
enum_field_types default_data_type() const override
Get the default data (output) type for the specific item.
Definition: item_cmpfunc.h:1565
enum Functype functype() const override
Definition: item_cmpfunc.h:1571
Item_result result_type() const override
Definition: item_cmpfunc.h:1564
bool is_bool_func() const override
This is a workaround for the broken inheritance hierarchy: this should inherit from Item_func instead...
Definition: item_cmpfunc.h:1586
void print(const THD *thd, String *str, enum_query_type query_type) const override
This method is used for to:
Definition: item_cmpfunc.h:1576
enum Item_result cached_result_type
Definition: item_cmpfunc.h:1552
Item_func_nullif(const POS &pos, Item *a, Item *b)
Definition: item_cmpfunc.h:1555
const char * func_name() const override
Definition: item_cmpfunc.h:1570
uint decimal_precision() const override
Definition: item_cmpfunc.h:1574
Definition: item_func.h:830
Definition: item_cmpfunc.h:1278
void negate()
Definition: item_cmpfunc.h:1293
bool ignore_unknown() const
Definition: item_cmpfunc.h:1295
bool subst_argument_checker(uchar **) override
Definition: item_cmpfunc.h:1311
Item * truth_transformer(THD *, Bool_test test) override
Informs an item that it is wrapped in a truth test, in case it wants to transforms itself to implemen...
Definition: item_cmpfunc.h:1296
void add_json_info(Json_object *obj) override
Add all the node-specific json fields.
Definition: item_cmpfunc.h:1314
bool pred_level
Definition: item_cmpfunc.h:1281
Item_func_opt_neg(const POS &pos, Item *a, Item *b, Item *c, bool is_negation)
Definition: item_cmpfunc.h:1283
void apply_is_true() override
Apply the IS TRUE truth property, meaning that an UNKNOWN result and a FALSE result are treated the s...
Definition: item_cmpfunc.h:1294
bool allow_replacement(Item_field *const original, Item_field *const subst) override
Check whether a function allows replacement of a field with another: In particular,...
Definition: item_cmpfunc.h:1301
Item_func_opt_neg(const POS &pos, PT_item_list *list, bool is_negation)
Definition: item_cmpfunc.h:1287
bool negated
Definition: item_cmpfunc.h:1280
Internal function used by subquery to derived transformation to check if a subquery is scalar.
Definition: item_cmpfunc.h:1206
table_map get_initial_pseudo_tables() const override
We add RAND_TABLE_BIT to prevent moving this item from the JOIN condition: it might raise an error to...
Definition: item_cmpfunc.h:1227
const char * func_name() const override
Definition: item_cmpfunc.h:1210
bool is_valid_for_pushdown(uchar *arg) override
Redefine to avoid pushing into derived table.
Definition: item_cmpfunc.h:1212
Item_func_reject_if(Item *a)
Definition: item_cmpfunc.h:1208
Definition: item_cmpfunc.h:1371
void print(const THD *thd, String *str, enum_query_type query_type) const override
This method is used for to:
Definition: item_cmpfunc.h:1380
bool resolve_type(THD *thd) override
Resolve type-related information for this item, such as result field type, maximum size,...
Definition: item_cmpfunc.h:1386
const char * func_name() const override
Definition: item_cmpfunc.h:1377
Item_func_strcmp(const POS &pos, Item *a, Item *b)
Definition: item_cmpfunc.h:1373
enum Functype functype() const override
Definition: item_cmpfunc.h:1378
optimize_type select_optimize(const THD *) override
Definition: item_cmpfunc.h:1376
Definition: item_cmpfunc.h:821
bool fix_fields(THD *thd, Item **ref) override
Definition: item_cmpfunc.h:885
enum_trig_type
Definition: item_cmpfunc.h:823
@ FOUND_MATCH
This trigger type deactivates predicated from WHERE condition when no row satisfying the join conditi...
Definition: item_cmpfunc.h:838
@ IS_NOT_NULL_COMPL
This trigger type deactivates join conditions when a row has been NULL-complemented.
Definition: item_cmpfunc.h:829
@ OUTER_FIELD_IS_NOT_NULL
In IN->EXISTS subquery transformation, new predicates are added: WHERE inner_field=outer_field OR inn...
Definition: item_cmpfunc.h:847
const char * func_name() const override
'<if>', to distinguish from the if() SQL function
Definition: item_cmpfunc.h:880
void add_trig_func_tables()
Definition: item_cmpfunc.h:890
void update_used_tables() override
Updates used tables, not null tables information and accumulates properties up the item tree,...
Definition: item_cmpfunc.h:899
enum enum_trig_type get_trig_type() const
Definition: item_cmpfunc.h:909
bool contains_only_equi_join_condition() const override
Whether this Item is an equi-join condition.
Definition: item_cmpfunc.cc:7646
Item_func_trig_cond(Item *a, bool *f, const JOIN *join, plan_idx idx, enum_trig_type trig_type_arg)
Definition: item_cmpfunc.h:870
table_map get_inner_tables() const
Get table_map of inner tables spanned by associated outer join operation.
Definition: item_cmpfunc.cc:7326
const JOIN * get_join() const
Definition: item_cmpfunc.h:908
void print(const THD *thd, String *str, enum_query_type query_type) const override
This method is used for to:
Definition: item_cmpfunc.cc:7346
void get_table_range(Table_ref **first_table, Table_ref **last_table) const
Get range of inner tables spanned by associated outer join operation.
Definition: item_cmpfunc.cc:7305
bool * get_trig_var()
Definition: item_cmpfunc.h:910
plan_idx idx() const
Definition: item_cmpfunc.h:914
plan_idx m_idx
Optional: if join!=NULL: index of table.
Definition: item_cmpfunc.h:856
void fix_after_pullout(Query_block *parent_query_block, Query_block *removed_query_block) override
Fix after tables have been moved from one query_block level to the parent level, e....
Definition: item_cmpfunc.h:903
longlong val_int() override
Definition: item_cmpfunc.cc:7291
enum_trig_type trig_type
Type of trig_var; for printing.
Definition: item_cmpfunc.h:858
enum Functype functype() const override
Definition: item_cmpfunc.h:878
bool * trig_var
Pointer to trigger variable.
Definition: item_cmpfunc.h:852
enum_trig_type get_trig_type()
Definition: item_cmpfunc.h:911
const JOIN * m_join
Optional: JOIN of table which is the source of trig_var.
Definition: item_cmpfunc.h:854
A predicate that is "always true".
Definition: item_cmpfunc.h:378
bool val_bool() override
Definition: item_cmpfunc.h:383
enum Functype functype() const override
Definition: item_cmpfunc.h:388
Item_func_true()
Definition: item_cmpfunc.h:380
void print(const THD *, String *str, enum_query_type) const override
This method is used for to:
Definition: item_cmpfunc.h:385
Item_func_true(const POS &pos)
Definition: item_cmpfunc.h:381
const char * func_name() const override
Definition: item_cmpfunc.h:382
longlong val_int() override
Definition: item_cmpfunc.h:384
Item class, to represent X IS [NOT] (TRUE | FALSE) boolean predicates.
Definition: item_cmpfunc.h:410
Bool_test truth_test
The value we're testing for.
Definition: item_cmpfunc.h:469
Item_bool_func super
Definition: item_cmpfunc.h:411
longlong val_int() override
Definition: item_cmpfunc.cc:2242
void apply_is_true() override
Apply the IS TRUE truth property, meaning that an UNKNOWN result and a FALSE result are treated the s...
Definition: item_cmpfunc.h:453
enum Functype functype() const override
Definition: item_cmpfunc.h:425
void print(const THD *thd, String *str, enum_query_type query_type) const override
This method is used for to:
Definition: item_cmpfunc.cc:2232
Item_func_truth(const POS &pos, Item *a, Bool_test truth_test)
Definition: item_cmpfunc.h:427
bool resolve_type(THD *) override
Resolve type-related information for this item, such as result field type, maximum size,...
Definition: item_cmpfunc.cc:2226
Item * truth_transformer(THD *, Bool_test test) override
Informs an item that it is wrapped in a truth test, in case it wants to transforms itself to implemen...
Definition: item_cmpfunc.h:418
Item_func_truth(Item *a, Bool_test truth_test)
Definition: item_cmpfunc.h:440
const char * func_name() const override
Definition: item_cmpfunc.h:422
XOR inherits from Item_bool_func2 because it is not optimized yet.
Definition: item_cmpfunc.h:718
Item_bool_func2 super
Definition: item_cmpfunc.h:719
const char * func_name() const override
Definition: item_cmpfunc.h:727
longlong val_int() override
Make a logical XOR of the arguments.
Definition: item_cmpfunc.cc:6694
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) override
Calculate the filter contribution that is relevant for table 'filter_for_table' for this item.
Definition: item_cmpfunc.cc:6656
enum Functype functype() const override
Definition: item_cmpfunc.h:726
void apply_is_true() override
Apply the IS TRUE truth property, meaning that an UNKNOWN result and a FALSE result are treated the s...
Definition: item_cmpfunc.h:730
Item_func_xor(const POS &pos, Item *i1, Item *i2)
Definition: item_cmpfunc.h:723
Item_func_xor(Item *i1, Item *i2)
Definition: item_cmpfunc.h:722
Item * truth_transformer(THD *, Bool_test) override
XOR can be negated by negating one of the operands:
Definition: item_cmpfunc.cc:6753
bool do_itemize(Parse_context *pc, Item **res) override
The core function that does the actual itemization.
Definition: item_cmpfunc.cc:6641
Definition: item_func.h:100
my_decimal * val_decimal(my_decimal *) override
Definition: item_func.cc:826
Item ** args
Array of pointers to arguments.
Definition: item_func.h:107
void update_used_tables() override
Updates used tables, not null tables information and accumulates properties up the item tree,...
Definition: item_func.cc:723
bool 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()
Definition: item_func.cc:712
void traverse_cond(Cond_traverser traverser, void *arg, traverse_order order) override
Definition: item_func.cc:631
Item * compile(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.
Definition: item_func.cc:689
Functype
Definition: item_func.h:183
@ TRIG_COND_FUNC
Definition: item_func.h:227
@ NOT_ALL_FUNC
Definition: item_func.h:224
@ LIKE_FUNC
Definition: item_func.h:194
@ FALSE_FUNC
Definition: item_func.h:307
@ NULLIF_FUNC
Definition: item_func.h:268
@ NOT_FUNC
Definition: item_func.h:223
@ XOR_FUNC
Definition: item_func.h:200
@ COND_OR_FUNC
Definition: item_func.h:199
@ COND_AND_FUNC
Definition: item_func.h:198
@ EQ_FUNC
Definition: item_func.h:185
@ TRUE_FUNC
Definition: item_func.h:306
@ IN_FUNC
Definition: item_func.h:202
@ LE_FUNC
Definition: item_func.h:189
@ MATCH_FUNC
Definition: item_func.h:193
@ LT_FUNC
Definition: item_func.h:188
@ ISNULL_FUNC
Definition: item_func.h:195
@ ISNOTNULLTEST_FUNC
Definition: item_func.h:205
@ MULT_EQUAL_FUNC
Definition: item_func.h:203
@ ISTRUTH_FUNC
Definition: item_func.h:197
@ BETWEEN
Definition: item_func.h:201
@ IF_FUNC
Definition: item_func.h:267
@ STRCMP_FUNC
Definition: item_func.h:305
@ NE_FUNC
Definition: item_func.h:187
@ GE_FUNC
Definition: item_func.h:190
@ EQUAL_FUNC
Definition: item_func.h:186
@ GT_FUNC
Definition: item_func.h:191
@ UNKNOWN_FUNC
Definition: item_func.h:184
@ ISNOTNULL_FUNC
Definition: item_func.h:196
@ CASE_FUNC
Definition: item_func.h:269
@ COALESCE_FUNC
Definition: item_func.h:299
void print_op(const THD *thd, String *str, enum_query_type query_type) const
Definition: item_func.cc:753
table_map used_tables_cache
Value used in calculation of result of used_tables()
Definition: item_func.h:169
optimize_type
Definition: item_func.h:321
@ OPTIMIZE_NONE
Definition: item_func.h:322
@ OPTIMIZE_EQUAL
Definition: item_func.h:326
@ OPTIMIZE_NULL
Definition: item_func.h:325
@ OPTIMIZE_KEY
Definition: item_func.h:323
@ OPTIMIZE_OP
Definition: item_func.h:324
bool do_itemize(Parse_context *pc, Item **res) override
The core function that does the actual itemization.
Definition: item_func.cc:359
bool resolve_type(THD *thd) override
Resolve type-related information for this item, such as result field type, maximum size,...
Definition: item_func.h:674
void print(const THD *thd, String *str, enum_query_type query_type) const override
This method is used for to:
Definition: item_func.cc:737
bool fix_fields(THD *, Item **ref) override
Definition: item_func.cc:404
void fix_after_pullout(Query_block *parent_query_block, Query_block *removed_query_block) override
Fix after tables have been moved from one query_block level to the parent level, e....
Definition: item_func.cc:458
bool set_arguments(mem_root_deque< Item * > *list, bool context_free)
Copy arguments from list to args array.
Definition: item_func.cc:327
uint arg_count
How many arguments in 'args'.
Definition: item_func.h:130
Field * tmp_table_field(TABLE *t_arg) override
Definition: item_func.cc:784
bool eq(const Item *item, bool binary_cmp) const override
Definition: item_func.cc:767
table_map not_null_tables_cache
Value used in calculation of result of not_null_tables()
Definition: item_func.h:171
bool null_on_null
Affects how to determine that NULL argument implies a NULL function return.
Definition: item_func.h:162
bool walk(Item_processor processor, enum_walk walk, uchar *arg) override
Traverses a tree of Items in prefix and/or postfix order.
Definition: item_func.cc:620
Item * transform(Item_transformer transformer, uchar *arg) override
Transform an Item_func object with a transformer callback function.
Definition: item_func.cc:664
virtual bool resolve_type_inner(THD *)
Resolve type of function after all arguments have had their data types resolved.
Definition: item_func.h:477
uint allowed_arg_cols
Definition: item_func.h:167
Definition: item_cmpfunc.h:491
bool split_sum_func(THD *thd, Ref_item_array ref_item_array, mem_root_deque< Item * > *fields) override
Definition: item_cmpfunc.cc:2360
bool is_null() override
The method allows to determine nullness of a complex expression without fully evaluating it,...
Definition: item_cmpfunc.cc:2542
bool fix_left(THD *thd)
Definition: item_cmpfunc.cc:2275
Item_cache * cache
Definition: item_cmpfunc.h:493
const char * func_name() const override
Definition: item_cmpfunc.h:518
longlong val_int() override
The implementation of optimized <outer expression> [NOT] IN <subquery> predicates.
Definition: item_cmpfunc.cc:2457
Item_in_optimizer(Item_in_subselect *item)
Definition: item_cmpfunc.h:503
int result_for_null_param
Stores the value of "NULL IN (SELECT ...)" for uncorrelated subqueries: UNKNOWN - "NULL in (SELECT ....
Definition: item_cmpfunc.h:500
void fix_after_pullout(Query_block *parent_query_block, Query_block *removed_query_block) override
Fix after tables have been moved from one query_block level to the parent level, e....
Definition: item_cmpfunc.cc:2349
void update_used_tables() override
Updates used tables, not null tables information and accumulates properties up the item tree,...
Definition: item_cmpfunc.cc:2547
void cleanup() override
Called for every Item after use (preparation and execution).
Definition: item_cmpfunc.cc:2537
Item_cache ** get_cache()
Definition: item_cmpfunc.h:519
bool fix_fields(THD *, Item **) override
Definition: item_cmpfunc.cc:2317
void print(const THD *thd, String *str, enum_query_type query_type) const override
This method is used for to:
Definition: item_cmpfunc.cc:2372
Representation of IN subquery predicates of the form "left_expr IN (SELECT ...)".
Definition: item_subselect.h:571
Definition: item_func.h:977
String * val_str(String *str) override
Definition: item_func.cc:1463
bool get_date(MYSQL_TIME *ltime, my_time_flags_t fuzzydate) override
Definition: item_func.h:1025
double val_real() override
Definition: item_func.cc:1457
enum Item_result result_type() const override
Definition: item_func.h:1029
bool get_time(MYSQL_TIME *ltime) override
Definition: item_func.h:1028
Definition: item_cmpfunc.h:2316
void print(const THD *thd, String *str, enum_query_type query_type) const override
This method is used for to:
Definition: item_cmpfunc.h:2335
Item_in_subselect * owner
Definition: item_cmpfunc.h:2317
const char * func_name() const override
Definition: item_cmpfunc.h:2324
Item_is_not_null_test(Item_in_subselect *ow, Item *a)
Definition: item_cmpfunc.h:2320
table_map get_initial_pseudo_tables() const override
We add RAND_TABLE_BIT to prevent moving this item from HAVING to WHERE.
Definition: item_cmpfunc.h:2332
enum Functype functype() const override
Definition: item_cmpfunc.h:2322
Definition: item_subselect.h:371
Item with result field.
Definition: item.h:5809
Field * result_field
Definition: item.h:5811
void cleanup() override
Called for every Item after use (preparation and execution).
Definition: item.cc:10883
Item which stores (x,y,...) and ROW(x,y,...).
Definition: item_row.h:53
Base class that is common to all subqueries and subquery predicates.
Definition: item_subselect.h:79
Abstract base class for the MIN and MAX aggregate functions.
Definition: item_sum.h:1539
Base class that is used to represent any kind of expression in a relational query.
Definition: item.h:933
virtual double val_real()=0
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.
Definition: item.h:2095
void set_nullable(bool nullable)
Definition: item.h:3627
DTCollation collation
Character set and collation properties assigned for this Item.
Definition: item.h:3525
void set_data_type_bool()
Definition: item.h:1515
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.
Definition: item.h:2755
bool is_nullable() const
Definition: item.h:3626
void set_subquery()
Set the "has subquery" property.
Definition: item.h:3381
void fix_char_length(uint32 max_char_length_arg)
Definition: item.h:3331
virtual Item * equality_substitution_transformer(uchar *)
Definition: item.h:2970
virtual uint decimal_precision() const
Definition: item.cc:773
virtual bool val_json(Json_wrapper *result)
Get a JSON value from an Item.
Definition: item.h:2067
virtual longlong val_int()=0
virtual void print(const THD *, String *str, enum_query_type) const
This method is used for to:
Definition: item.h:2461
bool fixed
True if item has been resolved.
Definition: item.h:3615
bool null_value
True if item is null.
Definition: item.h:3652
Type
Definition: item.h:968
@ COND_ITEM
Definition: item.h:982
virtual void apply_is_true()
Apply the IS TRUE truth property, meaning that an UNKNOWN result and a FALSE result are treated the s...
Definition: item.h:2534
virtual table_map not_null_tables() const
Return table map of tables that can't be NULL tables (tables that are used in a context where if they...
Definition: item.h:2350
virtual TYPELIB * get_typelib() const
Get the typelib information for an item of type set or enum.
Definition: item.h:1795
bool unsigned_flag
Definition: item.h:3653
virtual bool aggregate_check_group(uchar *)
Definition: item.h:2900
virtual bool is_null()
The method allows to determine nullness of a complex expression without fully evaluating it,...
Definition: item.h:2515
virtual bool aggregate_check_distinct(uchar *)
Definition: item.h:2898
cond_result
Definition: item.h:1001
@ COND_TRUE
Definition: item.h:1001
@ COND_FALSE
Definition: item.h:1001
@ COND_OK
Definition: item.h:1001
traverse_order
Definition: item.h:1003
Bool_test
< Modifier for result transformation
Definition: item.h:1016
@ BOOL_NOT_FALSE
Definition: item.h:1020
@ BOOL_NOT_TRUE
Definition: item.h:1019
@ BOOL_IS_TRUE
Definition: item.h:1016
@ BOOL_IS_FALSE
Definition: item.h:1017
@ BOOL_NEGATED
Definition: item.h:1023
uint32 max_length
Maximum length of result of evaluating this item, in number of bytes.
Definition: item.h:3543
virtual enum Type type() const =0
virtual uint cols() const
Definition: item.h:3141
Definition: sql_optimizer.h:132
Represents a JSON container value of type "object" (ECMA), type J_OBJECT here.
Definition: json_dom.h:367
bool add_alias(const std::string &key, Json_dom *value)
Insert the value into the object.
Definition: json_dom.h:409
A class that is capable of holding objects of any sub-type of Json_scalar.
Definition: json_dom.h:1895
Abstraction for accessing JSON values irrespective of whether they are (started out as) binary JSON v...
Definition: json_dom.h:1161
Definition: item_cmpfunc.h:609
Item_bool_func * create(Item *a, Item *b) const override
Definition: item_cmpfunc.cc:435
bool l_op() const override
Definition: item_cmpfunc.h:614
const char * symbol(bool invert) const override
This interface is only used by Item_allany_subselect.
Definition: item_cmpfunc.h:612
bool eqne_op() const override
Definition: item_cmpfunc.h:613
Abstract base class for the comparison operators =, <> and <=>.
Definition: item_cmpfunc.h:536
virtual Item_bool_func * create_scalar_predicate(Item *a, Item *b) const =0
Creates only an item tree node, without attempting to rewrite row constructors.
virtual Item_bool_func * combine(List< Item > list) const =0
Combines a list of conditions exp op exp.
bool eqne_op() const override
Definition: item_cmpfunc.h:539
Item_bool_func * create(Item *a, Item *b) const override
This implementation of the factory method also implements flattening of row constructors.
Definition: item_cmpfunc.cc:377
bool l_op() const override
Definition: item_cmpfunc.h:540
Definition: sql_list.h:620
Definition: sql_list.h:434
void sort(Node_cmp_func cmp)
Sort the list.
Definition: sql_list.h:534
T * head()
Definition: sql_list.h:460
Definition: item_cmpfunc.h:593
Item_bool_func * create(Item *a, Item *b) const override
Definition: item_cmpfunc.cc:427
bool l_op() const override
Definition: item_cmpfunc.h:598
bool eqne_op() const override
Definition: item_cmpfunc.h:597
const char * symbol(bool invert) const override
This interface is only used by Item_allany_subselect.
Definition: item_cmpfunc.h:596
A typesafe replacement for DYNAMIC_ARRAY.
Definition: mem_root_array.h:60
A typesafe replacement for DYNAMIC_ARRAY.
Definition: mem_root_array.h:425
Definition: item_cmpfunc.h:576
Item_bool_func * create_scalar_predicate(Item *a, Item *b) const override
Creates only an item tree node, without attempting to rewrite row constructors.
Definition: item_cmpfunc.cc:414
const char * symbol(bool invert) const override
This interface is only used by Item_allany_subselect.
Definition: item_cmpfunc.h:578
Item_bool_func * combine(List< Item > list) const override
Combines a list of conditions exp op exp.
Definition: item_cmpfunc.cc:419
Wrapper class for an Item list head, used to allocate Item lists in the parser in a context-independe...
Definition: parse_tree_helpers.h:104
Base class for parse tree nodes (excluding the Parse_tree_root hierarchy)
Definition: parse_tree_node_base.h:230
This class represents a query block, aka a query specification, which is a query consisting of a SELE...
Definition: sql_lex.h:1161
String class wrapper with a preallocated buffer of size buff_sz.
Definition: sql_string.h:658
Using this class is fraught with peril, and you need to be very careful when doing so.
Definition: sql_string.h:166
bool copy()
Definition: sql_string.cc:197
bool is_alloced() const
Definition: sql_string.h:414
For each client connection we create a separate thread with THD serving as a thread/connection descri...
Definition: sql_lexer_thd.h:35
uint elements
Definition: sql_list.h:136
Definition: item_cmpfunc.h:1936
longlong value
Definition: item_cmpfunc.h:1937
bool has_date
Distinguish between DATE/DATETIME/TIMESTAMP and TIME.
Definition: item_cmpfunc.h:1943
const Item * warn_item
Definition: item_cmpfunc.h:1941
Definition: item_cmpfunc.h:1971
my_decimal value
Definition: item_cmpfunc.h:1972
Definition: item_cmpfunc.h:1912
longlong value
Definition: item_cmpfunc.h:1913
void store_value(Item *item) override
Definition: item_cmpfunc.h:1916
int cmp(Item *arg) override
Definition: item_cmpfunc.h:1920
int compare(const cmp_item *ci) const override
Definition: item_cmpfunc.h:1924
Definition: item_cmpfunc.h:1886
unique_ptr_destroy_only< Json_wrapper > m_value
Cached JSON value to look up.
Definition: item_cmpfunc.h:1889
~cmp_item_json() override
String m_str_value
String buffer.
Definition: item_cmpfunc.h:1893
unique_ptr_destroy_only< Json_scalar_holder > m_holder
Cache for the value above.
Definition: item_cmpfunc.h:1891
Definition: item_cmpfunc.h:1952
int cmp(Item *arg) override
Definition: item_cmpfunc.h:1960
double value
Definition: item_cmpfunc.h:1953
void store_value(Item *item) override
Definition: item_cmpfunc.h:1956
int compare(const cmp_item *ci) const override
Definition: item_cmpfunc.h:1964
Definition: item_cmpfunc.h:2198
cmp_item_row(cmp_item_row &&other)
Definition: item_cmpfunc.h:2213
uint n
Definition: item_cmpfunc.h:2200
cmp_item_row(THD *thd, Item *item)
Definition: item_cmpfunc.h:2208
cmp_item_row()
Definition: item_cmpfunc.h:2203
cmp_item which stores a scalar (i.e. non-ROW).
Definition: item_cmpfunc.h:1852
void set_null_value(bool nv)
Definition: item_cmpfunc.h:1855
bool m_null_value
If stored value is NULL.
Definition: item_cmpfunc.h:1854
Definition: item_cmpfunc.h:1858
const String * value_res
Definition: item_cmpfunc.h:1860
int compare(const cmp_item *ci) const override
Definition: item_cmpfunc.h:1867
cmp_item_string(const CHARSET_INFO *cs)
Definition: item_cmpfunc.h:1865
void store_value(Item *item) override
Definition: item_cmpfunc.h:1872
const CHARSET_INFO * cmp_charset
Definition: item_cmpfunc.h:1862
StringBuffer< STRING_BUFFER_USUAL_SIZE > value
Definition: item_cmpfunc.h:1861
Definition: item_cmpfunc.h:1808
virtual void store_value(Item *item)=0
virtual int compare(const cmp_item *item) const =0
virtual int cmp(Item *item)=0
virtual ~cmp_item()=default
virtual cmp_item * make_same()=0
virtual void store_value_by_template(cmp_item *, Item *item)
Definition: item_cmpfunc.h:1846
Definition: item_cmpfunc.h:1720
Item_basic_constant * create_item(MEM_ROOT *mem_root) const override
Create an instance of Item_{type} (e.g.
Definition: item_cmpfunc.h:1724
in_datetime_as_longlong(MEM_ROOT *mem_root, uint elements)
Definition: item_cmpfunc.h:1722
Definition: item_cmpfunc.h:1748
Item_basic_constant * create_item(MEM_ROOT *mem_root) const override
Create an instance of Item_{type} (e.g.
Definition: item_cmpfunc.h:1755
Item * warn_item
An item used to issue warnings.
Definition: item_cmpfunc.h:1750
in_datetime(MEM_ROOT *mem_root, Item *warn_item_arg, uint elements)
Definition: item_cmpfunc.h:1753
Definition: item_cmpfunc.h:1784
Mem_root_array< my_decimal > base
Definition: item_cmpfunc.h:1785
in_decimal(MEM_ROOT *mem_root, uint elements)
Definition: item_cmpfunc.h:1788
void value_to_item(uint pos, Item_basic_constant *item) const override
Store the value at position pos into provided item object.
Definition: item_cmpfunc.h:1793
Item_basic_constant * create_item(MEM_ROOT *mem_root) const override
Create an instance of Item_{type} (e.g.
Definition: item_cmpfunc.h:1790
Definition: item_cmpfunc.h:1764
in_double(MEM_ROOT *mem_root, uint elements)
Definition: item_cmpfunc.h:1768
void value_to_item(uint pos, Item_basic_constant *item) const override
Store the value at position pos into provided item object.
Definition: item_cmpfunc.h:1773
Mem_root_array< double > base
Definition: item_cmpfunc.h:1765
Item_basic_constant * create_item(MEM_ROOT *mem_root) const override
Create an instance of Item_{type} (e.g.
Definition: item_cmpfunc.h:1770
Definition: item_cmpfunc.h:1687
Item_basic_constant * create_item(MEM_ROOT *mem_root) const override
Create an instance of Item_{type} (e.g.
Definition: item_cmpfunc.h:1700
in_longlong(MEM_ROOT *mem_root, uint elements)
Definition: item_cmpfunc.h:1698
void value_to_item(uint pos, Item_basic_constant *item) const override
Store the value at position pos into provided item object.
Definition: item_cmpfunc.h:1707
void set(uint pos, Item *item) override
Definition: item_cmpfunc.h:1715
Mem_root_array< packed_longlong > base
Definition: item_cmpfunc.h:1695
Definition: item_cmpfunc.h:2240
Mem_root_array< cmp_item_row * > base_pointers
Definition: item_cmpfunc.h:2244
Mem_root_array< cmp_item_row > base_objects
Definition: item_cmpfunc.h:2242
Item_basic_constant * create_item(MEM_ROOT *) const override
Create an instance of Item_{type} (e.g.
Definition: item_cmpfunc.h:2262
unique_ptr_destroy_only< cmp_item_row > tmp
Definition: item_cmpfunc.h:2241
bool is_row_result() const override
Definition: item_cmpfunc.h:2248
void value_to_item(uint, Item_basic_constant *) const override
Store the value at position pos into provided item object.
Definition: item_cmpfunc.h:2266
Definition: item_cmpfunc.h:1662
Mem_root_array< String * > base_pointers
Definition: item_cmpfunc.h:1667
Mem_root_array< String > base_objects
Definition: item_cmpfunc.h:1665
void value_to_item(uint pos, Item_basic_constant *item) const override
Store the value at position pos into provided item object.
Definition: item_cmpfunc.h:1675
const CHARSET_INFO * collation
Definition: item_cmpfunc.h:1668
String tmp
Definition: item_cmpfunc.h:1664
Item_basic_constant * create_item(MEM_ROOT *mem_root) const override
Create an instance of Item_{type} (e.g.
Definition: item_cmpfunc.h:1672
Definition: item_cmpfunc.h:1732
Item_basic_constant * create_item(MEM_ROOT *mem_root) const override
Create an instance of Item_{type} (e.g.
Definition: item_cmpfunc.h:1736
in_time_as_longlong(MEM_ROOT *mem_root, uint elements)
Definition: item_cmpfunc.h:1734
Definition: item_cmpfunc.h:1593
const uint m_size
Size of the vector.
Definition: item_cmpfunc.h:1595
virtual void cleanup()
Definition: item_cmpfunc.h:1653
virtual void set(uint pos, Item *item)=0
virtual void value_to_item(uint pos, Item_basic_constant *item) const =0
Store the value at position pos into provided item object.
virtual ~in_vector()=default
virtual bool find_item(Item *item)=0
Calls item->val_int() or item->val_str() etc.
virtual bool is_row_result() const
Definition: item_cmpfunc.h:1639
virtual bool compare_elems(uint pos1, uint pos2) const =0
Compare values number pos1 and pos2 for equality.
virtual Item_basic_constant * create_item(MEM_ROOT *mem_root) const =0
Create an instance of Item_{type} (e.g.
virtual void sort_array()=0
Sort the IN-list array, so we can do efficient lookup with binary_search.
in_vector(uint elements)
See Item_func_in::resolve_type() for why we need both count and used_count.
Definition: item_cmpfunc.h:1603
A (partial) implementation of std::deque allocating its blocks on a MEM_ROOT.
Definition: mem_root_deque.h:110
my_decimal class limits 'decimal_t' type to what we need in MySQL.
Definition: my_decimal.h:94
static MEM_ROOT mem_root
Definition: client_plugin.cc:113
static bool contains(const std::vector< std::string > &container, const std::string &file)
Definition: config_files.cc:40
enum_query_type
Query type constants (usable as bitmap flags).
Definition: enum_query_type.h:30
This file contains the field type.
enum_field_types
Column types for MySQL Note: Keep include/mysql/components/services/bits/stored_program_bits....
Definition: field_types.h:54
@ MYSQL_TYPE_VARCHAR
Definition: field_types.h:70
@ MYSQL_TYPE_TIME
Definition: field_types.h:66
@ MYSQL_TYPE_DATETIME
Definition: field_types.h:67
bool(Item::* Item_analyzer)(uchar **argp)
Definition: item.h:715
void(* Cond_traverser)(const Item *item, void *arg)
Definition: item.h:725
Item *(Item::* Item_transformer)(uchar *arg)
Type for transformers used by Item::transform and Item::compile.
Definition: item.h:724
static void ensure_multi_equality_fields_are_available(Item **args, int arg_idx, table_map available_tables, bool replace, bool *found)
Definition: item_cmpfunc.cc:8092
int(Arg_comparator::* arg_cmp_func)()
Definition: item_cmpfunc.h:73
Eq_creator eq_creator
Definition: mysqld.cc:1535
Ge_creator ge_creator
Definition: mysqld.cc:1540
Item * make_condition(Parse_context *pc, Item *item)
Ensure that all expressions involved in conditions are boolean functions.
Definition: item_cmpfunc.cc:5617
void find_and_adjust_equal_fields(Item *item, table_map available_tables, bool replace, bool *found)
Definition: item_cmpfunc.cc:8073
Lt_creator lt_creator
Definition: mysqld.cc:1539
bool get_mysql_time_from_str_no_warn(THD *thd, String *str, MYSQL_TIME *l_time, MYSQL_TIME_STATUS *status)
A minion of get_mysql_time_from_str, see its description.
Definition: item_cmpfunc.cc:992
Gt_creator gt_creator
Definition: mysqld.cc:1538
static const int UNKNOWN
Definition: item_cmpfunc.h:472
bool IsAnd(const Item *item)
Returns true if the item is a conjunction.
Definition: item_cmpfunc.h:2837
Ne_creator ne_creator
Definition: mysqld.cc:1536
Equal_creator equal_creator
Definition: mysqld.cc:1537
bool WalkConjunction(Item *condition, Func func)
Calls "func" on each term in "condition" if it's a conjunction (and recursively on any conjunction di...
Definition: item_cmpfunc.h:2850
bool get_mysql_time_from_str(THD *thd, String *str, enum_mysql_timestamp_type warn_type, const char *warn_name, MYSQL_TIME *l_time)
Parse date provided in a string to a MYSQL_TIME.
Definition: item_cmpfunc.cc:1023
Le_creator le_creator
Definition: mysqld.cc:1541
longlong get_datetime_value(THD *thd, Item ***item_arg, Item **, const Item *warn_item, bool *is_null)
Retrieve correct DATETIME value from given item.
Definition: item_cmpfunc.cc:1631
Item * and_conds(Item *a, Item *b)
Builds condition: (a AND b) IS TRUE.
Definition: item_cmpfunc.h:2795
String * eval_string_arg(const CHARSET_INFO *to_cs, Item *arg, String *buffer)
Definition: item_func.h:93
This file follows Google coding style, except for the name MEM_ROOT (which is kept for historical rea...
std::unique_ptr< T, Destroy_only< T > > unique_ptr_destroy_only
std::unique_ptr, but only destroying.
Definition: my_alloc.h:476
Header for compiler-dependent features.
It is interface module to fixed precision decimals library.
Some integer typedefs for easier portability.
unsigned long long int ulonglong
Definition: my_inttypes.h:55
unsigned char uchar
Definition: my_inttypes.h:51
long long int longlong
Definition: my_inttypes.h:54
uint16_t uint16
Definition: my_inttypes.h:64
uint64_t table_map
Definition: my_table_map.h:29
Interface for low level time utilities.
unsigned int my_time_flags_t
Flags to str_to_datetime and number_to_datetime.
Definition: my_time.h:93
Time declarations shared between the server and client API: you should not add anything to this heade...
enum_mysql_timestamp_type
Definition: mysql_time.h:44
static bool replace
Definition: mysqlimport.cc:69
std::string str(const mysqlrouter::ConfigGenerator::Options::Endpoint &ep)
Definition: config_generator.cc:1065
static PFS_engine_table_share_proxy table
Definition: pfs.cc:60
Definition: commit_order_queue.h:33
PT & ref(PT *tp)
Definition: tablespace_impl.cc:358
std::string join(Container cont, const std::string &delim)
join elements of an container into a string separated by a delimiter.
Definition: string.h:150
static mysql_service_status_t add(reference_caching_channel channel, const char *implementation_name) noexcept
Definition: component.cc:126
std::set< Key, Compare, ut::allocator< Key > > set
Specialization of set which uses ut_allocator.
Definition: ut0new.h:2881
std::list< T, ut::allocator< T > > list
Specialization of list which uses ut_allocator.
Definition: ut0new.h:2877
required uint32 status
Definition: replication_asynchronous_connection_failover.proto:60
required string type
Definition: replication_group_member_actions.proto:33
static int compare(size_t a, size_t b)
Function to compare two size_t integers for their relative order.
Definition: rpl_utility.cc:106
File containing constants that can be used throughout the server.
constexpr const table_map RAND_TABLE_BIT
Definition: sql_const.h:111
constexpr const size_t STRING_BUFFER_USUAL_SIZE
Definition: sql_const.h:124
constexpr const table_map OUTER_REF_TABLE_BIT
Definition: sql_const.h:110
enum_walk
Enumeration for {Item,Query_block[_UNIT],Table_function}walk.
Definition: sql_const.h:287
bool(Item::*)(unsigned char *) Item_processor
Processor type for {Item,Query_block[_UNIT],Table_function}walk.
Definition: sql_const.h:305
int plan_idx
This represents the index of a JOIN_TAB/QEP_TAB in an array.
Definition: sql_opt_exec_shared.h:53
Our own string classes, used pervasively throughout the executor.
int sortcmp(const String *a, const String *b, const CHARSET_INFO *cs)
Definition: sql_string.cc:688
Definition: m_ctype.h:422
The MEM_ROOT is a simple arena, where allocations are carved out of larger blocks.
Definition: my_alloc.h:82
Structure to return status from str_to_datetime(), str_to_time(), number_to_datetime(),...
Definition: my_time.h:169
Definition: mysql_time.h:81
Definition: my_bitmap.h:42
Bison "location" class.
Definition: parse_location.h:42
Environment data for the contextualization phase.
Definition: parse_tree_node_base.h:419
Definition: item_cmpfunc.h:1689
bool unsigned_flag
Definition: item_cmpfunc.h:1691
longlong val
Definition: item_cmpfunc.h:1690
Definition: item_cmpfunc.h:1394
Item_result type
Definition: item_cmpfunc.h:1395
double dbl
Definition: item_cmpfunc.h:1396
my_decimal dec
Definition: item_cmpfunc.h:1397
Target down_cast(Source *arg)
Casts from one pointer type to another in a type hierarchy.
Definition: template_utils.h:95
constexpr T pointer_cast(void *p)
Casts from one pointer type, to another, without using reinterpret_cast or C-style cast: foo f; bar *...
Definition: template_utils.h:74
Item_result
Type of the user defined function return slot and arguments.
Definition: udf_registration_types.h:38
@ INT_RESULT
double
Definition: udf_registration_types.h:42
@ INVALID_RESULT
Definition: udf_registration_types.h:39
int n
Definition: xcom_base.cc:508