Correlated Variables in TableModify(Update)
When creating a TableModify(Update), I see correlated variables are used to
encapsulate the right side of SET expressions.
I was wondering what is the purpose of creating correlated variable
On its face value, it seems to create stand-alone expressions, column
references are needed & to create column references without underlying
input co-related variables are needed. (This is what I Understood so far)
This seems to be a problem when we try to* generate a SqlNode from
The correct CONTEXT against the CorrelationId is not present when we try to
convert those SET expressions to SqlNode.
Any suggestions or info about this scenario would be appreciated.