Class TExpression

An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value. There are lots of types of expression in this SQL parser, ExpressionType was used to distinguish these types.

OBJECT NAME/CONSTANT/SOURCE TOKEN/FUNCTION CALL

• object name, usually this is a column reference like emp.ename
  • type: simple_object_name_t
  • object name: ObjectOperand
  • left operand: N/A
  • right operand: N/A
  • operator: N/A
• constant
  • type: simple_constant_t
  • constant: ConstantOperand
  • left operand: N/A
  • right operand: N/A
  • operator: N/A
• sourcetoken
  • type: simple_source_token_t
  • source token: SourcetokenOperand
  • left operand: N/A
  • right operand: N/A
  • operator: N/A
• function call
  • type: function_t
  • funcation call: FunctionCall
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

UNARY
<ul>
    <li>  + expr1
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_plus_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: getRightOperand</li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    <li>  - expr1
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_minus_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: getRightOperand</li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    <li>  expr1 !
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_factorial_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: N/A</li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    <li>  ~ expr1
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_bitwise_not_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    <li>  @ expr1
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_absolutevalue_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    <li>  |/ expr1
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_squareroot_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    <li>  ||/ expr1
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_cuberoot_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    <li>  !! expr1
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_factorialprefix_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    <li>  Oracle: PRIOR expr1
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_prior_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: getRightOperand</li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    <li>  Oracle: CONNECT_BY_ROOT expr1
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_connect_by_root_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: getRightOperand</li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    <li>  MySQL: BINARY expr1
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_prior_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: getRightOperand</li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

ARITHMETIC
<ul>
    <li>Addition: expr1 + expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.arithmetic_plus_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>Subtraction: expr1 - expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.arithmetic_minus_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>Multiplication: expr1 * expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.arithmetic_times_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>Division: expr1 / expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.arithmetic_divide_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>Modula: expr1 % expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.arithmetic_modulo_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>exponentiate: expr1 ^ expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.exponentiate_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>sql server 2008 +=,-=,*=,/=,%=: expr1 [+=|-=|*=|/=|%=] expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.arithmetic_compound_operator_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
</ul>

LOGICAL
<ul>
    <li>expr1 AND|&& expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.logical_and_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>expr1 OR | || expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.logical_or_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>expr1 XOR expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.logical_xor_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>NOT|! expr1
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.logical_not_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    </ul>

ASSIGNMENT
<ul>
    <li>ASSIGNMENT: expr1 [:=|=] expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.assignment_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    </ul>

CONCATENATE
<ul>
    <li>CONCATENATE: expr1 || expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.concatenate_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    </ul>

AT TIME ZONE
<ul>
    <li>expr1 at time zone expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.at_time_zone_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

AT LOCAL
<ul>
    <li>expr1 at local
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.at_local_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

BITWISE
<ul>
    <li>Bitwise and : expr1 & expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.bitwise_and_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>Bitwise or : expr1 | expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.bitwise_or_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>Bitwise exclusive or : expr1 ^ expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.bitwise_exclusive_or_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>Bitwise xor : expr1 ^ expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.bitwise_xor_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>Bitwise shift left : expr1 << expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.bitwise_shift_left_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    <li>Bitwise shift right : expr1 >> expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.bitwise_shift_right_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    </ul>

SUBQUERY
<ul>
    <li> A scalar subquery expression is a subquery that returns exactly one column value from one row.
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.subquery_t" data-throw-if-not-resolved="false"></xref></li>
         <li>subquery: <xref href="gudusoft.gsqlparser.nodes.TExpression.SubQuery" data-throw-if-not-resolved="false"></xref> </li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

EXPRESSION WITH PARENTHESIS
<ul>
    <li> ( expr1 )
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.parenthesis_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand is expr1:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: N/A </li>
        <li>operator: use <xref href="gudusoft.gsqlparser.nodes.TParseTreeNode.startToken" data-throw-if-not-resolved="false"></xref> to get ( and <xref href="gudusoft.gsqlparser.nodes.TParseTreeNode.endToken" data-throw-if-not-resolved="false"></xref> to get )</li>
        </ul>
    </li>
    </ul>

