Modifier and Type	Class and Description
public abstract class	MergeUsing.When Abstract WHEN command of the MERGE statement.
public class	MergeUsing.WhenMatchedThenDelete
public class	MergeUsing.WhenMatchedThenUpdate
public class	MergeUsing.WhenNotMatched

Modifier and Type	Field and Description
pack-priv Expression	onCondition ON condition expression.
pack-priv TableFilter	sourceTableFilter Source table filter.
private final HashSet<Long>	targetRowidsRemembered Contains _ROWID_ of processed rows.
pack-priv TableFilter	targetTableFilter Target table filter.
private ArrayList<MergeUsing.When>	when

Access	Constructor and Description
public	MergeUsing(SessionLocal session, TableFilter targetTableFilter)

Method Summary

Modifier and Type	Method and Description
public void	addWhen(MergeUsing.When new WHEN command to add (update, delete or insert). w) Adds WHEN command.
private void	checkRights()
public void	collectDependencies(HashSet<DbObject> collection of dependencies to populate dependencies) Overrides org.h2.command.Prepared.collectDependencies. Find and collect all DbObjects, this Prepared depends on.
pack-priv void	doPrepare() Implements abstract org.h2.command.dml.DataChangeStatement.doPrepare.
private int	evaluateTriggerMasks()
public Expression	getOnCondition()
public StringBuilder	getPlanSQL(StringBuilder string builder builder, int formatting flags sqlFlags) Overrides org.h2.command.Prepared.getPlanSQL. Appends the SQL statement with the execution plan.
public TableFilter	getSourceTableFilter()
public String	getStatementName() Implements abstract org.h2.command.dml.DataChangeStatement.getStatementName. Return the name of this statement.
public Table	getTable() Implements abstract org.h2.command.dml.DataChangeStatement.getTable. Return the target table.
public TableFilter	getTargetTableFilter()
public int	getType() Implements abstract org.h2.command.Prepared.getType. Get the command type as defined in CommandInterface
public ArrayList<MergeUsing.When>	getWhen()
private int	merge(boolean nullRow, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)
public void	setOnCondition(Expression condition)
public void	setSourceTableFilter(TableFilter sourceTableFilter)
public void	setTargetTableFilter(TableFilter targetTableFilter)
public long	update(ResultTarget target result deltaChangeCollector, DataChangeDeltaTable.ResultOption collection mode deltaChangeCollectionMode) Implements abstract org.h2.command.dml.DataChangeStatement.update. Execute the statement with specified delta change collector and collection mode.

Inherited from org.h2.command.dml.DataChangeStatement:: isCacheable isTransactional prepare queryMeta update

onCondition	back to summary
pack-priv Expression onCondition ON condition expression.

sourceTableFilter	back to summary
pack-priv TableFilter sourceTableFilter Source table filter.

targetRowidsRemembered	back to summary
private final HashSet<Long> targetRowidsRemembered Contains _ROWID_ of processed rows. Row identities are remembered to prevent duplicate updates of the same row.

targetTableFilter	back to summary
pack-priv TableFilter targetTableFilter Target table filter.

when	back to summary
private ArrayList<MergeUsing.When> when

Constructor Detail

MergeUsing	back to summary
public MergeUsing(SessionLocal session, TableFilter targetTableFilter)

Method Detail

addWhen	back to summary
public void addWhen(MergeUsing.When w) Adds WHEN command. Parameters w:MergeUsing.When new WHEN command to add (update, delete or insert).

addWhen

back to summary

public void addWhen(MergeUsing.When w)

Adds WHEN command.

Parameters

w:MergeUsing.When: new WHEN command to add (update, delete or insert).

checkRights	back to summary
private void checkRights()

collectDependencies	back to summary
public void collectDependencies(HashSet<DbObject> dependencies) Overrides org.h2.command.Prepared.collectDependencies. Doc from org.h2.command.Prepared.collectDependencies. Find and collect all DbObjects, this Prepared depends on. Parameters dependencies:HashSet<DbObject> collection of dependencies to populate Annotations @Override

