Debian Codegraph @

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

raw
1 # This test takes long time, so only run it with the --big-test mtr-flag.
2 --source include/big_test.inc
3 ################################################################################
4 # t/partition_alter1_1_innodb.test #
5 # #
6 # Purpose: #
7 # Tests around ADD/DROP PRIMARY KEY and/or UNIQUE INDEX #
8 # InnoDB branch #
9 # #
10 #------------------------------------------------------------------------------#
11 # Original Author: mleich #
12 # Original Date: 2006-03-05 #
13 # Change Author: pcrews #
14 # Change Date: 2008-05-05 #
15 # Change: Split up original partition_alter1.test file to better accommodate #
16 # PushBuild machines' workloads. Total run time for all components #
17 # is essentially the same, but max. single run time is significantly #
18 # reduced #
19 ################################################################################
20 #
21 # NOTE: PLEASE DO NOT ADD NOT INNODB SPECIFIC TESTCASES HERE !
22 # TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN
23 # THE SOURCED FILES ONLY.
24 #
25 # Please read the README at the end of inc/partition.pre before changing
26 # any of the variables.
27 #
28
29 #------------------------------------------------------------------------------#
30 # General not engine specific settings and requirements
31
32 ##### Options, for debugging support #####
33 let $debug= 0;
34 let $with_partitioning= 1;
35
36 ##### Option, for displaying files #####
37 let $ls= 1;
38
39 ##### Number of rows for the INSERT/UPDATE/DELETE/SELECT experiments #####
40 # on partioned tables
41 SET @max_row = 20;
42
43 ##### Execute more tests #####
44 let $more_trigger_tests= 0;
45 let $more_pk_ui_tests= 0;
46
47
48 #------------------------------------------------------------------------------#
49 # Engine specific settings and requirements
50
51 ##### Storage engine to be tested
52 let $engine= 'InnoDB';
53
54 ##### Execute the test of "table" files
55 # InnoDB has no files per PK, UI, ...
56 let $do_file_tests= 0;
57
58 ##### Execute PRIMARY KEY tests #####
59 # AFAIK InnoDB clusters the table around PRIMARY KEYs.
60 let $do_pk_tests= 1;
61
62 ##### Assign a big number smaller than the maximum value for partitions #####
63 # and smaller than the maximum value of SIGNED INTEGER
64 let $MAX_VALUE= (2147483646);
65
66 # Generate the prerequisites ($variables, @variables, tables) needed
67 --source suite/parts/inc/partition.pre
68
69 ##### Workarounds for known open engine specific bugs
70 # none
71
72 #------------------------------------------------------------------------------#
73 # Execute the tests to be applied to all storage engines
74 --source suite/parts/inc/partition_alter1_1.inc
75
76 #------------------------------------------------------------------------------#
77 # Execute storage engine specific tests
78
79 #------------------------------------------------------------------------------#
80 # Cleanup
81 --source suite/parts/inc/partition_cleanup.inc