sqltypes.h File Reference

Constants for Builtin SQL Types supported by OmniSci. More...

#include "Logger/Logger.h"
#include "StringTransform.h"
#include "funcannotations.h"
#include <cassert>
#include <cfloat>
#include <cstdint>
#include <ctime>
#include <limits>
#include <memory>
#include <string>
#include <type_traits>
#include <vector>
#include <string_view>
#include "../QueryEngine/DateAdd.h"
#include "../QueryEngine/DateTruncate.h"
#include "../QueryEngine/ExtractFromTime.h"
#include "InlineNullValues.h"

Include dependency graph for sqltypes.h:

This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Classes
struct	VarlenDatum
struct	DoNothingDeleter
struct	FreeDeleter
struct	HostArrayDatum
struct	DeviceArrayDatum
union	Datum
union	DataBlockPtr
class	SQLTypeInfo

Macros
#define	IS_INTEGER(T)   (((T) == kINT) || ((T) == kSMALLINT) || ((T) == kBIGINT) || ((T) == kTINYINT))
#define	IS_NUMBER(T)
#define	IS_STRING(T)   (((T) == kTEXT) || ((T) == kVARCHAR) || ((T) == kCHAR))
#define	IS_GEO(T)   (((T) == kPOINT) || ((T) == kLINESTRING) || ((T) == kPOLYGON) || ((T) == kMULTIPOLYGON))
#define	IS_INTERVAL(T)   ((T) == kINTERVAL_DAY_TIME || (T) == kINTERVAL_YEAR_MONTH)
#define	IS_DECIMAL(T)   ((T) == kNUMERIC || (T) == kDECIMAL)
#define	IS_GEO_POLY(T)   (((T) == kPOLYGON) || ((T) == kMULTIPOLYGON))
#define	NULL_BOOLEAN   INT8_MIN
#define	NULL_TINYINT   INT8_MIN
#define	NULL_SMALLINT   INT16_MIN
#define	NULL_INT   INT32_MIN
#define	NULL_BIGINT   INT64_MIN
#define	NULL_FLOAT   FLT_MIN
#define	NULL_DOUBLE   DBL_MIN
#define	NULL_ARRAY_BOOLEAN   (INT8_MIN + 1)
#define	NULL_ARRAY_TINYINT   (INT8_MIN + 1)
#define	NULL_ARRAY_SMALLINT   (INT16_MIN + 1)
#define	NULL_ARRAY_INT   (INT32_MIN + 1)
#define	NULL_ARRAY_BIGINT   (INT64_MIN + 1)
#define	NULL_ARRAY_FLOAT   (FLT_MIN * 2.0)
#define	NULL_ARRAY_DOUBLE   (DBL_MIN * 2.0)
#define	NULL_ARRAY_COMPRESSED_32   0x80000000U
#define	TRANSIENT_DICT_ID   0
#define	TRANSIENT_DICT(ID)   (-(ID))
#define	REGULAR_DICT(TRANSIENTID)   (-(TRANSIENTID))

Typedefs
using	ArrayDatum = std::conditional_t< is_cuda_compiler(), DeviceArrayDatum, HostArrayDatum >
using	StringOffsetT = int32_t
using	ArrayOffsetT = int32_t

Enumerations
enum	SQLTypes {   kNULLT = 0, kBOOLEAN = 1, kCHAR = 2, kVARCHAR = 3,   kNUMERIC = 4, kDECIMAL = 5, kINT = 6, kSMALLINT = 7,   kFLOAT = 8, kDOUBLE = 9, kTIME = 10, kTIMESTAMP = 11,   kBIGINT = 12, kTEXT = 13, kDATE = 14, kARRAY = 15,   kINTERVAL_DAY_TIME = 16, kINTERVAL_YEAR_MONTH = 17, kPOINT = 18, kLINESTRING = 19,   kPOLYGON = 20, kMULTIPOLYGON = 21, kTINYINT = 22, kGEOMETRY = 23,   kGEOGRAPHY = 24, kEVAL_CONTEXT_TYPE = 25, kVOID = 26, kCURSOR = 27,   kCOLUMN = 28, kSQLTYPE_LAST = 29 }
enum	EncodingType {   kENCODING_NONE = 0, kENCODING_FIXED = 1, kENCODING_RL = 2, kENCODING_DIFF = 3,   kENCODING_DICT = 4, kENCODING_SPARSE = 5, kENCODING_GEOINT = 6, kENCODING_DATE_IN_DAYS = 7,   kENCODING_LAST = 8 }

Functions
std::string	toString (const SQLTypes &type)
DEVICE constexpr bool	is_cuda_compiler ()
constexpr auto	is_datetime (SQLTypes type)
SQLTypes	decimal_to_int_type (const SQLTypeInfo &)
Datum	StringToDatum (std::string_view s, SQLTypeInfo &ti)
std::string	DatumToString (Datum d, const SQLTypeInfo &ti)
bool	DatumEqual (const Datum, const Datum, const SQLTypeInfo &ti)
int64_t	convert_decimal_value_to_scale (const int64_t decimal_value, const SQLTypeInfo &type_info, const SQLTypeInfo &new_type_info)
SQLTypeInfo	get_logical_type_info (const SQLTypeInfo &type_info)
SQLTypeInfo	get_nullable_type_info (const SQLTypeInfo &type_info)
SQLTypeInfo	get_nullable_logical_type_info (const SQLTypeInfo &type_info)
template<class T >
constexpr int64_t	inline_int_null_value ()
template<class T >
constexpr int64_t	inline_int_null_array_value ()
template<class T >
constexpr int64_t	max_valid_int_value ()
int8_t *	appendDatum (int8_t *buf, Datum d, const SQLTypeInfo &ti)