collectDependencies

back to summary

public void collectDependencies(HashSet<DbObject> dependencies)

Overrides org.h2.command.Prepared.collectDependencies.

Doc from org.h2.command.Prepared.collectDependencies.

Find and collect all DbObjects, this Prepared depends on.

Parameters

dependencies:HashSet<DbObject>: collection of dependencies to populate

Annotations

@Override

doPrepare	back to summary
pack-priv void doPrepare() Implements abstract org.h2.command.dml.DataChangeStatement.doPrepare. Annotations @Override

doPrepare

back to summary

pack-priv void doPrepare()

Implements abstract org.h2.command.dml.DataChangeStatement.doPrepare.

Annotations

@Override

evaluateTriggerMasks	back to summary
private int evaluateTriggerMasks()

getOnCondition	back to summary
public Expression getOnCondition()

getPlanSQL	back to summary
public StringBuilder getPlanSQL(StringBuilder builder, int sqlFlags) Overrides org.h2.command.Prepared.getPlanSQL. Doc from org.h2.command.Prepared.getPlanSQL. Appends the SQL statement with the execution plan. Parameters builder:StringBuilder string builder sqlFlags:int formatting flags Returns:StringBuilder the execution plan Annotations @Override

getPlanSQL

back to summary

public StringBuilder getPlanSQL(StringBuilder builder, int sqlFlags)

Overrides org.h2.command.Prepared.getPlanSQL.

Doc from org.h2.command.Prepared.getPlanSQL.

Appends the SQL statement with the execution plan.

Parameters

builder:StringBuilder: string builder
sqlFlags:int: formatting flags

Returns:StringBuilder

the execution plan

Annotations

@Override

getSourceTableFilter	back to summary
public TableFilter getSourceTableFilter()

getStatementName	back to summary
public String getStatementName() Implements abstract org.h2.command.dml.DataChangeStatement.getStatementName. Doc from org.h2.command.dml.DataChangeStatement.getStatementName. Return the name of this statement. Returns:String the short name of this statement. Annotations @Override

getStatementName

back to summary

public String getStatementName()

Implements abstract org.h2.command.dml.DataChangeStatement.getStatementName.

Doc from org.h2.command.dml.DataChangeStatement.getStatementName.

Return the name of this statement.

Returns:String

the short name of this statement.

Annotations

@Override

getTable	back to summary
public Table getTable() Implements abstract org.h2.command.dml.DataChangeStatement.getTable. Doc from org.h2.command.dml.DataChangeStatement.getTable. Return the target table. Returns:Table the target table Annotations @Override

getTable

back to summary

public Table getTable()

Implements abstract org.h2.command.dml.DataChangeStatement.getTable.

Doc from org.h2.command.dml.DataChangeStatement.getTable.

Return the target table.

Returns:Table

the target table

Annotations

@Override

getTargetTableFilter	back to summary
public TableFilter getTargetTableFilter()

getType	back to summary
public int getType() Implements abstract org.h2.command.Prepared.getType. Doc from org.h2.command.Prepared.getType. Get the command type as defined in CommandInterface Returns:int the statement type Annotations @Override

getType

back to summary

public int getType()

Implements abstract org.h2.command.Prepared.getType.

Doc from org.h2.command.Prepared.getType.

Get the command type as defined in CommandInterface

Returns:int

the statement type

Annotations

@Override

getWhen	back to summary
public ArrayList<MergeUsing.When> getWhen()

merge	back to summary
private int merge(boolean nullRow, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)

setOnCondition	back to summary
public void setOnCondition(Expression condition)

setSourceTableFilter	back to summary
public void setSourceTableFilter(TableFilter sourceTableFilter)

setTargetTableFilter	back to summary
public void setTargetTableFilter(TableFilter targetTableFilter)

update	back to summary
public long update(ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode) Implements abstract org.h2.command.dml.DataChangeStatement.update. Doc from org.h2.command.dml.DataChangeStatement.update. Execute the statement with specified delta change collector and collection mode. Parameters deltaChangeCollector:ResultTarget target result deltaChangeCollectionMode:DataChangeDeltaTable.ResultOption collection mode Returns:long the update count Annotations @Override

