Debian Codegraph @

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

raw
1 ################################################################################
2 # t/partition_value_myisam.test #
3 # #
4 # Purpose: #
5 # Tests around "exotic" values calculated by the partitioning function #
6 # MyISAM branch #
7 # #
8 #------------------------------------------------------------------------------#
9 # Original Author: mleich #
10 # Original Date: 2006-04-11 #
11 # Change Author: mleich #
12 # Change Date: 2008-12-08 #
13 # Change: Remove test from disabled.def + change test that it gets skipped #
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 # CAST() within the partitioning function si no more supported, but we get
27 # this functionality probably soon again. Therefor we do not delete this test.
28 --skip # CAST() in partitioning function is currently not supported.
29
30
31 #------------------------------------------------------------------------------#
32 # General not engine specific settings and requirements
33
34 ##### Options, for debugging support #####
35 let $debug= 0;
36
37 ##### Option, for displaying files #####
38 let $ls= 1;
39
40 ##### Number of rows for the INSERT/UPDATE/DELETE/SELECT experiments #####
41 # on partioned tables
42 SET @max_row = 20;
43
44 ##### Execute more tests #####
45 let $more_trigger_tests= 0;
46 let $more_pk_ui_tests= 0;
47
48 # The server must support partitioning.
49 --source include/have_partition.inc
50
51 #------------------------------------------------------------------------------#
52 # Engine specific settings and requirements
53
54 ##### Storage engine to be tested
55 let $engine= 'MyISAM';
56
57 ##### Execute the test of "table" files
58 # MyISAM has files per PK, UI, ...
59 let $do_file_tests= 1;
60
61 ##### Execute PRIMARY KEY tests #####
62 # AFAIK MyISAM treats PRIMARY KEYs like UNIQUE INDEXes
63 let $do_pk_tests= 0;
64
65 ##### Assign a big number smaller than the maximum value for partitions #####
66 # and smaller than the maximum value of SIGNED INTEGER
67 let $MAX_VALUE= (2147483646);
68
69 # Generate the prerequisites ($variables, @variables, tables) needed
70 --source suite/parts/inc/partition.pre
71
72 ##### Workarounds for known open engine specific bugs
73 # none
74
75 #------------------------------------------------------------------------------#
76 # Execute the tests to be applied to all storage engines
77 --source suite/parts/inc/partition_value.inc
78
79 #------------------------------------------------------------------------------#
80 # Execute storage engine specific tests
81
82 #------------------------------------------------------------------------------#
83 # Cleanup
84 --source suite/parts/inc/partition_cleanup.inc