sqldefs.h File Reference

Common Enum definitions for SQL processing. More...

#include <string>
#include "Logger/Logger.h"

Include dependency graph for sqldefs.h:

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

Go to the source code of this file.

Macros
#define	IS_COMPARISON(X)
#define	IS_LOGIC(X)   ((X) == kAND || (X) == kOR)
#define	IS_ARITHMETIC(X)   ((X) == kMINUS || (X) == kPLUS || (X) == kMULTIPLY || (X) == kDIVIDE || (X) == kMODULO)
#define	COMMUTE_COMPARISON(X)   ((X) == kLT ? kGT : (X) == kLE ? kGE : (X) == kGT ? kLT : (X) == kGE ? kLE : (X))
#define	IS_UNARY(X)   ((X) == kNOT || (X) == kUMINUS || (X) == kISNULL || (X) == kEXISTS || (X) == kCAST)
#define	IS_EQUIVALENCE(X)   ((X) == kEQ || (X) == kBW_EQ || (X) == kOVERLAPS)

Enumerations
enum	SQLOps {   kEQ = 0, kBW_EQ, kNE, kLT,   kGT, kLE, kGE, kAND,   kOR, kNOT, kMINUS, kPLUS,   kMULTIPLY, kDIVIDE, kMODULO, kUMINUS,   kISNULL, kISNOTNULL, kEXISTS, kCAST,   kARRAY_AT, kUNNEST, kFUNCTION, kIN,   kOVERLAPS }
enum	SQLQualifier { kONE, kANY, kALL }
enum	SQLAgg {   kAVG, kMIN, kMAX, kSUM,   kCOUNT, kAPPROX_COUNT_DISTINCT, kAPPROX_MEDIAN, kSAMPLE,   kSINGLE_VALUE }
enum	SqlWindowFunctionKind {   SqlWindowFunctionKind::ROW_NUMBER, SqlWindowFunctionKind::RANK, SqlWindowFunctionKind::DENSE_RANK, SqlWindowFunctionKind::PERCENT_RANK,   SqlWindowFunctionKind::CUME_DIST, SqlWindowFunctionKind::NTILE, SqlWindowFunctionKind::LAG, SqlWindowFunctionKind::LEAD,   SqlWindowFunctionKind::FIRST_VALUE, SqlWindowFunctionKind::LAST_VALUE, SqlWindowFunctionKind::AVG, SqlWindowFunctionKind::MIN,   SqlWindowFunctionKind::MAX, SqlWindowFunctionKind::SUM, SqlWindowFunctionKind::COUNT, SqlWindowFunctionKind::SUM_INTERNAL }
enum	SQLStmtType {   kSELECT, kUPDATE, kINSERT, kDELETE,   kCREATE_TABLE }
enum	StorageOption { kDISK = 0, kGPU = 1, kCPU = 2 }
enum	ViewRefreshOption { kMANUAL = 0, kAUTO = 1, kIMMEDIATE = 2 }
enum	JoinType { JoinType::INNER, JoinType::LEFT, JoinType::INVALID }

Functions
std::string	toString (const SQLAgg &kind)
std::string	toString (const SQLOps &op)
std::string	toString (const SqlWindowFunctionKind &kind)

Detailed Description

Common Enum definitions for SQL processing.

Author

Wei Hong wei@m.nosp@m.ap-d.nosp@m..com Copyright (c) 2014 MapD Technologies, Inc. All rights reserved.

Definition in file sqldefs.h.

Macro Definition Documentation

#define COMMUTE_COMPARISON

(

X

)

((X) == kLT ? kGT : (X) == kLE ? kGE : (X) == kGT ? kLT : (X) == kGE ? kLE : (X))

Definition at line 63 of file sqldefs.h.

Referenced by Analyzer::BinOper::normalize_simple_predicate().

#define IS_ARITHMETIC

(

X

)

((X) == kMINUS || (X) == kPLUS || (X) == kMULTIPLY || (X) == kDIVIDE || (X) == kMODULO)

Definition at line 61 of file sqldefs.h.

Referenced by Analyzer::BinOper::analyze_type_info(), CodeGenerator::codegen(), CodeGenerator::codegenArith(), and anonymous_namespace{ExpressionRewrite.cpp}::ConstantFoldingVisitor::foldOper().

#define IS_COMPARISON

(

X

)

Value:

((X) == kEQ || (X) == kBW_EQ || (X) == kOVERLAPS || (X) == kNE || (X) == kLT || \
   (X) == kGT || (X) == kLE || (X) == kGE)

Definition at line 57 of file sqldefs.h.

