Package org.apache.calcite.sql

Class SqlMerge

java.lang.Object

org.apache.calcite.sql.SqlNode

org.apache.calcite.sql.SqlCall

org.apache.calcite.sql.SqlMerge

All Implemented Interfaces:

Cloneable

public class SqlMerge
extends SqlCall

A SqlMerge is a node of a parse tree which represents a MERGE statement.

Field Summary

Fields

Modifier and Type	Field	Description
static final SqlSpecialOperator	OPERATOR

Fields inherited from class org.apache.calcite.sql.SqlNode

EMPTY_ARRAY, pos

Constructor Summary

Constructors

Constructor	Description
SqlMerge(SqlParserPos pos, SqlNode targetTable, SqlNode condition, SqlNode source, @Nullable SqlUpdate updateCall, @Nullable SqlInsert insertCall, @Nullable SqlSelect sourceSelect, @Nullable SqlIdentifier alias)

Method Summary

Modifier and Type	Method	Description
@Nullable SqlIdentifier	getAlias()	Returns the alias for the target table of this MERGE.
SqlNode	getCondition()	Returns the condition expression to determine whether to UPDATE or INSERT.
@Nullable SqlInsert	getInsertCall()	Returns the INSERT statement for this MERGE.
SqlKind	getKind()	Returns the type of node this is, or SqlKind.OTHER if it's nothing special.
List<@Nullable SqlNode>	getOperandList()	Returns the list of operands.
SqlOperator	getOperator()
@Nullable SqlSelect	getSourceSelect()	Gets the source SELECT expression for the data to be updated/inserted.
SqlNode	getSourceTableRef()	Returns the source query of this MERGE.
SqlNode	getTargetTable()	Return the identifier for the target table of this MERGE.
@Nullable SqlUpdate	getUpdateCall()	Returns the UPDATE statement for this MERGE.
void	setOperand(int i, @Nullable SqlNode operand)	Changes the value of an operand.
void	setSourceSelect(SqlSelect sourceSelect)
void	setSourceTableRef(SqlNode tableRef)
void	unparse(SqlWriter writer, int leftPrec, int rightPrec)	Writes a SQL representation of this node to a writer.
void	validate(SqlValidator validator, SqlValidatorScope scope)	Validates this call.

Methods inherited from class org.apache.calcite.sql.SqlCall

accept, clone, equalsDeep, findValidOptions, getCallSignature, getFunctionQuantifier, getMonotonicity, isCountStar, isExpanded, operand, operandCount

Methods inherited from class org.apache.calcite.sql.SqlNode

clone, clone, cloneArray, equalDeep, equalDeep, equalsDeep, getParserPosition, isA, toList, toList, toSqlString, toSqlString, toSqlString, toString, unparseWithParentheses, validateExpr

Methods inherited from class java.lang.Object

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

Field Details

OPERATOR

public static final SqlSpecialOperator OPERATOR

Constructor Details

SqlMerge

public SqlMerge(SqlParserPos pos,
 SqlNode targetTable,
 SqlNode condition,
 SqlNode source,
 @Nullable SqlUpdate updateCall,
 @Nullable SqlInsert insertCall,
 @Nullable SqlSelect sourceSelect,
 @Nullable SqlIdentifier alias)

Method Details

getOperator

public SqlOperator getOperator()

Specified by:

getOperator in class SqlCall

getKind

public SqlKind getKind()

Description copied from class: SqlNode

Returns the type of node this is, or SqlKind.OTHER if it's nothing special.

Overrides:

getKind in class SqlCall

Returns:

a SqlKind value, never null

See Also:

• SqlNode.isA(java.util.Set<org.apache.calcite.sql.SqlKind>)

getOperandList

public List<@Nullable SqlNode> getOperandList()

Description copied from class: SqlCall

Returns the list of operands. The set and order of operands is call-specific.

Note: the proper type would be List<@Nullable SqlNode>, however, it would trigger too many changes to the current codebase.

Specified by:

getOperandList in class SqlCall

Returns:

the list of call operands, never null, the operands can be null

setOperand

public void setOperand(int i,
 @Nullable SqlNode operand)

Description copied from class: SqlCall

Changes the value of an operand. Allows some rewrite by SqlValidator; use sparingly.

Overrides:

setOperand in class SqlCall

Parameters:

i - Operand index

operand - Operand value

getTargetTable

public SqlNode getTargetTable()

Return the identifier for the target table of this MERGE.

getAlias

@Pure
public @Nullable SqlIdentifier getAlias()

Returns the alias for the target table of this MERGE.

getSourceTableRef

public SqlNode getSourceTableRef()

Returns the source query of this MERGE.

setSourceTableRef

public void setSourceTableRef(SqlNode tableRef)

getUpdateCall

public @Nullable SqlUpdate getUpdateCall()

Returns the UPDATE statement for this MERGE.

getInsertCall

public @Nullable SqlInsert getInsertCall()

Returns the INSERT statement for this MERGE.

getCondition

public SqlNode getCondition()

Returns the condition expression to determine whether to UPDATE or INSERT.

getSourceSelect

public @Nullable SqlSelect getSourceSelect()

Gets the source SELECT expression for the data to be updated/inserted. Returns null before the statement has been expanded by SqlValidatorImpl.performUnconditionalRewrites(SqlNode, boolean).

Returns:

the source SELECT for the data to be updated

setSourceSelect

public void setSourceSelect(SqlSelect sourceSelect)

unparse

public void unparse(SqlWriter writer,
 int leftPrec,
 int rightPrec)

Description copied from class: SqlNode

Writes a SQL representation of this node to a writer.

The leftPrec and rightPrec parameters give us enough context to decide whether we need to enclose the expression in parentheses. For example, we need parentheses around "2 + 3" if preceded by "5 *". This is because the precedence of the "*" operator is greater than the precedence of the "+" operator.

The algorithm handles left- and right-associative operators by giving them slightly different left- and right-precedence.

If SqlWriter.isAlwaysUseParentheses() is true, we use parentheses even when they are not required by the precedence rules.

For the details of this algorithm, see SqlCall.unparse(org.apache.calcite.sql.SqlWriter, int, int).

Overrides:

unparse in class SqlCall

Parameters:

writer - Target writer

leftPrec - The precedence of the SqlNode immediately preceding this node in a depth-first scan of the parse tree

rightPrec - The precedence of the SqlNode immediately

validate

public void validate(SqlValidator validator,
 SqlValidatorScope scope)

Description copied from class: SqlCall

Validates this call.

The default implementation delegates the validation to the operator's SqlOperator.validateCall(org.apache.calcite.sql.SqlCall, org.apache.calcite.sql.validate.SqlValidator, org.apache.calcite.sql.validate.SqlValidatorScope, org.apache.calcite.sql.validate.SqlValidatorScope). Derived classes may override (as do, for example SqlSelect and SqlUpdate).

Overrides:

validate in class SqlCall

Parameters:

scope - Validator