Fix spec failure due to timestamp ordering issue in mySQL

Closes #26622

See merge request !8778