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

   1 ################################################################################
   2 # t/partition_alter1_2_myisam.test                                             #
   3 #                                                                              #
   4 # Purpose:                                                                     #
   5 #  Tests around ADD/DROP PRIMARY KEY and/or UNIQUE INDEX                       #
   6 #        MyISAM branch                                                         #
   7 #                                                                              #
   8 #------------------------------------------------------------------------------#
   9 # Original Author: mleich                                                      #
  10 # Original Date: 2006-03-05                                                    #
  11 # Change Author: pcrews                                                        #
  12 # Change Date: 2008-05-05                                                      #
  13 # Change: Split up original partition_alter1.test file to better accommodate   #
  14 #         PushBuild machines' workloads.  Total run time for all components    #
  15 #         is essentially the same, but max. single run time is significantly   #
  16 #         reduced                                                              #
  17 ################################################################################
  18
  19 #
  20 # NOTE: PLEASE DO NOT ADD NOT MYISAM SPECIFIC TESTCASES HERE !
  21 #       TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN
  22 #       THE SOURCED FILES ONLY.
  23 #
  24 # Please read the README at the end of inc/partition.pre before changing
  25 # any of the variables.
  26 #
  27
  28 #------------------------------------------------------------------------------#
  29 # General not engine specific settings and requirements
  30
  31 ##### Options, for debugging support #####
  32 let $debug= 0;
  33 let $with_partitioning= 1;
  34
  35 ##### Option, for displaying files #####
  36 let $ls= 1;
  37
  38 ##### Number of rows for the INSERT/UPDATE/DELETE/SELECT experiments #####
  39 #     on partioned tables
  40 SET @max_row = 20;
  41
  42 ##### Execute more tests                                             #####
  43 let $more_trigger_tests= 0;
  44 let $more_pk_ui_tests= 0;
  45
  46 # The server must support partitioning.
  47 --source include/have_partition.inc
  48
  49 #------------------------------------------------------------------------------#
  50 # Engine specific settings and requirements
  51
  52 ##### Storage engine to be tested
  53 let $engine= 'MyISAM';
  54
  55 ##### Execute the test of "table" files
  56 # MyISAM has files per PK, UI, ...
  57 let $do_file_tests= 1;
  58
  59 ##### Execute PRIMARY KEY tests                                      #####
  60 # AFAIK MyISAM treats PRIMARY KEYs like UNIQUE INDEXes
  61 let $do_pk_tests= 0;
  62
  63 ##### Assign a big number smaller than the maximum value for partitions  #####
  64 #     and smaller than the maximum value of SIGNED INTEGER
  65 let $MAX_VALUE= (2147483646);
  66
  67 # Generate the prerequisites ($variables, @variables, tables) needed
  68 --source suite/parts/inc/partition.pre
  69
  70 ##### Workarounds for known open engine specific bugs
  71 #     none
  72
  73 #------------------------------------------------------------------------------#
  74 # Execute the tests to be applied to all storage engines
  75 --source suite/parts/inc/partition_alter1_2.inc
  76
  77 #------------------------------------------------------------------------------#
  78 # Execute storage engine specific tests
  79
  80 #------------------------------------------------------------------------------#
  81 # Cleanup
  82 --source suite/parts/inc/partition_cleanup.inc