In a discussion on the LXR mailing list the proposal was made to avoid the whole "quoting `release` keyword" problem in MySQL 5 by simply renaming the column to something that's not a keyword (rather than going through and remembering to quote it everywhere).
This patch is a comprehensive attempt to do that, renaming the lxr_releases table to lxr_streams and the release column in that table to "stream". It also renames the "release" references in the DB backends to "stream" so that they're consistent. It does NOT attempt to rename the upper-level uses of the term "release", although that's something that might be worth doing for consistency's sake.
Finally, it provides some scripts to update existing databases and perform those renames on them, so you don't have to dump/reload your data, and gives instructions in the INSTALL file on how to use them.
Log in to post a comment.