Debian Codegraph @

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

raw
1 # Author: Horst Hunger
2 # Created: 2010-07-13
3
4 source include/not_windows.inc;
5 source include/have_partition.inc;
6 source include/have_symlink.inc;
7
8 let $engine_table= MYISAM;
9 let $engine_part= MYISAM;
10 let $engine_subpart= MYISAM;
11 let $data_dir_path= $MYSQLTEST_VARDIR/mysql-test-data-dir;
12 let $idx_dir_path= $MYSQLTEST_VARDIR/mysql-test-idx-dir;
13 mkdir $data_dir_path;
14 mkdir $idx_dir_path;
15
16 echo # === Data/Index directories are identical;
17 let $p_data_directory= DATA DIRECTORY = '$data_dir_path';
18 let $data_directory= DATA DIRECTORY = '$data_dir_path';
19 let $p_index_directory= INDEX DIRECTORY = '$idx_dir_path';
20 let $index_directory= INDEX DIRECTORY = '$idx_dir_path';
21 source suite/parts/inc/part_exch_tabs.inc;
22 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
23 source suite/parts/inc/part_exch_drop_tabs.inc;
24
25 echo # === partition has directories, the table does not;
26 let $p_data_directory= DATA DIRECTORY = '$data_dir_path';
27 let $data_directory= ;
28 let $p_index_directory= INDEX DIRECTORY = '$idx_dir_path';
29 let $index_directory= ;
30 source suite/parts/inc/part_exch_tabs.inc;
31 error ER_TABLES_DIFFERENT_METADATA;
32 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
33 source suite/parts/inc/part_exch_drop_tabs.inc;
34
35 echo # === the table has directories, partition does not;
36 let $p_data_directory= ;
37 let $data_directory= DATA DIRECTORY = '$data_dir_path';
38 let $p_index_directory= ;
39 let $index_directory= INDEX DIRECTORY = '$idx_dir_path';
40 source suite/parts/inc/part_exch_tabs.inc;
41 error ER_TABLES_DIFFERENT_METADATA;
42 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
43 source suite/parts/inc/part_exch_drop_tabs.inc;
44
45 echo # === data directory differs;
46 let $p_data_directory= DATA DIRECTORY = '$data_dir_path';
47 let $data_directory= DATA DIRECTORY = '$idx_dir_path';
48 let $p_index_directory= INDEX DIRECTORY = '$idx_dir_path';
49 let $index_directory= INDEX DIRECTORY = '$idx_dir_path';
50 source suite/parts/inc/part_exch_tabs.inc;
51 error ER_TABLES_DIFFERENT_METADATA;
52 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
53 source suite/parts/inc/part_exch_drop_tabs.inc;
54
55 echo # === index directory differs;
56 let $p_data_directory= DATA DIRECTORY = '$data_dir_path';
57 let $data_directory= DATA DIRECTORY = '$data_dir_path';
58 let $p_index_directory= DATA DIRECTORY = '$data_dir_path';
59 let $index_directory= DATA DIRECTORY = '$idx_dir_path';
60 source suite/parts/inc/part_exch_tabs.inc;
61 error ER_TABLES_DIFFERENT_METADATA;
62 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
63 source suite/parts/inc/part_exch_drop_tabs.inc;
64
65 rmdir $idx_dir_path;
66 rmdir $data_dir_path;