Archive
window-functions
-
The MySQL 8 upgrade: collations, sql_mode, and the CTEs we finally used
Moving a seven-year-old schema from 5.7 to 8.0 took a weekend. Two startup failures came from my.cnf, ONLY_FULL_GROUP_BY broke three reports, and a collation mismatch on one join reached production.