mariadb-columnstore-engine/utils/funcexp/func_ceil.cpp

/* Copyright (C) 2014 InfiniDB, Inc.
   Copyright (C) 2019 MariaDB Corporation

   This program is free software; you can redistribute it and/or
   modify it under the terms of the GNU General Public License
   as published by the Free Software Foundation; version 2 of
   the License.

   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 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 Street, Fifth Floor, Boston,
   MA 02110-1301, USA. */

/****************************************************************************
 * $Id: func_ceil.cpp 3923 2013-06-19 21:43:06Z bwilkinson $
 *
 *
 ****************************************************************************/

#include <cstdlib>
#include <iomanip>
#include <string>
using namespace std;

#include "functor_real.h"
#include "functioncolumn.h"
using namespace execplan;

#include "rowgroup.h"
using namespace rowgroup;

#include "errorcodes.h"
#include "idberrorinfo.h"
#include "errorids.h"
using namespace logging;
using namespace dataconvert;

#include "funchelpers.h"

namespace funcexp
{
CalpontSystemCatalog::ColType Func_ceil::operationType(FunctionParm& fp,
                                                       CalpontSystemCatalog::ColType& /*resultType*/)
{
  return fp[0]->data()->resultType();
}

inline int64_t ceilDateTime(Row& row, FunctionParm& parm, bool& isNull)
{
  // the following is to handle the case of ceil(datetime), the last 20 bits are the miliseconds, the -1 is to
  // make sure it could round up
  return parm[0]->data()->getDatetimeIntVal(row, isNull) + 0xffffe;
}
inline int64_t ceilTimeStamp(Row& row, FunctionParm& parm, bool& isNull)
{
  // the following is to handle the case of ceil(timestamp), the last 20 bits are the miliseconds, the -1 is
  // to make sure it could round up
  return parm[0]->data()->getTimestampIntVal(row, isNull) + 0xffffe;
}
inline int64_t ceilTime(Row& row, FunctionParm& parm, bool& isNull)
{
  // the following is to handle the case of ceil(time), the last 24 bits are the miliseconds, the -1 is to
  // make sure it could round up
  return parm[0]->data()->getTimeIntVal(row, isNull) + 0xfffffe;
}

int64_t Func_ceil::getIntVal(Row& row, FunctionParm& parm, bool& isNull, CalpontSystemCatalog::ColType& op_ct)
{
  int64_t ret = 0;

  switch (op_ct.colDataType)
  {
    case CalpontSystemCatalog::BIGINT:
    case CalpontSystemCatalog::INT:
    case CalpontSystemCatalog::MEDINT:
    case CalpontSystemCatalog::TINYINT:
    case CalpontSystemCatalog::SMALLINT:
    {
      ret = parm[0]->data()->getIntVal(row, isNull);
    }
    break;

    // ceil(decimal(X,Y)) leads to this path if X, Y allows to
    // downcast to INT otherwise Func_ceil::getDecimalVal() is called
    case execplan::CalpontSystemCatalog::DECIMAL:
    case execplan::CalpontSystemCatalog::UDECIMAL:
    {
      if (op_ct.scale == 0)
      {
        ret = parm[0]->data()->getIntVal(row, isNull);
        break;
      }

      IDB_Decimal d = parm[0]->data()->getDecimalVal(row, isNull);

      if (isNull)
        break;

      // negative scale is not supported by CNX yet
      if (d.scale > 0)
      {
        if (d.scale > datatypes::INT128MAXPRECISION)
        {
          std::ostringstream oss;
          oss << "ceil: datatype of " << execplan::colDataTypeToString(op_ct.colDataType) << " with scale "
              << (int)d.scale << " is beyond supported scale";
          throw logging::IDBExcept(oss.str(), ERR_DATATYPE_NOT_SUPPORT);
        }

        ret = d.toSInt64Ceil();
      }
    }
    break;

    case CalpontSystemCatalog::UBIGINT:
    case CalpontSystemCatalog::UINT:
    case CalpontSystemCatalog::UMEDINT:
    case CalpontSystemCatalog::UTINYINT:
    case CalpontSystemCatalog::USMALLINT:
    {
      ret = (int64_t)(parm[0]->data()->getUintVal(row, isNull));
    }
    break;

    case CalpontSystemCatalog::DOUBLE:
    case CalpontSystemCatalog::UDOUBLE:
    case CalpontSystemCatalog::FLOAT:
    case CalpontSystemCatalog::UFLOAT:
    {
      ret = (int64_t)ceil(parm[0]->data()->getDoubleVal(row, isNull));
    }
    break;

    case CalpontSystemCatalog::LONGDOUBLE:
    {
      ret = (int64_t)ceill(parm[0]->data()->getLongDoubleVal(row, isNull));
    }
    break;

    case CalpontSystemCatalog::VARCHAR:
    case CalpontSystemCatalog::CHAR:
    case CalpontSystemCatalog::TEXT:
    {
      const auto& str = parm[0]->data()->getStrVal(row, isNull);

      if (!isNull)
        ret = (int64_t)ceil(strtod(str.str(), 0));
    }
    break;

    case CalpontSystemCatalog::DATE:
    {
      // For some reason, MDB doesn't return this as a date,
      // but datetime is returned as a datetime. Expect
      // this to change in the future.
      Date d(parm[0]->data()->getDateIntVal(row, isNull));
      if (!isNull)
        ret = d.convertToMySQLint();
    }
    break;

    case CalpontSystemCatalog::DATETIME:
    {
      ret = ceilDateTime(row, parm, isNull);
    }
    break;

    case CalpontSystemCatalog::TIMESTAMP:
    {
      ret = ceilTimeStamp(row, parm, isNull);
    }
    break;

    case CalpontSystemCatalog::TIME:
    {
      ret = ceilTime(row, parm, isNull);
    }
    break;

    default:
    {
      std::ostringstream oss;
      oss << "ceil: datatype of " << colDataTypeToString(op_ct.colDataType) << " is not supported";
      throw logging::IDBExcept(oss.str(), ERR_DATATYPE_NOT_SUPPORT);
    }
  }

  return ret;
}

uint64_t Func_ceil::getUintVal(Row& row, FunctionParm& parm, bool& isNull,
                               CalpontSystemCatalog::ColType& op_ct)
{
  uint64_t ret = 0;

  switch (op_ct.colDataType)
  {
    case CalpontSystemCatalog::BIGINT:
    case CalpontSystemCatalog::INT:
    case CalpontSystemCatalog::MEDINT:
    case CalpontSystemCatalog::TINYINT:
    case CalpontSystemCatalog::SMALLINT:
    {
      ret = (uint64_t)parm[0]->data()->getIntVal(row, isNull);
    }
    break;

    // ceil(decimal(X,Y)) leads to this path if X, Y allows to
    // downcast to INT otherwise Func_ceil::getDecimalVal() is called
    case execplan::CalpontSystemCatalog::DECIMAL:
    case execplan::CalpontSystemCatalog::UDECIMAL:
    {
      if (op_ct.scale == 0)
      {
        ret = parm[0]->data()->getIntVal(row, isNull);
        break;
      }

      IDB_Decimal d = parm[0]->data()->getDecimalVal(row, isNull);

      if (isNull)
        break;

      // negative scale is not supported by CNX yet
      if (d.scale > 0)
      {
        if (d.scale > datatypes::INT128MAXPRECISION)
        {
          std::ostringstream oss;
          oss << "ceil: datatype of " << execplan::colDataTypeToString(op_ct.colDataType) << " with scale "
              << (int)d.scale << " is beyond supported scale";
          throw logging::IDBExcept(oss.str(), ERR_DATATYPE_NOT_SUPPORT);
        }

        ret = d.toUInt64Ceil();
      }
    }
    break;

    case CalpontSystemCatalog::UBIGINT:
    case CalpontSystemCatalog::UINT:
    case CalpontSystemCatalog::UMEDINT:
    case CalpontSystemCatalog::UTINYINT:
    case CalpontSystemCatalog::USMALLINT:
    {
      ret = (parm[0]->data()->getUintVal(row, isNull));
    }
    break;

    case CalpontSystemCatalog::DOUBLE:
    case CalpontSystemCatalog::UDOUBLE:
    case CalpontSystemCatalog::FLOAT:
    case CalpontSystemCatalog::UFLOAT:
    {
      ret = (uint64_t)ceil(parm[0]->data()->getDoubleVal(row, isNull));
    }
    break;

    case CalpontSystemCatalog::LONGDOUBLE:
    {
      ret = (uint64_t)ceill(parm[0]->data()->getLongDoubleVal(row, isNull));
    }
    break;

    case CalpontSystemCatalog::VARCHAR:
    case CalpontSystemCatalog::CHAR:
    case CalpontSystemCatalog::TEXT:
    {
      const auto& str = parm[0]->data()->getStrVal(row, isNull);

      if (!isNull)
        ret = (uint64_t)ceil(strtod(str.str(), 0));
    }
    break;

    case CalpontSystemCatalog::DATE:
    {
      // For some reason, MDB doesn't return this as a date,
      // but datetime is returned as a datetime. Expect
      // this to change in the future.
      Date d(parm[0]->data()->getDateIntVal(row, isNull));
      if (!isNull)
        ret = d.convertToMySQLint();
    }
    break;

    case CalpontSystemCatalog::DATETIME:
    {
      ret = ceilDateTime(row, parm, isNull);
    }
    break;

    case CalpontSystemCatalog::TIMESTAMP:
    {
      ret = ceilTimeStamp(row, parm, isNull);
    }
    break;

    case CalpontSystemCatalog::TIME:
    {
      ret = ceilTime(row, parm, isNull);
    }
    break;

    default:
    {
      std::ostringstream oss;
      oss << "ceil: datatype of " << colDataTypeToString(op_ct.colDataType) << " is not supported";
      throw logging::IDBExcept(oss.str(), ERR_DATATYPE_NOT_SUPPORT);
    }
  }

  return ret;
}

double Func_ceil::getDoubleVal(Row& row, FunctionParm& parm, bool& isNull,
                               CalpontSystemCatalog::ColType& op_ct)
{
  double ret = 0.0;

  if (op_ct.colDataType == CalpontSystemCatalog::DOUBLE ||
      op_ct.colDataType == CalpontSystemCatalog::UDOUBLE ||
      op_ct.colDataType == CalpontSystemCatalog::FLOAT || op_ct.colDataType == CalpontSystemCatalog::UFLOAT)
  {
    ret = ceil(parm[0]->data()->getDoubleVal(row, isNull));
  }
  else if (op_ct.colDataType == CalpontSystemCatalog::VARCHAR ||
           op_ct.colDataType == CalpontSystemCatalog::CHAR || op_ct.colDataType == CalpontSystemCatalog::TEXT)
  {
    const auto& str = parm[0]->data()->getStrVal(row, isNull);

    if (!isNull)
      ret = ceil(strtod(str.str(), 0));
  }
  else if (op_ct.colDataType == CalpontSystemCatalog::LONGDOUBLE)
  {
    ret = (double)ceill(parm[0]->data()->getLongDoubleVal(row, isNull));
  }
  else if (op_ct.colDataType == CalpontSystemCatalog::DECIMAL ||
           op_ct.colDataType == CalpontSystemCatalog::UDECIMAL)
  {
    IDB_Decimal tmp = getDecimalVal(row, parm, isNull, op_ct);

    if (op_ct.colWidth == datatypes::MAXDECIMALWIDTH)
    {
      ret = static_cast<double>(tmp.toTSInt128());
    }
    else
    {
      ret = (double)tmp.value;
    }
  }
  else
  {
    if (isUnsigned(op_ct.colDataType))
    {
      ret = (double)getUintVal(row, parm, isNull, op_ct);
    }
    else
    {
      ret = (double)getIntVal(row, parm, isNull, op_ct);
    }
  }

  return ret;
}

long double Func_ceil::getLongDoubleVal(Row& row, FunctionParm& parm, bool& isNull,
                                        CalpontSystemCatalog::ColType& op_ct)
{
  long double ret = 0.0;

  if (op_ct.colDataType == CalpontSystemCatalog::LONGDOUBLE)
  {
    ret = ceill(parm[0]->data()->getLongDoubleVal(row, isNull));
  }
  else if (op_ct.colDataType == CalpontSystemCatalog::DOUBLE ||
           op_ct.colDataType == CalpontSystemCatalog::UDOUBLE ||
           op_ct.colDataType == CalpontSystemCatalog::FLOAT ||
           op_ct.colDataType == CalpontSystemCatalog::UFLOAT)
  {
    ret = ceil(parm[0]->data()->getDoubleVal(row, isNull));
  }
  else if (op_ct.colDataType == CalpontSystemCatalog::VARCHAR ||
           op_ct.colDataType == CalpontSystemCatalog::CHAR || op_ct.colDataType == CalpontSystemCatalog::TEXT)
  {
    const auto& str = parm[0]->data()->getStrVal(row, isNull);

    if (!isNull)
    {
      ret = ceil(strtod(str.str(), 0));
    }
  }
  else if (op_ct.colDataType == CalpontSystemCatalog::DECIMAL ||
           op_ct.colDataType == CalpontSystemCatalog::UDECIMAL)
  {
    IDB_Decimal tmp = getDecimalVal(row, parm, isNull, op_ct);

    if (op_ct.colWidth == datatypes::MAXDECIMALWIDTH)
    {
      ret = static_cast<long double>(tmp.toTSInt128());
    }
    else
    {
      ret = (long double)tmp.value;
    }
  }
  else
  {
    if (isUnsigned(op_ct.colDataType))
    {
      ret = (double)getUintVal(row, parm, isNull, op_ct);
    }
    else
    {
      ret = (double)getIntVal(row, parm, isNull, op_ct);
    }
  }

  return ret;
}

string Func_ceil::getStrVal(Row& row, FunctionParm& parm, bool& isNull, CalpontSystemCatalog::ColType& op_ct)
{
  char tmp[512] = {'\0'};

  if (op_ct.colDataType == CalpontSystemCatalog::DOUBLE ||
      op_ct.colDataType == CalpontSystemCatalog::UDOUBLE ||
      op_ct.colDataType == CalpontSystemCatalog::FLOAT || op_ct.colDataType == CalpontSystemCatalog::UFLOAT ||
      op_ct.colDataType == CalpontSystemCatalog::VARCHAR || op_ct.colDataType == CalpontSystemCatalog::CHAR ||
      op_ct.colDataType == CalpontSystemCatalog::TEXT)
  {
    snprintf(tmp, 511, "%f", getDoubleVal(row, parm, isNull, op_ct));

    // remove the decimals in the oss string.
    char* d = tmp;

    while ((*d != '.') && (*d != '\0'))
      d++;

    *d = '\0';
  }
  else if (op_ct.colDataType == CalpontSystemCatalog::LONGDOUBLE)
  {
    snprintf(tmp, 511, "%Lf", getLongDoubleVal(row, parm, isNull, op_ct));

    // remove the decimals in the oss string.
    char* d = tmp;

    while ((*d != '.') && (*d != '\0'))
      d++;

    *d = '\0';
  }
  else if (op_ct.colDataType == CalpontSystemCatalog::DECIMAL ||
           op_ct.colDataType == CalpontSystemCatalog::UDECIMAL)
  {
    IDB_Decimal d = getDecimalVal(row, parm, isNull, op_ct);

    if (op_ct.colWidth == datatypes::MAXDECIMALWIDTH)
    {
      return d.toString(true);
    }
    else
    {
      return d.toString();
    }
  }
  else if (isUnsigned(op_ct.colDataType))
  {
#ifndef __LP64__
    snprintf(tmp, 511, "%llu", getUintVal(row, parm, isNull, op_ct));
#else
    snprintf(tmp, 511, "%lu", getUintVal(row, parm, isNull, op_ct));
#endif
  }
  else
  {
#ifndef __LP64__
    snprintf(tmp, 511, "%lld", getIntVal(row, parm, isNull, op_ct));
#else
    snprintf(tmp, 511, "%ld", getIntVal(row, parm, isNull, op_ct));
#endif
  }

  return string(tmp);
}

IDB_Decimal Func_ceil::getDecimalVal(Row& row, FunctionParm& parm, bool& isNull,
                                     CalpontSystemCatalog::ColType& op_ct)
{
  // Questionable approach. I believe we should use pointer here
  // and call an appropriate ctor
  IDB_Decimal ret;

  switch (op_ct.colDataType)
  {
    case execplan::CalpontSystemCatalog::BIGINT:
    case execplan::CalpontSystemCatalog::INT:
    case execplan::CalpontSystemCatalog::MEDINT:
    case execplan::CalpontSystemCatalog::TINYINT:
    case execplan::CalpontSystemCatalog::SMALLINT:
    {
      ret.value = parm[0]->data()->getIntVal(row, isNull);
    }
    break;

    case execplan::CalpontSystemCatalog::DECIMAL:
    case execplan::CalpontSystemCatalog::UDECIMAL:
    {
      ret = parm[0]->data()->getDecimalVal(row, isNull);

      if (isNull)
        break;

      // negative scale is not supported by CNX yet
      if (ret.scale > 0)
      {
        if (ret.scale > datatypes::INT128MAXPRECISION)
        {
          std::ostringstream oss;
          oss << "ceil: datatype of " << execplan::colDataTypeToString(op_ct.colDataType) << " with scale "
              << (int)ret.scale << " is beyond supported scale";
          throw logging::IDBExcept(oss.str(), ERR_DATATYPE_NOT_SUPPORT);
        }
        return ret.ceil();
      }
    }
    break;

    case execplan::CalpontSystemCatalog::UBIGINT:
    case execplan::CalpontSystemCatalog::UINT:
    case execplan::CalpontSystemCatalog::UMEDINT:
    case execplan::CalpontSystemCatalog::UTINYINT:
    case execplan::CalpontSystemCatalog::USMALLINT:
    {
      ret.value = (int64_t)parm[0]->data()->getUintVal(row, isNull);
    }
    break;

    case execplan::CalpontSystemCatalog::DOUBLE:
    case execplan::CalpontSystemCatalog::UDOUBLE:
    case execplan::CalpontSystemCatalog::FLOAT:
    case execplan::CalpontSystemCatalog::UFLOAT:
    {
      ret.value = (int64_t)ceil(parm[0]->data()->getDoubleVal(row, isNull));
    }
    break;

    case execplan::CalpontSystemCatalog::LONGDOUBLE:
    {
      ret.value = (int64_t)ceill(parm[0]->data()->getLongDoubleVal(row, isNull));
    }
    break;

    case execplan::CalpontSystemCatalog::VARCHAR:
    case execplan::CalpontSystemCatalog::CHAR:
    case execplan::CalpontSystemCatalog::TEXT:
    {
      const auto& str = parm[0]->data()->getStrVal(row, isNull);

      if (!isNull)
        ret.value = (int64_t)ceil(strtod(str.str(), 0));
    }
    break;

    case CalpontSystemCatalog::DATE:
    {
      Date d(parm[0]->data()->getDateIntVal(row, isNull));

      if (!isNull)
        ret.value = d.convertToMySQLint();
    }
    break;

    case CalpontSystemCatalog::DATETIME:
    {
      DateTime dt(ceilDateTime(row, parm, isNull));

      if (!isNull)
        ret.value = dt.convertToMySQLint();
    }
    break;

    case CalpontSystemCatalog::TIMESTAMP:
    {
      TimeStamp dt(ceilTimeStamp(row, parm, isNull));

      if (!isNull)
        ret.value = dt.convertToMySQLint(op_ct.getTimeZone());
    }
    break;

    case CalpontSystemCatalog::TIME:
    {
      Time dt(ceilTime(row, parm, isNull));

      if (!isNull)
        ret.value = dt.convertToMySQLint();
    }
    break;

    default:
    {
      std::ostringstream oss;
      oss << "ceil: datatype of " << colDataTypeToString(op_ct.colDataType) << " is not supported";
      throw logging::IDBExcept(oss.str(), ERR_DATATYPE_NOT_SUPPORT);
    }
  }

  ret.scale = 0;

  return ret;
}

}  // namespace funcexp