85
85
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) (PARTITION p1 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
88
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
89
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
90
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
91
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
92
$MYSQLTEST_VARDIR/master-data/test/t1.frm
93
$MYSQLTEST_VARDIR/master-data/test/t1.par
94
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p1.MYD
95
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p2.MYD
96
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p1.MYI
97
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p2.MYI
99
99
# check prerequisites-1 success: 1
100
100
# check COUNT(*) success: 1
562
562
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1) (PARTITION p1 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p3 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p4 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p5 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
565
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
566
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
567
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
568
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
569
$MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYD
570
$MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYI
571
$MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYD
572
$MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYI
573
$MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYD
574
$MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYI
575
$MYSQLTEST_VARDIR/master-data/test/t1.frm
576
$MYSQLTEST_VARDIR/master-data/test/t1.par
577
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p1.MYD
578
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p2.MYD
579
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p3.MYD
580
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p4.MYD
581
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p5.MYD
582
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p1.MYI
583
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p2.MYI
584
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p3.MYI
585
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p4.MYI
586
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p5.MYI
588
588
# check prerequisites-1 success: 1
589
589
# check COUNT(*) success: 1
1052
1052
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1,4)) (PARTITION part_3 VALUES IN (-3) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part0 VALUES IN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part1 VALUES IN (1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part2 VALUES IN (2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part3 VALUES IN (3) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
1054
1054
unified filelist
1055
$MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYD
1056
$MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYI
1057
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYD
1058
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYI
1059
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYD
1060
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYI
1061
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYD
1062
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYI
1063
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYD
1064
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYI
1065
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYD
1066
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYI
1067
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYD
1068
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYI
1069
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYD
1070
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYI
1071
$MYSQLTEST_VARDIR/master-data/test/t1.frm
1072
$MYSQLTEST_VARDIR/master-data/test/t1.par
1073
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part0.MYD
1074
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1.MYD
1075
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2.MYD
1076
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3.MYD
1077
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_1.MYD
1078
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_2.MYD
1079
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_3.MYD
1080
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_N.MYD
1081
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part0.MYI
1082
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1.MYI
1083
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2.MYI
1084
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3.MYI
1085
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_1.MYI
1086
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_2.MYI
1087
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_3.MYI
1088
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_N.MYI
1090
1090
# check prerequisites-1 success: 1
1091
1091
# check COUNT(*) success: 1
1556
1556
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) (PARTITION parta VALUES LESS THAN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
1558
1558
unified filelist
1559
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYD
1560
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYI
1561
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYD
1562
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYI
1563
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYD
1564
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYI
1565
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYD
1566
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYI
1567
$MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYD
1568
$MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYI
1569
$MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYD
1570
$MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYI
1571
$MYSQLTEST_VARDIR/master-data/test/t1.frm
1572
$MYSQLTEST_VARDIR/master-data/test/t1.par
1573
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta.MYD
1574
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb.MYD
1575
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc.MYD
1576
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd.MYD
1577
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parte.MYD
1578
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partf.MYD
1579
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta.MYI
1580
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb.MYI
1581
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc.MYI
1582
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd.MYI
1583
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parte.MYI
1584
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partf.MYI
1586
1586
# check prerequisites-1 success: 1
1587
1587
# check COUNT(*) success: 1
2044
2044
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1 DIV 2) SUBPARTITION BY HASH (f_int1) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
2046
2046
unified filelist
2047
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYD
2048
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYI
2049
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYD
2050
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYI
2051
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYD
2052
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYI
2053
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYD
2054
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYI
2055
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYD
2056
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYI
2057
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYD
2058
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYI
2059
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYD
2060
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYI
2061
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYD
2062
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYI
2063
$MYSQLTEST_VARDIR/master-data/test/t1.frm
2064
$MYSQLTEST_VARDIR/master-data/test/t1.par
2065
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta#SP#partasp0.MYD
2066
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta#SP#partasp1.MYD
2067
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb#SP#partbsp0.MYD
2068
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb#SP#partbsp1.MYD
2069
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc#SP#partcsp0.MYD
2070
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc#SP#partcsp1.MYD
2071
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd#SP#partdsp0.MYD
2072
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd#SP#partdsp1.MYD
2073
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta#SP#partasp0.MYI
2074
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta#SP#partasp1.MYI
2075
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb#SP#partbsp0.MYI
2076
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb#SP#partbsp1.MYI
2077
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc#SP#partcsp0.MYI
2078
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc#SP#partcsp1.MYI
2079
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd#SP#partdsp0.MYI
2080
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd#SP#partdsp1.MYI
2047
t1#P#parta#SP#partasp0.MYD
2048
t1#P#parta#SP#partasp0.MYI
2049
t1#P#parta#SP#partasp1.MYD
2050
t1#P#parta#SP#partasp1.MYI
2051
t1#P#partb#SP#partbsp0.MYD
2052
t1#P#partb#SP#partbsp0.MYI
2053
t1#P#partb#SP#partbsp1.MYD
2054
t1#P#partb#SP#partbsp1.MYI
2055
t1#P#partc#SP#partcsp0.MYD
2056
t1#P#partc#SP#partcsp0.MYI
2057
t1#P#partc#SP#partcsp1.MYD
2058
t1#P#partc#SP#partcsp1.MYI
2059
t1#P#partd#SP#partdsp0.MYD
2060
t1#P#partd#SP#partdsp0.MYI
2061
t1#P#partd#SP#partdsp1.MYD
2062
t1#P#partd#SP#partdsp1.MYI
2065
t1#P#parta#SP#partasp0.MYD
2066
t1#P#parta#SP#partasp1.MYD
2067
t1#P#partb#SP#partbsp0.MYD
2068
t1#P#partb#SP#partbsp1.MYD
2069
t1#P#partc#SP#partcsp0.MYD
2070
t1#P#partc#SP#partcsp1.MYD
2071
t1#P#partd#SP#partdsp0.MYD
2072
t1#P#partd#SP#partdsp1.MYD
2073
t1#P#parta#SP#partasp0.MYI
2074
t1#P#parta#SP#partasp1.MYI
2075
t1#P#partb#SP#partbsp0.MYI
2076
t1#P#partb#SP#partbsp1.MYI
2077
t1#P#partc#SP#partcsp0.MYI
2078
t1#P#partc#SP#partcsp1.MYI
2079
t1#P#partd#SP#partdsp0.MYI
2080
t1#P#partd#SP#partdsp1.MYI
2082
2082
# check prerequisites-1 success: 1
2083
2083
# check COUNT(*) success: 1
2542
2542
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int1) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart12 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart22 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart32 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart42 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM)) */
2544
2544
unified filelist
2545
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYD
2546
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYI
2547
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYD
2548
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYI
2549
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYD
2550
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYI
2551
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYD
2552
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYI
2553
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYD
2554
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYI
2555
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYD
2556
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYI
2557
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYD
2558
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYI
2559
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYD
2560
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYI
2561
$MYSQLTEST_VARDIR/master-data/test/t1.frm
2562
$MYSQLTEST_VARDIR/master-data/test/t1.par
2563
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#subpart11.MYD
2564
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#subpart12.MYD
2565
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#subpart21.MYD
2566
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#subpart22.MYD
2567
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#subpart31.MYD
2568
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#subpart32.MYD
2569
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#subpart41.MYD
2570
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#subpart42.MYD
2571
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#subpart11.MYI
2572
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#subpart12.MYI
2573
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#subpart21.MYI
2574
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#subpart22.MYI
2575
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#subpart31.MYI
2576
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#subpart32.MYI
2577
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#subpart41.MYI
2578
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#subpart42.MYI
2545
t1#P#part1#SP#subpart11.MYD
2546
t1#P#part1#SP#subpart11.MYI
2547
t1#P#part1#SP#subpart12.MYD
2548
t1#P#part1#SP#subpart12.MYI
2549
t1#P#part2#SP#subpart21.MYD
2550
t1#P#part2#SP#subpart21.MYI
2551
t1#P#part2#SP#subpart22.MYD
2552
t1#P#part2#SP#subpart22.MYI
2553
t1#P#part3#SP#subpart31.MYD
2554
t1#P#part3#SP#subpart31.MYI
2555
t1#P#part3#SP#subpart32.MYD
2556
t1#P#part3#SP#subpart32.MYI
2557
t1#P#part4#SP#subpart41.MYD
2558
t1#P#part4#SP#subpart41.MYI
2559
t1#P#part4#SP#subpart42.MYD
2560
t1#P#part4#SP#subpart42.MYI
2563
t1#P#part1#SP#subpart11.MYD
2564
t1#P#part1#SP#subpart12.MYD
2565
t1#P#part2#SP#subpart21.MYD
2566
t1#P#part2#SP#subpart22.MYD
2567
t1#P#part3#SP#subpart31.MYD
2568
t1#P#part3#SP#subpart32.MYD
2569
t1#P#part4#SP#subpart41.MYD
2570
t1#P#part4#SP#subpart42.MYD
2571
t1#P#part1#SP#subpart11.MYI
2572
t1#P#part1#SP#subpart12.MYI
2573
t1#P#part2#SP#subpart21.MYI
2574
t1#P#part2#SP#subpart22.MYI
2575
t1#P#part3#SP#subpart31.MYI
2576
t1#P#part3#SP#subpart32.MYI
2577
t1#P#part4#SP#subpart41.MYI
2578
t1#P#part4#SP#subpart42.MYI
2580
2580
# check prerequisites-1 success: 1
2581
2581
# check COUNT(*) success: 1
3058
3058
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int1 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp12 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp22 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp32 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp42 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM)) */
3060
3060
unified filelist
3061
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYD
3062
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYI
3063
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYD
3064
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYI
3065
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYD
3066
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYI
3067
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYD
3068
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYI
3069
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYD
3070
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYI
3071
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYD
3072
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYI
3073
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYD
3074
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYI
3075
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYD
3076
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYI
3077
$MYSQLTEST_VARDIR/master-data/test/t1.frm
3078
$MYSQLTEST_VARDIR/master-data/test/t1.par
3079
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#sp11.MYD
3080
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#sp12.MYD
3081
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#sp21.MYD
3082
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#sp22.MYD
3083
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#sp31.MYD
3084
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#sp32.MYD
3085
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#sp41.MYD
3086
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#sp42.MYD
3087
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#sp11.MYI
3088
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#sp12.MYI
3089
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#sp21.MYI
3090
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#sp22.MYI
3091
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#sp31.MYI
3092
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#sp32.MYI
3093
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#sp41.MYI
3094
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#sp42.MYI
3061
t1#P#part1#SP#sp11.MYD
3062
t1#P#part1#SP#sp11.MYI
3063
t1#P#part1#SP#sp12.MYD
3064
t1#P#part1#SP#sp12.MYI
3065
t1#P#part2#SP#sp21.MYD
3066
t1#P#part2#SP#sp21.MYI
3067
t1#P#part2#SP#sp22.MYD
3068
t1#P#part2#SP#sp22.MYI
3069
t1#P#part3#SP#sp31.MYD
3070
t1#P#part3#SP#sp31.MYI
3071
t1#P#part3#SP#sp32.MYD
3072
t1#P#part3#SP#sp32.MYI
3073
t1#P#part4#SP#sp41.MYD
3074
t1#P#part4#SP#sp41.MYI
3075
t1#P#part4#SP#sp42.MYD
3076
t1#P#part4#SP#sp42.MYI
3079
t1#P#part1#SP#sp11.MYD
3080
t1#P#part1#SP#sp12.MYD
3081
t1#P#part2#SP#sp21.MYD
3082
t1#P#part2#SP#sp22.MYD
3083
t1#P#part3#SP#sp31.MYD
3084
t1#P#part3#SP#sp32.MYD
3085
t1#P#part4#SP#sp41.MYD
3086
t1#P#part4#SP#sp42.MYD
3087
t1#P#part1#SP#sp11.MYI
3088
t1#P#part1#SP#sp12.MYI
3089
t1#P#part2#SP#sp21.MYI
3090
t1#P#part2#SP#sp22.MYI
3091
t1#P#part3#SP#sp31.MYI
3092
t1#P#part3#SP#sp32.MYI
3093
t1#P#part4#SP#sp41.MYI
3094
t1#P#part4#SP#sp42.MYI
3096
3096
# check prerequisites-1 success: 1
3097
3097
# check COUNT(*) success: 1
3554
3554
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int1) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part2 VALUES IN (1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
3556
3556
unified filelist
3557
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYD
3558
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYI
3559
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYD
3560
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYI
3561
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYD
3562
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYI
3563
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYD
3564
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYI
3565
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYD
3566
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYI
3567
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYD
3568
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYI
3569
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYD
3570
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYI
3571
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYD
3572
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYI
3573
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYD
3574
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYI
3575
$MYSQLTEST_VARDIR/master-data/test/t1.frm
3576
$MYSQLTEST_VARDIR/master-data/test/t1.par
3577
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp0.MYD
3578
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp1.MYD
3579
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp2.MYD
3580
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp0.MYD
3581
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp1.MYD
3582
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp2.MYD
3583
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp0.MYD
3584
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp1.MYD
3585
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp2.MYD
3586
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp0.MYI
3587
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp1.MYI
3588
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp2.MYI
3589
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp0.MYI
3590
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp1.MYI
3591
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp2.MYI
3592
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp0.MYI
3593
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp1.MYI
3594
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp2.MYI
3557
t1#P#part1#SP#part1sp0.MYD
3558
t1#P#part1#SP#part1sp0.MYI
3559
t1#P#part1#SP#part1sp1.MYD
3560
t1#P#part1#SP#part1sp1.MYI
3561
t1#P#part1#SP#part1sp2.MYD
3562
t1#P#part1#SP#part1sp2.MYI
3563
t1#P#part2#SP#part2sp0.MYD
3564
t1#P#part2#SP#part2sp0.MYI
3565
t1#P#part2#SP#part2sp1.MYD
3566
t1#P#part2#SP#part2sp1.MYI
3567
t1#P#part2#SP#part2sp2.MYD
3568
t1#P#part2#SP#part2sp2.MYI
3569
t1#P#part3#SP#part3sp0.MYD
3570
t1#P#part3#SP#part3sp0.MYI
3571
t1#P#part3#SP#part3sp1.MYD
3572
t1#P#part3#SP#part3sp1.MYI
3573
t1#P#part3#SP#part3sp2.MYD
3574
t1#P#part3#SP#part3sp2.MYI
3577
t1#P#part1#SP#part1sp0.MYD
3578
t1#P#part1#SP#part1sp1.MYD
3579
t1#P#part1#SP#part1sp2.MYD
3580
t1#P#part2#SP#part2sp0.MYD
3581
t1#P#part2#SP#part2sp1.MYD
3582
t1#P#part2#SP#part2sp2.MYD
3583
t1#P#part3#SP#part3sp0.MYD
3584
t1#P#part3#SP#part3sp1.MYD
3585
t1#P#part3#SP#part3sp2.MYD
3586
t1#P#part1#SP#part1sp0.MYI
3587
t1#P#part1#SP#part1sp1.MYI
3588
t1#P#part1#SP#part1sp2.MYI
3589
t1#P#part2#SP#part2sp0.MYI
3590
t1#P#part2#SP#part2sp1.MYI
3591
t1#P#part2#SP#part2sp2.MYI
3592
t1#P#part3#SP#part3sp0.MYI
3593
t1#P#part3#SP#part3sp1.MYI
3594
t1#P#part3#SP#part3sp2.MYI
3596
3596
# check prerequisites-1 success: 1
3597
3597
# check COUNT(*) success: 1
4052
4052
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1 + f_int2) (PARTITION p1 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
4054
4054
unified filelist
4055
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
4056
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
4057
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
4058
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
4059
$MYSQLTEST_VARDIR/master-data/test/t1.frm
4060
$MYSQLTEST_VARDIR/master-data/test/t1.par
4061
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p1.MYD
4062
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p2.MYD
4063
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p1.MYI
4064
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p2.MYI
4066
4066
# check prerequisites-1 success: 1
4067
4067
# check COUNT(*) success: 1
4529
4529
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1,f_int2) (PARTITION p1 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p3 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p4 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p5 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
4531
4531
unified filelist
4532
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
4533
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
4534
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
4535
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
4536
$MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYD
4537
$MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYI
4538
$MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYD
4539
$MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYI
4540
$MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYD
4541
$MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYI
4542
$MYSQLTEST_VARDIR/master-data/test/t1.frm
4543
$MYSQLTEST_VARDIR/master-data/test/t1.par
4544
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p1.MYD
4545
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p2.MYD
4546
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p3.MYD
4547
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p4.MYD
4548
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p5.MYD
4549
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p1.MYI
4550
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p2.MYI
4551
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p3.MYI
4552
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p4.MYI
4553
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p5.MYI
4555
4555
# check prerequisites-1 success: 1
4556
4556
# check COUNT(*) success: 1
5019
5019
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4)) (PARTITION part_3 VALUES IN (-3) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part0 VALUES IN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part1 VALUES IN (1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part2 VALUES IN (2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part3 VALUES IN (3) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
5021
5021
unified filelist
5022
$MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYD
5023
$MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYI
5024
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYD
5025
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYI
5026
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYD
5027
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYI
5028
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYD
5029
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYI
5030
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYD
5031
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYI
5032
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYD
5033
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYI
5034
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYD
5035
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYI
5036
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYD
5037
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYI
5038
$MYSQLTEST_VARDIR/master-data/test/t1.frm
5039
$MYSQLTEST_VARDIR/master-data/test/t1.par
5040
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part0.MYD
5041
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1.MYD
5042
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2.MYD
5043
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3.MYD
5044
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_1.MYD
5045
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_2.MYD
5046
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_3.MYD
5047
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_N.MYD
5048
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part0.MYI
5049
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1.MYI
5050
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2.MYI
5051
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3.MYI
5052
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_1.MYI
5053
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_2.MYI
5054
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_3.MYI
5055
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_N.MYI
5057
5057
# check prerequisites-1 success: 1
5058
5058
# check COUNT(*) success: 1
5523
5523
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) (PARTITION parta VALUES LESS THAN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
5525
5525
unified filelist
5526
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYD
5527
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYI
5528
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYD
5529
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYI
5530
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYD
5531
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYI
5532
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYD
5533
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYI
5534
$MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYD
5535
$MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYI
5536
$MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYD
5537
$MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYI
5538
$MYSQLTEST_VARDIR/master-data/test/t1.frm
5539
$MYSQLTEST_VARDIR/master-data/test/t1.par
5540
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta.MYD
5541
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb.MYD
5542
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc.MYD
5543
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd.MYD
5544
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parte.MYD
5545
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partf.MYD
5546
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta.MYI
5547
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb.MYI
5548
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc.MYI
5549
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd.MYI
5550
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parte.MYI
5551
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partf.MYI
5553
5553
# check prerequisites-1 success: 1
5554
5554
# check COUNT(*) success: 1
6011
6011
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY HASH (f_int2) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
6013
6013
unified filelist
6014
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYD
6015
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYI
6016
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYD
6017
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYI
6018
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYD
6019
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYI
6020
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYD
6021
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYI
6022
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYD
6023
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYI
6024
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYD
6025
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYI
6026
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYD
6027
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYI
6028
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYD
6029
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYI
6030
$MYSQLTEST_VARDIR/master-data/test/t1.frm
6031
$MYSQLTEST_VARDIR/master-data/test/t1.par
6032
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta#SP#partasp0.MYD
6033
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta#SP#partasp1.MYD
6034
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb#SP#partbsp0.MYD
6035
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb#SP#partbsp1.MYD
6036
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc#SP#partcsp0.MYD
6037
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc#SP#partcsp1.MYD
6038
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd#SP#partdsp0.MYD
6039
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd#SP#partdsp1.MYD
6040
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta#SP#partasp0.MYI
6041
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta#SP#partasp1.MYI
6042
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb#SP#partbsp0.MYI
6043
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb#SP#partbsp1.MYI
6044
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc#SP#partcsp0.MYI
6045
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc#SP#partcsp1.MYI
6046
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd#SP#partdsp0.MYI
6047
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd#SP#partdsp1.MYI
6014
t1#P#parta#SP#partasp0.MYD
6015
t1#P#parta#SP#partasp0.MYI
6016
t1#P#parta#SP#partasp1.MYD
6017
t1#P#parta#SP#partasp1.MYI
6018
t1#P#partb#SP#partbsp0.MYD
6019
t1#P#partb#SP#partbsp0.MYI
6020
t1#P#partb#SP#partbsp1.MYD
6021
t1#P#partb#SP#partbsp1.MYI
6022
t1#P#partc#SP#partcsp0.MYD
6023
t1#P#partc#SP#partcsp0.MYI
6024
t1#P#partc#SP#partcsp1.MYD
6025
t1#P#partc#SP#partcsp1.MYI
6026
t1#P#partd#SP#partdsp0.MYD
6027
t1#P#partd#SP#partdsp0.MYI
6028
t1#P#partd#SP#partdsp1.MYD
6029
t1#P#partd#SP#partdsp1.MYI
6032
t1#P#parta#SP#partasp0.MYD
6033
t1#P#parta#SP#partasp1.MYD
6034
t1#P#partb#SP#partbsp0.MYD
6035
t1#P#partb#SP#partbsp1.MYD
6036
t1#P#partc#SP#partcsp0.MYD
6037
t1#P#partc#SP#partcsp1.MYD
6038
t1#P#partd#SP#partdsp0.MYD
6039
t1#P#partd#SP#partdsp1.MYD
6040
t1#P#parta#SP#partasp0.MYI
6041
t1#P#parta#SP#partasp1.MYI
6042
t1#P#partb#SP#partbsp0.MYI
6043
t1#P#partb#SP#partbsp1.MYI
6044
t1#P#partc#SP#partcsp0.MYI
6045
t1#P#partc#SP#partcsp1.MYI
6046
t1#P#partd#SP#partdsp0.MYI
6047
t1#P#partd#SP#partdsp1.MYI
6049
6049
# check prerequisites-1 success: 1
6050
6050
# check COUNT(*) success: 1
6507
6507
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int2) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart12 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart22 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart32 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart42 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM)) */
6509
6509
unified filelist
6510
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYD
6511
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYI
6512
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYD
6513
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYI
6514
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYD
6515
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYI
6516
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYD
6517
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYI
6518
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYD
6519
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYI
6520
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYD
6521
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYI
6522
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYD
6523
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYI
6524
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYD
6525
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYI
6526
$MYSQLTEST_VARDIR/master-data/test/t1.frm
6527
$MYSQLTEST_VARDIR/master-data/test/t1.par
6528
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#subpart11.MYD
6529
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#subpart12.MYD
6530
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#subpart21.MYD
6531
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#subpart22.MYD
6532
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#subpart31.MYD
6533
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#subpart32.MYD
6534
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#subpart41.MYD
6535
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#subpart42.MYD
6536
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#subpart11.MYI
6537
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#subpart12.MYI
6538
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#subpart21.MYI
6539
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#subpart22.MYI
6540
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#subpart31.MYI
6541
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#subpart32.MYI
6542
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#subpart41.MYI
6543
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#subpart42.MYI
6510
t1#P#part1#SP#subpart11.MYD
6511
t1#P#part1#SP#subpart11.MYI
6512
t1#P#part1#SP#subpart12.MYD
6513
t1#P#part1#SP#subpart12.MYI
6514
t1#P#part2#SP#subpart21.MYD
6515
t1#P#part2#SP#subpart21.MYI
6516
t1#P#part2#SP#subpart22.MYD
6517
t1#P#part2#SP#subpart22.MYI
6518
t1#P#part3#SP#subpart31.MYD
6519
t1#P#part3#SP#subpart31.MYI
6520
t1#P#part3#SP#subpart32.MYD
6521
t1#P#part3#SP#subpart32.MYI
6522
t1#P#part4#SP#subpart41.MYD
6523
t1#P#part4#SP#subpart41.MYI
6524
t1#P#part4#SP#subpart42.MYD
6525
t1#P#part4#SP#subpart42.MYI
6528
t1#P#part1#SP#subpart11.MYD
6529
t1#P#part1#SP#subpart12.MYD
6530
t1#P#part2#SP#subpart21.MYD
6531
t1#P#part2#SP#subpart22.MYD
6532
t1#P#part3#SP#subpart31.MYD
6533
t1#P#part3#SP#subpart32.MYD
6534
t1#P#part4#SP#subpart41.MYD
6535
t1#P#part4#SP#subpart42.MYD
6536
t1#P#part1#SP#subpart11.MYI
6537
t1#P#part1#SP#subpart12.MYI
6538
t1#P#part2#SP#subpart21.MYI
6539
t1#P#part2#SP#subpart22.MYI
6540
t1#P#part3#SP#subpart31.MYI
6541
t1#P#part3#SP#subpart32.MYI
6542
t1#P#part4#SP#subpart41.MYI
6543
t1#P#part4#SP#subpart42.MYI
6545
6545
# check prerequisites-1 success: 1
6546
6546
# check COUNT(*) success: 1
7023
7023
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int2 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp12 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp22 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp32 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp42 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM)) */
7025
7025
unified filelist
7026
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYD
7027
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYI
7028
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYD
7029
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYI
7030
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYD
7031
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYI
7032
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYD
7033
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYI
7034
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYD
7035
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYI
7036
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYD
7037
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYI
7038
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYD
7039
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYI
7040
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYD
7041
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYI
7042
$MYSQLTEST_VARDIR/master-data/test/t1.frm
7043
$MYSQLTEST_VARDIR/master-data/test/t1.par
7044
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#sp11.MYD
7045
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#sp12.MYD
7046
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#sp21.MYD
7047
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#sp22.MYD
7048
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#sp31.MYD
7049
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#sp32.MYD
7050
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#sp41.MYD
7051
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#sp42.MYD
7052
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#sp11.MYI
7053
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#sp12.MYI
7054
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#sp21.MYI
7055
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#sp22.MYI
7056
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#sp31.MYI
7057
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#sp32.MYI
7058
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#sp41.MYI
7059
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#sp42.MYI
7026
t1#P#part1#SP#sp11.MYD
7027
t1#P#part1#SP#sp11.MYI
7028
t1#P#part1#SP#sp12.MYD
7029
t1#P#part1#SP#sp12.MYI
7030
t1#P#part2#SP#sp21.MYD
7031
t1#P#part2#SP#sp21.MYI
7032
t1#P#part2#SP#sp22.MYD
7033
t1#P#part2#SP#sp22.MYI
7034
t1#P#part3#SP#sp31.MYD
7035
t1#P#part3#SP#sp31.MYI
7036
t1#P#part3#SP#sp32.MYD
7037
t1#P#part3#SP#sp32.MYI
7038
t1#P#part4#SP#sp41.MYD
7039
t1#P#part4#SP#sp41.MYI
7040
t1#P#part4#SP#sp42.MYD
7041
t1#P#part4#SP#sp42.MYI
7044
t1#P#part1#SP#sp11.MYD
7045
t1#P#part1#SP#sp12.MYD
7046
t1#P#part2#SP#sp21.MYD
7047
t1#P#part2#SP#sp22.MYD
7048
t1#P#part3#SP#sp31.MYD
7049
t1#P#part3#SP#sp32.MYD
7050
t1#P#part4#SP#sp41.MYD
7051
t1#P#part4#SP#sp42.MYD
7052
t1#P#part1#SP#sp11.MYI
7053
t1#P#part1#SP#sp12.MYI
7054
t1#P#part2#SP#sp21.MYI
7055
t1#P#part2#SP#sp22.MYI
7056
t1#P#part3#SP#sp31.MYI
7057
t1#P#part3#SP#sp32.MYI
7058
t1#P#part4#SP#sp41.MYI
7059
t1#P#part4#SP#sp42.MYI
7061
7061
# check prerequisites-1 success: 1
7062
7062
# check COUNT(*) success: 1
7519
7519
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int2) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part2 VALUES IN (1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
7521
7521
unified filelist
7522
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYD
7523
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYI
7524
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYD
7525
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYI
7526
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYD
7527
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYI
7528
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYD
7529
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYI
7530
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYD
7531
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYI
7532
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYD
7533
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYI
7534
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYD
7535
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYI
7536
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYD
7537
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYI
7538
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYD
7539
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYI
7540
$MYSQLTEST_VARDIR/master-data/test/t1.frm
7541
$MYSQLTEST_VARDIR/master-data/test/t1.par
7542
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp0.MYD
7543
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp1.MYD
7544
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp2.MYD
7545
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp0.MYD
7546
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp1.MYD
7547
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp2.MYD
7548
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp0.MYD
7549
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp1.MYD
7550
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp2.MYD
7551
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp0.MYI
7552
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp1.MYI
7553
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp2.MYI
7554
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp0.MYI
7555
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp1.MYI
7556
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp2.MYI
7557
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp0.MYI
7558
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp1.MYI
7559
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp2.MYI
7522
t1#P#part1#SP#part1sp0.MYD
7523
t1#P#part1#SP#part1sp0.MYI
7524
t1#P#part1#SP#part1sp1.MYD
7525
t1#P#part1#SP#part1sp1.MYI
7526
t1#P#part1#SP#part1sp2.MYD
7527
t1#P#part1#SP#part1sp2.MYI
7528
t1#P#part2#SP#part2sp0.MYD
7529
t1#P#part2#SP#part2sp0.MYI
7530
t1#P#part2#SP#part2sp1.MYD
7531
t1#P#part2#SP#part2sp1.MYI
7532
t1#P#part2#SP#part2sp2.MYD
7533
t1#P#part2#SP#part2sp2.MYI
7534
t1#P#part3#SP#part3sp0.MYD
7535
t1#P#part3#SP#part3sp0.MYI
7536
t1#P#part3#SP#part3sp1.MYD
7537
t1#P#part3#SP#part3sp1.MYI
7538
t1#P#part3#SP#part3sp2.MYD
7539
t1#P#part3#SP#part3sp2.MYI
7542
t1#P#part1#SP#part1sp0.MYD
7543
t1#P#part1#SP#part1sp1.MYD
7544
t1#P#part1#SP#part1sp2.MYD
7545
t1#P#part2#SP#part2sp0.MYD
7546
t1#P#part2#SP#part2sp1.MYD
7547
t1#P#part2#SP#part2sp2.MYD
7548
t1#P#part3#SP#part3sp0.MYD
7549
t1#P#part3#SP#part3sp1.MYD
7550
t1#P#part3#SP#part3sp2.MYD
7551
t1#P#part1#SP#part1sp0.MYI
7552
t1#P#part1#SP#part1sp1.MYI
7553
t1#P#part1#SP#part1sp2.MYI
7554
t1#P#part2#SP#part2sp0.MYI
7555
t1#P#part2#SP#part2sp1.MYI
7556
t1#P#part2#SP#part2sp2.MYI
7557
t1#P#part3#SP#part3sp0.MYI
7558
t1#P#part3#SP#part3sp1.MYI
7559
t1#P#part3#SP#part3sp2.MYI
7561
7561
# check prerequisites-1 success: 1
7562
7562
# check COUNT(*) success: 1
8023
8023
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) (PARTITION p1 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
8025
8025
unified filelist
8026
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
8027
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
8028
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
8029
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
8030
$MYSQLTEST_VARDIR/master-data/test/t1.frm
8031
$MYSQLTEST_VARDIR/master-data/test/t1.par
8032
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p1.MYD
8033
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p2.MYD
8034
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p1.MYI
8035
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p2.MYI
8037
8037
# check prerequisites-1 success: 1
8038
8038
# check COUNT(*) success: 1
8553
8553
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1) (PARTITION p1 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p3 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p4 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p5 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
8555
8555
unified filelist
8556
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
8557
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
8558
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
8559
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
8560
$MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYD
8561
$MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYI
8562
$MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYD
8563
$MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYI
8564
$MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYD
8565
$MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYI
8566
$MYSQLTEST_VARDIR/master-data/test/t1.frm
8567
$MYSQLTEST_VARDIR/master-data/test/t1.par
8568
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p1.MYD
8569
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p2.MYD
8570
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p3.MYD
8571
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p4.MYD
8572
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p5.MYD
8573
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p1.MYI
8574
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p2.MYI
8575
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p3.MYI
8576
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p4.MYI
8577
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p5.MYI
8579
8579
# check prerequisites-1 success: 1
8580
8580
# check COUNT(*) success: 1
9096
9096
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1,4)) (PARTITION part_3 VALUES IN (-3) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part0 VALUES IN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part1 VALUES IN (1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part2 VALUES IN (2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part3 VALUES IN (3) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
9098
9098
unified filelist
9099
$MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYD
9100
$MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYI
9101
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYD
9102
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYI
9103
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYD
9104
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYI
9105
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYD
9106
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYI
9107
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYD
9108
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYI
9109
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYD
9110
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYI
9111
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYD
9112
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYI
9113
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYD
9114
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYI
9115
$MYSQLTEST_VARDIR/master-data/test/t1.frm
9116
$MYSQLTEST_VARDIR/master-data/test/t1.par
9117
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part0.MYD
9118
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1.MYD
9119
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2.MYD
9120
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3.MYD
9121
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_1.MYD
9122
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_2.MYD
9123
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_3.MYD
9124
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_N.MYD
9125
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part0.MYI
9126
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1.MYI
9127
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2.MYI
9128
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3.MYI
9129
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_1.MYI
9130
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_2.MYI
9131
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_3.MYI
9132
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_N.MYI
9134
9134
# check prerequisites-1 success: 1
9135
9135
# check COUNT(*) success: 1
9653
9653
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) (PARTITION parta VALUES LESS THAN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
9655
9655
unified filelist
9656
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYD
9657
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYI
9658
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYD
9659
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYI
9660
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYD
9661
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYI
9662
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYD
9663
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYI
9664
$MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYD
9665
$MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYI
9666
$MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYD
9667
$MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYI
9668
$MYSQLTEST_VARDIR/master-data/test/t1.frm
9669
$MYSQLTEST_VARDIR/master-data/test/t1.par
9670
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta.MYD
9671
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb.MYD
9672
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc.MYD
9673
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd.MYD
9674
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parte.MYD
9675
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partf.MYD
9676
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta.MYI
9677
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb.MYI
9678
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc.MYI
9679
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd.MYI
9680
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parte.MYI
9681
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partf.MYI
9683
9683
# check prerequisites-1 success: 1
9684
9684
# check COUNT(*) success: 1
10194
10194
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1 DIV 2) SUBPARTITION BY HASH (f_int1) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
10196
10196
unified filelist
10197
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYD
10198
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYI
10199
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYD
10200
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYI
10201
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYD
10202
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYI
10203
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYD
10204
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYI
10205
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYD
10206
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYI
10207
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYD
10208
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYI
10209
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYD
10210
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYI
10211
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYD
10212
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYI
10213
$MYSQLTEST_VARDIR/master-data/test/t1.frm
10214
$MYSQLTEST_VARDIR/master-data/test/t1.par
10215
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta#SP#partasp0.MYD
10216
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta#SP#partasp1.MYD
10217
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb#SP#partbsp0.MYD
10218
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb#SP#partbsp1.MYD
10219
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc#SP#partcsp0.MYD
10220
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc#SP#partcsp1.MYD
10221
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd#SP#partdsp0.MYD
10222
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd#SP#partdsp1.MYD
10223
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta#SP#partasp0.MYI
10224
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta#SP#partasp1.MYI
10225
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb#SP#partbsp0.MYI
10226
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb#SP#partbsp1.MYI
10227
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc#SP#partcsp0.MYI
10228
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc#SP#partcsp1.MYI
10229
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd#SP#partdsp0.MYI
10230
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd#SP#partdsp1.MYI
10197
t1#P#parta#SP#partasp0.MYD
10198
t1#P#parta#SP#partasp0.MYI
10199
t1#P#parta#SP#partasp1.MYD
10200
t1#P#parta#SP#partasp1.MYI
10201
t1#P#partb#SP#partbsp0.MYD
10202
t1#P#partb#SP#partbsp0.MYI
10203
t1#P#partb#SP#partbsp1.MYD
10204
t1#P#partb#SP#partbsp1.MYI
10205
t1#P#partc#SP#partcsp0.MYD
10206
t1#P#partc#SP#partcsp0.MYI
10207
t1#P#partc#SP#partcsp1.MYD
10208
t1#P#partc#SP#partcsp1.MYI
10209
t1#P#partd#SP#partdsp0.MYD
10210
t1#P#partd#SP#partdsp0.MYI
10211
t1#P#partd#SP#partdsp1.MYD
10212
t1#P#partd#SP#partdsp1.MYI
10215
t1#P#parta#SP#partasp0.MYD
10216
t1#P#parta#SP#partasp1.MYD
10217
t1#P#partb#SP#partbsp0.MYD
10218
t1#P#partb#SP#partbsp1.MYD
10219
t1#P#partc#SP#partcsp0.MYD
10220
t1#P#partc#SP#partcsp1.MYD
10221
t1#P#partd#SP#partdsp0.MYD
10222
t1#P#partd#SP#partdsp1.MYD
10223
t1#P#parta#SP#partasp0.MYI
10224
t1#P#parta#SP#partasp1.MYI
10225
t1#P#partb#SP#partbsp0.MYI
10226
t1#P#partb#SP#partbsp1.MYI
10227
t1#P#partc#SP#partcsp0.MYI
10228
t1#P#partc#SP#partcsp1.MYI
10229
t1#P#partd#SP#partdsp0.MYI
10230
t1#P#partd#SP#partdsp1.MYI
10232
10232
# check prerequisites-1 success: 1
10233
10233
# check COUNT(*) success: 1
10745
10745
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int1) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart12 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart22 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart32 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart42 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM)) */
10747
10747
unified filelist
10748
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYD
10749
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYI
10750
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYD
10751
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYI
10752
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYD
10753
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYI
10754
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYD
10755
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYI
10756
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYD
10757
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYI
10758
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYD
10759
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYI
10760
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYD
10761
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYI
10762
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYD
10763
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYI
10764
$MYSQLTEST_VARDIR/master-data/test/t1.frm
10765
$MYSQLTEST_VARDIR/master-data/test/t1.par
10766
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#subpart11.MYD
10767
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#subpart12.MYD
10768
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#subpart21.MYD
10769
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#subpart22.MYD
10770
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#subpart31.MYD
10771
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#subpart32.MYD
10772
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#subpart41.MYD
10773
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#subpart42.MYD
10774
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#subpart11.MYI
10775
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#subpart12.MYI
10776
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#subpart21.MYI
10777
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#subpart22.MYI
10778
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#subpart31.MYI
10779
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#subpart32.MYI
10780
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#subpart41.MYI
10781
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#subpart42.MYI
10748
t1#P#part1#SP#subpart11.MYD
10749
t1#P#part1#SP#subpart11.MYI
10750
t1#P#part1#SP#subpart12.MYD
10751
t1#P#part1#SP#subpart12.MYI
10752
t1#P#part2#SP#subpart21.MYD
10753
t1#P#part2#SP#subpart21.MYI
10754
t1#P#part2#SP#subpart22.MYD
10755
t1#P#part2#SP#subpart22.MYI
10756
t1#P#part3#SP#subpart31.MYD
10757
t1#P#part3#SP#subpart31.MYI
10758
t1#P#part3#SP#subpart32.MYD
10759
t1#P#part3#SP#subpart32.MYI
10760
t1#P#part4#SP#subpart41.MYD
10761
t1#P#part4#SP#subpart41.MYI
10762
t1#P#part4#SP#subpart42.MYD
10763
t1#P#part4#SP#subpart42.MYI
10766
t1#P#part1#SP#subpart11.MYD
10767
t1#P#part1#SP#subpart12.MYD
10768
t1#P#part2#SP#subpart21.MYD
10769
t1#P#part2#SP#subpart22.MYD
10770
t1#P#part3#SP#subpart31.MYD
10771
t1#P#part3#SP#subpart32.MYD
10772
t1#P#part4#SP#subpart41.MYD
10773
t1#P#part4#SP#subpart42.MYD
10774
t1#P#part1#SP#subpart11.MYI
10775
t1#P#part1#SP#subpart12.MYI
10776
t1#P#part2#SP#subpart21.MYI
10777
t1#P#part2#SP#subpart22.MYI
10778
t1#P#part3#SP#subpart31.MYI
10779
t1#P#part3#SP#subpart32.MYI
10780
t1#P#part4#SP#subpart41.MYI
10781
t1#P#part4#SP#subpart42.MYI
10783
10783
# check prerequisites-1 success: 1
10784
10784
# check COUNT(*) success: 1
11314
11314
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int1 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp12 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp22 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp32 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp42 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM)) */
11316
11316
unified filelist
11317
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYD
11318
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYI
11319
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYD
11320
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYI
11321
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYD
11322
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYI
11323
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYD
11324
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYI
11325
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYD
11326
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYI
11327
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYD
11328
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYI
11329
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYD
11330
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYI
11331
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYD
11332
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYI
11333
$MYSQLTEST_VARDIR/master-data/test/t1.frm
11334
$MYSQLTEST_VARDIR/master-data/test/t1.par
11335
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#sp11.MYD
11336
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#sp12.MYD
11337
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#sp21.MYD
11338
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#sp22.MYD
11339
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#sp31.MYD
11340
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#sp32.MYD
11341
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#sp41.MYD
11342
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#sp42.MYD
11343
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#sp11.MYI
11344
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#sp12.MYI
11345
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#sp21.MYI
11346
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#sp22.MYI
11347
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#sp31.MYI
11348
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#sp32.MYI
11349
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#sp41.MYI
11350
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#sp42.MYI
11317
t1#P#part1#SP#sp11.MYD
11318
t1#P#part1#SP#sp11.MYI
11319
t1#P#part1#SP#sp12.MYD
11320
t1#P#part1#SP#sp12.MYI
11321
t1#P#part2#SP#sp21.MYD
11322
t1#P#part2#SP#sp21.MYI
11323
t1#P#part2#SP#sp22.MYD
11324
t1#P#part2#SP#sp22.MYI
11325
t1#P#part3#SP#sp31.MYD
11326
t1#P#part3#SP#sp31.MYI
11327
t1#P#part3#SP#sp32.MYD
11328
t1#P#part3#SP#sp32.MYI
11329
t1#P#part4#SP#sp41.MYD
11330
t1#P#part4#SP#sp41.MYI
11331
t1#P#part4#SP#sp42.MYD
11332
t1#P#part4#SP#sp42.MYI
11335
t1#P#part1#SP#sp11.MYD
11336
t1#P#part1#SP#sp12.MYD
11337
t1#P#part2#SP#sp21.MYD
11338
t1#P#part2#SP#sp22.MYD
11339
t1#P#part3#SP#sp31.MYD
11340
t1#P#part3#SP#sp32.MYD
11341
t1#P#part4#SP#sp41.MYD
11342
t1#P#part4#SP#sp42.MYD
11343
t1#P#part1#SP#sp11.MYI
11344
t1#P#part1#SP#sp12.MYI
11345
t1#P#part2#SP#sp21.MYI
11346
t1#P#part2#SP#sp22.MYI
11347
t1#P#part3#SP#sp31.MYI
11348
t1#P#part3#SP#sp32.MYI
11349
t1#P#part4#SP#sp41.MYI
11350
t1#P#part4#SP#sp42.MYI
11352
11352
# check prerequisites-1 success: 1
11353
11353
# check COUNT(*) success: 1
11863
11863
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int1) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part2 VALUES IN (1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
11865
11865
unified filelist
11866
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYD
11867
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYI
11868
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYD
11869
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYI
11870
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYD
11871
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYI
11872
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYD
11873
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYI
11874
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYD
11875
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYI
11876
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYD
11877
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYI
11878
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYD
11879
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYI
11880
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYD
11881
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYI
11882
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYD
11883
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYI
11884
$MYSQLTEST_VARDIR/master-data/test/t1.frm
11885
$MYSQLTEST_VARDIR/master-data/test/t1.par
11886
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp0.MYD
11887
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp1.MYD
11888
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp2.MYD
11889
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp0.MYD
11890
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp1.MYD
11891
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp2.MYD
11892
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp0.MYD
11893
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp1.MYD
11894
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp2.MYD
11895
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp0.MYI
11896
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp1.MYI
11897
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp2.MYI
11898
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp0.MYI
11899
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp1.MYI
11900
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp2.MYI
11901
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp0.MYI
11902
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp1.MYI
11903
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp2.MYI
11866
t1#P#part1#SP#part1sp0.MYD
11867
t1#P#part1#SP#part1sp0.MYI
11868
t1#P#part1#SP#part1sp1.MYD
11869
t1#P#part1#SP#part1sp1.MYI
11870
t1#P#part1#SP#part1sp2.MYD
11871
t1#P#part1#SP#part1sp2.MYI
11872
t1#P#part2#SP#part2sp0.MYD
11873
t1#P#part2#SP#part2sp0.MYI
11874
t1#P#part2#SP#part2sp1.MYD
11875
t1#P#part2#SP#part2sp1.MYI
11876
t1#P#part2#SP#part2sp2.MYD
11877
t1#P#part2#SP#part2sp2.MYI
11878
t1#P#part3#SP#part3sp0.MYD
11879
t1#P#part3#SP#part3sp0.MYI
11880
t1#P#part3#SP#part3sp1.MYD
11881
t1#P#part3#SP#part3sp1.MYI
11882
t1#P#part3#SP#part3sp2.MYD
11883
t1#P#part3#SP#part3sp2.MYI
11886
t1#P#part1#SP#part1sp0.MYD
11887
t1#P#part1#SP#part1sp1.MYD
11888
t1#P#part1#SP#part1sp2.MYD
11889
t1#P#part2#SP#part2sp0.MYD
11890
t1#P#part2#SP#part2sp1.MYD
11891
t1#P#part2#SP#part2sp2.MYD
11892
t1#P#part3#SP#part3sp0.MYD
11893
t1#P#part3#SP#part3sp1.MYD
11894
t1#P#part3#SP#part3sp2.MYD
11895
t1#P#part1#SP#part1sp0.MYI
11896
t1#P#part1#SP#part1sp1.MYI
11897
t1#P#part1#SP#part1sp2.MYI
11898
t1#P#part2#SP#part2sp0.MYI
11899
t1#P#part2#SP#part2sp1.MYI
11900
t1#P#part2#SP#part2sp2.MYI
11901
t1#P#part3#SP#part3sp0.MYI
11902
t1#P#part3#SP#part3sp1.MYI
11903
t1#P#part3#SP#part3sp2.MYI
11905
11905
# check prerequisites-1 success: 1
11906
11906
# check COUNT(*) success: 1
12418
12418
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1 + f_int2) (PARTITION p1 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
12420
12420
unified filelist
12421
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
12422
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
12423
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
12424
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
12425
$MYSQLTEST_VARDIR/master-data/test/t1.frm
12426
$MYSQLTEST_VARDIR/master-data/test/t1.par
12427
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p1.MYD
12428
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p2.MYD
12429
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p1.MYI
12430
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p2.MYI
12432
12432
# check prerequisites-1 success: 1
12433
12433
# check COUNT(*) success: 1
12948
12948
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (f_int1,f_int2) (PARTITION p1 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p3 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p4 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p5 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
12950
12950
unified filelist
12951
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
12952
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
12953
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
12954
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
12955
$MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYD
12956
$MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYI
12957
$MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYD
12958
$MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYI
12959
$MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYD
12960
$MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYI
12961
$MYSQLTEST_VARDIR/master-data/test/t1.frm
12962
$MYSQLTEST_VARDIR/master-data/test/t1.par
12963
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p1.MYD
12964
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p2.MYD
12965
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p3.MYD
12966
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p4.MYD
12967
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p5.MYD
12968
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p1.MYI
12969
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p2.MYI
12970
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p3.MYI
12971
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p4.MYI
12972
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p5.MYI
12974
12974
# check prerequisites-1 success: 1
12975
12975
# check COUNT(*) success: 1
13491
13491
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4)) (PARTITION part_3 VALUES IN (-3) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part0 VALUES IN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part1 VALUES IN (1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part2 VALUES IN (2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part3 VALUES IN (3) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
13493
13493
unified filelist
13494
$MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYD
13495
$MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYI
13496
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYD
13497
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYI
13498
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYD
13499
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYI
13500
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYD
13501
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYI
13502
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYD
13503
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYI
13504
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYD
13505
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYI
13506
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYD
13507
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYI
13508
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYD
13509
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYI
13510
$MYSQLTEST_VARDIR/master-data/test/t1.frm
13511
$MYSQLTEST_VARDIR/master-data/test/t1.par
13512
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part0.MYD
13513
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1.MYD
13514
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2.MYD
13515
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3.MYD
13516
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_1.MYD
13517
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_2.MYD
13518
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_3.MYD
13519
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_N.MYD
13520
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part0.MYI
13521
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1.MYI
13522
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2.MYI
13523
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3.MYI
13524
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_1.MYI
13525
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_2.MYI
13526
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_3.MYI
13527
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_N.MYI
13529
13529
# check prerequisites-1 success: 1
13530
13530
# check COUNT(*) success: 1
14048
14048
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) (PARTITION parta VALUES LESS THAN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
14050
14050
unified filelist
14051
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYD
14052
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYI
14053
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYD
14054
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYI
14055
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYD
14056
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYI
14057
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYD
14058
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYI
14059
$MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYD
14060
$MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYI
14061
$MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYD
14062
$MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYI
14063
$MYSQLTEST_VARDIR/master-data/test/t1.frm
14064
$MYSQLTEST_VARDIR/master-data/test/t1.par
14065
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta.MYD
14066
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb.MYD
14067
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc.MYD
14068
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd.MYD
14069
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parte.MYD
14070
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partf.MYD
14071
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta.MYI
14072
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb.MYI
14073
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc.MYI
14074
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd.MYI
14075
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parte.MYI
14076
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partf.MYI
14078
14078
# check prerequisites-1 success: 1
14079
14079
# check COUNT(*) success: 1
14589
14589
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY HASH (f_int2) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
14591
14591
unified filelist
14592
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYD
14593
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYI
14594
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYD
14595
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYI
14596
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYD
14597
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYI
14598
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYD
14599
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYI
14600
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYD
14601
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYI
14602
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYD
14603
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYI
14604
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYD
14605
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYI
14606
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYD
14607
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYI
14608
$MYSQLTEST_VARDIR/master-data/test/t1.frm
14609
$MYSQLTEST_VARDIR/master-data/test/t1.par
14610
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta#SP#partasp0.MYD
14611
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parta#SP#partasp1.MYD
14612
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb#SP#partbsp0.MYD
14613
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb#SP#partbsp1.MYD
14614
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc#SP#partcsp0.MYD
14615
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc#SP#partcsp1.MYD
14616
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd#SP#partdsp0.MYD
14617
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd#SP#partdsp1.MYD
14618
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta#SP#partasp0.MYI
14619
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta#SP#partasp1.MYI
14620
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb#SP#partbsp0.MYI
14621
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partb#SP#partbsp1.MYI
14622
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc#SP#partcsp0.MYI
14623
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc#SP#partcsp1.MYI
14624
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd#SP#partdsp0.MYI
14625
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd#SP#partdsp1.MYI
14592
t1#P#parta#SP#partasp0.MYD
14593
t1#P#parta#SP#partasp0.MYI
14594
t1#P#parta#SP#partasp1.MYD
14595
t1#P#parta#SP#partasp1.MYI
14596
t1#P#partb#SP#partbsp0.MYD
14597
t1#P#partb#SP#partbsp0.MYI
14598
t1#P#partb#SP#partbsp1.MYD
14599
t1#P#partb#SP#partbsp1.MYI
14600
t1#P#partc#SP#partcsp0.MYD
14601
t1#P#partc#SP#partcsp0.MYI
14602
t1#P#partc#SP#partcsp1.MYD
14603
t1#P#partc#SP#partcsp1.MYI
14604
t1#P#partd#SP#partdsp0.MYD
14605
t1#P#partd#SP#partdsp0.MYI
14606
t1#P#partd#SP#partdsp1.MYD
14607
t1#P#partd#SP#partdsp1.MYI
14610
t1#P#parta#SP#partasp0.MYD
14611
t1#P#parta#SP#partasp1.MYD
14612
t1#P#partb#SP#partbsp0.MYD
14613
t1#P#partb#SP#partbsp1.MYD
14614
t1#P#partc#SP#partcsp0.MYD
14615
t1#P#partc#SP#partcsp1.MYD
14616
t1#P#partd#SP#partdsp0.MYD
14617
t1#P#partd#SP#partdsp1.MYD
14618
t1#P#parta#SP#partasp0.MYI
14619
t1#P#parta#SP#partasp1.MYI
14620
t1#P#partb#SP#partbsp0.MYI
14621
t1#P#partb#SP#partbsp1.MYI
14622
t1#P#partc#SP#partcsp0.MYI
14623
t1#P#partc#SP#partcsp1.MYI
14624
t1#P#partd#SP#partdsp0.MYI
14625
t1#P#partd#SP#partdsp1.MYI
14627
14627
# check prerequisites-1 success: 1
14628
14628
# check COUNT(*) success: 1
15138
15138
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int2) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart12 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart22 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart32 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart42 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM)) */
15140
15140
unified filelist
15141
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYD
15142
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYI
15143
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYD
15144
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYI
15145
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYD
15146
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYI
15147
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYD
15148
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYI
15149
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYD
15150
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYI
15151
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYD
15152
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYI
15153
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYD
15154
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYI
15155
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYD
15156
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYI
15157
$MYSQLTEST_VARDIR/master-data/test/t1.frm
15158
$MYSQLTEST_VARDIR/master-data/test/t1.par
15159
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#subpart11.MYD
15160
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#subpart12.MYD
15161
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#subpart21.MYD
15162
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#subpart22.MYD
15163
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#subpart31.MYD
15164
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#subpart32.MYD
15165
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#subpart41.MYD
15166
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#subpart42.MYD
15167
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#subpart11.MYI
15168
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#subpart12.MYI
15169
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#subpart21.MYI
15170
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#subpart22.MYI
15171
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#subpart31.MYI
15172
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#subpart32.MYI
15173
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#subpart41.MYI
15174
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#subpart42.MYI
15141
t1#P#part1#SP#subpart11.MYD
15142
t1#P#part1#SP#subpart11.MYI
15143
t1#P#part1#SP#subpart12.MYD
15144
t1#P#part1#SP#subpart12.MYI
15145
t1#P#part2#SP#subpart21.MYD
15146
t1#P#part2#SP#subpart21.MYI
15147
t1#P#part2#SP#subpart22.MYD
15148
t1#P#part2#SP#subpart22.MYI
15149
t1#P#part3#SP#subpart31.MYD
15150
t1#P#part3#SP#subpart31.MYI
15151
t1#P#part3#SP#subpart32.MYD
15152
t1#P#part3#SP#subpart32.MYI
15153
t1#P#part4#SP#subpart41.MYD
15154
t1#P#part4#SP#subpart41.MYI
15155
t1#P#part4#SP#subpart42.MYD
15156
t1#P#part4#SP#subpart42.MYI
15159
t1#P#part1#SP#subpart11.MYD
15160
t1#P#part1#SP#subpart12.MYD
15161
t1#P#part2#SP#subpart21.MYD
15162
t1#P#part2#SP#subpart22.MYD
15163
t1#P#part3#SP#subpart31.MYD
15164
t1#P#part3#SP#subpart32.MYD
15165
t1#P#part4#SP#subpart41.MYD
15166
t1#P#part4#SP#subpart42.MYD
15167
t1#P#part1#SP#subpart11.MYI
15168
t1#P#part1#SP#subpart12.MYI
15169
t1#P#part2#SP#subpart21.MYI
15170
t1#P#part2#SP#subpart22.MYI
15171
t1#P#part3#SP#subpart31.MYI
15172
t1#P#part3#SP#subpart32.MYI
15173
t1#P#part4#SP#subpart41.MYI
15174
t1#P#part4#SP#subpart42.MYI
15176
15176
# check prerequisites-1 success: 1
15177
15177
# check COUNT(*) success: 1
15707
15707
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int2 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp12 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp22 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp32 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp42 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM)) */
15709
15709
unified filelist
15710
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYD
15711
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYI
15712
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYD
15713
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYI
15714
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYD
15715
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYI
15716
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYD
15717
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYI
15718
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYD
15719
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYI
15720
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYD
15721
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYI
15722
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYD
15723
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYI
15724
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYD
15725
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYI
15726
$MYSQLTEST_VARDIR/master-data/test/t1.frm
15727
$MYSQLTEST_VARDIR/master-data/test/t1.par
15728
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#sp11.MYD
15729
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#sp12.MYD
15730
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#sp21.MYD
15731
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#sp22.MYD
15732
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#sp31.MYD
15733
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#sp32.MYD
15734
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#sp41.MYD
15735
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#sp42.MYD
15736
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#sp11.MYI
15737
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#sp12.MYI
15738
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#sp21.MYI
15739
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#sp22.MYI
15740
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#sp31.MYI
15741
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#sp32.MYI
15742
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#sp41.MYI
15743
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#sp42.MYI
15710
t1#P#part1#SP#sp11.MYD
15711
t1#P#part1#SP#sp11.MYI
15712
t1#P#part1#SP#sp12.MYD
15713
t1#P#part1#SP#sp12.MYI
15714
t1#P#part2#SP#sp21.MYD
15715
t1#P#part2#SP#sp21.MYI
15716
t1#P#part2#SP#sp22.MYD
15717
t1#P#part2#SP#sp22.MYI
15718
t1#P#part3#SP#sp31.MYD
15719
t1#P#part3#SP#sp31.MYI
15720
t1#P#part3#SP#sp32.MYD
15721
t1#P#part3#SP#sp32.MYI
15722
t1#P#part4#SP#sp41.MYD
15723
t1#P#part4#SP#sp41.MYI
15724
t1#P#part4#SP#sp42.MYD
15725
t1#P#part4#SP#sp42.MYI
15728
t1#P#part1#SP#sp11.MYD
15729
t1#P#part1#SP#sp12.MYD
15730
t1#P#part2#SP#sp21.MYD
15731
t1#P#part2#SP#sp22.MYD
15732
t1#P#part3#SP#sp31.MYD
15733
t1#P#part3#SP#sp32.MYD
15734
t1#P#part4#SP#sp41.MYD
15735
t1#P#part4#SP#sp42.MYD
15736
t1#P#part1#SP#sp11.MYI
15737
t1#P#part1#SP#sp12.MYI
15738
t1#P#part2#SP#sp21.MYI
15739
t1#P#part2#SP#sp22.MYI
15740
t1#P#part3#SP#sp31.MYI
15741
t1#P#part3#SP#sp32.MYI
15742
t1#P#part4#SP#sp41.MYI
15743
t1#P#part4#SP#sp42.MYI
15745
15745
# check prerequisites-1 success: 1
15746
15746
# check COUNT(*) success: 1
16256
16256
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2))) SUBPARTITION BY KEY (f_int2) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part2 VALUES IN (1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part3 VALUES IN (NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
16258
16258
unified filelist
16259
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYD
16260
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYI
16261
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYD
16262
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYI
16263
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYD
16264
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYI
16265
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYD
16266
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYI
16267
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYD
16268
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYI
16269
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYD
16270
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYI
16271
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYD
16272
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYI
16273
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYD
16274
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYI
16275
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYD
16276
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYI
16277
$MYSQLTEST_VARDIR/master-data/test/t1.frm
16278
$MYSQLTEST_VARDIR/master-data/test/t1.par
16279
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp0.MYD
16280
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp1.MYD
16281
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#part1sp2.MYD
16282
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp0.MYD
16283
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp1.MYD
16284
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#part2sp2.MYD
16285
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp0.MYD
16286
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp1.MYD
16287
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#part3sp2.MYD
16288
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp0.MYI
16289
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp1.MYI
16290
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#part1sp2.MYI
16291
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp0.MYI
16292
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp1.MYI
16293
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#part2sp2.MYI
16294
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp0.MYI
16295
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp1.MYI
16296
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#part3sp2.MYI
16259
t1#P#part1#SP#part1sp0.MYD
16260
t1#P#part1#SP#part1sp0.MYI
16261
t1#P#part1#SP#part1sp1.MYD
16262
t1#P#part1#SP#part1sp1.MYI
16263
t1#P#part1#SP#part1sp2.MYD
16264
t1#P#part1#SP#part1sp2.MYI
16265
t1#P#part2#SP#part2sp0.MYD
16266
t1#P#part2#SP#part2sp0.MYI
16267
t1#P#part2#SP#part2sp1.MYD
16268
t1#P#part2#SP#part2sp1.MYI
16269
t1#P#part2#SP#part2sp2.MYD
16270
t1#P#part2#SP#part2sp2.MYI
16271
t1#P#part3#SP#part3sp0.MYD
16272
t1#P#part3#SP#part3sp0.MYI
16273
t1#P#part3#SP#part3sp1.MYD
16274
t1#P#part3#SP#part3sp1.MYI
16275
t1#P#part3#SP#part3sp2.MYD
16276
t1#P#part3#SP#part3sp2.MYI
16279
t1#P#part1#SP#part1sp0.MYD
16280
t1#P#part1#SP#part1sp1.MYD
16281
t1#P#part1#SP#part1sp2.MYD
16282
t1#P#part2#SP#part2sp0.MYD
16283
t1#P#part2#SP#part2sp1.MYD
16284
t1#P#part2#SP#part2sp2.MYD
16285
t1#P#part3#SP#part3sp0.MYD
16286
t1#P#part3#SP#part3sp1.MYD
16287
t1#P#part3#SP#part3sp2.MYD
16288
t1#P#part1#SP#part1sp0.MYI
16289
t1#P#part1#SP#part1sp1.MYI
16290
t1#P#part1#SP#part1sp2.MYI
16291
t1#P#part2#SP#part2sp0.MYI
16292
t1#P#part2#SP#part2sp1.MYI
16293
t1#P#part2#SP#part2sp2.MYI
16294
t1#P#part3#SP#part3sp0.MYI
16295
t1#P#part3#SP#part3sp1.MYI
16296
t1#P#part3#SP#part3sp2.MYI
16298
16298
# check prerequisites-1 success: 1
16299
16299
# check COUNT(*) success: 1
16807
16807
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) (PARTITION p1 INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p2 INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
16809
16809
unified filelist
16810
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
16811
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
16812
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
16813
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
16814
$MYSQLTEST_VARDIR/master-data/test/t1.frm
16815
$MYSQLTEST_VARDIR/master-data/test/t1.par
16816
ls: $MYSQLTEST_VARDIR/mysql-test-data-dir/t1*: No such file or directory
16817
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p1.MYI
16818
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p2.MYI
16820
16819
# check prerequisites-1 success: 1
16821
16820
# check COUNT(*) success: 1
17331
17330
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) (PARTITION p1 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' ENGINE = MyISAM, PARTITION p2 INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p3 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION p4 ENGINE = MyISAM, PARTITION p5 INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
17333
17332
unified filelist
17334
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
17335
$MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
17336
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
17337
$MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
17338
$MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYD
17339
$MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYI
17340
$MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYD
17341
$MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYI
17342
$MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYD
17343
$MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYI
17344
$MYSQLTEST_VARDIR/master-data/test/t1.frm
17345
$MYSQLTEST_VARDIR/master-data/test/t1.par
17346
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p1.MYD
17347
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#p3.MYD
17348
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p2.MYI
17349
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p3.MYI
17350
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#p5.MYI
17352
17351
# check prerequisites-1 success: 1
17353
17352
# check COUNT(*) success: 1
17869
17868
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1,4)) (PARTITION part_3 VALUES IN (-3) INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_2 VALUES IN (-2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' ENGINE = MyISAM, PARTITION part_1 VALUES IN (-1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part_N VALUES IN (NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' ENGINE = MyISAM, PARTITION part0 VALUES IN (0) INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION part1 VALUES IN (1) ENGINE = MyISAM, PARTITION part2 VALUES IN (2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' ENGINE = MyISAM, PARTITION part3 VALUES IN (3) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
17871
17870
unified filelist
17872
$MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYD
17873
$MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYI
17874
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYD
17875
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYI
17876
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYD
17877
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYI
17878
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYD
17879
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYI
17880
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYD
17881
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYI
17882
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYD
17883
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYI
17884
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYD
17885
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYI
17886
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYD
17887
$MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYI
17888
$MYSQLTEST_VARDIR/master-data/test/t1.frm
17889
$MYSQLTEST_VARDIR/master-data/test/t1.par
17890
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2.MYD
17891
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3.MYD
17892
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_1.MYD
17893
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_2.MYD
17894
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part_N.MYD
17895
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part0.MYI
17896
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3.MYI
17897
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_1.MYI
17898
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part_3.MYI
17900
17899
# check prerequisites-1 success: 1
17901
17900
# check COUNT(*) success: 1
18413
18412
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) (PARTITION parta VALUES LESS THAN (0) INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' ENGINE = MyISAM, PARTITION partf VALUES LESS THAN (2147483646) INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
18415
18414
unified filelist
18416
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYD
18417
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYI
18418
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYD
18419
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYI
18420
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYD
18421
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYI
18422
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYD
18423
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYI
18424
$MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYD
18425
$MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYI
18426
$MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYD
18427
$MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYI
18428
$MYSQLTEST_VARDIR/master-data/test/t1.frm
18429
$MYSQLTEST_VARDIR/master-data/test/t1.par
18430
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb.MYD
18431
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partc.MYD
18432
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#parte.MYD
18433
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta.MYI
18434
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partc.MYI
18435
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partf.MYI
18437
18436
# check prerequisites-1 success: 1
18438
18437
# check COUNT(*) success: 1
18944
18943
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1 DIV 2) SUBPARTITION BY HASH (f_int1) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, PARTITION partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' ENGINE = MyISAM, PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, PARTITION partd VALUES LESS THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM) */
18946
18945
unified filelist
18947
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYD
18948
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYI
18949
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYD
18950
$MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYI
18951
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYD
18952
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYI
18953
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYD
18954
$MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYI
18955
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYD
18956
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYI
18957
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYD
18958
$MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYI
18959
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYD
18960
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYI
18961
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYD
18962
$MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYI
18963
$MYSQLTEST_VARDIR/master-data/test/t1.frm
18964
$MYSQLTEST_VARDIR/master-data/test/t1.par
18965
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb#SP#partbsp0.MYD
18966
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partb#SP#partbsp1.MYD
18967
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd#SP#partdsp0.MYD
18968
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#partd#SP#partdsp1.MYD
18969
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta#SP#partasp0.MYI
18970
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#parta#SP#partasp1.MYI
18971
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd#SP#partdsp0.MYI
18972
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#partd#SP#partdsp1.MYI
18946
t1#P#parta#SP#partasp0.MYD
18947
t1#P#parta#SP#partasp0.MYI
18948
t1#P#parta#SP#partasp1.MYD
18949
t1#P#parta#SP#partasp1.MYI
18950
t1#P#partb#SP#partbsp0.MYD
18951
t1#P#partb#SP#partbsp0.MYI
18952
t1#P#partb#SP#partbsp1.MYD
18953
t1#P#partb#SP#partbsp1.MYI
18954
t1#P#partc#SP#partcsp0.MYD
18955
t1#P#partc#SP#partcsp0.MYI
18956
t1#P#partc#SP#partcsp1.MYD
18957
t1#P#partc#SP#partcsp1.MYI
18958
t1#P#partd#SP#partdsp0.MYD
18959
t1#P#partd#SP#partdsp0.MYI
18960
t1#P#partd#SP#partdsp1.MYD
18961
t1#P#partd#SP#partdsp1.MYI
18964
t1#P#partb#SP#partbsp0.MYD
18965
t1#P#partb#SP#partbsp1.MYD
18966
t1#P#partd#SP#partdsp0.MYD
18967
t1#P#partd#SP#partdsp1.MYD
18968
t1#P#parta#SP#partasp0.MYI
18969
t1#P#parta#SP#partasp1.MYI
18970
t1#P#partd#SP#partdsp0.MYI
18971
t1#P#partd#SP#partdsp1.MYI
18974
18973
# check prerequisites-1 success: 1
18975
18974
# check COUNT(*) success: 1
19487
19486
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY KEY (f_int1) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' ENGINE = MyISAM, SUBPARTITION subpart12 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (5) (SUBPARTITION subpart21 INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart22 INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION subpart32 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part4 VALUES LESS THAN (2147483646) (SUBPARTITION subpart41 ENGINE = MyISAM, SUBPARTITION subpart42 ENGINE = MyISAM)) */
19489
19488
unified filelist
19490
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYD
19491
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYI
19492
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYD
19493
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYI
19494
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYD
19495
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYI
19496
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYD
19497
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYI
19498
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYD
19499
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYI
19500
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYD
19501
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYI
19502
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYD
19503
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYI
19504
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYD
19505
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYI
19506
$MYSQLTEST_VARDIR/master-data/test/t1.frm
19507
$MYSQLTEST_VARDIR/master-data/test/t1.par
19508
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#subpart11.MYD
19509
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#subpart12.MYD
19510
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#subpart31.MYD
19511
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#subpart32.MYD
19512
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#subpart21.MYI
19513
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#subpart22.MYI
19514
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#subpart31.MYI
19515
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#subpart32.MYI
19489
t1#P#part1#SP#subpart11.MYD
19490
t1#P#part1#SP#subpart11.MYI
19491
t1#P#part1#SP#subpart12.MYD
19492
t1#P#part1#SP#subpart12.MYI
19493
t1#P#part2#SP#subpart21.MYD
19494
t1#P#part2#SP#subpart21.MYI
19495
t1#P#part2#SP#subpart22.MYD
19496
t1#P#part2#SP#subpart22.MYI
19497
t1#P#part3#SP#subpart31.MYD
19498
t1#P#part3#SP#subpart31.MYI
19499
t1#P#part3#SP#subpart32.MYD
19500
t1#P#part3#SP#subpart32.MYI
19501
t1#P#part4#SP#subpart41.MYD
19502
t1#P#part4#SP#subpart41.MYI
19503
t1#P#part4#SP#subpart42.MYD
19504
t1#P#part4#SP#subpart42.MYI
19507
t1#P#part1#SP#subpart11.MYD
19508
t1#P#part1#SP#subpart12.MYD
19509
t1#P#part3#SP#subpart31.MYD
19510
t1#P#part3#SP#subpart32.MYD
19511
t1#P#part2#SP#subpart21.MYI
19512
t1#P#part2#SP#subpart22.MYI
19513
t1#P#part3#SP#subpart31.MYI
19514
t1#P#part3#SP#subpart32.MYI
19517
19516
# check prerequisites-1 success: 1
19518
19517
# check COUNT(*) success: 1
20040
20039
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) SUBPARTITION BY HASH (f_int1 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp12 INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part2 VALUES IN (1) (SUBPARTITION sp21 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' ENGINE = MyISAM, SUBPARTITION sp22 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part3 VALUES IN (2) (SUBPARTITION sp31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp32 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM), PARTITION part4 VALUES IN (NULL) (SUBPARTITION sp41 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM, SUBPARTITION sp42 DATA DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-data-dir' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/mysql-test-idx-dir' ENGINE = MyISAM)) */
20042
20041
unified filelist
20043
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYD
20044
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYI
20045
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYD
20046
$MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYI
20047
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYD
20048
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYI
20049
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYD
20050
$MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYI
20051
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYD
20052
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYI
20053
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYD
20054
$MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYI
20055
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYD
20056
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYI
20057
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYD
20058
$MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYI
20059
$MYSQLTEST_VARDIR/master-data/test/t1.frm
20060
$MYSQLTEST_VARDIR/master-data/test/t1.par
20061
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part1#SP#sp11.MYD
20062
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#sp21.MYD
20063
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part2#SP#sp22.MYD
20064
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#sp31.MYD
20065
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part3#SP#sp32.MYD
20066
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#sp41.MYD
20067
$MYSQLTEST_VARDIR/mysql-test-data-dir/t1#P#part4#SP#sp42.MYD
20068
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#sp11.MYI
20069
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part1#SP#sp12.MYI
20070
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part2#SP#sp22.MYI
20071
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#sp31.MYI
20072
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part3#SP#sp32.MYI
20073
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#sp41.MYI
20074
$MYSQLTEST_VARDIR/mysql-test-idx-dir/t1#P#part4#SP#sp42.MYI
20042
t1#P#part1#SP#sp11.MYD
20043
t1#P#part1#SP#sp11.MYI
20044
t1#P#part1#SP#sp12.MYD
20045
t1#P#part1#SP#sp12.MYI
20046
t1#P#part2#SP#sp21.MYD
20047
t1#P#part2#SP#sp21.MYI
20048
t1#P#part2#SP#sp22.MYD
20049
t1#P#part2#SP#sp22.MYI
20050
t1#P#part3#SP#sp31.MYD
20051
t1#P#part3#SP#sp31.MYI
20052
t1#P#part3#SP#sp32.MYD
20053
t1#P#part3#SP#sp32.MYI
20054
t1#P#part4#SP#sp41.MYD
20055
t1#P#part4#SP#sp41.MYI
20056
t1#P#part4#SP#sp42.MYD
20057
t1#P#part4#SP#sp42.MYI
20060
t1#P#part1#SP#sp11.MYD
20061
t1#P#part2#SP#sp21.MYD
20062
t1#P#part2#SP#sp22.MYD
20063
t1#P#part3#SP#sp31.MYD
20064
t1#P#part3#SP#sp32.MYD
20065
t1#P#part4#SP#sp41.MYD
20066
t1#P#part4#SP#sp42.MYD
20067
t1#P#part1#SP#sp11.MYI
20068
t1#P#part1#SP#sp12.MYI
20069
t1#P#part2#SP#sp22.MYI
20070
t1#P#part3#SP#sp31.MYI
20071
t1#P#part3#SP#sp32.MYI
20072
t1#P#part4#SP#sp41.MYI
20073
t1#P#part4#SP#sp42.MYI
20076
20075
# check prerequisites-1 success: 1
20077
20076
# check COUNT(*) success: 1