Last modified: 2007-07-02 16:34:13 UTC
Created attachment 3865 [details]
I created this report because I can't commit to the svn. I trust one of the developpers to do it after testing, but it works for me.
Problem : When you create the table from scrach, the script contains truncation.
maintenance/tables.sql lines 728-729:
-- oi_archive_name truncated to 14 to avoid key length overflow
INDEX oi_name_archive_name (oi_name,oi_archive_name(14))
But when you try to upgrade, the script doesn't so it stops, leaving the database in an unusable state.
maintenance/archives/patch-oi_metadata.sql line 11:
ADD INDEX oi_name_archive_name (oi_name,oi_archive_name),
Solution : Replace maintenance/archives/patch-oi_metadata.sql line 11 by:
ADD INDEX oi_name_archive_name (oi_name,oi_archive_name(14)),
Fixed in r23650.