gudusoft.gsqlparser.nodes

Class TExpression

java.lang.Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TExpression

All Implemented Interfaces:

Visitable

Direct Known Subclasses:

TCollMapBase, TCollPredBase, TNamedParameter, TPositionalParameter

public class TExpression
extends TParseTreeNode

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, getExpressionType() 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: EExpressionType.simple_object_name_t
  • object name: getObjectOperand()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A
• constant
  • type: EExpressionType.simple_constant_t
  • constant: getConstantOperand()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A
• sourcetoken
  • type: EExpressionType.simple_source_token_t
  • source token: getSourcetokenOperand()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A
• function call
  • type: EExpressionType.function_t
  • funcation call: getFunctionCall()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

UNARY

• + expr1
  • type: EExpressionType.unary_plus_t
  • left operand: N/A
  • right operand: getRightOperand
  • operator: getOperatorToken()
• - expr1
  • type: EExpressionType.unary_minus_t
  • left operand: N/A
  • right operand: getRightOperand
  • operator: getOperatorToken()
• expr1 !
  • type: EExpressionType.unary_factorial_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: getOperatorToken()
• ~ expr1
  • type: EExpressionType.unary_bitwise_not_t
  • left operand: N/A
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• @ expr1
  • type: EExpressionType.unary_absolutevalue_t
  • left operand: N/A
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• |/ expr1
  • type: EExpressionType.unary_squareroot_t
  • left operand: N/A
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• ||/ expr1
  • type: EExpressionType.unary_cuberoot_t
  • left operand: N/A
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• !! expr1
  • type: EExpressionType.unary_factorialprefix_t
  • left operand: N/A
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• Oracle: PRIOR expr1
  • type: EExpressionType.unary_prior_t
  • left operand: N/A
  • right operand: getRightOperand
  • operator: getOperatorToken()
• Oracle: CONNECT_BY_ROOT expr1
  • type: EExpressionType.unary_connect_by_root_t
  • left operand: N/A
  • right operand: getRightOperand
  • operator: getOperatorToken()
• MySQL: BINARY expr1
  • type: EExpressionType.unary_prior_t
  • left operand: N/A
  • right operand: getRightOperand
  • operator: getOperatorToken()

ARITHMETIC

• Addition: expr1 + expr2
  • type: EExpressionType.arithmetic_plus_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• Subtraction: expr1 - expr2
  • type: EExpressionType.arithmetic_minus_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• Multiplication: expr1 * expr2
  • type: EExpressionType.arithmetic_times_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• Division: expr1 / expr2
  • type: EExpressionType.arithmetic_divide_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• Modula: expr1 % expr2
  • type: EExpressionType.arithmetic_modulo_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• exponentiate: expr1 ^ expr2
  • type: EExpressionType.exponentiate_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• sql server 2008 +=,-=,*=,/=,%=: expr1 [+=|-=|*=|/=|%=] expr2
  • type: EExpressionType.arithmetic_compound_operator_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

LOGICAL

• expr1 AND|&& expr2
  • type: EExpressionType.logical_and_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• expr1 OR | || expr2
  • type: EExpressionType.logical_or_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• expr1 XOR expr2
  • type: EExpressionType.logical_xor_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• NOT|! expr1
  • type: EExpressionType.logical_not_t
  • left operand: N/A
  • right operand: getRightOperand()
  • operator: getOperatorToken()

ASSIGNMENT

• ASSIGNMENT: expr1 [:=|=] expr2
  • type: EExpressionType.assignment_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

CONCATENATE

• CONCATENATE: expr1 || expr2
  • type: EExpressionType.concatenate_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

AT TIME ZONE

• expr1 at time zone expr2
  • type: EExpressionType.at_time_zone_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: N/A

AT LOCAL

• expr1 at local
  • type: EExpressionType.at_local_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: N/A

BITWISE

• Bitwise and : expr1 & expr2
  • type: EExpressionType.bitwise_and_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• Bitwise or : expr1 | expr2
  • type: EExpressionType.bitwise_or_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• Bitwise exclusive or : expr1 ^ expr2
  • type: EExpressionType.bitwise_exclusive_or_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• Bitwise xor : expr1 ^ expr2
  • type: EExpressionType.bitwise_xor_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• Bitwise shift left : expr1 << expr2
  • type: EExpressionType.bitwise_shift_left_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• Bitwise shift right : expr1 >> expr2
  • type: EExpressionType.bitwise_shift_right_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

SUBQUERY

• A scalar subquery expression is a subquery that returns exactly one column value from one row.
  • type: EExpressionType.subquery_t
  • subquery: getSubQuery()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

EXPRESSION WITH PARENTHESIS

• ( expr1 )
  • type: EExpressionType.parenthesis_t
  • left operand is expr1: getLeftOperand()
  • right operand: N/A
  • operator: use TParseTreeNode.getStartToken() to get ( and TParseTreeNode.getEndToken() to get )

LIST EXPRESSION

• An expression list inside parenthesis like (expr,expr,...), or one or more set of expressions: ((expr1,expr2,...),(expr1,expr2,...),(expr1,expr2,...)...)
  • type: EExpressionType.list_t
  • expr list: getExprList(), may return null when expression list in syntax like this: ()
  • left operand: N/A
  • right operand: N/A
  • operator: open parenthsis ( can be fetched via TParseTreeNode.getStartToken(), close parenthesis ) can be fetched via TParseTreeNode.getEndToken()

COLLECTION CONSTRUCTORS (informix)

• Use a collection constructor to specify values for a collection column. SET|MULTISET|LIST { epxr_list }
  • type: EExpressionType.collection_constructor_set_t
  • type: EExpressionType.collection_constructor_multiset_t
  • type: EExpressionType.collection_constructor_list_t
  • expr list: getExprList(), 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

COMPARISON

• A simple comparison condition specifies a comparison with expressions or subquery results.
  expr1 EQUAL|NOT_EQUAL|LESS_THAN|GRREAT_THAN|LESS_EQUAL_THAN|GREATE_EQUAL_THAN expr2, or, (expr_list) EQUAL|NOT_EQUAL (subquery)
  • type: EExpressionType.simple_comparison_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
• A group comparison condition specifies a comparison with any or all members in a list or subquery.
  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)
  • type: EExpressionType.group_comparison_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
  • ANY|SOME|ALL: getQuantifier()

IN

• (expr|expr_list) |NOT] IN (expr_list)|(subquery)|expr
  • type: EExpressionType.in_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator is IN: getOperatorToken()
  • NOT keyword: getNotToken()

CASE

• case expression,let you use IF ... THEN ... ELSE logic in SQL statements without having to invoke procedures.
  • type: EExpressionType.case_t
  • case expression: getCaseExpression()}
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

CURSOR

• CURSOR subquery
  • type: EExpressionType.cursor_t
  • subquery: getSubQuery()
  • left operand: N/A
  • right operand: N/A
  • operator: CURSOR can be fetched via TParseTreeNode.getStartToken()

PATTERN MATCHING

• expr1 [NOT] [LIKE|ILIKE|RLIKE|REGEXP|SIMILAR TO] [ALL|ANY|SOME]expr2 [ESCAPE expr3]
  • type: EExpressionType.pattern_matching_t
  • left operand: getLeftOperand()
  • right operand:getRightOperand()
  • expr3: getLikeEscapeOperand()
  • operator: getOperatorToken()
  • NOT keyword: getNotToken()
  • ALL|ANY|SOME keyword: getQuantifier()
  • ESCAPE keyword: N/A

NULL

• expr ISNULL|NOTNULL|IS [NOT] NULL
  • type: EExpressionType.null_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator is NULL: getOperatorToken()
  • NOT keyword: getNotToken()

