That's expected behaviour. When the transaction is about to be committed (the before phase) the results of your statement are already produced, so you won't see trigger modifications at that time.
1 Like