update

back to summary

public long update(ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)

Implements abstract org.h2.command.dml.DataChangeStatement.update.

Doc from org.h2.command.dml.DataChangeStatement.update.

Execute the statement with specified delta change collector and collection mode.

Parameters

deltaChangeCollector:ResultTarget: target result
deltaChangeCollectionMode:DataChangeDeltaTable.ResultOption: collection mode

Returns:long

the update count

Annotations

@Override

org.h2.command.dml back to summary

public abstract Class MergeUsing.When

Class Inheritance

extends Object
implements HasSQL

java.lang.Object
org.h2.command.dml.MergeUsing.When

All Implemented Interfaces

org.h2.util.HasSQL

Known Direct Subclasses

org.h2.command.dml.MergeUsing.WhenMatchedThenDelete, org.h2.command.dml.MergeUsing.WhenMatchedThenUpdate, org.h2.command.dml.MergeUsing.WhenNotMatched

Abstract WHEN command of the MERGE statement.

Field Summary

Modifier and Type	Field and Description
pack-priv Expression	andCondition AND condition of the command.

Constructor Summary

Access	Constructor and Description
pack-priv	When()

Method Summary

Modifier and Type	Method and Description
pack-priv abstract void	checkRights() Checks user's INSERT, UPDATE, DELETE permission in appropriate cases.
pack-priv void	collectDependencies(ExpressionVisitor the expression visitor visitor) Find and collect all DbObjects, this When object depends on.
pack-priv abstract int	Returns: the trigger mask. evaluateTriggerMasks() Evaluates trigger mask (UPDATE, INSERT, DELETE).
public StringBuilder	getSQL(StringBuilder string builder builder, int formatting flags sqlFlags) Implements org.h2.util.HasSQL.getSQL. Appends the SQL statement of this object to the specified builder.
pack-priv abstract void	merge(SessionLocal the session session, ResultTarget target result deltaChangeCollector, DataChangeDeltaTable.ResultOption collection mode deltaChangeCollectionMode) Merges rows.
pack-priv boolean	Returns: `false` if this clause may be removed prepare(SessionLocal the session session) Prepares WHEN command.
public void	setAndCondition(Expression AND condition to set andCondition) Sets the specified AND condition.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

andCondition	back to summary
pack-priv Expression andCondition AND condition of the command.

Constructor Detail

When	back to summary
pack-priv When()

Method Detail

checkRights	back to summary
pack-priv abstract void checkRights() Checks user's INSERT, UPDATE, DELETE permission in appropriate cases.

collectDependencies	back to summary
pack-priv void collectDependencies(ExpressionVisitor visitor) Find and collect all DbObjects, this When object depends on. Parameters visitor:ExpressionVisitor the expression visitor

collectDependencies

back to summary

pack-priv void collectDependencies(ExpressionVisitor visitor)

Find and collect all DbObjects, this When object depends on.

Parameters

visitor:ExpressionVisitor: the expression visitor

evaluateTriggerMasks	back to summary
pack-priv abstract int evaluateTriggerMasks() Evaluates trigger mask (UPDATE, INSERT, DELETE). Returns:int the trigger mask.

evaluateTriggerMasks

back to summary

pack-priv abstract int evaluateTriggerMasks()

Evaluates trigger mask (UPDATE, INSERT, DELETE).

Returns:int: the trigger mask.

getSQL	back to summary
public StringBuilder getSQL(StringBuilder builder, int sqlFlags) Implements org.h2.util.HasSQL.getSQL. Doc from org.h2.util.HasSQL.getSQL. Appends the SQL statement of this object to the specified builder. Parameters builder:StringBuilder string builder sqlFlags:int formatting flags Returns:StringBuilder the specified string builder Annotations @Override

getSQL

back to summary

public StringBuilder getSQL(StringBuilder builder, int sqlFlags)

Implements org.h2.util.HasSQL.getSQL.