BETWEEN

• expr1 [NOT] BETWEEN expr2 AND expr3
  • type: EExpressionType.between_t
  • expr1: getBetweenOperand()
  • expr2: getLeftOperand()
  • expr3: getRightOperand()
  • operator is BETWEEN: getOperatorToken()
  • NOT keyword: getNotToken()

EXISTS

• EXISTS (subquery)
  • type: EExpressionType.exists_t
  • left operand: N/A
  • right operand: N/A
  • subquery: getSubQuery()
  • EXISTS: TParseTreeNode.getStartToken()

IS UNKNOWN

• expr1 IS [NOT] UNKNOWN
  • type: EExpressionType.is_unknown_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: getOperatorToken()
  • NOT keyword: getNotToken()

IS TRUE

• expr1 IS [NOT] TRUE
  • type: EExpressionType.is_true_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: getOperatorToken()
  • NOT keyword: getNotToken()

IS FALSE

• expr1 IS [NOT] FALSE
  • type: EExpressionType.is_false_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: getOperatorToken()
  • NOT keyword: getNotToken()

DAY TO SECOND

• expr DAY [( integer )] TO SECOND [( integer )]
  • type: EExpressionType.day_to_second_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: N/A

YEAR TO MONTH

• expr YEAR [( integer )] TO MONTH
  • type: EExpressionType.year_to_month_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: N/A

INTERVAL(teradata)

• ( date_time_expression date_time_term ) start TO end
  • type: EExpressionType.interval_t
  • date_time_expression: getIntervalExpr()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

NEW STRUCTURED TYPE

• NEW function_call
  • type: EExpressionType.new_structured_type_t
  • function_call: getFunctionCall()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

NEW VARIANT_TYPE

• NEW VARIANT_TYPE ( type_argument_list )
  • type: EExpressionType.new_variant_type_t
  • type_argument_list: getNewVariantTypeArgumentList()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

LDIFF,RDIFF,P_INTERSECT,P_NORMALIZE

• expr1 LDIFF|RDIFF|P_INTERSECT|P_NORMALIZE expr2
  • type: EExpressionType.new_variant_type_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

UNTIL CHANGED

• expr1 IS [NOT] UNTIL_CHANGED
  • type: EExpressionType.new_variant_type_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: getOperatorToken()
  • NOT keyword: getNotToken()

LEFT SHIFT

• expr1 << expr2
  • type: EExpressionType.left_shift_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

RIGHT SHIFT

• expr1 >> expr2
  • type: EExpressionType.right_shift_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

IS DOCUMENT

• expr1 IS [NOT] DOCUMENT
  • type: EExpressionType.is_document_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: getOperatorToken()
  • NOT keyword: getNotToken()

IS DISTINCT FROM

• expr1 IS [NOT] DISTINCT FROM expr2
  • type: EExpressionType.is_distinct_from_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
  • NOT keyword: getNotToken()

SQL SERVER left join

• expr1 *= expr2
  • type: EExpressionType.left_join_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

SQL SERVER right join

• expr1 =* expr2
  • type: EExpressionType.right_join_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

COLLATE

• expr1 COLLATE expr2
  • type: EExpressionType.collate_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()
  • NOT keyword: getNotToken()

MEMBER OF

• expr1 MEMBER OF expr2
  • type: EExpressionType.member_of_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

NEXT VALUE FOR

• NEXT VALUE FOR , or NEXT VALUE FOR
  • type: EExpressionType.next_value_for_t
  • sequence name: getSequenceName()
  • over_clause : getOver_clause()}
  • left operand(integer expression): getLeftOperand()

REF ARROW(named parameters in function call)

• expr1 => expr2
  • type: EExpressionType.ref_arrow_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

TYPECAST

• expr1 TYPECAST typename
  • type: EExpressionType.typecast_t
  • typename: getTypeName()
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: getOperatorToken()

MULTISET

• MULTISET subquery
  • type: EExpressionType.multiset_t
  • subquery: getSubQuery()
  • left operand: N/A
  • right operand: N/A
  • operator: MULTISET can be fetched via TParseTreeNode.getStartToken()

FLOATING POINT

• expr is [NOT] NAN|INFINITE
  • type: EExpressionType.floating_point_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator is IS: getOperatorToken()
  • NOT keyword: getNotToken()

ROW CONSTRUCTOR

• ROW ( expr_list )
  • type: EExpressionType.row_constructor_t
  • expr_list: getExprList()
  • left operand: N/A
  • right operand: N/A
  • operator is ROW: TParseTreeNode.getStartToken()

IS OF TYPE

• expr is of type ( datatype,...)
  • type: EExpressionType.is_of_type_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: N/A

PLACE HOLDER

• place holder expression
  • type: EExpressionType.place_holder_t
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

TYPE_CONSTRUCTOR_EXPRESSION

• [NEW] type_name( expr_list )
  • type: EExpressionType.type_constructor_t
  • type_name(expr_list): getFunctionCall()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

ARRAY ACCESS

• array_name(index1)(index2)(index3)
  • type: EExpressionType.arrayaccess_t
  • array_name(index1)(index2)(index3): getArrayAccess()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

OBJECT ACCESS EXPRESSION

• objectExpr.[attributes].method()
  • type: EExpressionType.object_access_t
  • objectExpr.[attributes].method(): getObjectAccess()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

Unknown

• expr OPERATOR expr, means this expression was not recognized by SQL parser yet.
  • type: EExpressionType.unknown_t
  • left operand: getLeftOperand()
  • right operand: getRightOperand()
  • operator: getOperatorToken()

Unknown unary left

• OPERATOR expr, means this expression was not recognized by SQL parser yet.
  • type: EExpressionType.unary_left_unknown_t
  • left operand: N/A
  • right operand: getRightOperand()
  • operator: getOperatorToken()

Unknown unary right

• expr OPERATOR, means this expression was not recognized by SQL parser yet.
  • type: EExpressionType.unary_right_unknown_t
  • left operand: getLeftOperand()
  • right operand: N/A
  • operator: getOperatorToken()

ARRAY CONSTRUCTOR

• 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 getExprList(),

  or getExprList() 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 getSubQuery()

  • type: EExpressionType.array_constructor_t
  • array element values: getExprList()
  • subquery: getSubQuery()
  • left operand: N/A
  • right operand: N/A
  • operator: N/A

FIELD SELECTION

• 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 getFieldName()

  (rowfunction(a,b)).col3

  (compositecol).somefield

  (mytable.compositecol).somefield

  (compositecol).*

  Otherwise, it will be marked as simpleObjectname:

  mytable.mycolumn

  $1.somecolumn

  • type: EExpressionType.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: EExpressionType.array_access_expr_t
  • fieldexpr: getLeftOperand()
  • expr_subscript: getRightOperand()
  • operator: N/A

HIVE FIELD ACCESS

• HIVE field access syntax like fieldexpr.identifier.identifier...
  • type: EExpressionType.object_access_t
  • fieldexpr: getLeftOperand()
  • identifier.identifier...: getFieldList()
  • operator: N/A

JSON Operators (PostgreSQL)

• expr1 -> expr2
  • type: EExpressionType.json_get_object
  • left operand: getLeftOperand()
  • right operand: getLeftOperand()
• expr1 ->> expr2
  • type: EExpressionType.json_get_text
  • left operand: getLeftOperand()
  • right operand: getLeftOperand()
• expr1 #> expr2
  • type: EExpressionType.json_get_object_at_path
  • left operand: getLeftOperand()
  • right operand: getLeftOperand()
• expr1 #>> expr2
  • type: EExpressionType.json_get_text_at_path
  • left operand: getLeftOperand()
  • right operand: getLeftOperand()
