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

   1 ################################################################################
   2 # t/partition_alter1_1_2_ndb.test                                              #
   3 #                                                                              #
   4 # Purpose:                                                                     #
   5 #  Tests around ADD/DROP PRIMARY KEY and/or UNIQUE INDEX                       #
   6 #        NDB 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 # NOTE: PLEASE DO NOT ADD NOT NDB SPECIFIC TESTCASES HERE !
  20 #       TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN
  21 #       THE SOURCED FILES ONLY.
  22 #
  23 # Please read the README at the end of inc/partition.pre before changing
  24 # any of the variables.
  25 #
  26
  27 #------------------------------------------------------------------------------#
  28 # General not engine specific settings and requirements
  29 --source include/big_test.inc
  30
  31 ##### Options, for debugging support #####
  32 let $debug= 0;
  33
  34 ##### Option, for displaying files #####
  35 let $ls= 1;
  36
  37 ##### Number of rows for the INSERT/UPDATE/DELETE/SELECT experiments #####
  38 #     on partioned tables
  39 SET @max_row = 20;
  40
  41 ##### Execute more tests                                             #####
  42 let $more_trigger_tests= 0;
  43 let $more_pk_ui_tests= 0;
  44
  45 # The server must support partitioning. But NDB is partitioned from the start.
  46 # Thats why the next line is set to comment.
  47 # --source include/have_partition.inc
  48
  49 #------------------------------------------------------------------------------#
  50 # Engine specific settings and requirements
  51
  52 ##### Storage engine to be tested
  53 --source include/have_ndb.inc
  54 let $engine= 'ndbcluster';
  55 connection default;
  56
  57 ##### Execute the test of "table" files
  58 # NDB has no files per PK, UI, ...
  59 let $do_file_tests= 0;
  60
  61 ##### Execute PRIMARY KEY tests                                      #####
  62 # AFAIK NDB is always partitioned using the explicit defined PRIMARY KEY
  63 #       or uses an internal one.
  64 let $do_pk_tests= 1;
  65
  66 ##### Assign a big number smaller than the maximum value for partitions  #####
  67 #     and smaller than the maximum value of SIGNED INTEGER
  68 # The NDB handler only supports 32 bit integers in VALUES
  69 #     2147483647 seems to be too big.
  70 let $MAX_VALUE= (2147483646);
  71
  72 # Generate the prerequisites ($variables, @variables, tables) needed
  73 --source suite/parts/inc/partition.pre
  74
  75 ##### Workarounds for known open engine specific bugs
  76 # Bug#18735: Partitions: NDB, UNIQUE INDEX, UPDATE, strange server response
  77 let $fixed_bug18735= 1;
  78
  79 #------------------------------------------------------------------------------#
  80 # Execute the tests to be applied to all storage engines
  81 --source suite/parts/inc/partition_alter1_1_2.inc
  82
  83 #------------------------------------------------------------------------------#
  84 # Execute storage engine specific tests
  85
  86 #------------------------------------------------------------------------------#
  87 # Cleanup
  88 --source suite/parts/inc/partition_cleanup.inc