LIST EXPRESSION
<ul>
    <li>An expression list inside parenthesis like (expr,expr,...),
    or one or more set of expressions: ((expr1,expr2,...),(expr1,expr2,...),(expr1,expr2,...)...)
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.list_t" data-throw-if-not-resolved="false"></xref></li>
         <li>expr list: <xref href="gudusoft.gsqlparser.nodes.TExpression.ExprList" data-throw-if-not-resolved="false"></xref>, may return null when expression list in syntax like this: () </li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: open parenthsis ( can be fetched via <xref href="gudusoft.gsqlparser.nodes.TParseTreeNode.startToken" data-throw-if-not-resolved="false"></xref>,
        close parenthesis ) can be fetched via <xref href="gudusoft.gsqlparser.nodes.TParseTreeNode.endToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    </ul>

COLLECTION CONSTRUCTORS (informix)

• Use a collection constructor to specify values for a collection column. SET|MULTISET|LIST { epxr_list }
  • type: collection_constructor_set_t
  • type: collection_constructor_multiset_t
  • type: collection_constructor_list_t
  • expr list: ExprList, may return null when expression list in syntax like this: ()
  • left operand: N/A
  • right operand: N/A

GROUP EXPRESSION,  @deprecated As of v1.4.3.3
<ul>
    <li>
    </li>
    </ul>

COMPARISON
<ul>
    <li>A <b>simple comparison condition</b> specifies a comparison with expressions or subquery results.
    <br />expr1 EQUAL|NOT_EQUAL|LESS_THAN|GRREAT_THAN|LESS_EQUAL_THAN|GREATE_EQUAL_THAN expr2,
    or, (expr_list) EQUAL|NOT_EQUAL (subquery)
        <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.simple_comparison_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    <li>A <b>group comparison condition</b> specifies a comparison with any or all members
    in a list or subquery.
    <br />expr EQUAL|NOT_EQUAL|LESS_THAN|GRREAT_THAN|LESS_EQUAL_THAN|GREATE_EQUAL_THAN ANY|SOME|ALL (expr_list|subquery),
    or, (expr_list) EQUAL|NOT_EQUAL ANY|SOME|ALL (expr_list|subquery)
        <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.group_comparison_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        <li> ANY|SOME|ALL: <xref href="gudusoft.gsqlparser.nodes.TExpression.Quantifier" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

IN
<ul>
    <li>(expr|expr_list) |NOT] IN (expr_list)|(subquery)|expr
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.in_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
       <li>operator is IN: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        <li>NOT keyword: <xref href="gudusoft.gsqlparser.nodes.TExpression.NotToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    </ul>

CASE
<ul>
    <li>case expression,let you use IF ... THEN ... ELSE logic in SQL statements without having to invoke procedures.
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.case_t" data-throw-if-not-resolved="false"></xref></li>
         <li> case expression: <xref href="gudusoft.gsqlparser.nodes.TExpression.CaseExpression" data-throw-if-not-resolved="false"></xref>}</li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: N/A </li>
        </ul>
    </li>
    </ul>

CURSOR
<ul>
    <li>CURSOR subquery
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.cursor_t" data-throw-if-not-resolved="false"></xref></li>
         <li>subquery: <xref href="gudusoft.gsqlparser.nodes.TExpression.SubQuery" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: CURSOR can be fetched via <xref href="gudusoft.gsqlparser.nodes.TParseTreeNode.startToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    </ul>

PATTERN MATCHING
<ul>
    <li>expr1 [NOT] [LIKE|ILIKE|RLIKE|REGEXP|SIMILAR TO] [ALL|ANY|SOME]expr2 [ESCAPE expr3]
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.pattern_matching_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand:<xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
         <li>expr3: <xref href="gudusoft.gsqlparser.nodes.TExpression.LikeEscapeOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
         <li>NOT keyword: <xref href="gudusoft.gsqlparser.nodes.TExpression.NotToken" data-throw-if-not-resolved="false"></xref></li>
         <li>ALL|ANY|SOME keyword: <xref href="gudusoft.gsqlparser.nodes.TExpression.Quantifier" data-throw-if-not-resolved="false"></xref></li>
         <li>ESCAPE keyword: N/A</li>
        </ul>
    </li>
    </ul>

