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

2.6.0 upgrade script has index, column add in wrong order, related to SAK-16554

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.6.0
    • Fix Version/s: 2.6.1
    • Component/s: Reference
    • Labels:
      None
    • Environment:
      the lastest svn pull of sakai, sakai_2_6_0_mysql_conversion.sql, current as of revision 65133

      Description

      The current conversion script reads

      SAK-13584 Further Improve the Performance of the Email Archive and Message API. Note you have to run a bash conversion script on your old mail archive data for it to
      – appear in the new mail archive. The script is in the source as mailarchive-runconversion.sh. Please see the SAK for more information on this script or SAK-16554 for
      – updates to this script.

      CREATE INDEX IE_MAILARC_SUBJECT ON MAILARCHIVE_MESSAGE
      (
      SUBJECT ASC
      );
      ALTER TABLE MAILARCHIVE_MESSAGE ADD COLUMN (
      SUBJECT VARCHAR (255) NULL,
      BODY LONGTEXT NULL
      );

      This fails when I apply it, because the column subject does not exist and therefore cannot be indexed.

      I had to flip the order to

      ALTER TABLE MAILARCHIVE_MESSAGE ADD COLUMN (
      SUBJECT VARCHAR (255) NULL,
      BODY LONGTEXT NULL
      );
      CREATE INDEX IE_MAILARC_SUBJECT ON MAILARCHIVE_MESSAGE
      (
      SUBJECT ASC
      );

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  jonespm Matthew Jones
                  Reporter:
                  jmarca James Marca (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code