So far the biggest problem I've encountered is the use of the newly reserved word "release" as a column name in the lxr_releases table.
I'm also having this problem with the "delete_indexes" prepared statement in LXR/Index/Mysql.pm:
mysql> delete lxr_indexes from lxr_indexes i, lxr_releases r where i.fileid = r.fileid and r.release = 'head';
ERROR 1109 (42S02): Unknown table 'lxr_indexes' in MULTI DELETE
This seems like it might actually be a bug in Mysql.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
So far the biggest problem I've encountered is the use of the newly reserved word "release" as a column name in the lxr_releases table.
I'm also having this problem with the "delete_indexes" prepared statement in LXR/Index/Mysql.pm:
mysql> delete lxr_indexes from lxr_indexes i, lxr_releases r where i.fileid = r.fileid and r.release = 'head';
ERROR 1109 (42S02): Unknown table 'lxr_indexes' in MULTI DELETE
This seems like it might actually be a bug in Mysql.