diff options
author | Sergey Vojtovich <svoj@mariadb.org> | 2013-09-27 16:58:49 +0400 |
---|---|---|
committer | Sergey Vojtovich <svoj@mariadb.org> | 2013-09-27 16:58:49 +0400 |
commit | 47a240c6bc994ddc26ff139050b16649137cb3ce (patch) | |
tree | e59a8bf3425542dd1604a5be4487b248af47b747 /mysql-test/suite/parts/r/partition_exch_qa_4_innodb.result | |
parent | a695674001c933ff6bf0fdbdf3b05436c50bd5bc (diff) | |
download | mariadb-git-47a240c6bc994ddc26ff139050b16649137cb3ce.tar.gz |
MDEV-4864 - Merge tests for EXCHANGE PARTITION feature
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; |