sqldefs.h File Reference

Common Enum definitions for SQL processing. More...

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

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

COMMUTE_COMPARISON

#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().

IS_ARITHMETIC

#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().

IS_COMPARISON

#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().

IS_EQUIVALENCE

#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(), JoinHashTable::getInstance(), CodeGenerator::hashJoinLhs(), and anonymous_namespace{CompareIR.cpp}::make_eq().

IS_LOGIC

#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().

IS_UNARY

#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

JoinType

enum JoinType

strong

Enumerator
INNER
LEFT
INVALID

Definition at line 107 of file sqldefs.h.

{ INNER, LEFT, INVALID };

SQLAgg

enum SQLAgg

Enumerator
kAVG
kMIN
kMAX
kSUM
kCOUNT
kAPPROX_COUNT_DISTINCT
kSAMPLE
kSINGLE_VALUE

Definition at line 71 of file sqldefs.h.

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

SQLOps

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

SQLQualifier

enum SQLQualifier

Enumerator
kONE
kANY
kALL

Definition at line 69 of file sqldefs.h.

{ kONE, kANY, kALL };

SQLStmtType

enum SQLStmtType

Enumerator
kSELECT
kUPDATE
kINSERT
kDELETE
kCREATE_TABLE

Definition at line 101 of file sqldefs.h.

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

SqlWindowFunctionKind

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 82 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.
};

StorageOption

enum StorageOption

Enumerator
kDISK
kGPU
kCPU

Definition at line 103 of file sqldefs.h.

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

ViewRefreshOption

enum ViewRefreshOption

Enumerator
kMANUAL
kAUTO
kIMMEDIATE

Definition at line 105 of file sqldefs.h.

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