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
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

◆ IS_DECIMAL

#define IS_DECIMAL ( T ) ((T) == kNUMERIC || (T) == kDECIMAL)

Definition at line 177 of file sqltypes.h.

◆ IS_GEO

#define IS_GEO ( T ) (((T) == kPOINT) || ((T) == kLINESTRING) || ((T) == kPOLYGON) || ((T) == kMULTIPOLYGON))

◆ IS_GEO_POLY

#define IS_GEO_POLY ( T ) (((T) == kPOLYGON) || ((T) == kMULTIPOLYGON))

Definition at line 178 of file sqltypes.h.

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

◆ IS_INTEGER

#define IS_INTEGER ( T ) (((T) == kINT) || ((T) == kSMALLINT) || ((T) == kBIGINT) || ((T) == kTINYINT))

Definition at line 168 of file sqltypes.h.

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

◆ IS_INTERVAL

#define IS_INTERVAL ( T ) ((T) == kINTERVAL_DAY_TIME || (T) == kINTERVAL_YEAR_MONTH)

Definition at line 176 of file sqltypes.h.

Referenced by SQLTypeInfo::is_timeinterval().

◆ IS_NUMBER

#define IS_NUMBER ( T )

Value:

(((T) == kINT) || ((T) == kSMALLINT) || ((T) == kDOUBLE) || ((T) == kFLOAT) || \

((T) == kBIGINT) || ((T) == kNUMERIC) || ((T) == kDECIMAL) || ((T) == kTINYINT))

kFLOAT

Definition: sqltypes.h:49

kDOUBLE

Definition: sqltypes.h:50

kBIGINT

Definition: sqltypes.h:53

kTINYINT

Definition: sqltypes.h:63

kSMALLINT

Definition: sqltypes.h:48

kDECIMAL

Definition: sqltypes.h:46

kNUMERIC

Definition: sqltypes.h:45

kINT

Definition: sqltypes.h:47

Definition at line 170 of file sqltypes.h.

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

◆ IS_STRING

#define IS_STRING ( T ) (((T) == kTEXT) || ((T) == kVARCHAR) || ((T) == kCHAR))

Definition at line 173 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(), foreign_storage::initialize_import_buffers(), 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().

◆ NULL_ARRAY_BIGINT

#define NULL_ARRAY_BIGINT (INT64_MIN + 1)

Definition at line 192 of file sqltypes.h.

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

◆ NULL_ARRAY_BOOLEAN

#define NULL_ARRAY_BOOLEAN (INT8_MIN + 1)

Definition at line 188 of file sqltypes.h.

Referenced by FixedLengthArrayNoneEncoder::is_null().

◆ NULL_ARRAY_COMPRESSED_32

#define NULL_ARRAY_COMPRESSED_32 0x80000000U

Definition at line 196 of file sqltypes.h.

Referenced by SQLTypeInfo::is_null_point_coord_array().

◆ NULL_ARRAY_DOUBLE

#define NULL_ARRAY_DOUBLE (DBL_MIN * 2.0)

Definition at line 194 of file sqltypes.h.

Referenced by Parser::InsertValuesStmt::analyze(), geospatial::compress_coords(), geospatial::compress_null_point(), GeoPointValueConverter::convertToColumnarFormat(), GeoLinestringValueConverter::convertToColumnarFormat(), GeoPolygonValueConverter::convertToColumnarFormat(), GeoMultiPolygonValueConverter::convertToColumnarFormat(), Geo_namespace::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(), and import_export::Importer::set_geo_physical_import_buffer_columnar().

◆ NULL_ARRAY_FLOAT

#define NULL_ARRAY_FLOAT (FLT_MIN * 2.0)

Definition at line 193 of file sqltypes.h.

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

◆ NULL_ARRAY_INT

#define NULL_ARRAY_INT (INT32_MIN + 1)

Definition at line 191 of file sqltypes.h.

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

◆ NULL_ARRAY_SMALLINT

#define NULL_ARRAY_SMALLINT (INT16_MIN + 1)

Definition at line 190 of file sqltypes.h.

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

◆ NULL_ARRAY_TINYINT

#define NULL_ARRAY_TINYINT (INT8_MIN + 1)