Doc from org.h2.util.HasSQL.getSQL.

Appends the SQL statement of this object to the specified builder.

Parameters

builder:StringBuilder: string builder
sqlFlags:int: formatting flags

Returns:StringBuilder

the specified string builder

Annotations

@Override

merge	back to summary
pack-priv abstract void merge(SessionLocal session, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode) Merges rows. Parameters session:SessionLocal the session deltaChangeCollector:ResultTarget target result deltaChangeCollectionMode:DataChangeDeltaTable.ResultOption collection mode

merge

back to summary

pack-priv abstract void merge(SessionLocal session, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)

Merges rows.

Parameters

session:SessionLocal: the session
deltaChangeCollector:ResultTarget: target result
deltaChangeCollectionMode:DataChangeDeltaTable.ResultOption: collection mode

prepare back to summary

prepare	back to summary
pack-priv boolean prepare(SessionLocal session) Prepares WHEN command. Parameters session:SessionLocal the session Returns:boolean `false` if this clause may be removed

pack-priv boolean prepare(SessionLocal session)

Prepares WHEN command.

Parameters

session:SessionLocal: the session

Returns:boolean

false if this clause may be removed

setAndCondition	back to summary
public void setAndCondition(Expression andCondition) Sets the specified AND condition. Parameters andCondition:Expression AND condition to set

setAndCondition

back to summary

public void setAndCondition(Expression andCondition)

Sets the specified AND condition.

Parameters

andCondition:Expression: AND condition to set

org.h2.command.dml back to summary

public final Class MergeUsing.WhenMatchedThenDelete

Class Inheritance

extends When

java.lang.Object
org.h2.command.dml.MergeUsing.When
org.h2.command.dml.MergeUsing.WhenMatchedThenDelete

Field Summary

Inherited from org.h2.command.dml.MergeUsing.When:: andCondition

Constructor Summary

Access	Constructor and Description
public	WhenMatchedThenDelete()

Method Summary

Modifier and Type	Method and Description
pack-priv void	checkRights() Implements abstract org.h2.command.dml.MergeUsing.When.checkRights. Checks user's INSERT, UPDATE, DELETE permission in appropriate cases.
pack-priv int	evaluateTriggerMasks() Implements abstract org.h2.command.dml.MergeUsing.When.evaluateTriggerMasks. Evaluates trigger mask (UPDATE, INSERT, DELETE).
public StringBuilder	getSQL(StringBuilder string builder builder, int formatting flags sqlFlags) Overrides org.h2.command.dml.MergeUsing.When.getSQL. Implements org.h2.util.HasSQL.getSQL. Appends the SQL statement of this object to the specified builder.
pack-priv void	merge(SessionLocal the session session, ResultTarget target result deltaChangeCollector, DataChangeDeltaTable.ResultOption collection mode deltaChangeCollectionMode) Implements abstract org.h2.command.dml.MergeUsing.When.merge. Merges rows.

Inherited from org.h2.command.dml.MergeUsing.When:: collectDependencies prepare setAndCondition

Constructor Detail

WhenMatchedThenDelete	back to summary
public WhenMatchedThenDelete()

Method Detail

checkRights	back to summary
pack-priv void checkRights() Implements abstract org.h2.command.dml.MergeUsing.When.checkRights. Doc from org.h2.command.dml.MergeUsing.When.checkRights. Checks user's INSERT, UPDATE, DELETE permission in appropriate cases. Annotations @Override

checkRights

back to summary

pack-priv void checkRights()

Implements abstract org.h2.command.dml.MergeUsing.When.checkRights.

Doc from org.h2.command.dml.MergeUsing.When.checkRights.

Checks user's INSERT, UPDATE, DELETE permission in appropriate cases.

Annotations

@Override

evaluateTriggerMasks	back to summary
pack-priv int evaluateTriggerMasks() Implements abstract org.h2.command.dml.MergeUsing.When.evaluateTriggerMasks. Doc from org.h2.command.dml.MergeUsing.When.evaluateTriggerMasks. Evaluates trigger mask (UPDATE, INSERT, DELETE). Returns:int the trigger mask. Annotations @Override