Detailed Description

Constants for Builtin SQL Types supported by OmniSci.

Author

Wei Hong wei@m.nosp@m.ap-d.nosp@m..com

Definition in file sqltypes.h.

Macro Definition Documentation

#define IS_DECIMAL

(

T

)

((T) == kNUMERIC || (T) == kDECIMAL)

Definition at line 248 of file sqltypes.h.

#define IS_GEO

(

T

)

(((T) == kPOINT) || ((T) == kLINESTRING) || ((T) == kPOLYGON) || ((T) == kMULTIPOLYGON))

Definition at line 245 of file sqltypes.h.

Referenced by DBHandler::detect_column_types(), Catalog_Namespace::Catalog::expandGeoColumn(), SQLTypeInfo::get_type_name(), Executor::getColLazyFetchInfo(), JsonColumnSqlType::getParam1(), JsonColumnSqlType::getParam2(), import_export::import_thread_delimited(), SQLTypeInfo::is_geometry(), SQLTypeInfo::is_varlen(), ResultSet::isGeoColOnGpu(), DBHandler::populateThriftColumnType(), foreign_storage::csv_file_buffer_parser::process_geo_column(), ThriftSerializers::target_meta_info_to_thrift(), thrift_to_name(), SQLTypeInfo::transforms(), RelAlgTranslator::translateGeoColumn(), RelAlgTranslator::translateGeoFunctionArg(), type_info_from_thrift(), ThriftSerializers::type_info_to_thrift(), ddl_utils::validate_and_set_type(), and anonymous_namespace{RelAlgExecutor.cpp}::RexUsedInputsVisitor::visitInput().

#define IS_GEO_POLY

(

T

)

(((T) == kPOLYGON) || ((T) == kMULTIPOLYGON))

Definition at line 249 of file sqltypes.h.

Referenced by CodeGenerator::codegenOverlaps(), and RelAlgTranslator::translateUnaryGeoFunction().

#define IS_INTEGER

(

T

)

(((T) == kINT) || ((T) == kSMALLINT) || ((T) == kBIGINT) || ((T) == kTINYINT))

Definition at line 239 of file sqltypes.h.

Referenced by anonymous_namespace{ArrowResultSetConverter.cpp}::get_physical_type(), getArrowImportType(), SQLTypeInfo::is_integer(), and ddl_utils::validate_and_set_fixed_encoding().

#define IS_INTERVAL

(

T

)

((T) == kINTERVAL_DAY_TIME || (T) == kINTERVAL_YEAR_MONTH)

Definition at line 247 of file sqltypes.h.

Referenced by SQLTypeInfo::is_timeinterval().

#define IS_NUMBER

(

T

)

Value:

(((T) == kINT) || ((T) == kSMALLINT) || ((T) == kDOUBLE) || ((T) == kFLOAT) || \
   ((T) == kBIGINT) || ((T) == kNUMERIC) || ((T) == kDECIMAL) || ((T) == kTINYINT))

Definition at line 241 of file sqltypes.h.

Referenced by SQLTypeInfo::is_number(), and anonymous_namespace{EquiJoinCondition.cpp}::make_composite_equals_impl().

#define IS_STRING

(

T

)

(((T) == kTEXT) || ((T) == kVARCHAR) || ((T) == kCHAR))

Definition at line 244 of file sqltypes.h.

Referenced by import_export::TypedImportBuffer::add_value(), import_export::TypedImportBuffer::add_values(), import_export::TypedImportBuffer::clear(), foreign_storage::csv_file_buffer_parser::convert_import_buffers_to_data_blocks(), Encoder::Create(), import_export::Loader::distributeToShards(), import_export::Detector::find_best_encodings(), import_export::Loader::get_data_block_pointers(), import_export::Loader::getStringDict(), SQLTypeInfo::is_string(), SQLTypeInfo::is_string_array(), SQLTypeInfo::is_varlen(), anonymous_namespace{EquiJoinCondition.cpp}::make_composite_equals_impl(), import_export::TypedImportBuffer::pop_value(), import_export::TypedImportBuffer::TypedImportBuffer(), and import_export::TypedImportBuffer::~TypedImportBuffer().

#define NULL_ARRAY_BIGINT   (INT64_MIN + 1)

Definition at line 263 of file sqltypes.h.

Referenced by FixedLengthArrayNoneEncoder::is_null(), and SQLTypeInfo::is_null_fixlen_array().

#define NULL_ARRAY_BOOLEAN   (INT8_MIN + 1)

Definition at line 259 of file sqltypes.h.

Referenced by FixedLengthArrayNoneEncoder::is_null().

#define NULL_ARRAY_COMPRESSED_32   0x80000000U

Definition at line 267 of file sqltypes.h.

Referenced by SQLTypeInfo::is_null_point_coord_array().

#define NULL_ARRAY_DOUBLE   (DBL_MIN * 2.0)

Definition at line 265 of file sqltypes.h.

Referenced by Parser::InsertValuesStmt::analyze(), Geospatial::compress_coords(), Geospatial::compress_null_point(), GeoPointValueConverter::convertToColumnarFormat(), GeoLinestringValueConverter::convertToColumnarFormat(), GeoPolygonValueConverter::convertToColumnarFormat(), GeoMultiPolygonValueConverter::convertToColumnarFormat(), Geospatial::GeoTypesFactory::getNullGeoColumns(), inline_fp_null_array_value< double >(), FixedLengthArrayNoneEncoder::is_null(), SQLTypeInfo::is_null_fixlen_array(), Geospatial::is_null_point(), SQLTypeInfo::is_null_point_coord_array(), import_export::NullArrayDatum(), import_export::Importer::set_geo_physical_import_buffer(), import_export::Importer::set_geo_physical_import_buffer_columnar(), and foreign_storage::ParquetFixedLengthArrayEncoder::setNullFixedLengthArraySentinel().

