Issue 267: Syntax error in upgrade015_016_part1_mysql.sql
Status:  Released
Owner:
Closed:  Oct 2012
Reported by code-rev...@gtempaccount.com, Sep 24, 2009
Reported by Benjamin Gilbert <bgilbert@backtick.net> on Wed Aug 26 10:01:30 PDT 2009
Source: JIRA GERRIT-268
Affected Version: 2.0.19.1
Environment: MySQL 5.0.75 from Ubuntu Jaunty

upgrade015_016_part1_mysql.sql includes ALTER INDEX statements, which are not
supported by MySQL.
Sep 24, 2009
#1 code-rev...@gtempaccount.com
Comment by Shawn Pearce <sop@google.com> on Wed Aug 26 10:10:21 PDT 2009

Whoops.  It appears MySQL has no way to rename an index.

So I guess that leaves one with:

  DROP INDEX change_approvals_closedbyuser on patch_set_approvals;
  DROP INDEX change_approvals_openbyuser ON patch_set_approvals;

  CREATE INDEX patch_set_approvals_openByUser
  ON patch_set_approvals (change_open, account_id);

  CREATE INDEX patch_set_approvals_closedByUser
  ON patch_set_approvals (change_open, account_id, change_sort_key);

Changed in I76946255c39ac10a7e77b49fa3bd8a94bfc344fa
Sep 24, 2009
#2 code-rev...@gtempaccount.com
Update by Shawn Pearce <sop@google.com> on Wed Aug 26 10:10:29 PDT 2009

Fixed in version 2.0.20.
Status: Fixed
Sep 25, 2009
#3 code-rev...@gtempaccount.com
(No comment was entered for this change.)
Labels: FixedIn-2.0.20
Oct 21, 2012
#4 sop@google.com
(No comment was entered for this change.)
Status: Released