NULL
<ul>
    <li>expr ISNULL|NOTNULL|IS [NOT] NULL
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.null_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: N/A </li>
        <li>operator is NULL: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
         <li>NOT keyword: <xref href="gudusoft.gsqlparser.nodes.TExpression.NotToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

BETWEEN
<ul>
    <li>expr1 [NOT] BETWEEN expr2 AND expr3
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.between_t" data-throw-if-not-resolved="false"></xref></li>
         <li>expr1:  <xref href="gudusoft.gsqlparser.nodes.TExpression.BetweenOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>expr2:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>expr3: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator is BETWEEN: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
         <li>NOT keyword: <xref href="gudusoft.gsqlparser.nodes.TExpression.NotToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

EXISTS
<ul>
    <li>EXISTS (subquery)
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.exists_t" data-throw-if-not-resolved="false"></xref></li>
         <li>left operand:  N/A</li>
        <li>right operand: N/A</li>
        <li>subquery: <xref href="gudusoft.gsqlparser.nodes.TExpression.SubQuery" data-throw-if-not-resolved="false"></xref> </li>
        <li>EXISTS: <xref href="gudusoft.gsqlparser.nodes.TParseTreeNode.startToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

IS UNKNOWN

• expr1 IS [NOT] UNKNOWN
  • type: is_unknown_t
  • left operand: LeftOperand
  • right operand: N/A
  • operator: OperatorToken
  • NOT keyword: NotToken

IS TRUE

• expr1 IS [NOT] TRUE
  • type: is_true_t
  • left operand: LeftOperand
  • right operand: N/A
  • operator: OperatorToken
  • NOT keyword: NotToken

IS FALSE

• expr1 IS [NOT] FALSE
  • type: is_false_t
  • left operand: LeftOperand
  • right operand: N/A
  • operator: OperatorToken
  • NOT keyword: NotToken

DAY TO SECOND
<ul>
    <li>expr DAY [( integer )] TO SECOND [( integer )]
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.day_to_second_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

YEAR TO MONTH
<ul>
    <li>expr YEAR [( integer )] TO MONTH
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.year_to_month_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

INTERVAL(teradata)
<ul>
    <li>( date_time_expression date_time_term ) start TO end
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.interval_t" data-throw-if-not-resolved="false"></xref></li>
         <li>date_time_expression: <xref href="gudusoft.gsqlparser.nodes.TExpression.IntervalExpr" data-throw-if-not-resolved="false"></xref> </li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

NEW STRUCTURED TYPE
<ul>
    <li>NEW function_call
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.new_structured_type_t" data-throw-if-not-resolved="false"></xref></li>
         <li>function_call: <xref href="gudusoft.gsqlparser.nodes.TExpression.FunctionCall" data-throw-if-not-resolved="false"></xref> </li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

NEW VARIANT_TYPE
<ul>
    <li>NEW VARIANT_TYPE ( type_argument_list )
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.new_variant_type_t" data-throw-if-not-resolved="false"></xref></li>
         <li>type_argument_list: <xref href="gudusoft.gsqlparser.nodes.TExpression.NewVariantTypeArgumentList" data-throw-if-not-resolved="false"></xref> </li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

LDIFF,RDIFF,P_INTERSECT,P_NORMALIZE
<ul>
    <li> expr1 LDIFF|RDIFF|P_INTERSECT|P_NORMALIZE expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.new_variant_type_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

UNTIL CHANGED

• expr1 IS [NOT] UNTIL_CHANGED
  • type: new_variant_type_t
  • left operand: LeftOperand
  • right operand: N/A
  • operator: OperatorToken
  • NOT keyword: NotToken

LEFT SHIFT
<ul>
    <li>expr1 >> expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.left_shift_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    </ul>

RIGHT SHIFT
<ul>
    <li>expr1 >> expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.right_shift_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    </ul>

IS DOCUMENT

• expr1 IS [NOT] DOCUMENT
  • type: is_document_t
  • left operand: LeftOperand
  • right operand: N/A
  • operator: OperatorToken
  • NOT keyword: NotToken

IS DISTINCT FROM
<ul>
    <li> expr1 IS [NOT] DISTINCT FROM expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.is_distinct_from_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        <li>NOT keyword: <xref href="gudusoft.gsqlparser.nodes.TExpression.NotToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

