summaryrefslogtreecommitdiff
path: root/mysql-test/suite/parts/r/partition_mgm_lc1_archive.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_mgm_lc1_archive.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_mgm_lc1_archive.result')
-rw-r--r--mysql-test/suite/parts/r/partition_mgm_lc1_archive.result72
1 files changed, 36 insertions, 36 deletions
diff --git a/mysql-test/suite/parts/r/partition_mgm_lc1_archive.result b/mysql-test/suite/parts/r/partition_mgm_lc1_archive.result
index 66ba08cfbe0..40436328185 100644
--- a/mysql-test/suite/parts/r/partition_mgm_lc1_archive.result
+++ b/mysql-test/suite/parts/r/partition_mgm_lc1_archive.result
@@ -56,14 +56,14 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY KEY (a)
+ PARTITION BY KEY (a)
(PARTITION parta ENGINE = ARCHIVE,
PARTITION partB ENGINE = ARCHIVE,
PARTITION Partc ENGINE = ARCHIVE,
PARTITION PartD ENGINE = ARCHIVE,
PARTITION partE ENGINE = ARCHIVE,
PARTITION Partf ENGINE = ARCHIVE,
- PARTITION PartG ENGINE = ARCHIVE) */
+ PARTITION PartG ENGINE = ARCHIVE)
ALTER TABLE TableA COALESCE PARTITION 4;
SELECT * FROM TableA;
a
@@ -84,10 +84,10 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY KEY (a)
+ PARTITION BY KEY (a)
(PARTITION parta ENGINE = ARCHIVE,
PARTITION partB ENGINE = ARCHIVE,
- PARTITION Partc ENGINE = ARCHIVE) */
+ PARTITION Partc ENGINE = ARCHIVE)
# Test of EXCHANGE PARTITION WITH TABLE
SELECT PARTITION_NAME, TABLE_ROWS FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA ='MySQL_Test_DB' AND TABLE_NAME = 'TableA';
PARTITION_NAME TABLE_ROWS
@@ -112,10 +112,10 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY KEY (a)
+ PARTITION BY KEY (a)
(PARTITION parta ENGINE = ARCHIVE,
PARTITION partB ENGINE = ARCHIVE,
- PARTITION Partc ENGINE = ARCHIVE) */
+ PARTITION Partc ENGINE = ARCHIVE)
SELECT * FROM TableB;
a
10
@@ -156,10 +156,10 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY KEY (a)
+ PARTITION BY KEY (a)
(PARTITION parta ENGINE = ARCHIVE,
PARTITION partB ENGINE = ARCHIVE,
- PARTITION Partc ENGINE = ARCHIVE) */
+ PARTITION Partc ENGINE = ARCHIVE)
# Test of REORGANIZE PARTITIONS
# Should not work on HASH/KEY
ALTER TABLE TableA REORGANIZE PARTITION parta,partB,Partc INTO
@@ -192,10 +192,10 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY KEY (a)
+ PARTITION BY KEY (a)
(PARTITION partB COMMENT = 'Previusly named parta' ENGINE = ARCHIVE,
PARTITION parta COMMENT = 'Previusly named partB' ENGINE = ARCHIVE,
- PARTITION Partc ENGINE = ARCHIVE) */
+ PARTITION Partc ENGINE = ARCHIVE)
# Test of RENAME TABLE
RENAME TABLE TableA to TableB;
SELECT * FROM TableB;
@@ -264,10 +264,10 @@ Table Create Table
tablea CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY KEY (a)
+ PARTITION BY KEY (a)
(PARTITION partB COMMENT = 'Previusly named parta' ENGINE = ARCHIVE,
PARTITION parta COMMENT = 'Previusly named partB' ENGINE = ARCHIVE,
- PARTITION Partc ENGINE = ARCHIVE) */
+ PARTITION Partc ENGINE = ARCHIVE)
# Test of REMOVE PARTITIONING
ALTER TABLE TableA REMOVE PARTITIONING;
SELECT * FROM TableA;
@@ -355,14 +355,14 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY HASH (a)
+ PARTITION BY HASH (a)
(PARTITION parta ENGINE = ARCHIVE,
PARTITION partB ENGINE = ARCHIVE,
PARTITION Partc ENGINE = ARCHIVE,
PARTITION PartD ENGINE = ARCHIVE,
PARTITION partE ENGINE = ARCHIVE,
PARTITION Partf ENGINE = ARCHIVE,
- PARTITION PartG ENGINE = ARCHIVE) */
+ PARTITION PartG ENGINE = ARCHIVE)
ALTER TABLE TableA COALESCE PARTITION 4;
SELECT * FROM TableA;
a
@@ -383,10 +383,10 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY HASH (a)
+ PARTITION BY HASH (a)
(PARTITION parta ENGINE = ARCHIVE,
PARTITION partB ENGINE = ARCHIVE,
- PARTITION Partc ENGINE = ARCHIVE) */
+ PARTITION Partc ENGINE = ARCHIVE)
# Test of REORGANIZE PARTITIONS
# Should not work on HASH/KEY
ALTER TABLE TableA REORGANIZE PARTITION parta,partB,Partc INTO
@@ -419,10 +419,10 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY HASH (a)
+ PARTITION BY HASH (a)
(PARTITION partB COMMENT = 'Previusly named parta' ENGINE = ARCHIVE,
PARTITION parta COMMENT = 'Previusly named partB' ENGINE = ARCHIVE,
- PARTITION Partc ENGINE = ARCHIVE) */
+ PARTITION Partc ENGINE = ARCHIVE)
# Test of RENAME TABLE
RENAME TABLE TableA to TableB;
SELECT * FROM TableB;
@@ -491,10 +491,10 @@ Table Create Table
tablea CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY HASH (a)
+ PARTITION BY HASH (a)
(PARTITION partB COMMENT = 'Previusly named parta' ENGINE = ARCHIVE,
PARTITION parta COMMENT = 'Previusly named partB' ENGINE = ARCHIVE,
- PARTITION Partc ENGINE = ARCHIVE) */
+ PARTITION Partc ENGINE = ARCHIVE)
# Test of REMOVE PARTITIONING
ALTER TABLE TableA REMOVE PARTITIONING;
SELECT * FROM TableA;
@@ -571,14 +571,14 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (a)
+ PARTITION BY RANGE (a)
(PARTITION parta VALUES LESS THAN (4) ENGINE = ARCHIVE,
PARTITION partB VALUES LESS THAN (7) ENGINE = ARCHIVE,
PARTITION Partc VALUES LESS THAN (10) ENGINE = ARCHIVE,
PARTITION PartD VALUES LESS THAN (13) ENGINE = ARCHIVE,
PARTITION partE VALUES LESS THAN (16) ENGINE = ARCHIVE,
PARTITION Partf VALUES LESS THAN (19) ENGINE = ARCHIVE,
- PARTITION PartG VALUES LESS THAN (22) ENGINE = ARCHIVE) */
+ PARTITION PartG VALUES LESS THAN (22) ENGINE = ARCHIVE)
ALTER TABLE TableA DROP PARTITION partE, PartG;
ALTER TABLE TableA DROP PARTITION Partf;
ALTER TABLE TableA ADD PARTITION
@@ -602,12 +602,12 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (a)
+ PARTITION BY RANGE (a)
(PARTITION parta VALUES LESS THAN (4) ENGINE = ARCHIVE,
PARTITION partB VALUES LESS THAN (7) ENGINE = ARCHIVE,
PARTITION Partc VALUES LESS THAN (10) ENGINE = ARCHIVE,
PARTITION PartD VALUES LESS THAN (13) ENGINE = ARCHIVE,
- PARTITION PartE VALUES LESS THAN MAXVALUE ENGINE = ARCHIVE) */
+ PARTITION PartE VALUES LESS THAN MAXVALUE ENGINE = ARCHIVE)
# Test of REORGANIZE PARTITIONS
# Error since it must reorganize a consecutive range
ALTER TABLE TableA REORGANIZE PARTITION parta,Partc INTO
@@ -640,11 +640,11 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (a)
+ PARTITION BY RANGE (a)
(PARTITION parta VALUES LESS THAN (4) ENGINE = ARCHIVE,
PARTITION partD VALUES LESS THAN (8) COMMENT = 'Previously partB and partly Partc' ENGINE = ARCHIVE,
PARTITION partB VALUES LESS THAN (11) COMMENT = 'Previously partly Partc and partly PartD' ENGINE = ARCHIVE,
- PARTITION partC VALUES LESS THAN MAXVALUE COMMENT = 'Previously partly PartD' ENGINE = ARCHIVE) */
+ PARTITION partC VALUES LESS THAN MAXVALUE COMMENT = 'Previously partly PartD' ENGINE = ARCHIVE)
# Test of RENAME TABLE
RENAME TABLE TableA to TableB;
SELECT * FROM TableB;
@@ -713,11 +713,11 @@ Table Create Table
tablea CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY RANGE (a)
+ PARTITION BY RANGE (a)
(PARTITION parta VALUES LESS THAN (4) ENGINE = ARCHIVE,
PARTITION partD VALUES LESS THAN (8) COMMENT = 'Previously partB and partly Partc' ENGINE = ARCHIVE,
PARTITION partB VALUES LESS THAN (11) COMMENT = 'Previously partly Partc and partly PartD' ENGINE = ARCHIVE,
- PARTITION partC VALUES LESS THAN MAXVALUE COMMENT = 'Previously partly PartD' ENGINE = ARCHIVE) */
+ PARTITION partC VALUES LESS THAN MAXVALUE COMMENT = 'Previously partly PartD' ENGINE = ARCHIVE)
# Test of REMOVE PARTITIONING
ALTER TABLE TableA REMOVE PARTITIONING;
SELECT * FROM TableA;
@@ -794,14 +794,14 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (a)
+ PARTITION BY LIST (a)
(PARTITION parta VALUES IN (1,8,9) ENGINE = ARCHIVE,
PARTITION partB VALUES IN (2,10,11) ENGINE = ARCHIVE,
PARTITION Partc VALUES IN (3,4,7) ENGINE = ARCHIVE,
PARTITION PartD VALUES IN (5,6,12) ENGINE = ARCHIVE,
PARTITION partE VALUES IN (16) ENGINE = ARCHIVE,
PARTITION Partf VALUES IN (19) ENGINE = ARCHIVE,
- PARTITION PartG VALUES IN (22) ENGINE = ARCHIVE) */
+ PARTITION PartG VALUES IN (22) ENGINE = ARCHIVE)
ALTER TABLE TableA DROP PARTITION partE, PartG;
ALTER TABLE TableA DROP PARTITION Partf;
ALTER TABLE TableA ADD PARTITION
@@ -825,12 +825,12 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (a)
+ PARTITION BY LIST (a)
(PARTITION parta VALUES IN (1,8,9) ENGINE = ARCHIVE,
PARTITION partB VALUES IN (2,10,11) ENGINE = ARCHIVE,
PARTITION Partc VALUES IN (3,4,7) ENGINE = ARCHIVE,
PARTITION PartD VALUES IN (5,6,12) ENGINE = ARCHIVE,
- PARTITION PartE VALUES IN (13) ENGINE = ARCHIVE) */
+ PARTITION PartE VALUES IN (13) ENGINE = ARCHIVE)
# Test of REORGANIZE PARTITIONS
ALTER TABLE TableA REORGANIZE PARTITION parta,Partc INTO
(PARTITION Partc VALUES IN (1,7)
@@ -863,12 +863,12 @@ Table Create Table
TableA CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (a)
+ PARTITION BY LIST (a)
(PARTITION Partc VALUES IN (1,7) COMMENT = 'Mix 1 of old parta and Partc' ENGINE = ARCHIVE,
PARTITION parta VALUES IN (3,9) COMMENT = 'Mix 2 of old parta and Partc' ENGINE = ARCHIVE,
PARTITION partB VALUES IN (4,8) COMMENT = 'Mix 3 of old parta and Partc' ENGINE = ARCHIVE,
PARTITION PartD VALUES IN (5,6,12) ENGINE = ARCHIVE,
- PARTITION PartE VALUES IN (13) ENGINE = ARCHIVE) */
+ PARTITION PartE VALUES IN (13) ENGINE = ARCHIVE)
# Test of RENAME TABLE
RENAME TABLE TableA to TableB;
SELECT * FROM TableB;
@@ -928,12 +928,12 @@ Table Create Table
tablea CREATE TABLE `tablea` (
`a` int(11) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1
-/*!50100 PARTITION BY LIST (a)
+ PARTITION BY LIST (a)
(PARTITION Partc VALUES IN (1,7) COMMENT = 'Mix 1 of old parta and Partc' ENGINE = ARCHIVE,
PARTITION parta VALUES IN (3,9) COMMENT = 'Mix 2 of old parta and Partc' ENGINE = ARCHIVE,
PARTITION partB VALUES IN (4,8) COMMENT = 'Mix 3 of old parta and Partc' ENGINE = ARCHIVE,
PARTITION PartD VALUES IN (5,6,12) ENGINE = ARCHIVE,
- PARTITION PartE VALUES IN (13) ENGINE = ARCHIVE) */
+ PARTITION PartE VALUES IN (13) ENGINE = ARCHIVE)
# Test of REMOVE PARTITIONING
ALTER TABLE TableA REMOVE PARTITIONING;
SELECT * FROM TableA;