Debian Codegraph @

mysql-test/suite/parts/inc/part_exch_valid_hash.inc

raw
1 use test;
2
3 call mtr.add_suppression("row in wrong partition.*from REBUILD/REORGANIZED");
4 #--disable_result_log
5 #--disable_query_log
6 --source suite/parts/inc/part_exch_ext_tabs.inc
7 #--enable_result_log
8 #--enable_query_log
9
10 --echo ####################################################################
11 --echo ### Hash partitioned tables with/out validation
12
13 --error ER_ROW_DOES_NOT_MATCH_PARTITION
14 ALTER TABLE tp_h EXCHANGE PARTITION p0 WITH TABLE t_10 WITH VALIDATION;
15 --sorted_result
16 SELECT * FROM tp_h PARTITION (p0);
17 --sorted_result
18 SELECT * FROM tp_h PARTITION (p1);
19 --sorted_result
20 SELECT * FROM tp_h PARTITION (p2);
21
22 --error ER_ROW_DOES_NOT_MATCH_PARTITION
23 ALTER TABLE tp_h EXCHANGE PARTITION p0 WITH TABLE t_100 WITH VALIDATION;
24 ALTER TABLE tp_h EXCHANGE PARTITION p0 WITH TABLE t_100 WITHOUT VALIDATION;
25 --sorted_result
26 SELECT * FROM tp_h PARTITION (p0);
27 --sorted_result
28 SELECT * FROM tp_h PARTITION (p1);
29 --sorted_result
30 SELECT * FROM tp_h PARTITION (p2);
31
32 #--error ER_ROW_IN_WRONG_PARTITION
33 #ALTER TABLE tp_h REBUILD PARTITION p0;
34 ALTER TABLE tp_h COALESCE PARTITION 1;
35 --sorted_result
36 SELECT * FROM tp_h PARTITION (p0);
37 --sorted_result
38 SELECT * FROM tp_h PARTITION (p1);
39 ALTER TABLE tp_h ADD PARTITION PARTITIONS 4;
40 ALTER TABLE tp_h EXCHANGE PARTITION p2 WITH TABLE t_100 WITHOUT VALIDATION;
41 --sorted_result
42 SELECT * FROM tp_h PARTITION (p2);
43 ALTER TABLE tp_h ANALYZE PARTITION p0;
44 ALTER TABLE tp_h OPTIMIZE PARTITION p0;
45
46 CREATE TABLE t_11 LIKE t_10;
47 INSERT INTO t_11 SELECT * FROM t_10;
48 INSERT INTO t_11 SELECT * FROM t_100;
49 ALTER TABLE tp_h EXCHANGE PARTITION p0 WITH TABLE t_11 WITHOUT VALIDATION;
50 --sorted_result
51 SELECT * FROM tp_h PARTITION (p0);
52 DELETE FROM tp_h PARTITION (p1);
53 --sorted_result
54 SELECT * FROM tp_h PARTITION (p1);
55 ALTER TABLE tp_h CHECK PARTITION p0 ;
56 ALTER TABLE tp_h REPAIR PARTITION p0 ;
57 --sorted_result
58 SELECT * FROM tp_h PARTITION (p0);
59 --sorted_result
60 SELECT * FROM tp_h PARTITION (p1);
61 --sorted_result
62 SELECT * FROM tp_h PARTITION (p2);
63 ALTER TABLE tp_h COALESCE PARTITION 2;
64 --sorted_result
65 SELECT * FROM tp_h PARTITION (p0);
66 --sorted_result
67 SELECT * FROM tp_h PARTITION (p1);
68 --sorted_result
69 SELECT * FROM tp_h PARTITION (p2);
70 --sorted_result
71 SELECT * FROM tp_h PARTITION (p3);
72 DROP TABLE IF EXISTS t_11;
73
74 --source suite/parts/inc/part_exch_drop_ext_tabs.inc
75