#39 Rename "release" to "stream" in SQL interface


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.


  • Paul D. Smith

    Paul D. Smith - 2007-04-03
  • Andre-Littoz

    Andre-Littoz - 2011-03-12

    Fixed some time in the past 'release' -> 'releaseid'

  • Andre-Littoz

    Andre-Littoz - 2011-03-12
    • status: open --> closed-fixed
  • Andre-Littoz

    Andre-Littoz - 2011-03-13
    • status: closed-fixed --> closed-out-of-date
  • Andre-Littoz

    Andre-Littoz - 2011-03-13

    Fixed sometime in the past


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks