[updated with a more concise example inspired from tests]
In an AFTER UPDATE trigger, the new value for a timestamp ON UPDATE NOW() column is set to NOW() even when the row is not updated.
Steps to reproduce the issue
Value of the t column is equal to the value of the new.t column in the trigger
Value of the t column is NOT equal to the value of the new.t column in the trigger
I've relied on this for years to distinguish updated from non updated rows, including in Mysql, but I skipped a lot of versions. The last working version for me was 10.3.17, and I found out about this when upgrading to 10.3.18 (the current stable Debian packaged version) so this is currently blocking for me.
After a chat on irc #maria@freenode I understand it might not be clear what is the expected behavior since it doesn't seem to be documented, but I'll make the case that the NEW value in the trigger should reflect the value that's persisted in the database.
Looking forward to reading some feedback on this!