Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

> Silent truncation only occurs if strict sql_mode is disabled. Strict sql_mode has been the default since MySQL 5.7, released over 6 years ago.

What happens if you upgrade from older version? Are defaults from previous version used, or is it default only on fresh installs?



If you don't have an explicit value set in your my.cnf config and the client sends no explicit value upon connecting you get the current built in default of the version you are using. If you set something somewhere it will be respected.


See bottom of https://news.ycombinator.com/item?id=29910494 and my reply https://news.ycombinator.com/item?id=29910863




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: