/* Copyright (c) 2000, 2024, Oracle and/or its affiliates. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License, version 2.0, as published by the Free Software Foundation. This program is designed to work with certain software (including but not limited to OpenSSL) that is licensed under separate terms, as designated in a particular file or component or in included license documentation. The authors of MySQL hereby grant you an additional permission to link the program and your derivative works with the separately licensed software that they have either included with the program or referenced in the documentation. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License, version 2.0, for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */ /** @file @brief Buffers to save and compare item values */ #include #include #include "my_alloc.h" #include "my_dbug.h" #include "my_inttypes.h" #include "mysql/udf_registration_types.h" #include "sql-common/json_dom.h" // Json_wrapper #include "sql-common/my_decimal.h" #include "sql/current_thd.h" // current_thd #include "sql/item.h" // Cached_item, ... #include "sql/sql_class.h" // THD #include "sql/system_variables.h" #include "sql/thr_malloc.h" #include "sql_string.h" #include "template_utils.h" using std::max; using std::min; /** Create right type of Cached_item for an item. */ Cached_item *new_Cached_item(THD *thd, Item *item) { switch (item->result_type()) { case STRING_RESULT: if (item->is_temporal()) return new (thd->mem_root) Cached_item_temporal(item); if (item->data_type() == MYSQL_TYPE_JSON) return new (thd->mem_root) Cached_item_json(item); return new (thd->mem_root) Cached_item_str(item); case INT_RESULT: return new (thd->mem_root) Cached_item_int(item); case REAL_RESULT: return new (thd->mem_root) Cached_item_real(item); case DECIMAL_RESULT: return new (thd->mem_root) Cached_item_decimal(item); case ROW_RESULT: default: assert(0); return nullptr; } } bool Cached_item_str::cmp() { DBUG_TRACE; assert(!item->is_temporal()); assert(item->data_type() != MYSQL_TYPE_JSON); String *res = item->val_str(&tmp_value); DBUG_PRINT("info", ("old: %s, new: %s", value.c_ptr_safe(), res ? res->c_ptr_safe() : "")); if (item->null_value) { if (null_value) return false; null_value = true; return true; } else if (null_value || sortcmp(&value, res, item->collation.collation) != 0) { null_value = false; value.copy(*res); // Remember for next comparison return true; } return false; } Cached_item_json::Cached_item_json(Item *item_arg) : Cached_item(item_arg), m_value(new (*THR_MALLOC) Json_wrapper()) {} Cached_item_json::~Cached_item_json() { if (m_value != nullptr) ::destroy_at(m_value); } /** Compare the new JSON value in member 'item' with the previous value. @retval true if the new value is different from the previous value, or if there is no previously cached value @retval false if the new value is the same as the already cached value */ bool Cached_item_json::cmp() { Json_wrapper wr; if (item->val_json(&wr)) { null_value = true; /* purecov: inspected */ return true; /* purecov: inspected */ } if (item->null_value) { if (null_value) return false; null_value = true; return true; } else if (null_value || m_value->empty() || m_value->compare(wr) != 0) { null_value = false; /* Old and new are not equal, and new is not null. Remember the current value till the next time we're called. */ *m_value = std::move(wr); /* The row buffer may change, which would garble the JSON binary representation pointed to by m_value. Convert to DOM so that we own the copy. */ m_value->to_dom(); return true; } return false; } bool Cached_item_real::cmp() { DBUG_TRACE; const double nr = item->val_real(); DBUG_PRINT("info", ("old: %f, new: %f", value, nr)); if (item->null_value) { if (null_value) return false; null_value = true; return true; } else if (null_value || nr != value) { null_value = false; value = nr; return true; } return false; } bool Cached_item_int::cmp() { DBUG_TRACE; const longlong nr = item->val_int(); DBUG_PRINT("info", ("old: 0x%.16llx, new: 0x%.16llx", (ulonglong)value, (ulonglong)nr)); if (item->null_value) { if (null_value) return false; null_value = true; return true; } else if (null_value || nr != value) { null_value = false; value = nr; return true; } return false; } bool Cached_item_temporal::cmp() { DBUG_TRACE; const longlong nr = item->val_temporal_by_field_type(); DBUG_PRINT("info", ("old: %lld, new: %lld", value, nr)); if (item->null_value) { if (null_value) return false; null_value = true; return true; } else if (null_value || nr != value) { null_value = false; value = nr; return true; } return false; } bool Cached_item_decimal::cmp() { DBUG_TRACE; my_decimal tmp; my_decimal *ptmp = item->val_decimal(&tmp); /* Intermediate decimal values may have higher precision than the expected result, thus to get a correct result it may be needed to round the value according to the desired precision (scale). */ if (ptmp != nullptr && ptmp->frac > item->decimals) { if (my_decimal_round(E_DEC_FATAL_ERROR, ptmp, item->decimals, false, ptmp)) return false; } if (item->null_value) { if (null_value) return false; null_value = true; return true; } else if (null_value || my_decimal_cmp(&value, ptmp)) { null_value = false; my_decimal2decimal(ptmp, &value); return true; } return false; }