Debian Codegraph @

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

raw
1 # Author: Horst Hunger
2 # Created: 2010-07-13
3
4 # windows does not support symlink
5 --source include/not_windows.inc
6
7 let $engine_table= INNODB;
8 let $engine_part= INNODB;
9 let $engine_subpart= INNODB;
10
11 # DATA DIRECTORY
12 # Make directory for partition data
13 let $data_dir_path= $MYSQLTEST_VARDIR/mysql-test-data-dir;
14 --mkdir $data_dir_path
15 let $p_data_directory= DATA DIRECTORY = '$data_dir_path';
16 let $data_directory= DATA DIRECTORY = '$data_dir_path';
17
18 # INDEX DIRECTORY is not supported by InnoDB for partitions.
19
20 use test;
21
22 --disable_result_log
23 --disable_query_log
24 --source suite/parts/inc/part_exch_tabs.inc
25 --enable_result_log
26 --enable_query_log
27
28 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
29
30 --source suite/parts/inc/part_exch_drop_tabs.inc
31 --rmdir $data_dir_path/test
32 --rmdir $data_dir_path
33
34 # DATA DIRECTORY
35 # Make directory for partition data
36 let $data_dir_path= $MYSQLTEST_VARDIR/mysql-test-data-dir;
37 --mkdir $data_dir_path
38 let $p_data_directory= DATA DIRECTORY = '$data_dir_path';
39
40 # INDEX DIRECTORY is not supported by InnoDB for partitions.
41
42 use test;
43
44 --disable_result_log
45 --disable_query_log
46 --source suite/parts/inc/part_exch_tabs.inc
47 --enable_result_log
48 --enable_query_log
49
50 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
51
52 --source suite/parts/inc/part_exch_drop_tabs.inc
53 --rmdir $data_dir_path/test
54 --rmdir $data_dir_path
55
56 # DATA DIRECTORY
57 # Make directory for partition data
58 let $data_dir_path= $MYSQLTEST_VARDIR/mysql-test-data-dir;
59 --mkdir $data_dir_path
60 let $data_directory= DATA DIRECTORY = '$data_dir_path';
61
62 # INDEX DIRECTORY is not supported by InnoDB for partitions.
63
64 use test;
65
66 --disable_result_log
67 --disable_query_log
68 --source suite/parts/inc/part_exch_tabs.inc
69 --enable_result_log
70 --enable_query_log
71
72 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
73
74 --source suite/parts/inc/part_exch_drop_tabs.inc
75 --rmdir $data_dir_path/test
76 --rmdir $data_dir_path
77