I have a table with a definition similar to this:
from the binlog:
Note that column 32 (created_on) gets the correct value but column 21 (last_modified) does not. It gets a value of 0.
Note that neither one of those fields was explicitly mentioned in INSERT statement.
I have linked to another ticket that is somewhat similar for UPDATE statements occasionally ignoring the ON UPDATE CURRENT_TIMESTAMP clause.
Is there some sequence of events that could cause this? any known related issues that might explain it?? thanks!!