Debian Codegraph @

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

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