For sql jobs with multi-sinks, the plan is divided into relNode blocks, changeLog mode should be also inferred among blocks. Currently, updateKind trait is not propagated properly from parent block to child blocks for the following pattern.
block0 -> block1 -> block4
In the above example, if block3 requires UB and block2, block4 do not require UB, block1 only contains Calc node.
For Agg in block0, UB should be emitted, but the updateKind for block0 is inferred as ONLY_UPDATE_AFTER.