• expr1 @> expr2
  • type: EExpressionType.json_left_contain
  • left operand: getLeftOperand()
  • right operand: getLeftOperand()
• expr1 >@ expr2
  • type: EExpressionType.json_right_contain
  • left operand: getLeftOperand()
  • right operand: getLeftOperand()
• expr1 ? expr2
  • type: EExpressionType.json_exist
  • left operand: getLeftOperand()
  • right operand: getLeftOperand()
• expr1 ?| expr2
  • type: EExpressionType.json_any_exist
  • left operand: getLeftOperand()
  • right operand: getLeftOperand()
• expr1 ?& expr2
  • type: EExpressionType.json_all_exist
  • left operand: getLeftOperand()
  • right operand: getLeftOperand()

IS [NOT] A SET

• Oracle set operator: IS [NOT] A SET
  • type: EExpressionType.is_a_set_t
  • left operand: getLeftOperand()
  • operator: N/A

Big Query ARRAY <T>[ expr_list ]

• ARRAY <T>[ expr_list ], expr_list maybe empty
  • type: EExpressionType.array_t
  • left operand: getExprList()
  • getTypeName() returns the T of this Array if specified.

Field Summary

Fields

Modifier and Type	Field and Description
static int	absoluteValue Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_absolutevalue_t
static int	arrayaccess Deprecated. As of v1.4.3.0, replaced by EExpressionType.arrayaccess_t
static int	arrayConstructor Deprecated. As of v1.4.3.0, replaced by EExpressionType.array_constructor_t
static int	ASSIGNMENT Deprecated. As of v1.4.3.0, replaced by EExpressionType.assignment_t
static int	at_local Deprecated. As of v1.4.3.0, replaced by EExpressionType.at_local_t
static int	at_time_zone Deprecated. As of v1.4.3.0, replaced by EExpressionType.at_time_zone_t
static int	between_conditions Deprecated. As of v1.4.3.0, replaced by EExpressionType.between_t
static int	BigAndOrNestLevel
static int	BITWISE_AND Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_and_t
static int	BITWISE_EXCLUSIVE_OR Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_exclusive_or_t
static int	BITWISE_NOT Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_bitwise_not_t
static int	BITWISE_OR Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_or_t
static int	BITWISE_SHIFT_LEFT Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_shift_left_t
static int	BITWISE_SHIFT_RIGHT Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_shift_right_t
static int	BITWISE_XOR Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_xor_t
static int	caseExprOperator Deprecated. As of v1.4.3.0, replaced by EExpressionType.case_t
static int	COLLATE Deprecated. As of v1.4.3.0, replaced by EExpressionType.collate_t
static int	compoundAssignment Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_compound_operator_t
static int	compoundParenthesis Deprecated. As of v1.4.3.0, replaced by EExpressionType.parenthesis_t
static int	compoundPrior Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_prior_t
static int	compoundUnaryBitwiseNot Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_bitwise_not_t
static int	compoundUnaryMinus Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_minus_t
static int	compoundUnaryPlus Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_plus_t
static int	CONCATENATE Deprecated. As of v1.4.3.0, replaced by EExpressionType.concatenate_t
static int	connect_by_root Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_connect_by_root_t
static int	cubeRoot Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_cuberoot_t
static int	cursorExprOperator Deprecated. As of v1.4.3.0, replaced by EExpressionType.cursor_t
static int	datetimeExprOperator Deprecated. As of v1.4.3.0
static int	day_to_second Deprecated. As of v1.4.3.0, replaced by EExpressionType.day_to_second_t
static int	DIVIDE Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_divide_t
static int	dummyOperator Deprecated. As of v1.4.3.0
static int	exists_condition Deprecated. As of v1.4.3.0, replaced by EExpressionType.exists_t
static int	EXPONENTIATE Deprecated. As of v1.4.3.0, replaced by EExpressionType.exponentiate_t
static int	expr_list Deprecated. As of v1.4.3.0, replaced by EExpressionType.list_t
static int	factorial Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_factorial_t
static int	factorialPrefix Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_factorialprefix_t
static int	fieldSelection Deprecated. As of v1.4.3.0, replaced by EExpressionType.fieldselection_t
static int	floating_point_conditions Deprecated. As of v1.4.3.0, replaced by EExpressionType.floating_point_t
static int	funcationCallOperator Deprecated. As of v1.4.3.0, replaced by EExpressionType.function_t
static int	group_comparison_conditions Deprecated. As of v1.4.3.0, replaced by EExpressionType.group_comparison_t
static int	in_conditions Deprecated. As of v1.4.3.0, replaced by EExpressionType.in_t
static int	in_expr Deprecated. As of v1.4.3.0, replaced by EExpressionType.group_t
static int	interval_expression Deprecated. As of v1.4.3.0, replaced by EExpressionType.interval_t
static int	intervalExprOperator Deprecated. As of v1.4.3.0
static int	is_distinct_from Deprecated. As of v1.4.3.0, replaced by EExpressionType.is_distinct_from_t
static int	is_document Deprecated. As of v1.4.3.0, replaced by EExpressionType.is_document_t
static int	isoftype_condition Deprecated. As of v1.4.3.0, replaced by EExpressionType.is_of_type_t
static int	left_shift Deprecated. As of v1.4.3.0, replaced by EExpressionType.left_shift_t
static int	LEFTJOIN_OP Deprecated. As of v1.4.3.0, replaced by EExpressionType.left_join_t
static int	logical_conditions_and Deprecated. As of v1.4.3.0, replaced by EExpressionType.logical_and_t
static int	logical_conditions_is Deprecated. As of v1.4.3.0, replaced by EExpressionType.is_t
static int	logical_conditions_not Deprecated. As of v1.4.3.0, replaced by EExpressionType.logical_not_t
static int	logical_conditions_or Deprecated. As of v1.4.3.0, replaced by EExpressionType.logical_or_t
static int	logical_conditions_xor Deprecated. As of v1.4.3.0, replaced by EExpressionType.logical_xor_t
static int	member_of Deprecated. As of v1.4.3.0, replaced by EExpressionType.member_of_t
static int	MINUS Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_minus_t
static int	modelExprOperator Deprecated. As of v1.4.3.0
static int	MODULO Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_modulo_t
static int	multisetExprOperator Deprecated. As of v1.4.3.0, replaced by EExpressionType.multiset_t
static int	mysql_binary_operator Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_binary_operator_t
static int	new_structured_type Deprecated. As of v1.4.3.0, replaced by EExpressionType.new_structured_type_t
static int	new_variant_type Deprecated. As of v1.4.3.0, replaced by EExpressionType.new_variant_type_t
static int	nextValueOf Deprecated. As of v1.4.3.0, replaced by EExpressionType.next_value_for_t
static int	null_conditions Deprecated. As of v1.4.3.0, replaced by EExpressionType.null_t
static int	objectaccessExprOperator Deprecated. As of v1.4.3.0, replaced by EExpressionType.object_access_t
static int	pattern_matching_conditions Deprecated. As of v1.4.3.0, replaced by EExpressionType.pattern_matching_t
static int	period_ldiff Deprecated. As of v1.4.3.0, replaced by EExpressionType.period_ldiff_t
static int	period_p_intersect Deprecated. As of v1.4.3.0, replaced by EExpressionType.period_p_intersect_t
static int	period_p_normalize Deprecated. As of v1.4.3.0, replaced by EExpressionType.period_p_normalize_t
static int	period_rdiff Deprecated. As of v1.4.3.0, replaced by EExpressionType.period_rdiff_t
static int	placeholderExprOperator Deprecated. As of v1.4.3.0, replaced by EExpressionType.place_holder_t
static int	PLUS Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_plus_t
static int	POWER Deprecated. As of v1.4.3.0, replaced by EExpressionType.power_t
static int	RANGE Deprecated. As of v1.4.3.0, replaced by EExpressionType.range_t
static int	ref_arrow Deprecated. As of v1.4.3.0, replaced by EExpressionType.ref_arrow_t
static int	right_shift Deprecated. As of v1.4.3.0, replaced by EExpressionType.right_shift_t
static int	RIGHTJOIN_OP Deprecated. As of v1.4.3.0, replaced by EExpressionType.right_join_t
static int	rowConstructor Deprecated. As of v1.4.3.0, replaced by EExpressionType.row_constructor_t
static int	SCOPE_RESOLUTION Deprecated. As of v1.4.3.0, replaced by EExpressionType.scope_resolution_t
static int	simple_comparison_conditions Deprecated. As of v1.4.3.0, replaced by EExpressionType.simple_comparison_t
static int	simpleConstant Deprecated. As of v1.4.3.0, replaced by EExpressionType.simple_constant_t
static int	simpleObjectname Deprecated. As of v1.4.3.0, replaced by EExpressionType.simple_object_name_t
static int	simpleSourcetoken Deprecated. As of v1.4.3.0, replaced by EExpressionType.simple_source_token_t
static int	sqlserver_proprietary_column_alias Deprecated. As of v1.4.3.0, replaced by EExpressionType.sqlserver_proprietary_column_alias_t
static int	squareRoot Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_squareroot_t
static int	subqueryExprOperator Deprecated. As of v1.4.3.0, replaced by EExpressionType.subquery_t
static int	TIMES Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_times_t
static int	true_false_unknown Deprecated. As of v1.4.3.0, replaced by EExpressionType.is_true_t, EExpressionType.is_false_t,EExpressionType.is_unknown_t
static int	typecast Deprecated. As of v1.4.3.0, replaced by EExpressionType.typecast_t
static int	typeconstructorExprOperator Deprecated. As of v1.4.3.0
static int	unknown Deprecated. As of v1.4.3.0, replaced by EExpressionType.not_initialized_yet_t
static int	UnknownOperator Deprecated. As of v1.4.3.0, replaced by EExpressionType.unknown_t
static int	UnknownUnaryOperator Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_left_unknown_t
static int	UnknownUnaryOperatorRight Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_right_unknown_t
static int	until_changed Deprecated. As of v1.4.3.0, replaced by EExpressionType.until_changed_t
static int	year_to_month Deprecated. As of v1.4.3.0, replaced by EExpressionType.year_to_month_t

