diff options
Diffstat (limited to 'mysql-test/suite/parts/r/partition_exch_innodb.result')
| -rw-r--r-- | mysql-test/suite/parts/r/partition_exch_innodb.result | 355 |
1 files changed, 355 insertions, 0 deletions
diff --git a/mysql-test/suite/parts/r/partition_exch_innodb.result b/mysql-test/suite/parts/r/partition_exch_innodb.result new file mode 100644 index 00000000..d444e2e3 --- /dev/null +++ b/mysql-test/suite/parts/r/partition_exch_innodb.result @@ -0,0 +1,355 @@ +use test; +SELECT * FROM t_10; +a b +1 One +3 Three +5 Five +9 Nine +SELECT * FROM t_100; +a b +11 Eleven +13 Thirdteen +15 Fifeteen +19 Nineteen +91 Ninety-one +93 Ninety-three +95 Ninety-five +99 Ninety-nine +SELECT * FROM t_1000; +a b +111 Hundred elven +113 Hundred thirdteen +115 Hundred fiveteen +119 Hundred nineteen +131 Hundred thirty-one +133 Hundred thirty-three +135 Hundred thirty-five +139 Hundred thirty-nine +151 Hundred fifty-one +153 Hundred fifty-three +155 Hundred fity-five +159 Hundred fifty-nine +191 Hundred ninety-one +193 Hundred ninety-three +195 Hundred ninety-five +199 Hundred ninety-nine +SELECT * FROM tp; +a b +112 Hundred twelve +114 Hundred fourteen +116 Hundred sixteen +118 Hundred eightteen +12 twelve +122 Hundred twenty-two +124 Hundred twenty-four +126 Hundred twenty-six +128 Hundred twenty-eight +14 Fourteen +16 Sixteen +162 Hundred sixty-two +164 Hundred sixty-four +166 Hundred sixty-six +168 Hundred sixty-eight +18 Eightteen +182 Hundred eighty-two +184 Hundred eighty-four +186 Hundred eighty-six +188 Hundred eighty-eight +2 Two +4 Four +6 Six +8 Eight +SELECT * FROM tsp; +a b +112 Hundred twelve +114 Hundred fourteen +116 Hundred sixteen +118 Hundred eightteen +12 twelve +122 Hundred twenty-two +124 Hundred twenty-four +126 Hundred twenty-six +128 Hundred twenty-eight +14 Fourteen +16 Sixteen +162 Hundred sixty-two +164 Hundred sixty-four +166 Hundred sixty-six +168 Hundred sixty-eight +18 Eightteen +182 Hundred eight-two +184 Hundred eighty-four +186 Hundred eighty-six +188 Hundred eighty-eight +2 Two +4 Four +6 Six +8 Eight +SELECT * FROM tsp_00; +a b +5 Five +SELECT * FROM tsp_01; +a b +1 One +SELECT * FROM tsp_02; +a b +SELECT * FROM tsp_03; +a b +3 Three +SELECT * FROM tsp_04; +a b +9 Nine +ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10; +SELECT * FROM t_10; +a b +2 Two +4 Four +6 Six +8 Eight +SELECT * FROM tp WHERE a BETWEEN 0 AND 10; +a b +1 One +3 Three +5 Five +9 Nine +ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10; +SELECT * FROM t_10; +a b +1 One +3 Three +5 Five +9 Nine +SELECT * FROM tp WHERE a BETWEEN 0 AND 10; +a b +2 Two +4 Four +6 Six +8 Eight +ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_empty; +SELECT * FROM t_empty; +a b +2 Two +4 Four +6 Six +8 Eight +SELECT * FROM tp WHERE a BETWEEN 0 AND 10; +a b +ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_empty; +SELECT * FROM t_empty; +a b +SELECT * FROM tp WHERE a BETWEEN 0 AND 10; +a b +2 Two +4 Four +6 Six +8 Eight +ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_null; +SELECT * FROM t_null; +a b +2 Two +4 Four +6 Six +8 Eight +SELECT * FROM tp WHERE a BETWEEN 0 AND 10; +a b +1 NULL +ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_null; +SELECT * FROM t_null; +a b +1 NULL +SELECT * FROM tp WHERE a BETWEEN 0 AND 10; +a b +2 Two +4 Four +6 Six +8 Eight +ALTER TABLE tp EXCHANGE PARTITION p1 WITH TABLE t_100; +SELECT * FROM t_100; +a b +12 twelve +14 Fourteen +16 Sixteen +18 Eightteen +SELECT * FROM tp WHERE a BETWEEN 10 AND 100; +a b +11 Eleven +13 Thirdteen +15 Fifeteen +19 Nineteen +91 Ninety-one +93 Ninety-three +95 Ninety-five +99 Ninety-nine +ALTER TABLE tp EXCHANGE PARTITION p1 WITH TABLE t_100; +SELECT * FROM t_100; +a b +11 Eleven +13 Thirdteen +15 Fifeteen +19 Nineteen +91 Ninety-one +93 Ninety-three +95 Ninety-five +99 Ninety-nine +SELECT * FROM tp WHERE a BETWEEN 10 AND 100; +a b +12 twelve +14 Fourteen +16 Sixteen +18 Eightteen +ALTER TABLE tp EXCHANGE PARTITION p2 WITH TABLE t_1000; +SELECT * FROM t_1000; +a b +112 Hundred twelve +114 Hundred fourteen +116 Hundred sixteen +118 Hundred eightteen +122 Hundred twenty-two +124 Hundred twenty-four +126 Hundred twenty-six +128 Hundred twenty-eight +162 Hundred sixty-two +164 Hundred sixty-four +166 Hundred sixty-six +168 Hundred sixty-eight +182 Hundred eighty-two +184 Hundred eighty-four +186 Hundred eighty-six +188 Hundred eighty-eight +SELECT * FROM tp WHERE a BETWEEN 100 AND 1000; +a b +111 Hundred elven +113 Hundred thirdteen +115 Hundred fiveteen +119 Hundred nineteen +131 Hundred thirty-one +133 Hundred thirty-three +135 Hundred thirty-five +139 Hundred thirty-nine +151 Hundred fifty-one +153 Hundred fifty-three +155 Hundred fity-five +159 Hundred fifty-nine +191 Hundred ninety-one +193 Hundred ninety-three +195 Hundred ninety-five +199 Hundred ninety-nine +ALTER TABLE tp EXCHANGE PARTITION p2 WITH TABLE t_1000; +SELECT * FROM t_1000; +a b +111 Hundred elven +113 Hundred thirdteen +115 Hundred fiveteen +119 Hundred nineteen +131 Hundred thirty-one +133 Hundred thirty-three +135 Hundred thirty-five +139 Hundred thirty-nine +151 Hundred fifty-one +153 Hundred fifty-three +155 Hundred fity-five +159 Hundred fifty-nine +191 Hundred ninety-one +193 Hundred ninety-three +195 Hundred ninety-five +199 Hundred ninety-nine +SELECT * FROM tp WHERE a BETWEEN 100 AND 1000; +a b +112 Hundred twelve +114 Hundred fourteen +116 Hundred sixteen +118 Hundred eightteen +122 Hundred twenty-two +124 Hundred twenty-four +126 Hundred twenty-six +128 Hundred twenty-eight +162 Hundred sixty-two +164 Hundred sixty-four +166 Hundred sixty-six +168 Hundred sixty-eight +182 Hundred eighty-two +184 Hundred eighty-four +186 Hundred eighty-six +188 Hundred eighty-eight +ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00; +ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE tsp_01; +ALTER TABLE tsp EXCHANGE PARTITION sp02 WITH TABLE tsp_02; +ALTER TABLE tsp EXCHANGE PARTITION sp03 WITH TABLE tsp_03; +ALTER TABLE tsp EXCHANGE PARTITION sp04 WITH TABLE tsp_04; +SELECT * FROM tsp_00; +a b +SELECT * FROM tsp_01; +a b +6 Six +SELECT * FROM tsp_02; +a b +2 Two +SELECT * FROM tsp_03; +a b +8 Eight +SELECT * FROM tsp_04; +a b +4 Four +SELECT * FROM tsp WHERE a BETWEEN 0 AND 10; +a b +1 One +3 Three +5 Five +9 Nine +ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00; +ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE tsp_01; +ALTER TABLE tsp EXCHANGE PARTITION sp02 WITH TABLE tsp_02; +ALTER TABLE tsp EXCHANGE PARTITION sp03 WITH TABLE tsp_03; +ALTER TABLE tsp EXCHANGE PARTITION sp04 WITH TABLE tsp_04; +SELECT * FROM tsp_00; +a b +5 Five +SELECT * FROM tsp_01; +a b +1 One +SELECT * FROM tsp_02; +a b +SELECT * FROM tsp_03; +a b +3 Three +SELECT * FROM tsp_04; +a b +9 Nine +SELECT * FROM tsp WHERE a BETWEEN 0 AND 10; +a b +2 Two +4 Four +6 Six +8 Eight +ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE t_null; +SELECT * FROM t_null; +a b +6 Six +SELECT * FROM tsp WHERE a BETWEEN 0 AND 10; +a b +1 NULL +2 Two +4 Four +8 Eight +ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE t_null; +SELECT * FROM t_null; +a b +1 NULL +SELECT * FROM tsp WHERE a BETWEEN 0 AND 10; +a b +2 Two +4 Four +6 Six +8 Eight +DROP TABLE IF EXISTS t_10; +DROP TABLE IF EXISTS t_100; +DROP TABLE IF EXISTS t_1000; +DROP TABLE IF EXISTS tp; +DROP TABLE IF EXISTS tsp; +DROP TABLE IF EXISTS tsp_00; +DROP TABLE IF EXISTS tsp_01; +DROP TABLE IF EXISTS tsp_02; +DROP TABLE IF EXISTS tsp_03; +DROP TABLE IF EXISTS tsp_04; +DROP TABLE IF EXISTS t_empty; +DROP TABLE IF EXISTS t_null; |