SQL SERVER left join
<ul>
    <li> expr1 *= expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.left_join_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
       <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

SQL SERVER right join
<ul>
    <li> expr1 =* expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.right_join_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
       <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

COLLATE
<ul>
    <li> expr1 COLLATE expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.collate_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        <li>NOT keyword: <xref href="gudusoft.gsqlparser.nodes.TExpression.NotToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

MEMBER OF
<ul>
    <li> expr1 MEMBER OF expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.member_of_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

NEXT VALUE FOR
<ul>
    <li> NEXT VALUE FOR sequence name, or NEXT integer expression VALUE FOR sequence name
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.next_value_for_t" data-throw-if-not-resolved="false"></xref></li>
        <li>sequence name: <xref href="gudusoft.gsqlparser.nodes.TExpression.SequenceName" data-throw-if-not-resolved="false"></xref>   </li>
        <li>over_clause : <xref href="gudusoft.gsqlparser.nodes.TExpression.Over_clause" data-throw-if-not-resolved="false"></xref>} </li>
        <li>left operand(integer expression):  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>

    </ul>

REF ARROW(named parameters in function call)
<ul>
    <li> expr1 => expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.ref_arrow_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    </ul>

TYPECAST
<ul>
    <li> expr1 TYPECAST typename
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.typecast_t" data-throw-if-not-resolved="false"></xref></li>
         <li>typename: <xref href="gudusoft.gsqlparser.nodes.TExpression.TypeName" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: N/A </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref> </li>
    </ul>
    </li>
</ul>

MULTISET
<ul>
    <li>MULTISET subquery
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.multiset_t" data-throw-if-not-resolved="false"></xref></li>
         <li>subquery: <xref href="gudusoft.gsqlparser.nodes.TExpression.SubQuery" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: MULTISET can be fetched via <xref href="gudusoft.gsqlparser.nodes.TParseTreeNode.startToken" data-throw-if-not-resolved="false"></xref> </li>
        </ul>
    </li>
    </ul>

FLOATING POINT
<ul>
    <li>expr is [NOT] NAN|INFINITE
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.floating_point_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: N/A </li>
        <li>operator is IS: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
         <li>NOT keyword: <xref href="gudusoft.gsqlparser.nodes.TExpression.NotToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

ROW CONSTRUCTOR
<ul>
    <li>ROW ( expr_list )
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.row_constructor_t" data-throw-if-not-resolved="false"></xref></li>
         <li>expr_list:  <xref href="gudusoft.gsqlparser.nodes.TExpression.ExprList" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator is ROW: <xref href="gudusoft.gsqlparser.nodes.TParseTreeNode.startToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

IS OF TYPE
<ul>
    <li>expr is of type ( datatype,...)
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.is_of_type_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

PLACE HOLDER
<ul>
    <li>place holder expression
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.place_holder_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

TYPE_CONSTRUCTOR_EXPRESSION
<ul>
    <li>[NEW] type_name( expr_list )
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.type_constructor_t" data-throw-if-not-resolved="false"></xref></li>
        <li>type_name(expr_list): <xref href="gudusoft.gsqlparser.nodes.TExpression.FunctionCall" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

ARRAY ACCESS
<ul>
    <li>array_name(index1)(index2)(index3)
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.arrayaccess_t" data-throw-if-not-resolved="false"></xref></li>
        <li>array_name(index1)(index2)(index3): <xref href="gudusoft.gsqlparser.nodes.TExpression.ArrayAccess" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
    </ul>

OBJECT ACCESS EXPRESSION
<ul>
    <li>objectExpr.[attributes].method()
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.object_access_t" data-throw-if-not-resolved="false"></xref></li>
        <li>objectExpr.[attributes].method(): <xref href="gudusoft.gsqlparser.nodes.TExpression.ObjectAccess" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  N/A</li>
        <li>right operand: N/A </li>
        <li>operator: N/A</li>
        </ul>
    </li>
 </ul>

Unknown
<ul>
    <li>expr OPERATOR expr, means this expression was not recognized by SQL parser yet.
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unknown_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

Unknown unary left
<ul>
    <li>OPERATOR expr, means this expression was not recognized by SQL parser yet.
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_left_unknown_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand: N/A</li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.RightOperand" data-throw-if-not-resolved="false"></xref> </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

Unknown unary right
<ul>
    <li> expr OPERATOR, means this expression was not recognized by SQL parser yet.
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.unary_right_unknown_t" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: N/A </li>
        <li>operator: <xref href="gudusoft.gsqlparser.nodes.TExpression.OperatorToken" data-throw-if-not-resolved="false"></xref></li>
        </ul>
    </li>
    </ul>

ARRAY CONSTRUCTOR
<ul>
    <li>

An array constructor is an expression that builds an array value using values for its member elements.

like this: ARRAY[1,2,3+4]

array element values can be accessed via ExprList,

or ExprList can be null when it is: array[]

It is also possible to construct an array from the results of a subquery like this:

SELECT ARRAY(SELECT oid FROM pg_proc WHERE proname LIKE 'bytea%');

thus, subquery can be access via SubQuery

• type: array_constructor_t
• array element values: ExprList
• subquery: SubQuery
• left operand: N/A
• right operand: N/A
• operator: N/A

   </p>
   </li> </ul>
FIELD SELECTION
<ul>
    <li>

If an expression yields a value of a composite type (row type), then a specific field of the row can be extracted by writing

expression.fieldname

In general the row expression must be parenthesized, but the parentheses can be omitted

when the expression to be selected from is just a table reference or positional parameter.

For example:

mytable.mycolumn

$1.somecolumn

(rowfunction(a,b)).col3

(Thus, a qualified column reference is actually just a special case of the field selection syntax.) An important special case is extracting a field from a table column that is of a composite type:

(compositecol).somefield

(mytable.compositecol).somefield

The parentheses are required here to show that compositecol is a column name not a table name,

or that mytable is a table name not a schema name in the second case.

n a select list, you can ask for all fields of a composite value by writing .*:

(compositecol).*

When expression in following syntax, it will be marked as fieldSelection, and check FieldName

(rowfunction(a,b)).col3

(compositecol).somefield

(mytable.compositecol).somefield

(compositecol).*

Otherwise, it will be marked as simpleObjectname:

mytable.mycolumn

$1.somecolumn

• type: fieldselection_t
• left operand: N/A
• right operand: N/A
• operator: N/A

HIVE ARRAY ACCESS

• HIVE field expression syntax like fieldexpr[expr_subscript]
  • type: array_access_expr_t
  • fieldexpr: LeftOperand
  • expr_subscript: RightOperand
  • operator: N/A

HIVE FIELD ACCESS

• HIVE field access syntax like fieldexpr.identifier.identifier...
  • type: object_access_t
  • fieldexpr: LeftOperand
  • identifier.identifier...: FieldList
  • operator: N/A

JSON Operators (PostgreSQL)

<ul>
    <li> expr1 -> expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.json_get_object" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref> </li>
    </ul>
    </li>
    <li> expr1 ->> expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.json_get_text" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref> </li>
    </ul>
    </li>
    <li> expr1 > expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.json_get_object_at_path" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref> </li>
    </ul>
    </li>
    <li> expr1 >> expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.json_get_text_at_path" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref> </li>
    </ul>
    </li>
    <li> expr1 @> expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.json_left_contain" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref> </li>
    </ul>
    </li>
    <li> expr1 >@ expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.json_right_contain" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref> </li>
    </ul>
    </li>
    <li> expr1 ? expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.json_exist" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref> </li>
    </ul>
    </li>
    <li> expr1 ?| expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.json_any_exist" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref> </li>
    </ul>
    </li>
    <li> expr1 ?& expr2
    <ul>
        <li>type: <xref href="gudusoft.gsqlparser.EExpressionType.json_all_exist" data-throw-if-not-resolved="false"></xref></li>
        <li>left operand:  <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref></li>
        <li>right operand: <xref href="gudusoft.gsqlparser.nodes.TExpression.LeftOperand" data-throw-if-not-resolved="false"></xref> </li>
    </ul>
    </li>
</ul>

public class TExpression : TParseTreeNode, Visitable

public TExpression()

public TExpression(EExpressionType exprType)

public TExpression(EExpressionType exprType, TConstant constant)

public TExpression(EExpressionType exprType, TExpression left, TExpression right)