Constructor Summary

Constructors

Constructor and Description
TExpression()
TExpression(EExpressionType pExpressionType)
TExpression(EExpressionType pExpressionType, TExpression pLeft, TExpression pRight)
TExpression(EExpressionType pExpressionType, TExpression pLeft, TExpression pRight, EComparisonType pComparisonType)
TExpression(TConstant constantOperand)
TExpression(TFunctionCall functionCall)
TExpression(TObjectName objectOperand)

Method Summary

Modifier and Type	Method and Description
void	accept(TParseTreeVisitor v) Accept a visitor
void	acceptChildren(TParseTreeVisitor v) Accept a visitor to iterate this class and sub-nodes of this class
void	addANDCondition(String condition) if original expr is f > 1, and call addANDCondition("f2 > 2") expression will be: f > 1 and f2 > 2
void	addORCondition(String condition) if original expr is f > 1, and call addORCondition("f2 > 2") expression will be: f > 1 or f2 > 2
void	copyTo(TExpression target)
void	doParse(TCustomSqlStatement psql, ESqlClause plocation) Analyze the sub-nodes inside this node.
TSourceToken	getAndOrTokenBeforeExpr()
TArrayAccess	getArrayAccess()
TArrayConstruct	getArrayConstruct()
TExpression	getBetweenOperand()
TCaseExpression	getCaseExpression()
TCollectionArray	getCollectionArray()
TCollectionCondition	getCollectionCondition()
TSourceToken	getComparisonOperator()
EComparisonType	getComparisonType()
static EComparisonType	getComparisonType(TSourceToken comparisonOperator)
TConstant	getConstantOperand()
TExplicitDataTypeConversion	getDataTypeConversion()
TPTNodeList<TExplicitDataTypeConversion>	getDataTypeConversionList()
TAliasClause	getExprAlias() In Teradata, it is possible there is an alias for expression
EExpressionType	getExpressionType() change return type from int to EExpressionType since 1.4.3.0
TExpressionList	getExprList()
TObjectNameList	getFieldList()
TObjectName	getFieldName() valid when getExpressionType() is fieldSelection
ArrayList	getFlattedAndOrExprs() Binary tree structure representation of expression makes AND/OR expression nested deeply when there are lots of AND/OR condition is used.
TSourceToken	getFractionalSecondsPrecision()
TFunctionCall	getFunctionCall()
THiveVariable	getHive_variable()
TIndirection	getIndirection()
TInExpr	getInExpr() Deprecated. As of v1.4.3.3, replaced by getRightOperand()
TIntervalExpression	getIntervalExpr()
TSourceToken	getLeadingPrecision()
TExpression	getLeftOperand()
TExpression	getLikeEscapeOperand()
TNamedParameter	getNamedParameter()
TNewVariantTypeArgumentList	getNewVariantTypeArgumentList()
TSourceToken	getNotToken()
TObjectAccess	getObjectAccess()
TObjectConstruct	getObjectConstruct()
TObjectName	getObjectOperand()
TSourceToken	getOperatorToken() Operator token used in expression such as +,-,*,/ and etc
TOutputFormatPhraseList	getOutputFormatPhraseList() teradata:
TAnalyticFunction	getOver_clause()
TExpression	getParentExpr()
TPositionalParameter	getPositionalParameter()
TSourceToken	getQuantifier() one of the following quantifier keywords: SOME, ANY, ALL
EQuantifierType	getQuantifierType()
TExpression	getRightOperand()
TObjectName	getSequenceName()
TSourceToken	getSourcetokenOperand()
TSelectSqlStatement	getSubQuery()
TTypeName	getTypeName()
Object	getVal() value of this expression, valid only after evaluate this expression.
void	init(Object arg1) Initialize a query tree node.
void	init(Object arg1, Object arg2)
void	init(Object arg1, Object arg2, Object arg3)
void	init(Object arg1, Object arg2, Object arg3, Object arg4) initialize a new instance of TExpression.
void	inOrderTraverse(IExpressionVisitor ev) Traverse expression in In Order.
boolean	isLeaf() expression type such as column reference is a leaf expression while subtract expression is not a leaf expression.
boolean	isLeafExpr(TParseTreeNode pnode)
boolean	isNotModifier() Deprecated. As of v1.4.3.0, replaced by getNotToken()
boolean	isNotOperator()
boolean	isOracleOuterJoin()
boolean	isSubscripts() If an expression yields a value of an array type, then a specific element of the array value can be extracted by writing
boolean	isSymmetric() PostgreSQL BETWEEN SYMMETRIC is the same as BETWEEN except there is no requirement that the argument to the left of AND be less than or equal to the argument on the right.
boolean	isVisitSubTree()
static TExpression	mergeObjectNameList(TExpression expr, TObjectNameList objectNameList)
void	postOrderTraverse(IExpressionVisitor ev) Traverse expression in post order.
void	preOrderTraverse(IExpressionVisitor ev) Traverse expression in pre Order.
void	remove()
void	remove2() remove this expression from it's parent expr.
TExpressionList	searchColumn(String columnName)
void	setArrayAccess(TArrayAccess arrayAccess) Deprecated. As of v1.4.3.3
void	setBetweenOperand(TExpression betweenOperand)
void	setCaseExpression(TCaseExpression caseExpression)
void	setComparisonOperator(TSourceToken comparisonOperator)
void	setComparisonType(EComparisonType comparisonType)
void	setConstantOperand(TConstant constantOperand)
void	setDataTypeConversion(TExplicitDataTypeConversion dataTypeConversion)
void	setDataTypeConversionList(TPTNodeList<TExplicitDataTypeConversion> dataTypeConversionList)
void	setDatetimeExpression(TDatetimeExpression datetimeExpression)
void	setExprAlias(TAliasClause exprAlias)
void	setExpressionType(EExpressionType exprType)
void	setExprList(TExpressionList exprList)
void	setFieldList(TObjectNameList fieldList)
void	setFractionalSecondsPrecision(TSourceToken fractionalSecondsPrecision)
void	setFunctionCall(TFunctionCall functionCall)
void	setHive_variable(THiveVariable hive_variable)
void	setIndirection(TIndirection indirection)
void	setInExpr(TInExpr inExpr)
void	setIntervalExpr(TIntervalExpression intervalExpr)
void	setIntervalExpression(TIntervalExpression intervalExpression)
void	setLeadingPrecision(TSourceToken leadingPrecision)
void	setLeftOperand(TExpression leftOperand)
void	setLikeEscapeOperand(TExpression likeEscapeOperand)
void	setNewVariantTypeArgumentList(TNewVariantTypeArgumentList newVariantTypeArgumentList)
void	setNotToken(TSourceToken notToken)
void	setObjectAccess(TObjectAccess objectAccess)
void	setObjectOperand(TObjectName objectOperand)
void	setOperatorToken(TSourceToken operatorToken)
void	setOracleOuterJoin(boolean oracleOuterJoin)
void	setOutputFormatPhraseList(TOutputFormatPhraseList outputFormatPhraseList)
void	setParentExpr(TExpression parentExpr)
void	setQuantifier(TSourceToken quantifier)
void	setQuantifierType(EQuantifierType quantifierType)
void	setRightOperand(TExpression rightOperand)
void	setSourcetokenOperand(TSourceToken sourcetokenOperand)
void	setSubQuery(TSelectSqlStatement subQuery)
void	setSubQueryInStmt(boolean subQueryInStmt)
void	setSubQueryNode(TSelectSqlNode subQueryNode)
void	setSymmetric(boolean symmetric)
void	setTokenToIdentifier()
void	setTypeName(TTypeName typeName)
void	setVal(Object val)
void	setVisitSubTree(boolean visitSubTree)
void	setWindowSpecification(TWindowDef windowSpecification)

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, appendString, fastSetString, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, removeAllMyTokensFromTokenList, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setGsqlparser, setIncludingComment, setNodeType, setStartToken, setStartToken, setStartToken, setStartToken, setString, toScript, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

