index missing when upgraded in comment module

Yuryu

Joined: 2004-11-22
Posts: 6
Posted: Mon, 2009-03-09 10:18

Hello,

I found that an index is missing from upgrading procedures in
schema.tpl of comment module.

Although it is adding publishStatus column, there is no query
to add index for that column.
When "creating" from scratch, the table has the index.

http://fisheye3.atlassian.com/browse/gallery/branches/BRANCH_2_3/gallery2/modules/core/classes/GalleryStorage/schema.tpl?r=18194

20 ALTER TABLE DB_TABLE_PREFIXComment
21 ADD COLUMN DB_COLUMN_PREFIXpublishStatus int(11) NOT NULL DEFAULT '0';

Thus, I was suffering from fatal performance degradation.
I don't know whether this is reported or not. Sorry if it's a duplicate.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Mon, 2009-03-09 14:55

Please file a bug:
http://sourceforge.net/tracker/?atid=107130&group_id=7130&func=browse

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team