public TExpression(EExpressionType exprType, TExpression left, TExpression right, EComparisonType comparisonType)

public TExpression(EExpressionType exprType, TFunctionCall func)

public TExpression(EExpressionType exprType, TObjectName dbObject)

public const int ASSIGNMENT = 7

public const int BITWISE_AND = 8

public const int BITWISE_EXCLUSIVE_OR = 11

public const int BITWISE_NOT = 529

public const int BITWISE_OR = 9

public const int BITWISE_SHIFT_LEFT = 525

public const int BITWISE_SHIFT_RIGHT = 527

public const int BITWISE_XOR = 10

public static int BigAndOrNestLevel

public const int COLLATE = 223

public const int CONCATENATE = 5

public const int DIVIDE = 4

public const int EXPONENTIATE = 13

public const int LEFTJOIN_OP = 224

public const int MINUS = 2

public const int MODULO = 6

public const int PLUS = 1

public const int POWER = 56

public const int RANGE = 55

public const int RIGHTJOIN_OP = 225

public const int SCOPE_RESOLUTION = 12

public const int TIMES = 3

public const int UnknownOperator = 901

public const int UnknownUnaryOperator = 905

public const int UnknownUnaryOperatorRight = 909

public const int absoluteValue = 523

public const int arrayConstructor = 505

public const int at_local = 101

public const int at_time_zone = 100

public const int between_conditions = 47

public const int caseExprOperator = 22

public const int compoundAssignment = 14

public const int compoundParenthesis = 18

public const int compoundPrior = 21

public const int compoundUnaryBitwiseNot = 222

public const int compoundUnaryMinus = 20

public const int compoundUnaryPlus = 19

public const int connect_by_root = 229

public const int cubeRoot = 519

public const int cursorExprOperator = 23

public const int datetimeExprOperator = 25

public const int day_to_second = 102

public const int dummyOperator = 37

public const int exists_condition = 48

public const int expr_list = 35

public const int factorial = 515

public const int factorialPrefix = 521

public const int fieldSelection = 501

public const int floating_point_conditions = 43

public const int funcationCallOperator = 24

public const int group_comparison_conditions = 41

public const int in_conditions = 42

public const int in_expr = 34

public const int intervalExprOperator = 26

public const int interval_expression = 104

public const int is_distinct_from = 135

public const int is_document = 133

public const int isoftype_condition = 49

public const int left_shift = 301

public const int logical_conditions_and = 50

public const int logical_conditions_is = 54

public const int logical_conditions_not = 53

public const int logical_conditions_or = 51

public const int logical_conditions_xor = 52

public const int member_of = 541

public const int modelExprOperator = 27

public const int multisetExprOperator = 310

public const int mysql_binary_operator = 300

public const int new_structured_type = 110

public const int new_variant_type = 111

public const int nextValueOf = 601

public const int null_conditions = 46

public const int objectaccessExprOperator = 30

public const int pattern_matching_conditions = 45

public const int period_ldiff = 115

public const int period_p_intersect = 119

public const int period_p_normalize = 121

public const int period_rdiff = 117

public const int placeholderExprOperator = 32

public const int ref_arrow = 226

public const int right_shift = 302

public const int rowConstructor = 509

public const int simpleConstant = 16

public const int simpleObjectname = 15

public const int simpleSourcetoken = 17

public const int simple_comparison_conditions = 40

public const int sqlserver_proprietary_column_alias = 230

public const int squareRoot = 517

public const int subqueryExprOperator = 28

public const int true_false_unknown = 137

public const int typecast = 227

public const int typeconstructorExprOperator = 29

public const int unknown = 0

public const int until_changed = 123

public const int year_to_month = 103

public virtual TArrayAccess ArrayAccess { get; set; }

public virtual TExpression BetweenOperand { get; set; }

public virtual TCaseExpression CaseExpression { get; set; }

public virtual TSourceToken ComparisonOperator { get; set; }

public virtual EComparisonType ComparisonType { get; set; }

public virtual TConstant ConstantOperand { get; set; }

public virtual TExplicitDataTypeConversion DataTypeConversion { get; set; }

public virtual List<TExplicitDataTypeConversion> DataTypeConversionList { get; set; }

public virtual TDatetimeExpression DatetimeExpression { get; set; }

public virtual TAliasClause ExprAlias { get; set; }

