Debian Codegraph @

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

raw
1 ################################################################################
2 # t/partition_basic_myisam.test #
3 # #
4 # Purpose: #
5 # Tests around Create Partitioned table using DATA/INDEX DIR #
6 # MyISAM branch #
7 # #
8 #------------------------------------------------------------------------------#
9 # Original Author: mleich #
10 # Original Date: 2006-03-05 #
11 # Change Author: mattiasj #
12 # Change Date: 2008-02-05 #
13 # Change: copied it from partition_basic_myisam.test and kept DATA DIR #
14 ################################################################################
15
16 #
17 # NOTE: PLEASE DO NOT ADD NOT MYISAM 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 #------------------------------------------------------------------------------#
26 # General not engine specific settings and requirements
27
28 ##### Options, for debugging support #####
29 let $debug= 0;
30 let $with_partitioning= 1;
31
32 ##### Option, for displaying files #####
33 let $ls= 1;
34
35 ##### Number of rows for the INSERT/UPDATE/DELETE/SELECT experiments #####
36 # on partioned tables
37 SET @max_row = 20;
38
39 ##### Execute more tests #####
40 let $more_trigger_tests= 0;
41 let $more_pk_ui_tests= 0;
42
43 # This test relies on connecting externally from mysqltest, doesn't
44 # work with embedded.
45 --source include/not_embedded.inc
46 # The server must support partitioning.
47 --source include/have_partition.inc
48 # The server must support symlink for DATA/INDEX DIRECTORY.
49 --source include/have_symlink.inc
50 # windows does not support symlink for DATA/INDEX DIRECTORY.
51 --source include/not_windows.inc
52
53 #------------------------------------------------------------------------------#
54 # Engine specific settings and requirements
55
56 ##### Storage engine to be tested
57 let $engine= 'MyISAM';
58 # The server uses in case of MyISAM symlinking (if available) and the expected
59 # results fit to symlinking support.
60 --source include/have_symlink.inc
61
62 ##### Execute the test of "table" files
63 # MyISAM has files per PK, UI, ...
64 let $do_file_tests= 1;
65
66 ##### Execute PRIMARY KEY tests #####
67 # AFAIK MyISAM treats PRIMARY KEYs like UNIQUE INDEXes
68 let $do_pk_tests= 0;
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 # Generate the prerequisites ($variables, @variables, tables) needed
75 --source suite/parts/inc/partition.pre
76
77 ##### Workarounds for known open engine specific bugs
78 # none
79
80 #------------------------------------------------------------------------------#
81 # Execute the tests to be applied to all storage engines
82 --source suite/parts/inc/partition_basic_symlink.inc
83
84 #------------------------------------------------------------------------------#
85 # Execute storage engine specific tests
86
87 #------------------------------------------------------------------------------#
88 # Cleanup
89 --source suite/parts/inc/partition_cleanup.inc