Class MergeScope

Object
gudusoft.gsqlparser.resolver2.scope.AbstractScope
gudusoft.gsqlparser.resolver2.scope.MergeScope
All Implemented Interfaces:
IScope

public class MergeScope extends AbstractScope
Scope for MERGE statement. Contains: - Target table (MERGE INTO table) - Source table/subquery (USING clause) - ON clause condition - WHEN MATCHED/NOT MATCHED clauses Example: MERGE INTO archive ar USING (SELECT activity, description FROM activities) ac ON (ar.activity = ac.activity) WHEN MATCHED THEN UPDATE SET description = ac.description WHEN NOT MATCHED THEN INSERT (activity, description) VALUES (ac.activity, ac.description) Resolution strategy: - All column references resolve from target table or source table/subquery - Qualified names (ar.col, ac.col) resolve to specific table - Unqualified names search all visible tables