BigAndOrNestLevel

public static final int BigAndOrNestLevel

See Also:

Constant Field Values

unknown

public static final int unknown

Deprecated. As of v1.4.3.0, replaced by EExpressionType.not_initialized_yet_t

See Also:

Constant Field Values

PLUS

public static final int PLUS

Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_plus_t

See Also:

Constant Field Values

MINUS

public static final int MINUS

Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_minus_t

See Also:

Constant Field Values

TIMES

public static final int TIMES

Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_times_t

See Also:

Constant Field Values

DIVIDE

public static final int DIVIDE

Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_divide_t

See Also:

Constant Field Values

CONCATENATE

public static final int CONCATENATE

Deprecated. As of v1.4.3.0, replaced by EExpressionType.concatenate_t

See Also:

Constant Field Values

MODULO

public static final int MODULO

Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_modulo_t

See Also:

Constant Field Values

ASSIGNMENT

public static final int ASSIGNMENT

Deprecated. As of v1.4.3.0, replaced by EExpressionType.assignment_t

See Also:

Constant Field Values

BITWISE_AND

public static final int BITWISE_AND

Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_and_t

See Also:

Constant Field Values

BITWISE_OR

public static final int BITWISE_OR

Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_or_t

See Also:

Constant Field Values

BITWISE_XOR

public static final int BITWISE_XOR

Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_xor_t

See Also:

Constant Field Values

BITWISE_EXCLUSIVE_OR

public static final int BITWISE_EXCLUSIVE_OR

Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_exclusive_or_t

See Also:

Constant Field Values

SCOPE_RESOLUTION

public static final int SCOPE_RESOLUTION

Deprecated. As of v1.4.3.0, replaced by EExpressionType.scope_resolution_t

See Also:

Constant Field Values

EXPONENTIATE

public static final int EXPONENTIATE

Deprecated. As of v1.4.3.0, replaced by EExpressionType.exponentiate_t

See Also:

Constant Field Values

compoundAssignment

public static final int compoundAssignment

Deprecated. As of v1.4.3.0, replaced by EExpressionType.arithmetic_compound_operator_t

See Also:

Constant Field Values

simpleObjectname

public static final int simpleObjectname

Deprecated. As of v1.4.3.0, replaced by EExpressionType.simple_object_name_t

See Also:

Constant Field Values

simpleConstant

public static final int simpleConstant

Deprecated. As of v1.4.3.0, replaced by EExpressionType.simple_constant_t

See Also:

Constant Field Values

simpleSourcetoken

public static final int simpleSourcetoken

Deprecated. As of v1.4.3.0, replaced by EExpressionType.simple_source_token_t

See Also:

Constant Field Values

compoundParenthesis

public static final int compoundParenthesis

Deprecated. As of v1.4.3.0, replaced by EExpressionType.parenthesis_t

See Also:

Constant Field Values

compoundUnaryPlus

public static final int compoundUnaryPlus

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_plus_t

See Also:

Constant Field Values

compoundUnaryMinus

public static final int compoundUnaryMinus

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_minus_t

See Also:

Constant Field Values

compoundPrior

public static final int compoundPrior

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_prior_t

See Also:

Constant Field Values

caseExprOperator

public static final int caseExprOperator

Deprecated. As of v1.4.3.0, replaced by EExpressionType.case_t

See Also:

Constant Field Values

cursorExprOperator

public static final int cursorExprOperator

Deprecated. As of v1.4.3.0, replaced by EExpressionType.cursor_t

See Also:

Constant Field Values

funcationCallOperator

public static final int funcationCallOperator

Deprecated. As of v1.4.3.0, replaced by EExpressionType.function_t

See Also:

Constant Field Values

datetimeExprOperator

public static final int datetimeExprOperator

Deprecated. As of v1.4.3.0

See Also:

Constant Field Values

intervalExprOperator

public static final int intervalExprOperator

Deprecated. As of v1.4.3.0

See Also:

Constant Field Values

modelExprOperator

public static final int modelExprOperator

Deprecated. As of v1.4.3.0

See Also:

Constant Field Values

subqueryExprOperator

public static final int subqueryExprOperator

Deprecated. As of v1.4.3.0, replaced by EExpressionType.subquery_t

See Also:

Constant Field Values

typeconstructorExprOperator

public static final int typeconstructorExprOperator

Deprecated. As of v1.4.3.0

See Also:

Constant Field Values

objectaccessExprOperator

public static final int objectaccessExprOperator

Deprecated. As of v1.4.3.0, replaced by EExpressionType.object_access_t

See Also:

Constant Field Values

placeholderExprOperator

public static final int placeholderExprOperator

Deprecated. As of v1.4.3.0, replaced by EExpressionType.place_holder_t

See Also:

Constant Field Values

in_expr

public static final int in_expr

Deprecated. As of v1.4.3.0, replaced by EExpressionType.group_t

See Also:

Constant Field Values

expr_list

