partition_basic_myisam.test 3.17 KB
Newer Older
1 2 3 4 5 6 7 8
################################################################################
# t/partition_basic_myisam.test                                                #
#                                                                              #
# Purpose:                                                                     #
#  Tests around Create Partitioned table                                       #
#        MyISAM 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 MYISAM 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 51 52 53 54 55 56 57 58 59 60 61 62 63 64
# 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
let $engine= 'MyISAM';

##### Execute the test of "table" files
# MyISAM has files per PK, UI, ...
let $do_file_tests= 1;

##### Execute PRIMARY KEY tests                                      #####
# AFAIK MyISAM treats PRIMARY KEYs like UNIQUE INDEXes
let $do_pk_tests= 0;

##### 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
65
--source suite/parts/inc/partition.pre
66 67 68 69 70 71

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

#------------------------------------------------------------------------------#
# Execute the tests to be applied to all storage engines
unknown's avatar
unknown committed
72
--source suite/parts/inc/partition_basic.inc
73 74 75 76 77 78

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

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