summaryrefslogtreecommitdiff
path: root/mysql-test/suite/parts/r/partition_basic_myisam.result
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2015-11-20 13:11:35 +0100
committerSergei Golubchik <serg@mariadb.org>2016-12-12 20:27:25 +0100
commit0bef3bb8d0a0c3d25b6e4c707144c96cb0350e99 (patch)
treec980515c68e37f13987d38eefe8a010683e7db6a /mysql-test/suite/parts/r/partition_basic_myisam.result
parentd440319842e564a727a54d2c44f92104bd96e0de (diff)
downloadmariadb-git-0bef3bb8d0a0c3d25b6e4c707144c96cb0350e99.tar.gz
cleanup: remove Item::intro_version
and partition_info::set_show_version_string - they were already broken and impossible to maintain
Diffstat (limited to 'mysql-test/suite/parts/r/partition_basic_myisam.result')
-rw-r--r--mysql-test/suite/parts/r/partition_basic_myisam.result128
1 files changed, 64 insertions, 64 deletions
diff --git a/mysql-test/suite/parts/r/partition_basic_myisam.result b/mysql-test/suite/parts/r/partition_basic_myisam.result
index 3351201ea06..69799a07076 100644
--- a/mysql-test/suite/parts/r/partition_basic_myisam.result
+++ b/mysql-test/suite/parts/r/partition_basic_myisam.result
@@ -73,8 +73,8 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY HASH (f_int1)
-PARTITIONS 2 */
+ PARTITION BY HASH (f_int1)
+PARTITIONS 2
unified filelist
t1#P#p0.MYD
@@ -533,8 +533,8 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY KEY (f_int1)
-PARTITIONS 5 */
+ PARTITION BY KEY (f_int1)
+PARTITIONS 5
unified filelist
t1#P#p0.MYD
@@ -1007,7 +1007,7 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (MOD(f_int1,4))
+ PARTITION BY LIST (MOD(f_int1,4))
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
@@ -1015,7 +1015,7 @@ t1 CREATE TABLE `t1` (
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
- PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
+ PARTITION part3 VALUES IN (3) ENGINE = MyISAM)
unified filelist
t1#P#part0.MYD
@@ -1492,13 +1492,13 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (f_int1)
+ PARTITION BY RANGE (f_int1)
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
- PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
+ PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM)
unified filelist
t1#P#parta.MYD
@@ -1967,13 +1967,13 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (f_int1 DIV 2)
+ PARTITION BY RANGE (f_int1 DIV 2)
SUBPARTITION BY HASH (f_int1)
SUBPARTITIONS 2
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
- PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
+ PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM)
unified filelist
t1#P#parta#SP#partasp0.MYD
@@ -2452,7 +2452,7 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (f_int1)
+ PARTITION BY RANGE (f_int1)
SUBPARTITION BY KEY (f_int1)
(PARTITION part1 VALUES LESS THAN (0)
(SUBPARTITION subpart11 ENGINE = MyISAM,
@@ -2465,7 +2465,7 @@ SUBPARTITION BY KEY (f_int1)
SUBPARTITION subpart32 ENGINE = MyISAM),
PARTITION part4 VALUES LESS THAN (2147483646)
(SUBPARTITION subpart41 ENGINE = MyISAM,
- SUBPARTITION subpart42 ENGINE = MyISAM)) */
+ SUBPARTITION subpart42 ENGINE = MyISAM))
unified filelist
t1#P#part1#SP#subpart11.MYD
@@ -2946,7 +2946,7 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
+ PARTITION BY LIST (ABS(MOD(f_int1,3)))
SUBPARTITION BY HASH (f_int1 + 1)
(PARTITION part1 VALUES IN (0)
(SUBPARTITION sp11 ENGINE = MyISAM,
@@ -2959,7 +2959,7 @@ SUBPARTITION BY HASH (f_int1 + 1)
SUBPARTITION sp32 ENGINE = MyISAM),
PARTITION part4 VALUES IN (NULL)
(SUBPARTITION sp41 ENGINE = MyISAM,
- SUBPARTITION sp42 ENGINE = MyISAM)) */
+ SUBPARTITION sp42 ENGINE = MyISAM))
unified filelist
t1#P#part1#SP#sp11.MYD
@@ -3434,12 +3434,12 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
+ PARTITION BY LIST (ABS(MOD(f_int1,2)))
SUBPARTITION BY KEY (f_int1)
SUBPARTITIONS 3
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
- PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
+ PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM)
unified filelist
t1#P#part1#SP#part1sp0.MYD
@@ -3914,8 +3914,8 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY HASH (f_int1 + f_int2)
-PARTITIONS 2 */
+ PARTITION BY HASH (f_int1 + f_int2)
+PARTITIONS 2
unified filelist
t1#P#p0.MYD
@@ -4374,8 +4374,8 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY KEY (f_int1,f_int2)
-PARTITIONS 5 */
+ PARTITION BY KEY (f_int1,f_int2)
+PARTITIONS 5
unified filelist
t1#P#p0.MYD
@@ -4848,7 +4848,7 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4))
+ PARTITION BY LIST (MOD(f_int1 + f_int2,4))
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
@@ -4856,7 +4856,7 @@ t1 CREATE TABLE `t1` (
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
- PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
+ PARTITION part3 VALUES IN (3) ENGINE = MyISAM)
unified filelist
t1#P#part0.MYD
@@ -5333,13 +5333,13 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2)
+ PARTITION BY RANGE ((f_int1 + f_int2) DIV 2)
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
- PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
+ PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM)
unified filelist
t1#P#parta.MYD
@@ -5808,13 +5808,13 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (f_int1)
+ PARTITION BY RANGE (f_int1)
SUBPARTITION BY HASH (f_int2)
SUBPARTITIONS 2
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
- PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
+ PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM)
unified filelist
t1#P#parta#SP#partasp0.MYD
@@ -6291,7 +6291,7 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (f_int1)
+ PARTITION BY RANGE (f_int1)
SUBPARTITION BY KEY (f_int2)
(PARTITION part1 VALUES LESS THAN (0)
(SUBPARTITION subpart11 ENGINE = MyISAM,
@@ -6304,7 +6304,7 @@ SUBPARTITION BY KEY (f_int2)
SUBPARTITION subpart32 ENGINE = MyISAM),
PARTITION part4 VALUES LESS THAN (2147483646)
(SUBPARTITION subpart41 ENGINE = MyISAM,
- SUBPARTITION subpart42 ENGINE = MyISAM)) */
+ SUBPARTITION subpart42 ENGINE = MyISAM))
unified filelist
t1#P#part1#SP#subpart11.MYD
@@ -6781,7 +6781,7 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
+ PARTITION BY LIST (ABS(MOD(f_int1,3)))
SUBPARTITION BY HASH (f_int2 + 1)
(PARTITION part1 VALUES IN (0)
(SUBPARTITION sp11 ENGINE = MyISAM,
@@ -6794,7 +6794,7 @@ SUBPARTITION BY HASH (f_int2 + 1)
SUBPARTITION sp32 ENGINE = MyISAM),
PARTITION part4 VALUES IN (NULL)
(SUBPARTITION sp41 ENGINE = MyISAM,
- SUBPARTITION sp42 ENGINE = MyISAM)) */
+ SUBPARTITION sp42 ENGINE = MyISAM))
unified filelist
t1#P#part1#SP#sp11.MYD
@@ -7269,12 +7269,12 @@ t1 CREATE TABLE `t1` (
`f_char2` char(20) DEFAULT NULL,
`f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
+ PARTITION BY LIST (ABS(MOD(f_int1,2)))
SUBPARTITION BY KEY (f_int2)
SUBPARTITIONS 3
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
- PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
+ PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM)
unified filelist
t1#P#part1#SP#part1sp0.MYD
@@ -7755,8 +7755,8 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY HASH (f_int1)
-PARTITIONS 2 */
+ PARTITION BY HASH (f_int1)
+PARTITIONS 2
unified filelist
t1#P#p0.MYD
@@ -8268,8 +8268,8 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY KEY (f_int1)
-PARTITIONS 5 */
+ PARTITION BY KEY (f_int1)
+PARTITIONS 5
unified filelist
t1#P#p0.MYD
@@ -8795,7 +8795,7 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (MOD(f_int1,4))
+ PARTITION BY LIST (MOD(f_int1,4))
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
@@ -8803,7 +8803,7 @@ t1 CREATE TABLE `t1` (
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
- PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
+ PARTITION part3 VALUES IN (3) ENGINE = MyISAM)
unified filelist
t1#P#part0.MYD
@@ -9333,13 +9333,13 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (f_int1)
+ PARTITION BY RANGE (f_int1)
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
- PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
+ PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM)
unified filelist
t1#P#parta.MYD
@@ -9861,13 +9861,13 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (f_int1 DIV 2)
+ PARTITION BY RANGE (f_int1 DIV 2)
SUBPARTITION BY HASH (f_int1)
SUBPARTITIONS 2
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
- PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
+ PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM)
unified filelist
t1#P#parta#SP#partasp0.MYD
@@ -10399,7 +10399,7 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (f_int1)
+ PARTITION BY RANGE (f_int1)
SUBPARTITION BY KEY (f_int1)
(PARTITION part1 VALUES LESS THAN (0)
(SUBPARTITION subpart11 ENGINE = MyISAM,
@@ -10412,7 +10412,7 @@ SUBPARTITION BY KEY (f_int1)
SUBPARTITION subpart32 ENGINE = MyISAM),
PARTITION part4 VALUES LESS THAN (2147483646)
(SUBPARTITION subpart41 ENGINE = MyISAM,
- SUBPARTITION subpart42 ENGINE = MyISAM)) */
+ SUBPARTITION subpart42 ENGINE = MyISAM))
unified filelist
t1#P#part1#SP#subpart11.MYD
@@ -10946,7 +10946,7 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
+ PARTITION BY LIST (ABS(MOD(f_int1,3)))
SUBPARTITION BY HASH (f_int1 + 1)
(PARTITION part1 VALUES IN (0)
(SUBPARTITION sp11 ENGINE = MyISAM,
@@ -10959,7 +10959,7 @@ SUBPARTITION BY HASH (f_int1 + 1)
SUBPARTITION sp32 ENGINE = MyISAM),
PARTITION part4 VALUES IN (NULL)
(SUBPARTITION sp41 ENGINE = MyISAM,
- SUBPARTITION sp42 ENGINE = MyISAM)) */
+ SUBPARTITION sp42 ENGINE = MyISAM))
unified filelist
t1#P#part1#SP#sp11.MYD
@@ -11487,12 +11487,12 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
+ PARTITION BY LIST (ABS(MOD(f_int1,2)))
SUBPARTITION BY KEY (f_int1)
SUBPARTITIONS 3
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
- PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
+ PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM)
unified filelist
t1#P#part1#SP#part1sp0.MYD
@@ -12024,8 +12024,8 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY HASH (f_int1 + f_int2)
-PARTITIONS 2 */
+ PARTITION BY HASH (f_int1 + f_int2)
+PARTITIONS 2
unified filelist
t1#P#p0.MYD
@@ -12537,8 +12537,8 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY KEY (f_int1,f_int2)
-PARTITIONS 5 */
+ PARTITION BY KEY (f_int1,f_int2)
+PARTITIONS 5
unified filelist
t1#P#p0.MYD
@@ -13064,7 +13064,7 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4))
+ PARTITION BY LIST (MOD(f_int1 + f_int2,4))
(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM,
PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM,
PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM,
@@ -13072,7 +13072,7 @@ t1 CREATE TABLE `t1` (
PARTITION part0 VALUES IN (0) ENGINE = MyISAM,
PARTITION part1 VALUES IN (1) ENGINE = MyISAM,
PARTITION part2 VALUES IN (2) ENGINE = MyISAM,
- PARTITION part3 VALUES IN (3) ENGINE = MyISAM) */
+ PARTITION part3 VALUES IN (3) ENGINE = MyISAM)
unified filelist
t1#P#part0.MYD
@@ -13602,13 +13602,13 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2)
+ PARTITION BY RANGE ((f_int1 + f_int2) DIV 2)
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM,
PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM,
- PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
+ PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM)
unified filelist
t1#P#parta.MYD
@@ -14130,13 +14130,13 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (f_int1)
+ PARTITION BY RANGE (f_int1)
SUBPARTITION BY HASH (f_int2)
SUBPARTITIONS 2
(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM,
PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM,
PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM,
- PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) */
+ PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM)
unified filelist
t1#P#parta#SP#partasp0.MYD
@@ -14666,7 +14666,7 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (f_int1)
+ PARTITION BY RANGE (f_int1)
SUBPARTITION BY KEY (f_int2)
(PARTITION part1 VALUES LESS THAN (0)
(SUBPARTITION subpart11 ENGINE = MyISAM,
@@ -14679,7 +14679,7 @@ SUBPARTITION BY KEY (f_int2)
SUBPARTITION subpart32 ENGINE = MyISAM),
PARTITION part4 VALUES LESS THAN (2147483646)
(SUBPARTITION subpart41 ENGINE = MyISAM,
- SUBPARTITION subpart42 ENGINE = MyISAM)) */
+ SUBPARTITION subpart42 ENGINE = MyISAM))
unified filelist
t1#P#part1#SP#subpart11.MYD
@@ -15209,7 +15209,7 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
+ PARTITION BY LIST (ABS(MOD(f_int1,3)))
SUBPARTITION BY HASH (f_int2 + 1)
(PARTITION part1 VALUES IN (0)
(SUBPARTITION sp11 ENGINE = MyISAM,
@@ -15222,7 +15222,7 @@ SUBPARTITION BY HASH (f_int2 + 1)
SUBPARTITION sp32 ENGINE = MyISAM),
PARTITION part4 VALUES IN (NULL)
(SUBPARTITION sp41 ENGINE = MyISAM,
- SUBPARTITION sp42 ENGINE = MyISAM)) */
+ SUBPARTITION sp42 ENGINE = MyISAM))
unified filelist
t1#P#part1#SP#sp11.MYD
@@ -15750,12 +15750,12 @@ t1 CREATE TABLE `t1` (
UNIQUE KEY `uidx1` (`f_int1`,`f_int2`),
UNIQUE KEY `uidx2` (`f_int2`,`f_int1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
+ PARTITION BY LIST (ABS(MOD(f_int1,2)))
SUBPARTITION BY KEY (f_int2)
SUBPARTITIONS 3
(PARTITION part1 VALUES IN (0) ENGINE = MyISAM,
PARTITION part2 VALUES IN (1) ENGINE = MyISAM,
- PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) */
+ PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM)
unified filelist
t1#P#part1#SP#part1sp0.MYD