Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-20081

Missing announcement ALTER TABLE and CREATE INDEX scripts in the 2.8.0 Oracle conversion scripts.

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.8.0
    • Fix Version/s: 2.8.0
    • Component/s: Reference
    • Labels:
      None
    • Conversion Script Required:
      Yes
    • CLE Team Issue:
      Yes

      Description

      A liquibase comparison of a virgin 2.8.0-b04 db vs a converted 2.7.1->2.8.0 db revealed a missing announcements column (MESSAGE_ORDER) as well as missing indexes in the converted database associated with SAK-8005 work. I added the following scripts to the 2.8.0 MySQL conversion scripts as part of my test/fix work:

      SAK-8005
      alter table ANNOUNCEMENT_MESSAGE add column MESSAGE_ORDER int(11) default null;

      drop index IE_ANNC_MSG_ATTRIB on ANNOUNCEMENT_MESSAGE;
      create index IE_ANNC_MSG_ATTRIB on ANNOUNCEMENT_MESSAGE (DRAFT, PUBVIEW, OWNER, MESSAGE_ORDER);

      drop index ANNOUNCEMENT_MESSAGE_CDD on ANNOUNCEMENT_MESSAGE;
      create index ANNOUNCEMENT_MESSAGE_CDD on ANNOUNCEMENT_MESSAGE (CHANNEL_ID, MESSAGE_DATE, MESSAGE_ORDER, DRAFT);

      We need the parallel scripts written in the Oracle dialect added to the 2.8.0 Oracle conversion scripts.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  savithap Savitha Prakash (Inactive)
                  Reporter:
                  arwhyte Anthony Whyte
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration