CREATE INDEX statements included in the 2.8.0 conversion scripts are not created when a virgin sakai-2.8.0-b04/profile2-1.4.0-b02 db is populated with auto.ddl=true
GENERAL
TESTING
GENERAL
TESTING
Description
is related to
Activity
Show:
Steve Swinsburg February 15, 2011 at 2:08 PM
As agreed we will ship the indexes in a separate script. They are already included in the profile2 distro.
Steve Swinsburg February 7, 2011 at 1:43 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 profile2/docs to get around this.
Won't Fix
Created February 7, 2011 at 12:12 PM
Updated July 15, 2014 at 7:12 AM
Resolved February 15, 2011 at 2:08 PM
The following CREATE INDEX statements are included in the 2.8.0 conversion scripts (good) but the indexes are not created when a virgin sakai-2.8.0-b04/profile2-1.4.0-b02 db is populated with auto.ddl=true. Converted and auto-generated db objects should match.
MySQL trunk 2.8.0 conversion script:
create index PROFILE_COMPANY_PROFILES_USER_UUID_I on PROFILE_COMPANY_PROFILES_T (USER_UUID);
create index PROFILE_MESSAGES_THREAD_I on PROFILE_MESSAGES_T (MESSAGE_THREAD);
create index PROFILE_MESSAGES_DATE_POSTED_I on PROFILE_MESSAGES_T (DATE_POSTED);
create index PROFILE_MESSAGES_FROM_UUID_I on PROFILE_MESSAGES_T (FROM_UUID);
create index PROFILE_MESSAGE_PARTICIPANT_UUID_I on PROFILE_MESSAGE_PARTICIPANTS_T (PARTICIPANT_UUID);
create index PROFILE_MESSAGE_PARTICIPANT_MESSAGE_ID_I on PROFILE_MESSAGE_PARTICIPANTS_T (MESSAGE_ID);
create index PROFILE_MESSAGE_PARTICIPANT_DELETED_I on PROFILE_MESSAGE_PARTICIPANTS_T (MESSAGE_DELETED);
create index PROFILE_MESSAGE_PARTICIPANT_READ_I on PROFILE_MESSAGE_PARTICIPANTS_T (MESSAGE_READ);
create index PROFILE_GALLERY_IMAGES_USER_UUID_I on PROFILE_GALLERY_IMAGES_T (USER_UUID);
Liquibase test results:
Missing Indexes:
PROFILE_COMPANY_PROFILES_USER_UUID_I unique on profile_company_profiles_t(USER_UUID)
PROFILE_GALLERY_IMAGES_USER_UUID_I unique on profile_gallery_images_t(USER_UUID)
PROFILE_MESSAGE_PARTICIPANT_DELETED_I unique on profile_message_participants_t(MESSAGE_DELETED)
PROFILE_MESSAGE_PARTICIPANT_MESSAGE_ID_I unique on profile_message_participants_t(MESSAGE_ID)
PROFILE_MESSAGE_PARTICIPANT_READ_I unique on profile_message_participants_t(MESSAGE_READ)
PROFILE_MESSAGE_PARTICIPANT_UUID_I unique on profile_message_participants_t(PARTICIPANT_UUID)
PROFILE_MESSAGES_DATE_POSTED_I unique on profile_messages_t(DATE_POSTED)
PROFILE_MESSAGES_FROM_UUID_I unique on profile_messages_t(FROM_UUID)
PROFILE_MESSAGES_THREAD_I unique on profile_messages_t(MESSAGE_THREAD)