EVOLUTION-MANAGER

Edit File: partition_exch_qa_4_myisam.result

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;