release/src/router/mysql/mysql-test/suite/parts/t/partition_alter4_innodb.test

   1 ################################################################################
   2 # t/partition_alter4_innodb.test                                               #
   3 #                                                                              #
   4 # Purpose:                                                                     #
   5 #  Tests of ALTER ... ANALYZE/OPTIMIZE/... PARTITION                           #
   6 #     in InnoDB branch                                                         #
   7 #                                                                              #
   8 #------------------------------------------------------------------------------#
   9 # Original Author: HH                                                          #
  10 # Original Date: 2006-07-27                                                    #
  11 # Change Author:                                                               #
  12 # Change Date:                                                                 #
  13 # Change:                                                                      #
  14 ################################################################################
  15
  16 #
  17 # NOTE: PLEASE DO NOT ADD NOT INNODB SPECIFIC TESTCASES HERE !
  18 #       TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN
  19 #       THE SOURCED FILES ONLY.
  20 #
  21 # Please read the README at the end of inc/partition.pre before changing
  22 # any of the variables.
  23 #
  24
  25 #------------------------------------------------------------------------------#
  26 # General not engine specific settings and requirements
  27
  28 ##### Options, for debugging support #####
  29 let $debug= 0;
  30 let $with_partitioning= 1;
  31
  32 ##### Option, for displaying files #####
  33 let $ls= 1;
  34
  35 ##### Number of rows for the INSERT/UPDATE/DELETE/SELECT experiments #####
  36 #     on partioned tables
  37 SET @max_row = 20;
  38
  39 ##### Execute more tests                                             #####
  40 let $more_trigger_tests= 0;
  41 let $more_pk_ui_tests= 0;
  42
  43 # The server must support partitioning.
  44 --source include/have_partition.inc
  45
  46 # This test takes long time, so only run it with the --big mtr-flag.
  47 --source include/big_test.inc
  48
  49 #------------------------------------------------------------------------------#
  50 # Engine specific settings and requirements
  51
  52 ##### Storage engine to be tested
  53 --source include/have_innodb.inc
  54 let $engine= 'InnoDB';
  55
  56 ##### Execute the test of "table" files
  57 # InnoDB has no files per PK, UI, ...
  58 let $do_file_tests= 0;
  59
  60 ##### Execute                                   #####
  61 # AFAIK InnoDB clusters the table around PRIMARY KEYs.
  62 let $do_pk_tests= 1;
  63
  64 ##### Assign a big number smaller than the maximum value for partitions  #####
  65 #     and smaller than the maximum value of SIGNED INTEGER
  66 let $MAX_VALUE= (2147483646);
  67
  68 # Generate the prerequisites ($variables, @variables, tables) needed
  69 --source suite/parts/inc/partition.pre
  70
  71 ##### Workarounds for known open engine specific bugs
  72 #     none
  73
  74 #------------------------------------------------------------------------------#
  75 # Execute the tests to be applied to all storage engines
  76 --source suite/parts/inc/partition_alter4.inc
  77
  78 #------------------------------------------------------------------------------#
  79 # Execute storage engine specific tests
  80
  81 #------------------------------------------------------------------------------#
  82 # Cleanup
  83 --source suite/parts/inc/partition_cleanup.inc