evaluateTriggerMasks

back to summary

pack-priv int evaluateTriggerMasks()

Implements abstract org.h2.command.dml.MergeUsing.When.evaluateTriggerMasks.

Doc from org.h2.command.dml.MergeUsing.When.evaluateTriggerMasks.

Evaluates trigger mask (UPDATE, INSERT, DELETE).

Returns:int

the trigger mask.

Annotations

@Override

getSQL	back to summary
public StringBuilder getSQL(StringBuilder builder, int sqlFlags) Overrides org.h2.command.dml.MergeUsing.When.getSQL. Implements org.h2.util.HasSQL.getSQL. Doc from org.h2.util.HasSQL.getSQL. Appends the SQL statement of this object to the specified builder. Parameters builder:StringBuilder string builder sqlFlags:int formatting flags Returns:StringBuilder the specified string builder Annotations @Override

getSQL

back to summary

public StringBuilder getSQL(StringBuilder builder, int sqlFlags)

Overrides org.h2.command.dml.MergeUsing.When.getSQL.

Implements org.h2.util.HasSQL.getSQL.

Doc from org.h2.util.HasSQL.getSQL.

Appends the SQL statement of this object to the specified builder.

Parameters

builder:StringBuilder: string builder
sqlFlags:int: formatting flags

Returns:StringBuilder

the specified string builder

Annotations

@Override

merge	back to summary
pack-priv void merge(SessionLocal session, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode) Implements abstract org.h2.command.dml.MergeUsing.When.merge. Doc from org.h2.command.dml.MergeUsing.When.merge. Merges rows. Parameters session:SessionLocal the session deltaChangeCollector:ResultTarget target result deltaChangeCollectionMode:DataChangeDeltaTable.ResultOption collection mode Annotations @Override

merge

back to summary

pack-priv void merge(SessionLocal session, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)

Implements abstract org.h2.command.dml.MergeUsing.When.merge.

Doc from org.h2.command.dml.MergeUsing.When.merge.

Merges rows.

Parameters

session:SessionLocal: the session
deltaChangeCollector:ResultTarget: target result
deltaChangeCollectionMode:DataChangeDeltaTable.ResultOption: collection mode

Annotations

@Override

org.h2.command.dml back to summary

public final Class MergeUsing.WhenMatchedThenUpdate

Class Inheritance

extends When

java.lang.Object
org.h2.command.dml.MergeUsing.When
org.h2.command.dml.MergeUsing.WhenMatchedThenUpdate

Field Summary

Modifier and Type	Field and Description
private SetClauseList	setClauseList

Inherited from org.h2.command.dml.MergeUsing.When:: andCondition

Constructor Summary

Access	Constructor and Description
public	WhenMatchedThenUpdate()

Method Summary

Modifier and Type	Method and Description
pack-priv void	checkRights() Implements abstract org.h2.command.dml.MergeUsing.When.checkRights. Checks user's INSERT, UPDATE, DELETE permission in appropriate cases.
pack-priv void	collectDependencies(ExpressionVisitor the expression visitor visitor) Overrides org.h2.command.dml.MergeUsing.When.collectDependencies. Find and collect all DbObjects, this When object depends on.
pack-priv int	evaluateTriggerMasks() Implements abstract org.h2.command.dml.MergeUsing.When.evaluateTriggerMasks. Evaluates trigger mask (UPDATE, INSERT, DELETE).
public StringBuilder	getSQL(StringBuilder string builder builder, int formatting flags sqlFlags) Overrides org.h2.command.dml.MergeUsing.When.getSQL. Implements org.h2.util.HasSQL.getSQL. Appends the SQL statement of this object to the specified builder.
pack-priv void	merge(SessionLocal the session session, ResultTarget target result deltaChangeCollector, DataChangeDeltaTable.ResultOption collection mode deltaChangeCollectionMode) Implements abstract org.h2.command.dml.MergeUsing.When.merge. Merges rows.
pack-priv boolean	prepare(SessionLocal the session session) Overrides org.h2.command.dml.MergeUsing.When.prepare. Prepares WHEN command.
public void	setSetClauseList(SetClauseList setClauseList)

Inherited from org.h2.command.dml.MergeUsing.When:: setAndCondition

Field Detail

setClauseList	back to summary
private SetClauseList setClauseList

Constructor Detail

WhenMatchedThenUpdate	back to summary
public WhenMatchedThenUpdate()

Method Detail

checkRights

back to summary

pack-priv void checkRights()

Implements abstract org.h2.command.dml.MergeUsing.When.checkRights.

Doc from org.h2.command.dml.MergeUsing.When.checkRights.

Checks user's INSERT, UPDATE, DELETE permission in appropriate cases.

Annotations

@Override

collectDependencies

back to summary

pack-priv void collectDependencies(ExpressionVisitor visitor)

Overrides org.h2.command.dml.MergeUsing.When.collectDependencies.

Doc from org.h2.command.dml.MergeUsing.When.collectDependencies.

Find and collect all DbObjects, this When object depends on.

Parameters

visitor:ExpressionVisitor: the expression visitor

Annotations

@Override

evaluateTriggerMasks

back to summary

pack-priv int evaluateTriggerMasks()

Implements abstract org.h2.command.dml.MergeUsing.When.evaluateTriggerMasks.

Doc from org.h2.command.dml.MergeUsing.When.evaluateTriggerMasks.

Evaluates trigger mask (UPDATE, INSERT, DELETE).

Returns:int

the trigger mask.

Annotations

@Override

getSQL

back to summary

public StringBuilder getSQL(StringBuilder builder, int sqlFlags)

Overrides org.h2.command.dml.MergeUsing.When.getSQL.

Implements org.h2.util.HasSQL.getSQL.

Doc from org.h2.util.HasSQL.getSQL.

Appends the SQL statement of this object to the specified builder.

Parameters

builder:StringBuilder: string builder
sqlFlags:int: formatting flags

Returns:StringBuilder

the specified string builder

Annotations

@Override

merge

back to summary

pack-priv void merge(SessionLocal session, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)

Implements abstract org.h2.command.dml.MergeUsing.When.merge.

Doc from org.h2.command.dml.MergeUsing.When.merge.

Merges rows.

Parameters

session:SessionLocal: the session
deltaChangeCollector:ResultTarget: target result
deltaChangeCollectionMode:DataChangeDeltaTable.ResultOption: collection mode

Annotations

@Override

prepare back to summary

pack-priv boolean prepare(SessionLocal session)

Overrides org.h2.command.dml.MergeUsing.When.prepare.

Doc from org.h2.command.dml.MergeUsing.When.prepare.

Prepares WHEN command.

Parameters

session:SessionLocal: the session

Returns:boolean

false if this clause may be removed

Annotations

@Override

setSetClauseList	back to summary
public void setSetClauseList(SetClauseList setClauseList)

org.h2.command.dml back to summary

public final Class MergeUsing.WhenNotMatched

Class Inheritance

extends When

java.lang.Object
org.h2.command.dml.MergeUsing.When
org.h2.command.dml.MergeUsing.WhenNotMatched

Field Summary

Modifier and Type	Field and Description
private Column[]	columns
private final Boolean	overridingSystem
private final Expression[]	values

Inherited from org.h2.command.dml.MergeUsing.When:: andCondition

Constructor Summary

Access	Constructor and Description
public	WhenNotMatched(Column[] columns, Boolean overridingSystem, Expression[] values)

Method Summary

