diff options
Diffstat (limited to 'mysql-test/suite/parts/r/partition_exch_qa_4_innodb.result')
-rwxr-xr-x | mysql-test/suite/parts/r/partition_exch_qa_4_innodb.result | 76 |
1 files changed, 76 insertions, 0 deletions
diff --git a/mysql-test/suite/parts/r/partition_exch_qa_4_innodb.result b/mysql-test/suite/parts/r/partition_exch_qa_4_innodb.result new file mode 100755 index 00000000000..35f3499fce7 --- /dev/null +++ b/mysql-test/suite/parts/r/partition_exch_qa_4_innodb.result @@ -0,0 +1,76 @@ +CREATE DATABASE test_2; +USE test; +USE test; +ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE test_2.t_10; +SELECT * FROM test_2.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 test_2.t_10; +SELECT * FROM test_2.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 tsp EXCHANGE PARTITION sp00 WITH TABLE test_2.tsp_00; +SELECT * FROM test_2.tsp_00; +a b +SELECT * FROM tsp WHERE a BETWEEN 0 AND 10; +a b +2 Two +4 Four +5 Five +6 Six +8 Eight +ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE test_2.tsp_00; +SELECT * FROM test_2.tsp_00; +a b +5 Five +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; +USE test_2; +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; +USE test; +DROP DATABASE test_2; |