Referenced by Analyzer::BinOper::analyze_type_info(), CodeGenerator::codegen(), CodeGenerator::codegenCmp(), anonymous_namespace{ExpressionRewrite.cpp}::ConstantFoldingVisitor::foldOper(), Parser::OperExpr::normalize(), Analyzer::BinOper::normalize_simple_predicate(), RelAlgTranslator::translateOper(), and anonymous_namespace{ExpressionRewrite.cpp}::ConstantFoldingVisitor::visitBinOper().

#define IS_EQUIVALENCE

(

X

)

((X) == kEQ || (X) == kBW_EQ || (X) == kOVERLAPS)

Definition at line 67 of file sqldefs.h.

Referenced by Executor::buildCurrentLevelHashTable(), anonymous_namespace{EquiJoinCondition.cpp}::can_combine_with(), CodeGenerator::codegenCmp(), anonymous_namespace{FromTableReordering.cpp}::get_join_qual_cost(), PerfectJoinHashTable::getInstance(), CodeGenerator::hashJoinLhs(), and anonymous_namespace{CompareIR.cpp}::make_eq().

#define IS_LOGIC

(

X

)

((X) == kAND || (X) == kOR)

Definition at line 60 of file sqldefs.h.

Referenced by Analyzer::BinOper::analyze_type_info(), CodeGenerator::codegen(), CodeGenerator::codegenLogical(), and anonymous_namespace{ExpressionRewrite.cpp}::ConstantFoldingVisitor::foldOper().

#define IS_UNARY

(

X

)

((X) == kNOT || (X) == kUMINUS || (X) == kISNULL || (X) == kEXISTS || (X) == kCAST)

Definition at line 65 of file sqldefs.h.

Enumeration Type Documentation

enum JoinType

strong

Enumerator
INNER
LEFT
INVALID

Definition at line 108 of file sqldefs.h.

{ INNER, LEFT, INVALID };

enum SQLAgg

Enumerator
kAVG
kMIN
kMAX
kSUM
kCOUNT
kAPPROX_COUNT_DISTINCT
kAPPROX_MEDIAN
kSAMPLE
kSINGLE_VALUE

Definition at line 71 of file sqldefs.h.

            {
  kAVG,
  kMIN,
  kMAX,
  kSUM,
  kCOUNT,
  kAPPROX_COUNT_DISTINCT,
  kAPPROX_MEDIAN,
  kSAMPLE,
  kSINGLE_VALUE
};

enum SQLOps

Enumerator
kEQ
kBW_EQ
kNE
kLT
kGT
kLE
kGE
kAND
kOR
kNOT
kMINUS
kPLUS
kMULTIPLY
kDIVIDE
kMODULO
kUMINUS
kISNULL
kISNOTNULL
kEXISTS
kCAST
kARRAY_AT
kUNNEST
kFUNCTION
kIN
kOVERLAPS

Definition at line 29 of file sqldefs.h.

            {
  kEQ = 0,
  kBW_EQ,
  kNE,
  kLT,
  kGT,
  kLE,
  kGE,
  kAND,
  kOR,
  kNOT,
  kMINUS,
  kPLUS,
  kMULTIPLY,
  kDIVIDE,
  kMODULO,
  kUMINUS,
  kISNULL,
  kISNOTNULL,
  kEXISTS,
  kCAST,
  kARRAY_AT,
  kUNNEST,
  kFUNCTION,
  kIN,
  kOVERLAPS
};

enum SQLQualifier

Enumerator
kONE
kANY
kALL

Definition at line 69 of file sqldefs.h.

{ kONE, kANY, kALL };

enum SQLStmtType

Enumerator
kSELECT
kUPDATE
kINSERT
kDELETE
kCREATE_TABLE

Definition at line 102 of file sqldefs.h.

{ kSELECT, kUPDATE, kINSERT, kDELETE, kCREATE_TABLE };

enum SqlWindowFunctionKind

strong

Enumerator
ROW_NUMBER
RANK
DENSE_RANK
PERCENT_RANK
CUME_DIST
NTILE
LAG
LEAD
FIRST_VALUE
LAST_VALUE
AVG
MIN
MAX
SUM
COUNT
SUM_INTERNAL

Definition at line 83 of file sqldefs.h.

                                 {
  ROW_NUMBER,
  RANK,
  DENSE_RANK,
  PERCENT_RANK,
  CUME_DIST,
  NTILE,
  LAG,
  LEAD,
  FIRST_VALUE,
  LAST_VALUE,
  AVG,
  MIN,
  MAX,
  SUM,
  COUNT,
  SUM_INTERNAL  // For deserialization from Calcite only. Gets rewritten to a regular SUM.
};

enum StorageOption

Enumerator
kDISK
kGPU
kCPU

Definition at line 104 of file sqldefs.h.

{ kDISK = 0, kGPU = 1, kCPU = 2 };

enum ViewRefreshOption

Enumerator
kMANUAL
kAUTO
kIMMEDIATE

Definition at line 106 of file sqldefs.h.

