partition_alter2_2_innodb.test 3.21 KB
Newer Older
1
################################################################################
2
# t/partition_alter2_2_innodb.test                                             #
3 4 5 6 7 8
#                                                                              #
# Purpose:                                                                     #
#  Tests around Alter column used in partitioning function                     #
#        InnoDB branch                                                         #
#                                                                              #
#------------------------------------------------------------------------------#
unknown's avatar
unknown committed
9
# Original Author: mleich                                                      #
10 11 12 13 14 15 16 17 18 19 20
# Original Date: 2006-03-05                                                    #
# Change Author:                                                               #
# Change Date:                                                                 #
# Change:                                                                      #
################################################################################

#
# NOTE: PLEASE DO NOT ADD NOT INNODB SPECIFIC TESTCASES HERE !
#       TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN
#       THE SOURCED FILES ONLY.
#
unknown's avatar
unknown committed
21
# Please read the README at the end of inc/partition.pre before changing
22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
# any of the variables.
#

#------------------------------------------------------------------------------#
# General not engine specific settings and requirements

##### Options, for debugging support #####
let $debug= 0;
let $with_partitioning= 1;

##### Option, for displaying files #####
let $ls= 1;

##### Number of rows for the INSERT/UPDATE/DELETE/SELECT experiments #####
#     on partioned tables
SET @max_row = 20;

##### Execute more tests                                             #####
let $more_trigger_tests= 0;
let $more_pk_ui_tests= 0;

# The server must support partitioning.
--source include/have_partition.inc

#------------------------------------------------------------------------------#
# Engine specific settings and requirements

##### Storage engine to be tested
--source include/have_innodb.inc
unknown's avatar
unknown committed
51
let $engine= 'InnoDB';
52 53 54 55 56 57 58 59 60 61 62 63 64 65

##### Execute the test of "table" files
# InnoDB has no files per PK, UI, ...
let $do_file_tests= 0;

##### Execute PRIMARY KEY tests                                      #####
# AFAIK InnoDB clusters the table around PRIMARY KEYs.
let $do_pk_tests= 1;

##### Assign a big number smaller than the maximum value for partitions  #####
#     and smaller than the maximum value of SIGNED INTEGER
let $MAX_VALUE= (2147483646);

# Generate the prerequisites ($variables, @variables, tables) needed
unknown's avatar
unknown committed
66
--source suite/parts/inc/partition.pre
67 68 69 70 71 72

##### Workarounds for known open engine specific bugs
#     none

#------------------------------------------------------------------------------#
# Execute the tests to be applied to all storage engines
73
--source suite/parts/inc/partition_alter2_2.inc
74 75 76 77 78 79

#------------------------------------------------------------------------------#
# Execute storage engine specific tests

#------------------------------------------------------------------------------#
# Cleanup
unknown's avatar
unknown committed
80
--source suite/parts/inc/partition_cleanup.inc