1 ################################################################################
2 # t/partition_engine_innodb.test #
5 # Tests around Create/Alter partitioned tables and storage engine settings #
8 #------------------------------------------------------------------------------#
9 # Original Author: mleich #
10 # Original Date: 2006-03-05 #
14 ################################################################################
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.
21 # Please read the README at the end of inc/partition.pre before changing
22 # any of the variables.
25 #------------------------------------------------------------------------------#
26 # General not engine specific settings and requirements
28 ##### Options, for debugging support #####
31 ##### Option, for displaying files #####
34 ##### Number of rows for the INSERT/UPDATE/DELETE/SELECT experiments #####
38 ##### Execute more tests #####
39 let $more_trigger_tests= 0;
40 let $more_pk_ui_tests= 0;
42 # The server must support partitioning.
43 --source include/have_partition.inc
45 #------------------------------------------------------------------------------#
46 # Engine specific settings and requirements
48 ##### Storage engine to be tested
49 --source include/have_innodb.inc
50 let $engine= 'InnoDB';
52 ##### Execute the test of "table" files
53 # InnoDB has no files per PK, UI, ...
54 let $do_file_tests= 0;
56 ##### Execute PRIMARY KEY tests #####
57 # AFAIK InnoDB clusters the table around PRIMARY KEYs.
60 ##### Assign a big number smaller than the maximum value for partitions #####
61 # and smaller than the maximum value of SIGNED INTEGER
62 let $MAX_VALUE= (2147483646);
64 # Generate the prerequisites ($variables, @variables, tables) needed
65 --source suite/parts/inc/partition.pre
67 ##### Workarounds for known open engine specific bugs
70 #------------------------------------------------------------------------------#
71 # Execute the tests to be applied to all storage engines
72 --source suite/parts/inc/partition_engine.inc
74 #------------------------------------------------------------------------------#
75 # Execute storage engine specific tests
77 #------------------------------------------------------------------------------#
79 --source suite/parts/inc/partition_cleanup.inc