Jay Luker - 2006-04-27

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.