Changes the name of a partition. This clause can be applied to
all types of indexes. It is particularly useful for specifying
a more meaningful name for the default partition. Use the SHOW
INDEX (PARTITION) statement to display the default names of the
partitions. See Example 4 in the Examples section.
No other clauses may appear in the same ALTER INDEX statement.