public static final int expr_list

Deprecated. As of v1.4.3.0, replaced by EExpressionType.list_t

See Also:

Constant Field Values

dummyOperator

public static final int dummyOperator

Deprecated. As of v1.4.3.0

See Also:

Constant Field Values

simple_comparison_conditions

public static final int simple_comparison_conditions

Deprecated. As of v1.4.3.0, replaced by EExpressionType.simple_comparison_t

See Also:

Constant Field Values

group_comparison_conditions

public static final int group_comparison_conditions

Deprecated. As of v1.4.3.0, replaced by EExpressionType.group_comparison_t

See Also:

Constant Field Values

in_conditions

public static final int in_conditions

Deprecated. As of v1.4.3.0, replaced by EExpressionType.in_t

See Also:

Constant Field Values

floating_point_conditions

public static final int floating_point_conditions

Deprecated. As of v1.4.3.0, replaced by EExpressionType.floating_point_t

See Also:

Constant Field Values

pattern_matching_conditions

public static final int pattern_matching_conditions

Deprecated. As of v1.4.3.0, replaced by EExpressionType.pattern_matching_t

See Also:

Constant Field Values

null_conditions

public static final int null_conditions

Deprecated. As of v1.4.3.0, replaced by EExpressionType.null_t

See Also:

Constant Field Values

between_conditions

public static final int between_conditions

Deprecated. As of v1.4.3.0, replaced by EExpressionType.between_t

See Also:

Constant Field Values

exists_condition

public static final int exists_condition

Deprecated. As of v1.4.3.0, replaced by EExpressionType.exists_t

See Also:

Constant Field Values

isoftype_condition

public static final int isoftype_condition

Deprecated. As of v1.4.3.0, replaced by EExpressionType.is_of_type_t

See Also:

Constant Field Values

logical_conditions_and

public static final int logical_conditions_and

Deprecated. As of v1.4.3.0, replaced by EExpressionType.logical_and_t

See Also:

Constant Field Values

logical_conditions_or

public static final int logical_conditions_or

Deprecated. As of v1.4.3.0, replaced by EExpressionType.logical_or_t

See Also:

Constant Field Values

logical_conditions_xor

public static final int logical_conditions_xor

Deprecated. As of v1.4.3.0, replaced by EExpressionType.logical_xor_t

See Also:

Constant Field Values

logical_conditions_not

public static final int logical_conditions_not

Deprecated. As of v1.4.3.0, replaced by EExpressionType.logical_not_t

See Also:

Constant Field Values

logical_conditions_is

public static final int logical_conditions_is

Deprecated. As of v1.4.3.0, replaced by EExpressionType.is_t

See Also:

Constant Field Values

RANGE

public static final int RANGE

Deprecated. As of v1.4.3.0, replaced by EExpressionType.range_t

See Also:

Constant Field Values

POWER

public static final int POWER

Deprecated. As of v1.4.3.0, replaced by EExpressionType.power_t

See Also:

Constant Field Values

at_time_zone

public static final int at_time_zone

Deprecated. As of v1.4.3.0, replaced by EExpressionType.at_time_zone_t

See Also:

Constant Field Values

at_local

public static final int at_local

Deprecated. As of v1.4.3.0, replaced by EExpressionType.at_local_t

See Also:

Constant Field Values

day_to_second

public static final int day_to_second

Deprecated. As of v1.4.3.0, replaced by EExpressionType.day_to_second_t

See Also:

Constant Field Values

year_to_month

public static final int year_to_month

Deprecated. As of v1.4.3.0, replaced by EExpressionType.year_to_month_t

See Also:

Constant Field Values

interval_expression

public static final int interval_expression

Deprecated. As of v1.4.3.0, replaced by EExpressionType.interval_t

See Also:

Constant Field Values

new_structured_type

public static final int new_structured_type

Deprecated. As of v1.4.3.0, replaced by EExpressionType.new_structured_type_t

See Also:

Constant Field Values

new_variant_type

public static final int new_variant_type

Deprecated. As of v1.4.3.0, replaced by EExpressionType.new_variant_type_t

See Also:

Constant Field Values

period_ldiff

public static final int period_ldiff

Deprecated. As of v1.4.3.0, replaced by EExpressionType.period_ldiff_t

See Also:

Constant Field Values

period_rdiff

public static final int period_rdiff

Deprecated. As of v1.4.3.0, replaced by EExpressionType.period_rdiff_t

See Also:

Constant Field Values

period_p_intersect

public static final int period_p_intersect

Deprecated. As of v1.4.3.0, replaced by EExpressionType.period_p_intersect_t

See Also:

Constant Field Values

period_p_normalize

public static final int period_p_normalize

Deprecated. As of v1.4.3.0, replaced by EExpressionType.period_p_normalize_t

See Also:

Constant Field Values

until_changed

public static final int until_changed

Deprecated. As of v1.4.3.0, replaced by EExpressionType.until_changed_t

See Also:

Constant Field Values

is_document

public static final int is_document

Deprecated. As of v1.4.3.0, replaced by EExpressionType.is_document_t

See Also:

Constant Field Values

is_distinct_from

public static final int is_distinct_from

Deprecated. As of v1.4.3.0, replaced by EExpressionType.is_distinct_from_t

See Also:

Constant Field Values

true_false_unknown

public static final int true_false_unknown

Deprecated. As of v1.4.3.0, replaced by EExpressionType.is_true_t, EExpressionType.is_false_t,EExpressionType.is_unknown_t

See Also:

Constant Field Values

COLLATE

public static final int COLLATE

Deprecated. As of v1.4.3.0, replaced by EExpressionType.collate_t

See Also:

Constant Field Values

LEFTJOIN_OP

public static final int LEFTJOIN_OP

Deprecated. As of v1.4.3.0, replaced by EExpressionType.left_join_t

See Also:

Constant Field Values

RIGHTJOIN_OP

public static final int RIGHTJOIN_OP

Deprecated. As of v1.4.3.0, replaced by EExpressionType.right_join_t

See Also:

Constant Field Values

ref_arrow

public static final int ref_arrow

Deprecated. As of v1.4.3.0, replaced by EExpressionType.ref_arrow_t

See Also:

Constant Field Values

typecast

public static final int typecast

Deprecated. As of v1.4.3.0, replaced by EExpressionType.typecast_t

See Also:

Constant Field Values

arrayaccess

public static final int arrayaccess

Deprecated. As of v1.4.3.0, replaced by EExpressionType.arrayaccess_t

See Also:

Constant Field Values

connect_by_root

public static final int connect_by_root

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_connect_by_root_t

See Also:

Constant Field Values

sqlserver_proprietary_column_alias

public static final int sqlserver_proprietary_column_alias

Deprecated. As of v1.4.3.0, replaced by EExpressionType.sqlserver_proprietary_column_alias_t

See Also:

Constant Field Values

mysql_binary_operator

public static final int mysql_binary_operator

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_binary_operator_t

See Also:

Constant Field Values

left_shift

public static final int left_shift

Deprecated. As of v1.4.3.0, replaced by EExpressionType.left_shift_t

See Also:

Constant Field Values

right_shift

public static final int right_shift

Deprecated. As of v1.4.3.0, replaced by EExpressionType.right_shift_t

See Also:

Constant Field Values

multisetExprOperator

public static final int multisetExprOperator

Deprecated. As of v1.4.3.0, replaced by EExpressionType.multiset_t

See Also:

Constant Field Values

fieldSelection

public static final int fieldSelection

Deprecated. As of v1.4.3.0, replaced by EExpressionType.fieldselection_t

See Also:

Constant Field Values

arrayConstructor

public static final int arrayConstructor