{ kMANUAL = 0, kAUTO = 1, kIMMEDIATE = 2 };

Function Documentation

std::string toString ( const SQLAgg &  kind )

inline

Definition at line 115 of file sqldefs.h.

References logger::FATAL, kAPPROX_COUNT_DISTINCT, kAPPROX_MEDIAN, kAVG, kCOUNT, kMAX, kMIN, kSAMPLE, kSINGLE_VALUE, kSUM, and LOG.

                                              {
  switch (kind) {
    case kAVG:
      return "AVG";
    case kMIN:
      return "MIN";
    case kMAX:
      return "MAX";
    case kSUM:
      return "SUM";
    case kCOUNT:
      return "COUNT";
    case kAPPROX_COUNT_DISTINCT:
      return "APPROX_COUNT_DISTINCT";
    case kAPPROX_MEDIAN:
      return "APPROX_MEDIAN";
    case kSAMPLE:
      return "SAMPLE";
    case kSINGLE_VALUE:
      return "SINGLE_VALUE";
  }
  LOG(FATAL) << "Invalid aggregate kind: " << kind;
  return "";
}

std::string toString ( const SQLOps &  op )

inline

Definition at line 140 of file sqldefs.h.

References logger::FATAL, kAND, kARRAY_AT, kBW_EQ, kCAST, kDIVIDE, kEQ, kEXISTS, kFUNCTION, kGE, kGT, kIN, kISNOTNULL, kISNULL, kLE, kLT, kMINUS, kMODULO, kMULTIPLY, kNE, kNOT, kOR, kOVERLAPS, kPLUS, kUMINUS, kUNNEST, and LOG.

                                            {
  switch (op) {
    case kEQ:
      return "EQ";
    case kBW_EQ:
      return "BW_EQ";
    case kNE:
      return "NE";
    case kLT:
      return "LT";
    case kGT:
      return "GT";
    case kLE:
      return "LE";
    case kGE:
      return "GE";
    case kAND:
      return "AND";
    case kOR:
      return "OR";
    case kNOT:
      return "NOT";
    case kMINUS:
      return "MINUS";
    case kPLUS:
      return "PLUS";
    case kMULTIPLY:
      return "MULTIPLY";
    case kDIVIDE:
      return "DIVIDE";
    case kMODULO:
      return "MODULO";
    case kUMINUS:
      return "UMINUS";
    case kISNULL:
      return "ISNULL";
    case kISNOTNULL:
      return "ISNOTNULL";
    case kEXISTS:
      return "EXISTS";
    case kCAST:
      return "CAST";
    case kARRAY_AT:
      return "ARRAY_AT";
    case kUNNEST:
      return "UNNEST";
    case kFUNCTION:
      return "FUNCTION";
    case kIN:
      return "IN";
    case kOVERLAPS:
      return "OVERLAPS";
  }
  LOG(FATAL) << "Invalid operation kind: " << op;
  return "";
}

std::string toString ( const SqlWindowFunctionKind &  kind )

inline

Definition at line 197 of file sqldefs.h.

References AVG, COUNT, CUME_DIST, DENSE_RANK, logger::FATAL, FIRST_VALUE, LAG, LAST_VALUE, LEAD, LOG, MAX, MIN, NTILE, PERCENT_RANK, RANK, ROW_NUMBER, SUM, and SUM_INTERNAL.

                                                             {
  switch (kind) {
    case SqlWindowFunctionKind::ROW_NUMBER:
      return "ROW_NUMBER";
    case SqlWindowFunctionKind::RANK:
      return "RANK";
    case SqlWindowFunctionKind::DENSE_RANK:
      return "DENSE_RANK";
    case SqlWindowFunctionKind::PERCENT_RANK:
      return "PERCENT_RANK";
    case SqlWindowFunctionKind::CUME_DIST:
      return "CUME_DIST";
    case SqlWindowFunctionKind::NTILE:
      return "NTILE";
    case SqlWindowFunctionKind::LAG:
      return "LAG";
    case SqlWindowFunctionKind::LEAD:
      return "LEAD";
    case SqlWindowFunctionKind::FIRST_VALUE:
      return "FIRST_VALUE";
    case SqlWindowFunctionKind::LAST_VALUE:
      return "LAST_VALUE";
    case SqlWindowFunctionKind::AVG:
      return "AVG";
    case SqlWindowFunctionKind::MIN:
      return "MIN";
    case SqlWindowFunctionKind::MAX:
      return "MAX";
    case SqlWindowFunctionKind::SUM:
      return "SUM";
    case SqlWindowFunctionKind::COUNT:
      return "COUNT";
    case SqlWindowFunctionKind::SUM_INTERNAL:
      return "SUM_INTERNAL";
  }
  LOG(FATAL) << "Invalid window function kind.";
  return "";
}