public virtual TExpressionList ExprList { get; set; }

public virtual EExpressionType ExpressionType { get; set; }

public virtual TObjectNameList FieldList { get; set; }

public virtual TObjectName FieldName { get; set; }

public virtual TFunctionCall FunctionCall { get; set; }

public virtual THiveVariable Hive_variable { get; set; }

public virtual TInExpr InExpr { get; set; }

public virtual TIndirection Indirection { get; set; }

public virtual TIntervalExpression IntervalExpr { get; set; }

public virtual TIntervalExpression IntervalExpression { get; set; }

public virtual bool Leaf { get; }

public virtual TExpression LeftOperand { get; set; }

public virtual TExpression LikeEscapeOperand { get; set; }

public virtual TNewVariantTypeArgumentList NewVariantTypeArgumentList { get; set; }

expr NOT IS NULL, expr NOT LIKE expr , expr NOT BETWEEN expr AND expr

expr IS NULL, expr LIKE expr , expr BETWEEN expr AND expr

[Obsolete("Property is deprecated, , please use NotToken instead")]
public virtual bool NotModifier { get; }

public virtual bool NotOperator { get; set; }

public virtual TSourceToken NotToken { get; set; }

public virtual TObjectAccess ObjectAccess { get; set; }

public virtual TObjectName ObjectOperand { get; set; }

public virtual TSourceToken OperatorToken { get; set; }

public virtual bool OracleOuterJoin { get; set; }

public virtual TOutputFormatPhraseList OutputFormatPhraseList { get; set; }

public virtual TAnalyticFunction Over_clause { get; set; }

public virtual TCustomSqlStatement OwnerStmt { get; set; }

public virtual TExpression ParentExpr { get; set; }

public virtual TSourceToken Quantifier { get; set; }

public virtual EQuantifierType QuantifierType { get; set; }

public virtual TExpression RightOperand { get; set; }

public virtual TObjectName SequenceName { get; set; }

public virtual TSourceToken SourcetokenOperand { get; set; }

public virtual TSelectSqlStatement SubQuery { get; set; }

public virtual bool SubQueryInStmt { get; set; }

public virtual TSelectSqlNode SubQueryNode { set; }

public virtual bool Subscripts { get; set; }

public virtual bool Symmetric { get; set; }

public virtual TTypeName TypeName { get; set; }

public virtual object Val { get; set; }

public virtual bool VisitSubTree { get; set; }

public virtual TWindowDef WindowSpecification { set; }

public override void accept(TParseTreeVisitor v)

public override void acceptChildren(TParseTreeVisitor v)

public virtual void addANDCondition(string condition)

public virtual void addORCondition(string condition)

public void copyTo(TExpression target)

public override void doParse(TCustomSqlStatement psql, ESqlClause plocation)

public TSourceToken getAndOrTokenBeforeExpr()

public static EComparisonType getComparisonType(TSourceToken comparisonOperator)

public ArrayList getFlattedAndOrExprs()

public virtual void inOrderTraverse(IExpressionVisitor ev)

public override void init(object arg1)

public override void init(object arg1, object arg2)

public override void init(object arg1, object arg2, object arg3)

public override void init(object arg1, object arg2, object arg3, object arg4)

public virtual bool isLeafExpr(TParseTreeNode pnode)

public static TExpression mergeObjectNameList(TExpression expr, TObjectNameList objectNameList)

public virtual void postOrderTraverse(IExpressionVisitor ev)

public virtual void preOrderTraverse(IExpressionVisitor ev)

public void remove()

public TExpressionList searchColumn(string columnName)

public void setBetweenOperand(TExpression e)

public void setCaseExpression(TCaseExpression ce)

public void setExprList(TExpressionList el)

public void setFunctionCall(TFunctionCall c)

public void setIndirection(TIndirection i)

public void setLeftOperand(TExpression e)

public void setLikeEscapeOperand(TExpression e)

public void setNotToken(TSourceToken st)

public void setOperatorToken(TSourceToken st)

public void setQuantifier(TSourceToken st)

public void setRightOperand(TExpression e)

public void setSubQueryNode(TSelectSqlNode subquery)

public void setSymmetric(bool b)

public virtual void setTokenToIdentifier()

public void setTypeName(TTypeName n)