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

Remove duplicate descending indexes for mysql

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.8.1
    • Fix Version/s: 2.9.0, 10.0
    • Component/s: Email Archive
    • Labels:
      None
    • 2.9 Status:
      Resolved
    • Conversion Script Required:
      Yes

      Description

      Email Archive and Announcement contain ascending and descending versions of the same index. However, according to mysql http://dev.mysql.com/doc/refman/5.5/en/create-index.html

      An index_col_name specification can end with ASC or DESC. These keywords are permitted for future extensions for specifying ascending or descending index value storage. Currently, they are parsed but ignored; index values are always stored in ascending order.

      The DESC indexes are therefore duplicates that serve no purpose in mysql and should be removed.

      mailarchive-impl/impl/src/sql/mysql/sakai_mailarchive.sql

      CREATE INDEX IE_MAILARC_MSG_DATE ON MAILARCHIVE_MESSAGE
      (
      MESSAGE_DATE ASC
      );

      CREATE INDEX IE_MAILARC_MSG_DATE_DESC ON MAILARCHIVE_MESSAGE
      (
      MESSAGE_DATE DESC
      );

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ottenhoff Sam Ottenhoff
                  Reporter:
                  yorkadam@umich.edu Adam York (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code