Jinhua Luo wrote:
> The document said, "Read Committed mode starts each command with a new
> snapshot that includes all transactions committed up to that instant".
>
> But what about the embedded commands within the outer command itself?
> Do they share the same snapshot with the outer command?
>
> a) trigger
> b) CTE
> c) other forms of sub-query
All these share the snapshot of the command to which they belong.
As you wrote, things would break if it were different.
Yours,
Laurenz Albe