Debian Codegraph @

mysql-test/suite/parts/t/partition_alter2_1_1_innodb.test

raw
1 ################################################################################
2 # t/partition_alter2_1_1_innodb.test #
3 # #
4 # Purpose: #
5 # Tests around Alter column used in partitioning function #
6 # InnoDB branch #
7 # #
8 #------------------------------------------------------------------------------#
9 # Original Author: mleich #
10 # Original Date: 2006-03-05 #
11 # Change Author: #
12 # Change Date: #
13 # Change: #
14 ################################################################################
15
16 #
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.
20 #
21 # Please read the README at the end of inc/partition.pre before changing
22 # any of the variables.
23 #
24
25 --source include/big_test.inc
26
27 #------------------------------------------------------------------------------#
28 # General not engine specific settings and requirements
29
30 ##### Options, for debugging support #####
31 let $debug= 0;
32 let $with_partitioning= 1;
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 # only do the first part
45 let $only_part_1= 1;
46
47 # This test relies on connecting externally from mysqltest, doesn't
48 # work with embedded.
49 --source include/not_embedded.inc
50 # The server must support partitioning.
51 --source include/have_partition.inc
52
53 # This test takes long time, so only run it with the --big mtr-flag.
54 --source include/big_test.inc
55
56 #------------------------------------------------------------------------------#
57 # Engine specific settings and requirements
58
59 ##### Storage engine to be tested
60 --source include/have_innodb.inc
61 let $engine= 'InnoDB';
62
63 ##### Execute the test of "table" files
64 # InnoDB has no files per PK, UI, ...
65 let $do_file_tests= 0;
66
67 ##### Execute PRIMARY KEY tests #####
68 # AFAIK InnoDB clusters the table around PRIMARY KEYs.
69 let $do_pk_tests= 1;
70
71 ##### Assign a big number smaller than the maximum value for partitions #####
72 # and smaller than the maximum value of SIGNED INTEGER
73 let $MAX_VALUE= (2147483646);
74
75 # Generate the prerequisites ($variables, @variables, tables) needed
76 --source suite/parts/inc/partition.pre
77
78 ##### Workarounds for known open engine specific bugs
79 # none
80
81 #------------------------------------------------------------------------------#
82 # Execute the tests to be applied to all storage engines
83 --source suite/parts/inc/partition_alter2_1.inc
84
85 #------------------------------------------------------------------------------#
86 # Execute storage engine specific tests
87
88 #------------------------------------------------------------------------------#
89 # Cleanup
90 --source suite/parts/inc/partition_cleanup.inc