Deprecated. As of v1.4.3.0, replaced by EExpressionType.array_constructor_t

See Also:

Constant Field Values

rowConstructor

public static final int rowConstructor

Deprecated. As of v1.4.3.0, replaced by EExpressionType.row_constructor_t

See Also:

Constant Field Values

factorial

public static final int factorial

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_factorial_t

See Also:

Constant Field Values

squareRoot

public static final int squareRoot

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_squareroot_t

See Also:

Constant Field Values

cubeRoot

public static final int cubeRoot

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_cuberoot_t

See Also:

Constant Field Values

factorialPrefix

public static final int factorialPrefix

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_factorialprefix_t

See Also:

Constant Field Values

absoluteValue

public static final int absoluteValue

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_absolutevalue_t

See Also:

Constant Field Values

BITWISE_SHIFT_LEFT

public static final int BITWISE_SHIFT_LEFT

Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_shift_left_t

See Also:

Constant Field Values

BITWISE_SHIFT_RIGHT

public static final int BITWISE_SHIFT_RIGHT

Deprecated. As of v1.4.3.0, replaced by EExpressionType.bitwise_shift_right_t

See Also:

Constant Field Values

BITWISE_NOT

public static final int BITWISE_NOT

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_bitwise_not_t

See Also:

Constant Field Values

compoundUnaryBitwiseNot

public static final int compoundUnaryBitwiseNot

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_bitwise_not_t

See Also:

Constant Field Values

member_of

public static final int member_of

Deprecated. As of v1.4.3.0, replaced by EExpressionType.member_of_t

See Also:

Constant Field Values

nextValueOf

public static final int nextValueOf

Deprecated. As of v1.4.3.0, replaced by EExpressionType.next_value_for_t

See Also:

Constant Field Values

UnknownOperator

public static final int UnknownOperator

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unknown_t

See Also:

Constant Field Values

UnknownUnaryOperator

public static final int UnknownUnaryOperator

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_left_unknown_t

See Also:

Constant Field Values

UnknownUnaryOperatorRight

public static final int UnknownUnaryOperatorRight

Deprecated. As of v1.4.3.0, replaced by EExpressionType.unary_right_unknown_t

See Also:

Constant Field Values

Constructor Detail

TExpression

public TExpression()

TExpression

public TExpression(TObjectName objectOperand)

TExpression

public TExpression(TConstant constantOperand)

TExpression

public TExpression(TFunctionCall functionCall)

TExpression

public TExpression(EExpressionType pExpressionType)

TExpression

public TExpression(EExpressionType pExpressionType,
                   TExpression pLeft,
                   TExpression pRight)

TExpression

public TExpression(EExpressionType pExpressionType,
                   TExpression pLeft,
                   TExpression pRight,
                   EComparisonType pComparisonType)

Method Detail

getCollectionCondition

public TCollectionCondition getCollectionCondition()

getCollectionArray

public TCollectionArray getCollectionArray()

getNamedParameter

public TNamedParameter getNamedParameter()

getPositionalParameter

public TPositionalParameter getPositionalParameter()

getArrayConstruct

public TArrayConstruct getArrayConstruct()

getObjectConstruct

public TObjectConstruct getObjectConstruct()

searchColumn

public TExpressionList searchColumn(String columnName)

getAndOrTokenBeforeExpr

public TSourceToken getAndOrTokenBeforeExpr()

Returns:

AND/OR token before expression when you get flattened expression using getFlattedAndOrExprs()

getFlattedAndOrExprs

public ArrayList getFlattedAndOrExprs()

Binary tree structure representation of expression makes AND/OR expression nested deeply when there are lots of AND/OR condition is used. Recursively function call on those nested AND/OR expression will cause stack overflow exception. After flatten those expressions. we can iterate those expression in a linear way.

Returns:

null if this is not AND/OR expression

setTokenToIdentifier

public void setTokenToIdentifier()

setComparisonType

public void setComparisonType(EComparisonType comparisonType)

getComparisonType

public static EComparisonType getComparisonType(TSourceToken comparisonOperator)

getExprAlias

public TAliasClause getExprAlias()

In Teradata, it is possible there is an alias for expression

Returns:

expression alias

setExprAlias

public void setExprAlias(TAliasClause exprAlias)

setDataTypeConversionList

public void setDataTypeConversionList(TPTNodeList<TExplicitDataTypeConversion> dataTypeConversionList)

getDataTypeConversionList

public TPTNodeList<TExplicitDataTypeConversion> getDataTypeConversionList()

setDataTypeConversion

public void setDataTypeConversion(TExplicitDataTypeConversion dataTypeConversion)

getDataTypeConversion

public TExplicitDataTypeConversion getDataTypeConversion()

Returns:

the first DataTypeConversion in getDataTypeConversionList()

getSequenceName

public TObjectName getSequenceName()

getOver_clause

public TAnalyticFunction getOver_clause()

getHive_variable

public THiveVariable getHive_variable()

setHive_variable

public void setHive_variable(THiveVariable hive_variable)

setSymmetric

public void setSymmetric(boolean symmetric)

isSymmetric

public boolean isSymmetric()

PostgreSQL BETWEEN SYMMETRIC is the same as BETWEEN except there is no requirement that the argument to the left of AND be less than or equal to the argument on the right. If it is not, those two arguments are automatically swapped, so that a nonempty range is always implied.

Returns:

true if SYMMETRIC is used

setObjectAccess

public void setObjectAccess(TObjectAccess objectAccess)

getObjectAccess

public TObjectAccess getObjectAccess()

isNotOperator

public boolean isNotOperator()

setNotToken

public void setNotToken(TSourceToken notToken)

getNotToken

public TSourceToken getNotToken()

init

public void init(Object arg1)

Description copied from class: TParseTreeNode

Initialize a query tree node. Used internally

Overrides:

init in class TParseTreeNode

Parameters:

arg1 - first argument

setLeadingPrecision

public void setLeadingPrecision(TSourceToken leadingPrecision)

setFractionalSecondsPrecision

public void setFractionalSecondsPrecision(TSourceToken fractionalSecondsPrecision)

getLeadingPrecision

public TSourceToken getLeadingPrecision()

getFractionalSecondsPrecision

public TSourceToken getFractionalSecondsPrecision()

init

public void init(Object arg1,
                 Object arg2)

Overrides:

init in class TParseTreeNode

init

public void init(Object arg1,
                 Object arg2,
                 Object arg3)

Overrides:

init in class TParseTreeNode

init

public void init(Object arg1,
                 Object arg2,
                 Object arg3,
                 Object arg4)

initialize a new instance of TExpression.

Overrides:

init in class TParseTreeNode

Parameters:

arg1 - type of this expression, a value of type EExpressionType

arg2 - operator, a value of TSourceToken

arg3 - left operand, a value of TExpression the meaning of this parameter varies depends on the value of arg1.

arg4 - right operand, a value of TExpression

setOperatorToken

public void setOperatorToken(TSourceToken operatorToken)

getOperatorToken

public TSourceToken getOperatorToken()

Operator token used in expression such as +,-,*,/ and etc

Returns:

operator token

setVal

public void setVal(Object val)

getVal

public Object getVal()

value of this expression, valid only after evaluate this expression.

Returns:

a value object

getConstantOperand

public TConstant getConstantOperand()

setNewVariantTypeArgumentList

public void setNewVariantTypeArgumentList(TNewVariantTypeArgumentList newVariantTypeArgumentList)

getNewVariantTypeArgumentList

public TNewVariantTypeArgumentList getNewVariantTypeArgumentList()

setTypeName

public void setTypeName(TTypeName typeName)

getTypeName

public TTypeName getTypeName()

getFieldName

public TObjectName getFieldName()

valid when getExpressionType() is fieldSelection

Returns:

field name

setIndirection

public void setIndirection(TIndirection indirection)

isSubscripts

public boolean isSubscripts()

If an expression yields a value of an array type, then a specific element of the array value can be extracted by writing

expression[subscript]

or multiple adjacent elements (an "array slice") can be extracted by writing

expression[lower_subscript:upper_subscript]

In general the array expression must be parenthesized, but the parentheses can be omitted when the expression to be subscripted is just a column reference or positional parameter.

Also, multiple subscripts can be concatenated when the original array is multidimensional. For example:

when sytnax like this:

mytable.arraycolumn[4]

mytable.two_d_column[17][34]

$1[10:42]

check getObjectOperand() for more detailed information about subscript.

when syntax like this:

(arrayfunction(a,b))[42]

check getIndirection() when isSubscripts() is true.

Returns:

tells whether it is an expression with subscript.

getIndirection

public TIndirection getIndirection()

isNotModifier

public boolean isNotModifier()

Deprecated. As of v1.4.3.0, replaced by getNotToken()

setOutputFormatPhraseList

public void setOutputFormatPhraseList(TOutputFormatPhraseList outputFormatPhraseList)

getOutputFormatPhraseList

public TOutputFormatPhraseList getOutputFormatPhraseList()

teradata:

column_expr (named alias_name)

Returns:

(named alias_name) in column_expr

getExprList

public TExpressionList getExprList()

setIntervalExpr

public void setIntervalExpr(TIntervalExpression intervalExpr)

getIntervalExpr

public TIntervalExpression getIntervalExpr()

setFieldList

public void setFieldList(TObjectNameList fieldList)

getFieldList

public TObjectNameList getFieldList()

setInExpr

public void setInExpr(TInExpr inExpr)

getInExpr

public TInExpr getInExpr()

Deprecated. As of v1.4.3.3, replaced by getRightOperand()

setExprList

public void setExprList(TExpressionList exprList)

setOracleOuterJoin

public void setOracleOuterJoin(boolean oracleOuterJoin)

isOracleOuterJoin

public boolean isOracleOuterJoin()

getParentExpr

public TExpression getParentExpr()

setParentExpr

public void setParentExpr(TExpression parentExpr)

setLeftOperand

public void setLeftOperand(TExpression leftOperand)

setRightOperand

public void setRightOperand(TExpression rightOperand)

getRightOperand

public TExpression getRightOperand()

Returns:

right operand of this expression which should be type of TExpression

getLeftOperand

public TExpression getLeftOperand()

Returns:

left operand of this expression which should be type of TExpression

getLikeEscapeOperand

public TExpression getLikeEscapeOperand()

getBetweenOperand

public TExpression getBetweenOperand()

getArrayAccess

public TArrayAccess getArrayAccess()

getExpressionType

public EExpressionType getExpressionType()

change return type from int to EExpressionType since 1.4.3.0

Returns:

a value of EExpressionType

setExpressionType

public void setExpressionType(EExpressionType exprType)

Parameters:

exprType - type to distinguish expression, change type from int to EExpressionType since 1.4.3.0

setObjectOperand

public void setObjectOperand(TObjectName objectOperand)

getObjectOperand

public TObjectName getObjectOperand()

setConstantOperand

public void setConstantOperand(TConstant constantOperand)

getSourcetokenOperand

public TSourceToken getSourcetokenOperand()

setSourcetokenOperand

public void setSourcetokenOperand(TSourceToken sourcetokenOperand)

setCaseExpression

public void setCaseExpression(TCaseExpression caseExpression)

getCaseExpression

public TCaseExpression getCaseExpression()

setArrayAccess

public void setArrayAccess(TArrayAccess arrayAccess)

Deprecated. As of v1.4.3.3

setSubQueryNode

public void setSubQueryNode(TSelectSqlNode subQueryNode)

setSubQuery

public void setSubQuery(TSelectSqlStatement subQuery)

getSubQuery

public TSelectSqlStatement getSubQuery()

setSubQueryInStmt

public void setSubQueryInStmt(boolean subQueryInStmt)

getFunctionCall

public TFunctionCall getFunctionCall()

setFunctionCall

public void setFunctionCall(TFunctionCall functionCall)

setDatetimeExpression

public void setDatetimeExpression(TDatetimeExpression datetimeExpression)

setIntervalExpression

public void setIntervalExpression(TIntervalExpression intervalExpression)

setBetweenOperand

public void setBetweenOperand(TExpression betweenOperand)

setLikeEscapeOperand

public void setLikeEscapeOperand(TExpression likeEscapeOperand)

doParse

public void doParse(TCustomSqlStatement psql,
                    ESqlClause plocation)

Description copied from class: TParseTreeNode

Analyze the sub-nodes inside this node. Such as build the relationship between table and column.

Overrides:

doParse in class TParseTreeNode

Parameters:

psql - SQL statement this node belongs to

plocation - SQL clause this node belongs to

setQuantifierType

public void setQuantifierType(EQuantifierType quantifierType)

getQuantifierType

public EQuantifierType getQuantifierType()

getComparisonType

public EComparisonType getComparisonType()

getQuantifier

public TSourceToken getQuantifier()

one of the following quantifier keywords: SOME, ANY, ALL

Returns:

SOME, ANY, ALL in group comparison condition.

getComparisonOperator

public TSourceToken getComparisonOperator()

Returns:

operator used in comparison condition.

setComparisonOperator

public void setComparisonOperator(TSourceToken comparisonOperator)

setQuantifier

public void setQuantifier(TSourceToken quantifier)

accept

public void accept(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

acceptChildren

public void acceptChildren(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor to iterate this class and sub-nodes of this class

Specified by:

acceptChildren in interface Visitable

Overrides:

acceptChildren in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

isLeaf

public boolean isLeaf()

expression type such as column reference is a leaf expression while subtract expression is not a leaf expression. Usually, non-leaf expression should including both getLeftOperand() and getRightOperand().

Returns:

leaf expression or not.

isLeafExpr

public boolean isLeafExpr(TParseTreeNode pnode)

setVisitSubTree

public void setVisitSubTree(boolean visitSubTree)

isVisitSubTree

public boolean isVisitSubTree()

setWindowSpecification

public void setWindowSpecification(TWindowDef windowSpecification)

preOrderTraverse

public void preOrderTraverse(IExpressionVisitor ev)

Traverse expression in pre Order.

Parameters:

ev - user defined visitor

inOrderTraverse

public void inOrderTraverse(IExpressionVisitor ev)

Traverse expression in In Order.

Parameters:

ev - user defined visitor

postOrderTraverse

public void postOrderTraverse(IExpressionVisitor ev)

Traverse expression in post order.

Parameters:

ev - user defined visitor

addANDCondition

public void addANDCondition(String condition)

if original expr is f > 1, and call addANDCondition("f2 > 2") expression will be: f > 1 and f2 > 2

Parameters:

condition -

addORCondition

public void addORCondition(String condition)

if original expr is f > 1, and call addORCondition("f2 > 2") expression will be: f > 1 or f2 > 2

Parameters:

condition -

remove2

public void remove2()

remove this expression from it's parent expr. if itself is the top level expression, then remove it from parse tree

f1 > 1 and f2 > 2, after remove f2>2, parent expression will be changed to: f1 > 1

If we need to remove condition f > 1 from where clause: where f > 1, Here f > 1 is the top level expression, after remove it from where clause, only WHERE keyword left in where clause.

remove

public void remove()

copyTo

public void copyTo(TExpression target)

mergeObjectNameList

public static TExpression mergeObjectNameList(TExpression expr,
                                              TObjectNameList objectNameList)