3 ms·
> silent truncation when inserting is still the default behavior, I think MySQL 5.7, released in Oct 2015, changed the default to enable strict sql_mode. All
by evanelias 4y ago
> silent truncation when inserting is still the default behavior, I think
MySQL 5.7, released in Oct 2015, changed the default to enable strict sql_mode. All prior versions have hit end-of-life for support years ago, so there is no modern version of MySQL with this silent truncation behavior.
That said, there's still a major problem, but it's not MySQL's fault; rather, it's Amazon and their nonstandard defaults. AWS's managed database offerings inexplicably change the default sql_mode to disable strict-mode, both for regular RDS as well as Aurora. This is a huge problem, and it also definitely perpetuates this "MySQL still silently truncates!" perception.