Definition at line 189 of file sqltypes.h.

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

◆ NULL_BIGINT

#define NULL_BIGINT INT64_MIN

Definition at line 184 of file sqltypes.h.

Referenced by CodeGenerator::codegen(), CodeGenerator::codegenCastTimestampToDate(), CodeGenerator::codegenDateTruncHighPrecisionTimestamps(), 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(), 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().

◆ NULL_BOOLEAN

#define NULL_BOOLEAN INT8_MIN

Definition at line 180 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().

◆ NULL_DOUBLE

#define NULL_DOUBLE DBL_MIN

Definition at line 186 of file sqltypes.h.

Referenced by import_export::TypedImportBuffer::add_value(), import_export::TypedImportBuffer::add_values(), Parser::InsertValuesStmt::analyze(), CodeGenerator::codegenCmp(), 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(), Geo_namespace::GeoPoint::getColumns(), Geo_namespace::GeoLineString::getColumns(), Geo_namespace::GeoPolygon::getColumns(), Geo_namespace::GeoMultiPolygon::getColumns(), Geo_namespace::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().

◆ NULL_FLOAT

#define NULL_FLOAT FLT_MIN

Definition at line 185 of file sqltypes.h.

Referenced by import_export::TypedImportBuffer::add_value(), import_export::TypedImportBuffer::add_values(), CodeGenerator::codegenCmp(), 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().

◆ NULL_INT

#define NULL_INT INT32_MIN

Definition at line 183 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(), FixedWidthSmallDate::FixedWidthSmallDate(), 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(), 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().

◆ NULL_SMALLINT

#define NULL_SMALLINT INT16_MIN

Definition at line 182 of file sqltypes.h.

Referenced by import_export::QueryExporterCSV::exportResults(), FixedWidthSmallDate::FixedWidthSmallDate(), 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(), 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().

◆ NULL_TINYINT

#define NULL_TINYINT INT8_MIN

Definition at line 181 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().

◆ REGULAR_DICT

#define REGULAR_DICT ( TRANSIENTID ) (-(TRANSIENTID))

Definition at line 200 of file sqltypes.h.

Referenced by Executor::getStringDictionaryProxy().

◆ TRANSIENT_DICT

#define TRANSIENT_DICT ( ID ) (-(ID))

Definition at line 199 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==().

◆ TRANSIENT_DICT_ID

#define TRANSIENT_DICT_ID 0

Definition at line 198 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

◆ ArrayDatum

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

Definition at line 131 of file sqltypes.h.

◆ ArrayOffsetT

using ArrayOffsetT = int32_t

Definition at line 868 of file sqltypes.h.

◆ StringOffsetT

using StringOffsetT = int32_t

Definition at line 867 of file sqltypes.h.

Enumeration Type Documentation

◆ EncodingType

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 156 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
 };

◆ SQLTypes

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

◆ appendDatum()

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

inline

Definition at line 870 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:

◆ convert_decimal_value_to_scale()

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

Definition at line 315 of file Datum.cpp.

References SQLTypeInfo::get_scale().

Referenced by import_export::TypedImportBuffer::add_value(), Analyzer::Constant::cast_number(), SQLTypeInfo::get_storage_size(), 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:

◆ DatumEqual()

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

Definition at line 190 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, kNUMERIC, kSMALLINT, kTEXT, kTIME, kTIMESTAMP, kTINYINT, kVARCHAR, Datum::smallintval, Datum::stringval, and Datum::tinyintval.

Referenced by SQLTypeInfo::get_storage_size(), and 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:
       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:

◆ DatumToString()

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

Definition at line 236 of file Datum.cpp.

References Datum::bigintval, Datum::boolval, CHECK_EQ, CHECK_LE, 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, and to_string().

Referenced by Analyzer::Constant::cast_to_string(), datum_to_string(), ChunkMetadata::dump(), SQLTypeInfo::get_storage_size(), 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 = 32;
   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: {
       // we need to consider buf_size including the scale and null terminator
       char str[ti.get_dimension() + ti.get_scale() + 2];
       double v = (double)d.bigintval / pow(10, ti.get_scale());
       sprintf(str, "%*.*f", ti.get_dimension(), ti.get_scale(), v);
       return std::string(str);
     }
     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:

◆ decimal_to_int_type()

SQLTypes decimal_to_int_type ( const SQLTypeInfo & )

Definition at line 299 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(), SQLTypeInfo::get_storage_size(), 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:

◆ get_logical_type_info()

SQLTypeInfo get_logical_type_info ( const SQLTypeInfo & type_info )

inline

Definition at line 819 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:

◆ get_nullable_logical_type_info()

SQLTypeInfo get_nullable_logical_type_info ( const SQLTypeInfo & type_info )

inline

Definition at line 840 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:

◆ get_nullable_type_info()

SQLTypeInfo get_nullable_type_info ( const SQLTypeInfo & type_info )

inline

Definition at line 834 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:

◆ inline_int_null_array_value()

template<class T >

constexpr int64_t inline_int_null_array_value ( )

inline

Definition at line 852 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.
 }

◆ inline_int_null_value()

template<class T >

constexpr int64_t inline_int_null_value ( )

inline

Definition at line 846 of file sqltypes.h.

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

◆ is_cuda_compiler()

DEVICE constexpr bool is_cuda_compiler ( )

inline

Definition at line 122 of file sqltypes.h.

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

◆ is_datetime()

constexpr auto is_datetime ( SQLTypes type )

Definition at line 202 of file sqltypes.h.

References kDATE, kTIME, and kTIMESTAMP.

Referenced by SQLTypeInfo::is_time(), DateTimeStringValidate< SQL_TYPE >::operator()(), foreign_storage::anonymous_namespace{LazyParquetImporter.cpp}::read_parquet_metadata_into_import_buffer(), and RexLiteral::RexLiteral().

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

Here is the caller graph for this function:

◆ max_valid_int_value()

template<class T >

constexpr int64_t max_valid_int_value ( )

inline

Definition at line 860 of file sqltypes.h.

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

◆ StringToDatum()

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

Definition at line 124 of file Datum.cpp.

References Datum::bigintval, Datum::boolval, 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(), SQLTypeInfo::get_storage_size(), 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 = DateTimeStringValidate<kTIME>()(std::string(s), ti.get_dimension());
         break;
       case kTIMESTAMP:
         d.bigintval =
             DateTimeStringValidate<kTIMESTAMP>()(std::string(s), ti.get_dimension());
         break;
       case kDATE:
         d.bigintval = DateTimeStringValidate<kDATE>()(std::string(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:

Classes

Macros

Typedefs

Enumerations

Functions

Detailed Description

Macro Definition Documentation

◆ IS_DECIMAL

◆ IS_GEO

◆ IS_GEO_POLY

◆ IS_INTEGER

◆ IS_INTERVAL

◆ IS_NUMBER

◆ IS_STRING

◆ NULL_ARRAY_BIGINT

◆ NULL_ARRAY_BOOLEAN

◆ NULL_ARRAY_COMPRESSED_32

◆ NULL_ARRAY_DOUBLE

◆ NULL_ARRAY_FLOAT

◆ NULL_ARRAY_INT

◆ NULL_ARRAY_SMALLINT

◆ NULL_ARRAY_TINYINT

◆ NULL_BIGINT

◆ NULL_BOOLEAN

◆ NULL_DOUBLE

◆ NULL_FLOAT

◆ NULL_INT

◆ NULL_SMALLINT

◆ NULL_TINYINT

◆ REGULAR_DICT

◆ TRANSIENT_DICT

◆ TRANSIENT_DICT_ID

Typedef Documentation

◆ ArrayDatum

◆ ArrayOffsetT

◆ StringOffsetT

Enumeration Type Documentation

◆ EncodingType

◆ SQLTypes

Function Documentation

◆ appendDatum()

◆ convert_decimal_value_to_scale()

◆ DatumEqual()

◆ DatumToString()

◆ decimal_to_int_type()

◆ get_logical_type_info()

◆ get_nullable_logical_type_info()

◆ get_nullable_type_info()

◆ inline_int_null_array_value()

◆ inline_int_null_value()

◆ is_cuda_compiler()

◆ is_datetime()

◆ max_valid_int_value()

◆ StringToDatum()