The SET SQL_MODE=@OLD_SQL_MODE; and SET SQL_MODE=@OLD_SQL_MODE, @foo='bar'; are missing so in cases like these and /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; from a mysqldump, the mode will not be reset ...