#define NULL_ARRAY_FLOAT   (FLT_MIN * 2.0)

Definition at line 264 of file sqltypes.h.

Referenced by inline_fp_null_array_value< float >(), FixedLengthArrayNoneEncoder::is_null(), SQLTypeInfo::is_null_fixlen_array(), import_export::NullArrayDatum(), and foreign_storage::ParquetFixedLengthArrayEncoder::setNullFixedLengthArraySentinel().

#define NULL_ARRAY_INT   (INT32_MIN + 1)

Definition at line 262 of file sqltypes.h.

Referenced by FixedLengthArrayNoneEncoder::is_null(), and SQLTypeInfo::is_null_fixlen_array().

#define NULL_ARRAY_SMALLINT   (INT16_MIN + 1)

Definition at line 261 of file sqltypes.h.

Referenced by FixedLengthArrayNoneEncoder::is_null(), and SQLTypeInfo::is_null_fixlen_array().

#define NULL_ARRAY_TINYINT   (INT8_MIN + 1)

Definition at line 260 of file sqltypes.h.

Referenced by FixedLengthArrayNoneEncoder::is_null(), and SQLTypeInfo::is_null_fixlen_array().

#define NULL_BIGINT   INT64_MIN

Definition at line 255 of file sqltypes.h.

Referenced by datum_to_string(), import_export::QueryExporterCSV::exportResults(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_array_column(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_scalar_column(), SQLTypeInfo::is_null(), Analyzer::anonymous_namespace{Analyzer.cpp}::is_null_value(), result_set::lazy_decode(), Analyzer::Constant::set_null_value(), FixedLengthArrayNoneEncoder::update_elem_stats(), ArrayNoneEncoder::update_elem_stats(), DBHandler::value_to_thrift(), and DBHandler::value_to_thrift_column().

#define NULL_BOOLEAN   INT8_MIN

Definition at line 251 of file sqltypes.h.

Referenced by datum_to_string(), import_export::QueryExporterCSV::exportResults(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_array_column(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_scalar_column(), SQLTypeInfo::is_null(), Analyzer::anonymous_namespace{Analyzer.cpp}::is_null_value(), Analyzer::Constant::set_null_value(), FixedLengthArrayNoneEncoder::update_elem_stats(), ArrayNoneEncoder::update_elem_stats(), DBHandler::value_to_thrift(), and DBHandler::value_to_thrift_column().

#define NULL_DOUBLE   DBL_MIN

Definition at line 257 of file sqltypes.h.

Referenced by import_export::TypedImportBuffer::add_value(), import_export::TypedImportBuffer::add_values(), Parser::InsertValuesStmt::analyze(), CodeGenerator::codegenDiv(), CodeGenerator::codegenFpArith(), CodeGenerator::codegenIsNullNumber(), Geospatial::compress_null_point(), GeoPointValueConverter::convertToColumnarFormat(), GeoLinestringValueConverter::convertToColumnarFormat(), GeoPolygonValueConverter::convertToColumnarFormat(), GeoMultiPolygonValueConverter::convertToColumnarFormat(), import_export::QueryExporterCSV::exportResults(), float_to_double_bin(), Geospatial::GeoPoint::getColumns(), Geospatial::GeoLineString::getColumns(), Geospatial::GeoPolygon::getColumns(), Geospatial::GeoMultiPolygon::getColumns(), Geospatial::GeoTypesFactory::getNullGeoColumns(), inline_fp_null_value< double >(), CgenState::inlineFpNull(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_array_column(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_scalar_column(), SQLTypeInfo::is_null(), Analyzer::anonymous_namespace{Analyzer.cpp}::is_null_value(), ResultSet::isNull(), ResultSet::makeTargetValue(), import_export::NullDatum(), import_export::Importer::set_geo_physical_import_buffer(), import_export::Importer::set_geo_physical_import_buffer_columnar(), Analyzer::Constant::set_null_value(), import_export::TDatumToDatum(), FixedLengthArrayNoneEncoder::update_elem_stats(), ArrayNoneEncoder::update_elem_stats(), DBHandler::value_to_thrift(), and DBHandler::value_to_thrift_column().

#define NULL_FLOAT   FLT_MIN

Definition at line 256 of file sqltypes.h.

Referenced by import_export::TypedImportBuffer::add_value(), import_export::TypedImportBuffer::add_values(), CodeGenerator::codegenDiv(), CodeGenerator::codegenFpArith(), CodeGenerator::codegenIsNullNumber(), import_export::QueryExporterCSV::exportResults(), float_to_double_bin(), inline_fp_null_value< float >(), CgenState::inlineFpNull(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_array_column(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_scalar_column(), SQLTypeInfo::is_null(), Analyzer::anonymous_namespace{Analyzer.cpp}::is_null_value(), import_export::NullDatum(), Analyzer::Constant::set_null_value(), import_export::TDatumToDatum(), FixedLengthArrayNoneEncoder::update_elem_stats(), ArrayNoneEncoder::update_elem_stats(), DBHandler::value_to_thrift(), and DBHandler::value_to_thrift_column().

#define NULL_INT   INT32_MIN

Definition at line 254 of file sqltypes.h.

Referenced by anonymous_namespace{ResultSetIteration.cpp}::build_string_array_target_value(), GeoPolygonValueConverter::convertToColumnarFormat(), GeoMultiPolygonValueConverter::convertToColumnarFormat(), DictionaryConverterFactory< TARGET_TYPE >::create(), import_export::QueryExporterCSV::exportResults(), JoinColumnIterator::getElementSwitch(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_array_column(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_scalar_column(), SQLTypeInfo::is_null(), Analyzer::anonymous_namespace{Analyzer.cpp}::is_null_value(), result_set::lazy_decode(), ResultSet::makeTargetValue(), Analyzer::Constant::set_null_value(), string_decompress(), FixedLengthArrayNoneEncoder::update_elem_stats(), ArrayNoneEncoder::update_elem_stats(), DBHandler::value_to_thrift(), and DBHandler::value_to_thrift_column().

#define NULL_SMALLINT   INT16_MIN

Definition at line 253 of file sqltypes.h.

Referenced by import_export::QueryExporterCSV::exportResults(), JoinColumnIterator::getElementSwitch(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_array_column(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_scalar_column(), SQLTypeInfo::is_null(), Analyzer::anonymous_namespace{Analyzer.cpp}::is_null_value(), result_set::lazy_decode(), Analyzer::Constant::set_null_value(), FixedLengthArrayNoneEncoder::update_elem_stats(), ArrayNoneEncoder::update_elem_stats(), DBHandler::value_to_thrift(), and DBHandler::value_to_thrift_column().

#define NULL_TINYINT   INT8_MIN

Definition at line 252 of file sqltypes.h.

Referenced by import_export::QueryExporterCSV::exportResults(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_array_column(), import_export::anonymous_namespace{QueryExporterGDAL.cpp}::insert_scalar_column(), SQLTypeInfo::is_null(), Analyzer::anonymous_namespace{Analyzer.cpp}::is_null_value(), Analyzer::Constant::set_null_value(), FixedLengthArrayNoneEncoder::update_elem_stats(), ArrayNoneEncoder::update_elem_stats(), DBHandler::value_to_thrift(), and DBHandler::value_to_thrift_column().

#define REGULAR_DICT

(

TRANSIENTID

)

(-(TRANSIENTID))

Definition at line 271 of file sqltypes.h.

Referenced by Executor::getStringDictionaryProxy().

#define TRANSIENT_DICT

(

ID

)

(-(ID))

Definition at line 270 of file sqltypes.h.

Referenced by Analyzer::Expr::add_cast(), Analyzer::UOper::add_cast(), Analyzer::CaseExpr::add_cast(), Analyzer::BinOper::common_string_type(), SQLTypeInfo::operator!=(), and SQLTypeInfo::operator==().

#define TRANSIENT_DICT_ID   0

Definition at line 269 of file sqltypes.h.

Referenced by Analyzer::Expr::add_cast(), Analyzer::CaseExpr::add_cast(), Parser::QuerySpec::analyze_group_by(), anonymous_namespace{RelAlgExecutor.cpp}::set_transient_dict(), RelAlgTranslator::translateArrayFunction(), and anonymous_namespace{ExpressionRewrite.cpp}::ArrayElementStringLiteralEncodingVisitor::visitArrayOper().

Typedef Documentation

using ArrayDatum = std::conditional_t<is_cuda_compiler(), DeviceArrayDatum, HostArrayDatum>

Definition at line 202 of file sqltypes.h.

using ArrayOffsetT = int32_t

Definition at line 948 of file sqltypes.h.

using StringOffsetT = int32_t

Definition at line 947 of file sqltypes.h.

Enumeration Type Documentation

enum EncodingType

Enumerator
kENCODING_NONE
kENCODING_FIXED
kENCODING_RL
kENCODING_DIFF
kENCODING_DICT
kENCODING_SPARSE
kENCODING_GEOINT
kENCODING_DATE_IN_DAYS
kENCODING_LAST

Definition at line 227 of file sqltypes.h.

                  {
  kENCODING_NONE = 0,          // no encoding
  kENCODING_FIXED = 1,         // Fixed-bit encoding
  kENCODING_RL = 2,            // Run Length encoding
  kENCODING_DIFF = 3,          // Differential encoding
  kENCODING_DICT = 4,          // Dictionary encoding
  kENCODING_SPARSE = 5,        // Null encoding for sparse columns
  kENCODING_GEOINT = 6,        // Encoding coordinates as intergers
  kENCODING_DATE_IN_DAYS = 7,  // Date encoding in days
  kENCODING_LAST = 8
};

enum SQLTypes

Enumerator
kNULLT
kBOOLEAN
kCHAR
kVARCHAR
kNUMERIC
kDECIMAL
kINT
kSMALLINT
kFLOAT
kDOUBLE
kTIME
kTIMESTAMP
kBIGINT
kTEXT
kDATE
kARRAY
kINTERVAL_DAY_TIME
kINTERVAL_YEAR_MONTH
kPOINT
kLINESTRING
kPOLYGON
kMULTIPOLYGON
kTINYINT
kGEOMETRY
kGEOGRAPHY
kEVAL_CONTEXT_TYPE
kVOID
kCURSOR
kCOLUMN
kSQLTYPE_LAST

Definition at line 40 of file sqltypes.h.

              {
  kNULLT = 0,  // type for null values
  kBOOLEAN = 1,
  kCHAR = 2,
  kVARCHAR = 3,
  kNUMERIC = 4,
  kDECIMAL = 5,
  kINT = 6,
  kSMALLINT = 7,
  kFLOAT = 8,
  kDOUBLE = 9,
  kTIME = 10,
  kTIMESTAMP = 11,
  kBIGINT = 12,
  kTEXT = 13,
  kDATE = 14,
  kARRAY = 15,
  kINTERVAL_DAY_TIME = 16,
  kINTERVAL_YEAR_MONTH = 17,
  kPOINT = 18,
  kLINESTRING = 19,
  kPOLYGON = 20,
  kMULTIPOLYGON = 21,
  kTINYINT = 22,
  kGEOMETRY = 23,
  kGEOGRAPHY = 24,
  kEVAL_CONTEXT_TYPE = 25,  // Placeholder Type for ANY
  kVOID = 26,
  kCURSOR = 27,
  kCOLUMN = 28,
  kSQLTYPE_LAST = 29
};

Function Documentation

int8_t* appendDatum ( int8_t *  buf, Datum  d, const SQLTypeInfo &  ti  )

inline

Definition at line 950 of file sqltypes.h.

References Datum::bigintval, Datum::boolval, Datum::doubleval, Datum::floatval, SQLTypeInfo::get_type(), Datum::intval, kBIGINT, kBOOLEAN, kDATE, kDECIMAL, kDOUBLE, kFLOAT, kINT, kNUMERIC, kSMALLINT, kTIME, kTIMESTAMP, kTINYINT, Datum::smallintval, and Datum::tinyintval.

Referenced by RelAlgExecutor::executeSimpleInsert(), import_export::NullArray(), import_export::StringToArray(), and import_export::TDatumToArrayDatum().

                                                                        {
  switch (ti.get_type()) {
    case kBOOLEAN:
      *(bool*)buf = d.boolval;
      return buf + sizeof(bool);
    case kNUMERIC:
    case kDECIMAL:
    case kBIGINT:
      *(int64_t*)buf = d.bigintval;
      return buf + sizeof(int64_t);
    case kINT:
      *(int32_t*)buf = d.intval;
      return buf + sizeof(int32_t);
    case kSMALLINT:
      *(int16_t*)buf = d.smallintval;
      return buf + sizeof(int16_t);
    case kTINYINT:
      *(int8_t*)buf = d.tinyintval;
      return buf + sizeof(int8_t);
    case kFLOAT:
      *(float*)buf = d.floatval;
      return buf + sizeof(float);
    case kDOUBLE:
      *(double*)buf = d.doubleval;
      return buf + sizeof(double);
    case kTIME:
    case kTIMESTAMP:
    case kDATE:
      *reinterpret_cast<int64_t*>(buf) = d.bigintval;
      return buf + sizeof(int64_t);
    default:
      return nullptr;
  }
}

Here is the call graph for this function:

Here is the caller graph for this function:

int64_t convert_decimal_value_to_scale	(	const int64_t	decimal_value,
		const SQLTypeInfo &	type_info,
		const SQLTypeInfo &	new_type_info
	)

Definition at line 318 of file Datum.cpp.

References SQLTypeInfo::get_scale().

Referenced by import_export::TypedImportBuffer::add_value(), Analyzer::Constant::cast_number(), anonymous_namespace{ArrowImporter.h}::ArrowValue< arrow::Decimal128 >::operator const DATA_TYPE(), and anonymous_namespace{TypedDataAccessors.h}::put_scalar().

                                                                         {
  auto converted_decimal_value = decimal_value;
  if (new_type_info.get_scale() > type_info.get_scale()) {
    for (int i = 0; i < new_type_info.get_scale() - type_info.get_scale(); i++) {
      converted_decimal_value *= 10;
    }
  } else if (new_type_info.get_scale() < type_info.get_scale()) {
    for (int i = 0; i < type_info.get_scale() - new_type_info.get_scale(); i++) {
      if (converted_decimal_value > 0) {
        converted_decimal_value = (converted_decimal_value + 5) / 10;
      } else {
        converted_decimal_value = (converted_decimal_value - 5) / 10;
      }
    }
  }
  return converted_decimal_value;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool DatumEqual	(	const Datum	,
		const Datum	,
		const SQLTypeInfo &	ti
	)

Definition at line 189 of file Datum.cpp.

References Datum::bigintval, Datum::boolval, Datum::doubleval, Datum::floatval, SQLTypeInfo::get_compression(), SQLTypeInfo::get_type(), Datum::intval, kBIGINT, kBOOLEAN, kCHAR, kDATE, kDECIMAL, kDOUBLE, kENCODING_DICT, kFLOAT, kINT, kINTERVAL_DAY_TIME, kINTERVAL_YEAR_MONTH, kLINESTRING, kMULTIPOLYGON, kNUMERIC, kPOINT, kPOLYGON, kSMALLINT, kTEXT, kTIME, kTIMESTAMP, kTINYINT, kVARCHAR, Datum::smallintval, Datum::stringval, and Datum::tinyintval.

Referenced by ChunkMetadata::operator==().

                                                                     {
  switch (ti.get_type()) {
    case kBOOLEAN:
      return a.boolval == b.boolval;
    case kBIGINT:
    case kNUMERIC:
    case kDECIMAL:
      return a.bigintval == b.bigintval;
    case kINT:
      return a.intval == b.intval;
    case kSMALLINT:
      return a.smallintval == b.smallintval;
    case kTINYINT:
      return a.tinyintval == b.tinyintval;
    case kFLOAT:
      return a.floatval == b.floatval;
    case kDOUBLE:
      return a.doubleval == b.doubleval;
    case kTIME:
    case kTIMESTAMP:
    case kDATE:
    case kINTERVAL_DAY_TIME:
    case kINTERVAL_YEAR_MONTH:
      return a.bigintval == b.bigintval;
    case kTEXT:
    case kVARCHAR:
    case kCHAR:
    case kPOINT:
    case kLINESTRING:
    case kPOLYGON:
    case kMULTIPOLYGON:
      if (ti.get_compression() == kENCODING_DICT) {
        return a.intval == b.intval;
      }
      if (a.stringval == nullptr && b.stringval == nullptr) {
        return true;
      }
      if (a.stringval == nullptr || b.stringval == nullptr) {
        return false;
      }
      return *a.stringval == *b.stringval;
    default:
      return false;
  }
  return false;
}

Here is the call graph for this function:

Here is the caller graph for this function:

std::string DatumToString	(	Datum	d,
		const SQLTypeInfo &	ti
	)

Definition at line 239 of file Datum.cpp.

References Datum::bigintval, Datum::boolval, CHECK_EQ, CHECK_LE, CHECK_LT, Datum::doubleval, Datum::floatval, shared::formatDate(), shared::formatDateTime(), shared::formatHMS(), SQLTypeInfo::get_dimension(), SQLTypeInfo::get_scale(), SQLTypeInfo::get_type(), SQLTypeInfo::get_type_name(), Datum::intval, kBIGINT, kBOOLEAN, kCHAR, kDATE, kDECIMAL, kDOUBLE, kFLOAT, kINT, kINTERVAL_DAY_TIME, kINTERVAL_YEAR_MONTH, kNUMERIC, kSMALLINT, kTEXT, kTIME, kTIMESTAMP, kTINYINT, kVARCHAR, Datum::smallintval, Datum::stringval, Datum::tinyintval, to_string(), and SQLTypeInfo::to_string().

Referenced by Analyzer::Constant::cast_to_string(), datum_to_string(), ChunkMetadata::dump(), anonymous_namespace{ArrowImporter.h}::ArrowValue< int64_t >::operator const std::string(), Analyzer::Constant::toString(), Fragmenter_Namespace::InsertOrderFragmenter::updateChunkStats(), and ScalarExprToSql::visitConstant().

                                                        {
  constexpr size_t buf_size = 64;
  char buf[buf_size];  // Hold "2000-03-01 12:34:56.123456789" and large years.
  switch (ti.get_type()) {
    case kBOOLEAN:
      if (d.boolval) {
        return "t";
      }
      return "f";
    case kNUMERIC:
    case kDECIMAL: {
      double v = (double)d.bigintval / pow(10, ti.get_scale());
      int size = snprintf(buf, buf_size, "%*.*f", ti.get_dimension(), ti.get_scale(), v);
      CHECK_LE(0, size) << v << ' ' << ti.to_string();
      CHECK_LT(size_t(size), buf_size) << v << ' ' << ti.to_string();
      return buf;
    }
    case kINT:
      return std::to_string(d.intval);
    case kSMALLINT:
      return std::to_string(d.smallintval);
    case kTINYINT:
      return std::to_string(d.tinyintval);
    case kBIGINT:
      return std::to_string(d.bigintval);
    case kFLOAT:
      return std::to_string(d.floatval);
    case kDOUBLE:
      return std::to_string(d.doubleval);
    case kTIME: {
      size_t const len = shared::formatHMS(buf, buf_size, d.bigintval);
      CHECK_EQ(8u, len);  // 8 == strlen("HH:MM:SS")
      return buf;
    }
    case kTIMESTAMP: {
      unsigned const dim = ti.get_dimension();  // assumes dim <= 9
      size_t const len = shared::formatDateTime(buf, buf_size, d.bigintval, dim);
      CHECK_LE(19u + bool(dim) + dim, len);  // 19 = strlen("YYYY-MM-DD HH:MM:SS")
      return buf;
    }
    case kDATE: {
      size_t const len = shared::formatDate(buf, buf_size, d.bigintval);
      CHECK_LE(10u, len);  // 10 == strlen("YYYY-MM-DD")
      return buf;
    }
    case kINTERVAL_DAY_TIME:
      return std::to_string(d.bigintval) + " ms (day-time interval)";
    case kINTERVAL_YEAR_MONTH:
      return std::to_string(d.bigintval) + " month(s) (year-month interval)";
    case kTEXT:
    case kVARCHAR:
    case kCHAR:
      if (d.stringval == nullptr) {
        return "NULL";
      }
      return *d.stringval;
    default:
      throw std::runtime_error("Internal error: invalid type " + ti.get_type_name() +
                               " in DatumToString.");
  }
  return "";
}

Here is the call graph for this function:

Here is the caller graph for this function:

SQLTypes decimal_to_int_type

(

const SQLTypeInfo &

)

Definition at line 302 of file Datum.cpp.

References CHECK, SQLTypeInfo::get_size(), kBIGINT, kINT, kNULLT, kSMALLINT, and kTINYINT.

Referenced by import_export::TypedImportBuffer::add_value(), CodeGenerator::codegen(), CodeGenerator::codegenIntConst(), anonymous_namespace{LogicalIR.cpp}::contains_unsafe_division(), import_export::Loader::distributeToShards(), extract_from_datum(), anonymous_namespace{ColumnIR.cpp}::get_col_decoder(), CgenState::getOrAddLiteral(), ResultSet::makeTargetValue(), import_export::NullArrayDatum(), import_export::NullDatum(), import_export::TypedImportBuffer::pop_value(), import_export::TDatumToDatum(), anonymous_namespace{ExpressionRewrite.cpp}::ConstantFoldingVisitor::visitBinOper(), and anonymous_namespace{ExpressionRewrite.cpp}::ConstantFoldingVisitor::visitUOper().

                                                    {
  switch (ti.get_size()) {
    case 1:
      return kTINYINT;
    case 2:
      return kSMALLINT;
    case 4:
      return kINT;
    case 8:
      return kBIGINT;
    default:
      CHECK(false);
  }
  return kNULLT;
}

Here is the call graph for this function:

Here is the caller graph for this function:

SQLTypeInfo get_logical_type_info ( const SQLTypeInfo &  type_info )

inline

Definition at line 899 of file sqltypes.h.

References SQLTypeInfo::get_comp_param(), SQLTypeInfo::get_compression(), SQLTypeInfo::get_dimension(), SQLTypeInfo::get_notnull(), SQLTypeInfo::get_scale(), SQLTypeInfo::get_subtype(), SQLTypeInfo::get_type(), kARRAY, kENCODING_DATE_IN_DAYS, kENCODING_FIXED, and kENCODING_NONE.

Referenced by anonymous_namespace{ColumnarResults.cpp}::fixed_encoding_nullable_val(), anonymous_namespace{RelAlgExecutor.cpp}::get_logical_type_for_expr(), anonymous_namespace{TypedDataAccessors.h}::NullSentinelSupplier::get_null_sentinel_for_type(), get_nullable_logical_type_info(), get_target_info(), JoinHashTable::getHashJoinArgs(), getLeafColumnRange(), Parser::CaseExpr::normalize(), TableOptimizer::recomputeMetadata(), rows_to_columnar_results(), Fragmenter_Namespace::InsertOrderFragmenter::updateChunkStats(), and Fragmenter_Namespace::InsertOrderFragmenter::updateColumns().

                                                                       {
  EncodingType encoding = type_info.get_compression();
  if (encoding == kENCODING_DATE_IN_DAYS ||
      (encoding == kENCODING_FIXED && type_info.get_type() != kARRAY)) {
    encoding = kENCODING_NONE;
  }
  return SQLTypeInfo(type_info.get_type(),
                     type_info.get_dimension(),
                     type_info.get_scale(),
                     type_info.get_notnull(),
                     encoding,
                     type_info.get_comp_param(),
                     type_info.get_subtype());
}

Here is the call graph for this function:

Here is the caller graph for this function:

SQLTypeInfo get_nullable_logical_type_info ( const SQLTypeInfo &  type_info )

inline

Definition at line 920 of file sqltypes.h.

References get_logical_type_info(), and get_nullable_type_info().

Referenced by anonymous_namespace{RelAlgExecutor.cpp}::get_logical_type_for_expr(), and RelAlgTranslator::translateArrayFunction().

                                                                                {
  SQLTypeInfo nullable_type_info = get_logical_type_info(type_info);
  return get_nullable_type_info(nullable_type_info);
}

Here is the call graph for this function:

Here is the caller graph for this function:

SQLTypeInfo get_nullable_type_info ( const SQLTypeInfo &  type_info )

inline

Definition at line 914 of file sqltypes.h.

References SQLTypeInfo::set_notnull().

Referenced by CodeGenerator::createInValuesBitmap(), Analyzer::Constant::do_cast(), and get_nullable_logical_type_info().

                                                                        {
  SQLTypeInfo nullable_type_info = type_info;
  nullable_type_info.set_notnull(false);
  return nullable_type_info;
}

Here is the call graph for this function:

Here is the caller graph for this function:

template<class T >

constexpr int64_t inline_int_null_array_value ( )

inline

Definition at line 932 of file sqltypes.h.

                                                       {
  return std::is_signed<T>::value ? std::numeric_limits<T>::min() + 1
                                  : std::numeric_limits<T>::max() - 1;
  // TODO: null_array values in signed types would step on max valid value
  // in fixlen unsigned arrays, the max valid value may need to be lowered.
}

template<class T >

constexpr int64_t inline_int_null_value ( )

inline

Definition at line 926 of file sqltypes.h.

                                                 {
  return std::is_signed<T>::value ? std::numeric_limits<T>::min()
                                  : std::numeric_limits<T>::max();
}

DEVICE constexpr bool is_cuda_compiler ( )

inline

Definition at line 193 of file sqltypes.h.

                                                {
#ifdef __CUDACC__
  return true;
#else
  return false;
#endif
}

constexpr auto is_datetime

(

SQLTypes

type

)

Definition at line 273 of file sqltypes.h.

References kDATE, kTIME, and kTIMESTAMP.

Referenced by ArrowForeignStorageBase::generateNullValues(), ArrowForeignStorageBase::generateSentinelValues(), SQLTypeInfo::is_time(), RexLiteral::RexLiteral(), and ddl_utils::validate_and_set_fixed_encoding().

                                          {
  return type == kTIME || type == kTIMESTAMP || type == kDATE;
}

Here is the caller graph for this function:

template<class T >

constexpr int64_t max_valid_int_value ( )

inline

Definition at line 940 of file sqltypes.h.

                                               {
  return std::is_signed<T>::value ? std::numeric_limits<T>::max()
                                  : std::numeric_limits<T>::max() - 1;
}

Datum StringToDatum	(	std::string_view	s,
		SQLTypeInfo &	ti
	)

Definition at line 124 of file Datum.cpp.

References Datum::bigintval, Datum::boolval, dateTimeParse< kDATE >(), dateTimeParse< kTIME >(), dateTimeParse< kTIMESTAMP >(), Datum::doubleval, Datum::floatval, SQLTypeInfo::get_dimension(), SQLTypeInfo::get_type(), SQLTypeInfo::get_type_name(), Datum::intval, kARRAY, kBIGINT, kBOOLEAN, kCOLUMN, kDATE, kDECIMAL, kDOUBLE, kFLOAT, kINT, kLINESTRING, kMULTIPOLYGON, kNUMERIC, kPOINT, kPOLYGON, kSMALLINT, kTIME, kTIMESTAMP, kTINYINT, parse_numeric(), Datum::smallintval, Datum::tinyintval, and to_upper().

Referenced by import_export::TypedImportBuffer::add_value(), Parser::FixedPtLiteral::analyze(), Analyzer::Constant::cast_from_string(), anonymous_namespace{ArrowImporter.h}::ArrowValue< std::string >::operator const bool(), anonymous_namespace{ArrowImporter.h}::ArrowValue< std::string >::operator const DATA_TYPE(), populate_TColumn(), and import_export::StringToArray().

                                                       {
  Datum d;
  try {
    switch (ti.get_type()) {
      case kARRAY:
      case kCOLUMN:
        break;
      case kBOOLEAN:
        if (s == "t" || s == "T" || s == "1" || to_upper(std::string(s)) == "TRUE") {
          d.boolval = true;
        } else if (s == "f" || s == "F" || s == "0" ||
                   to_upper(std::string(s)) == "FALSE") {
          d.boolval = false;
        } else {
          throw std::runtime_error("Invalid string for boolean " + std::string(s));
        }
        break;
      case kNUMERIC:
      case kDECIMAL:
        d.bigintval = parse_numeric(s, ti);
        break;
      case kBIGINT:
        d.bigintval = std::stoll(std::string(s));
        break;
      case kINT:
        d.intval = std::stoi(std::string(s));
        break;
      case kSMALLINT:
        d.smallintval = std::stoi(std::string(s));
        break;
      case kTINYINT:
        d.tinyintval = std::stoi(std::string(s));
        break;
      case kFLOAT:
        d.floatval = std::stof(std::string(s));
        break;
      case kDOUBLE:
        d.doubleval = std::stod(std::string(s));
        break;
      case kTIME:
        d.bigintval = dateTimeParse<kTIME>(s, ti.get_dimension());
        break;
      case kTIMESTAMP:
        d.bigintval = dateTimeParse<kTIMESTAMP>(s, ti.get_dimension());
        break;
      case kDATE:
        d.bigintval = dateTimeParse<kDATE>(s, ti.get_dimension());
        break;
      case kPOINT:
      case kLINESTRING:
      case kPOLYGON:
      case kMULTIPOLYGON:
        throw std::runtime_error("Internal error: geometry type in StringToDatum.");
      default:
        throw std::runtime_error("Internal error: invalid type in StringToDatum.");
    }
  } catch (const std::invalid_argument&) {
    throw std::runtime_error("Invalid conversion from string to " + ti.get_type_name());
  } catch (const std::out_of_range&) {
    throw std::runtime_error("Got out of range error during conversion from string to " +
                             ti.get_type_name());
  }
  return d;
}

Here is the call graph for this function:

Here is the caller graph for this function:

std::string toString ( const SQLTypes &  type )

inline

Definition at line 75 of file sqltypes.h.

References logger::FATAL, kARRAY, kBIGINT, kBOOLEAN, kCHAR, kCOLUMN, kCURSOR, kDATE, kDECIMAL, kDOUBLE, kEVAL_CONTEXT_TYPE, kFLOAT, kGEOGRAPHY, kGEOMETRY, kINT, kINTERVAL_DAY_TIME, kINTERVAL_YEAR_MONTH, kLINESTRING, kMULTIPOLYGON, kNULLT, kNUMERIC, kPOINT, kPOLYGON, kSMALLINT, kSQLTYPE_LAST, kTEXT, kTIME, kTIMESTAMP, kTINYINT, kVARCHAR, kVOID, LOG, and run_benchmark_import::type.

                                                {
  switch (type) {
    case kNULLT:
      return "NULL";
    case kBOOLEAN:
      return "BOOL";
    case kCHAR:
      return "CHAR";
    case kVARCHAR:
      return "VARCHAR";
    case kNUMERIC:
      return "NUMERIC";
    case kDECIMAL:
      return "DECIMAL";
    case kINT:
      return "INT";
    case kSMALLINT:
      return "SMALLINT";
    case kFLOAT:
      return "FLOAT";
    case kDOUBLE:
      return "DOUBLE";
    case kTIME:
      return "TIME";
    case kTIMESTAMP:
      return "TIMESTAMP";
    case kBIGINT:
      return "BIGINT";
    case kTEXT:
      return "TEXT";
    case kDATE:
      return "DATE";
    case kARRAY:
      return "ARRAY";
    case kINTERVAL_DAY_TIME:
      return "DAY TIME INTERVAL";
    case kINTERVAL_YEAR_MONTH:
      return "YEAR MONTH INTERVAL";
    case kPOINT:
      return "POINT";
    case kLINESTRING:
      return "LINESTRING";
    case kPOLYGON:
      return "POLYGON";
    case kMULTIPOLYGON:
      return "MULTIPOLYGON";
    case kTINYINT:
      return "TINYINT";
    case kGEOMETRY:
      return "GEOMETRY";
    case kGEOGRAPHY:
      return "GEOGRAPHY";
    case kEVAL_CONTEXT_TYPE:
      return "UNEVALUATED ANY";
    case kVOID:
      return "VOID";
    case kCURSOR:
      return "CURSOR";
    case kCOLUMN:
      return "COLUMN";
    case kSQLTYPE_LAST:
      break;
  }
  LOG(FATAL) << "Invalid SQL type: " << type;
  return "";
}