[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
using RelToSqlConverter.

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.