Idea: a reverse changelog for MySQL
Most software changelogs list what’s changed and what bugs are fixed during each upgrade. But when you’re evaluating an upgrade, what you’re typically concerned about is slightly different — it’s a combination of what’s changed and what might have broken. The fixed bugs aren’t as important for most people, who are either using a workaround or aren’t using the software. What people ask is “what do I have to change in my application, and/or make sure I’m not going to run afoul of, in order to use this new version?”
One of the interesting things about this is that you don’t know until sometime in the future, and it’s never a finished process. So as you look back from each new version, you have more information about the older versions. You see bugs that were fixed, and weren’t known when an older version was released, but which affected that version. So a “20/20 hindsight changelog” is going to be an evolving thing.
Such a changelog might say something like “when upgrading to 5.0.45, watch out for broken tmpdir handling; upgrade to at least 5.0.48 to avoid this bug.” Yes, this is necessarily a pessimistic look at the server, but people who are responsible for mission-critical server deployments are typically pretty conservative, and the good ones focus actively on identifying and managing risks. So it’s a good kind of pessimism.



YES!! This would be great. I’ve been wanting software to do this for a while now. I wanted to do this with a closed source piece of software I was employed to write, but management wouldn’t let me. But, yeah it doesn’t just apply to MySql. Its just an honest thing to do.
William
27 Jan 09 at 11:46 am
[...] has a good idea: a reverse changelog. If you have ever worked your way through a changelog in preparation for an upgrade, this will [...]
Log Buffer #133: A Carnival of the Vanities for DBAs
30 Jan 09 at 1:08 pm
One can hope so!
Dan C
9 Feb 09 at 6:30 am
Thanks for the idea – you might want to investigate the new section of the MySQL Version Reference I added on friday: http://dev.mysql.com/doc/mysqld-version-reference/en/bugsfixed.html
That should (I hope) address your concerns – but also view http://coalface.mcslp.com/2009/03/14/reverse-changelog/ to see what else is possible and let me know if you have any further ideas on you’d like to see.
MC Brown
14 Mar 09 at 6:00 am
Wow! You are amazing! The docs at MySQL just keep getting better and better. I’ve checked out the bugs-fixed page and that is exactly what I think users need — that is so useful. Thank you!
Xaprb
14 Mar 09 at 9:13 am