/* Copyright (c) 2000, 2025, 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 <stddef.h>
#include <algorithm>

#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:
      switch (item->data_type()) {
        case MYSQL_TYPE_TIME:
          return new (thd->mem_root) Cached_item_time(item);
        case MYSQL_TYPE_DATE:
        case MYSQL_TYPE_DATETIME:
        case MYSQL_TYPE_TIMESTAMP:
          return new (thd->mem_root) Cached_item_temporal(item);
        case MYSQL_TYPE_JSON:
          return new (thd->mem_root) Cached_item_json(item);
        default:
          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_time::cmp() {
  DBUG_TRACE;
  Time_val time;
  if (item->val_time(&time)) return true;

  if (item->null_value) {
    if (null_value) return false;
    null_value = true;
    return true;
  } else if (null_value || m_time.compare(time) != 0) {
    null_value = false;
    m_time = time;
    return true;
  }
  return false;
}

bool Cached_item_temporal::cmp() {
  DBUG_TRACE;
  assert(item->data_type() != MYSQL_TYPE_TIME);
  longlong nr = 0;
  switch (item->data_type()) {
    case MYSQL_TYPE_DATE:
    case MYSQL_TYPE_DATETIME:
    case MYSQL_TYPE_TIMESTAMP:
      nr = item->val_date_temporal();
      break;
    default:
      assert(false);
      break;
  }
  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;
}