Modifier and Type	Method and Description
pack-priv void	checkRights() Implements abstract org.h2.command.dml.MergeUsing.When.checkRights. Checks user's INSERT, UPDATE, DELETE permission in appropriate cases.
pack-priv void	collectDependencies(ExpressionVisitor the expression visitor visitor) Overrides org.h2.command.dml.MergeUsing.When.collectDependencies. Find and collect all DbObjects, this When object depends on.
pack-priv int	evaluateTriggerMasks() Implements abstract org.h2.command.dml.MergeUsing.When.evaluateTriggerMasks. Evaluates trigger mask (UPDATE, INSERT, DELETE).
public StringBuilder	getSQL(StringBuilder string builder builder, int formatting flags sqlFlags) Overrides org.h2.command.dml.MergeUsing.When.getSQL. Implements org.h2.util.HasSQL.getSQL. Appends the SQL statement of this object to the specified builder.
pack-priv void	merge(SessionLocal the session session, ResultTarget target result deltaChangeCollector, DataChangeDeltaTable.ResultOption collection mode deltaChangeCollectionMode) Implements abstract org.h2.command.dml.MergeUsing.When.merge. Merges rows.
pack-priv boolean	prepare(SessionLocal the session session) Overrides org.h2.command.dml.MergeUsing.When.prepare. Prepares WHEN command.

Inherited from org.h2.command.dml.MergeUsing.When:: setAndCondition

Field Detail

columns	back to summary
private Column[] columns

overridingSystem	back to summary
private final Boolean overridingSystem

values	back to summary
private final Expression[] values

Constructor Detail

WhenNotMatched	back to summary
public WhenNotMatched(Column[] columns, Boolean overridingSystem, Expression[] values)

Method Detail

checkRights

back to summary

pack-priv void checkRights()

Implements abstract org.h2.command.dml.MergeUsing.When.checkRights.

Doc from org.h2.command.dml.MergeUsing.When.checkRights.

Checks user's INSERT, UPDATE, DELETE permission in appropriate cases.

Annotations

@Override

collectDependencies

back to summary

pack-priv void collectDependencies(ExpressionVisitor visitor)

Overrides org.h2.command.dml.MergeUsing.When.collectDependencies.

Doc from org.h2.command.dml.MergeUsing.When.collectDependencies.

Find and collect all DbObjects, this When object depends on.

Parameters

visitor:ExpressionVisitor: the expression visitor

Annotations

@Override

evaluateTriggerMasks

back to summary

pack-priv int evaluateTriggerMasks()

Implements abstract org.h2.command.dml.MergeUsing.When.evaluateTriggerMasks.

Doc from org.h2.command.dml.MergeUsing.When.evaluateTriggerMasks.

Evaluates trigger mask (UPDATE, INSERT, DELETE).

Returns:int

the trigger mask.

Annotations

@Override

getSQL

back to summary

public StringBuilder getSQL(StringBuilder builder, int sqlFlags)

Overrides org.h2.command.dml.MergeUsing.When.getSQL.

Implements org.h2.util.HasSQL.getSQL.

Doc from org.h2.util.HasSQL.getSQL.

Appends the SQL statement of this object to the specified builder.

Parameters

builder:StringBuilder: string builder
sqlFlags:int: formatting flags

Returns:StringBuilder

the specified string builder

Annotations

@Override

merge

back to summary

pack-priv void merge(SessionLocal session, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)

Implements abstract org.h2.command.dml.MergeUsing.When.merge.

Doc from org.h2.command.dml.MergeUsing.When.merge.

Merges rows.

Parameters

session:SessionLocal: the session
deltaChangeCollector:ResultTarget: target result
deltaChangeCollectionMode:DataChangeDeltaTable.ResultOption: collection mode

Annotations

@Override

prepare back to summary

pack-priv boolean prepare(SessionLocal session)

Overrides org.h2.command.dml.MergeUsing.When.prepare.

Doc from org.h2.command.dml.MergeUsing.When.prepare.

Prepares WHEN command.

Parameters

session:SessionLocal: the session

Returns:boolean

false if this clause may be removed

Annotations

@Override

public final Class MergeUsing

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

public abstract Class MergeUsing.When

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

public final Class MergeUsing.WhenMatchedThenDelete

Field Summary

Constructor Summary

Method Summary

Constructor Detail

Method Detail

public final Class MergeUsing.WhenMatchedThenUpdate

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

public final Class MergeUsing.WhenNotMatched

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail