Debian Codegraph @

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

raw
1 #Considering the time taken for this test on slow solaris platforms making it a big test
2 --source include/big_test.inc
3 # Skiping this test from Valgrind execution as per Bug-14627884
4 --source include/not_valgrind.inc
5 ################################################################################
6 # t/partition_basic_innodb.test #
7 # #
8 # Purpose: #
9 # Tests around Create Partitioned table #
10 # InnoDB branch #
11 # #
12 #------------------------------------------------------------------------------#
13 # Original Author: mleich #
14 # Original Date: 2006-03-05 #
15 # Change Author: #
16 # Change Date: #
17 # Change: #
18 ################################################################################
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 # The server must support partitioning.
48 --source include/have_partition.inc
49
50 # Does not work with --embedded
51 --source include/not_embedded.inc
52
53 #------------------------------------------------------------------------------#
54 # Engine specific settings and requirements
55
56 ##### Storage engine to be tested
57 --source include/have_innodb.inc
58 let $engine= 'InnoDB';
59
60 ##### Execute the test of "table" files
61 # InnoDB has no files per PK, UI, ... But only .frm file
62 let $do_file_tests= 1;
63
64 ##### Execute PRIMARY KEY tests #####
65 # AFAIK InnoDB clusters the table around PRIMARY KEYs.
66 let $do_pk_tests= 1;
67
68 ##### Assign a big number smaller than the maximum value for partitions #####
69 # and smaller than the maximum value of SIGNED INTEGER
70 let $MAX_VALUE= (2147483646);
71
72 # Generate the prerequisites ($variables, @variables, tables) needed
73 --source suite/parts/inc/partition.pre
74
75 ##### Workarounds for known open engine specific bugs
76 # none
77
78 #------------------------------------------------------------------------------#
79 # Execute the tests to be applied to all storage engines
80 --source suite/parts/inc/partition_basic.inc
81
82 #------------------------------------------------------------------------------#
83 # Execute storage engine specific tests
84
85 #------------------------------------------------------------------------------#
86 # Cleanup
87 --source suite/parts/inc/partition_cleanup.inc