Index KEY_INDEX not created when using auto.ddl=true
GENERAL
TESTING
GENERAL
TESTING
Description
is related to
Activity
Show:
Anthony Whyte March 10, 2011 at 2:45 AM
The indexes were added to both the 2.8.0 MySQL and Oracle "index-only" conversion scripts.
Seth Theriault February 15, 2011 at 7:19 AM
I think this affects Oracle as well.
Steve Swinsburg February 7, 2011 at 1:44 PM
This is a hibernate issue. I have tried several approaches but still it will not create the indexes. If there is a way I'd love to know about it. I include the indexes in a separate script in shortenedurl/docs to get around this.
Fixed
Created February 7, 2011 at 12:54 PM
Updated September 24, 2013 at 8:08 AM
Resolved March 10, 2011 at 2:46 AM
The following indexes, included in the 2.8.0 conversion scripts, are not generated when creating a MySQL 5.1 sakai-2.8.0-b04/shortenedurlservice-1.0.0-b01 db using auto.ddl=true
create index URL_INDEX on URL_RANDOMISED_MAPPINGS_T (URL);
create index KEY_INDEX on URL_RANDOMISED_MAPPINGS_T (TINY);