gaurantee the order of writes when writes come from the same session

[lmatz]

Due to https://github.com/risingwavelabs/risingwave/blob/main/src/source/src/table.rs#L86,
we may not know which writes will win when there are multiple ones.
(pk conflict, and due to https://github.com/risingwavelabs/rfcs/pull/4/files#diff-73ca4924ee3c22e62b50a34acb513c5252bc3d5c44075d5b0398a2387f6d5c4dR32, the first writes win and the rest will be ignored)?

from the same session seems to be a reasonable setting

[BugenZhao]

A quick but working workaround might be always scheduling the DML to a fixed node and choosing a fixed parallelism here. 🥵

[lmatz]

A quick but working workaround might be always scheduling the DML to a fixed node and choosing a fixed parallelism here. 🥵

https://github.com/risingwavelabs/rfcs/pull/4/files#diff-73ca4924ee3c22e62b50a34acb513c5252bc3d5c44075d5b0398a2387f6d5c4dR54 seems there was a plan

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.

[xxchan]

close in favor of #7213