4 ms·
> 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 i
by Ginden 5y ago
> 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?
- evanelias 5y agoSee bottom of https://news.ycombinator.com/item?id=29910494 https://news.ycombinator.com/item?id=29910494 and my reply https://news.ycombinator.com/item?id=29910863 https://news.ycombinator.com/item?id=29910863
- johannes1234321 5y agoIf 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.