1 files changed, 126 insertions, 0 deletions
diff --git a/mysql-test/suite/parts/inc/partition_alter4.inc b/mysql-test/suite/parts/inc/partition_alter4.inc
new file mode 100644
index 00000000000..e6f5dadbcca
--- /dev/null
+++ b/mysql-test/suite/parts/inc/partition_alter4.inc
@@ -0,0 +1,126 @@
+################################################################################
+# include/partition_alter1.inc                                                 #
+#                                                                              #
+# Purpose:                                                                     #
+#   Execute ALTER ... OPTIMIZE/CHECK/REBUID/ANALYZE statements (maintenance)   #
+#                                                                              #
+#------------------------------------------------------------------------------#
+# Original Author: HH                                                          #
+# Original Date: 2006-07-27                                                    #
+# Change Author:                                                               #
+# Change Date:                                                                 #
+# Change:                                                                      #
+################################################################################
+
+--echo
+--echo #========================================================================
+--echo #  1.1.1.12    ALTER TABLE <maintenance> PARTITION
+--echo #========================================================================
+--echo #------------------------------------------------------------------------
+--echo #  1   ALTER ... ANALYZE PARTITION
+--echo #------------------------------------------------------------------------
+--echo #  1.1 ALTER ... ANALYZE PARTITION part_1;
+let $alter= ALTER TABLE t1 ANALYZE PARTITION part_1;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  1.2 ALTER ... ANALYZE PARTITION part_1,part_2;
+let $alter= ALTER TABLE t1 ANALYZE PARTITION part_1,part_2;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  1.3 ALTER ... ANALYZE PARTITION part_1,part_2,part_5,part_6,part_10;
+let $alter= ALTER TABLE t1 ANALYZE PARTITION part_1,part_2,part_5,part_6,part_10;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  1.4 ALTER ... ANALYZE PARTITION part_1,part_1,part_1;
+let $alter= ALTER TABLE t1 ANALYZE PARTITION part_1,part_1,part_1;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+
+--echo #------------------------------------------------------------------------
+--echo #  2   ALTER ... CHECK PARTITION
+--echo #------------------------------------------------------------------------
+--echo #  2.1 ALTER ... CHECK PARTITION part_1;
+let $alter= ALTER TABLE t1 CHECK PARTITION part_1;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  2.2 ALTER ... CHECK PARTITION part_1,part_2;
+let $alter= ALTER TABLE t1 CHECK PARTITION part_1,part_2;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  2.3 ALTER ... CHECK PARTITION part_1,part_2,part_5,part_6,part_10;
+let $alter= ALTER TABLE t1 CHECK PARTITION part_1,part_2,part_5,part_6,part_10;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  2.4 ALTER ... CHECK PARTITION part_1,part_1,part_1;
+let $alter= ALTER TABLE t1 CHECK PARTITION part_1,part_1,part_1;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+
+--echo #------------------------------------------------------------------------
+--echo #  3   ALTER ... OPTIMIZE PARTITION
+--echo #------------------------------------------------------------------------
+--echo #  3.1 ALTER ... OPTIMIZE PARTITION part_1;
+let $alter= ALTER TABLE t1 OPTIMIZE PARTITION part_1;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  3.2 ALTER ... OPTIMIZE PARTITION part_1,part_2;
+let $alter= ALTER TABLE t1 OPTIMIZE PARTITION part_1,part_2;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  3.3 ALTER ... OPTIMIZE PARTITION part_1,part_2,part_5,part_6,part_10;
+let $alter= ALTER TABLE t1 OPTIMIZE PARTITION part_1,part_2,part_5,part_6,part_10;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  3.4 ALTER ... OPTIMIZE PARTITION part_1,part_1,part_1;
+let $alter= ALTER TABLE t1 OPTIMIZE PARTITION part_1,part_1,part_1;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+
+--echo #------------------------------------------------------------------------
+--echo #  4   ALTER ... REBUILD PARTITION
+--echo #------------------------------------------------------------------------
+--echo #  4.1 ALTER ... REBUILD PARTITION part_1;
+let $alter= ALTER TABLE t1 REBUILD PARTITION part_1;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  4.2 ALTER ... REBUILD PARTITION part_1,part_2;
+let $alter= ALTER TABLE t1 REBUILD PARTITION part_1,part_2;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  4.3 ALTER ... REBUILD PARTITION part_1,part_2,part_5,part_6,part_10;
+let $alter= ALTER TABLE t1 REBUILD PARTITION part_1,part_2,part_5,part_6,part_10;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  4.4 ALTER ... REBUILD PARTITION part_1,part_1,part_1;
+let $alter= ALTER TABLE t1 REBUILD PARTITION part_1,part_1,part_1;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+
+--echo #------------------------------------------------------------------------
+--echo #  5   ALTER ... REPAIR PARTITION
+--echo #------------------------------------------------------------------------
+--echo #  5.1 ALTER ... REBUILD PARTITION part_1;
+let $alter= ALTER TABLE t1 REBUILD PARTITION part_1;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  5.2 ALTER ... REBUILD PARTITION part_1,part_2;
+let $alter= ALTER TABLE t1 REBUILD PARTITION part_1,part_2;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  5.3 ALTER ... REBUILD PARTITION part_1,part_2,part_5,part_6,part_10;
+let $alter= ALTER TABLE t1 REBUILD PARTITION part_1,part_2,part_5,part_6,part_10;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+--echo #  5.4 ALTER ... REBUILD PARTITION part_1,part_1,part_1;
+let $alter= ALTER TABLE t1 REBUILD PARTITION part_1,part_1,part_1;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+
+--echo #------------------------------------------------------------------------
+--echo #  6   ALTER ... REMOVE PARTITIONING
+--echo #------------------------------------------------------------------------
+--echo #  6.1 ALTER ... REMOVE PARTITIONING;
+let $alter= ALTER TABLE t1 REMOVE PARTITIONING;
+--source suite/parts/inc/partition_alter_41.inc
+# --source include/partition_alter_41.inc
+