1CREATE USER test_2@localhost; 2send 3ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10; 4connect (test_2,localhost,test_2,,test,MASTER_MYPORT,MASTER_MYSOCK); 5SELECT * FROM t_10; 6a b 72 Two 84 Four 96 Six 108 Eight 11SELECT * FROM tp WHERE a BETWEEN 0 AND 10; 12a b 131 One 143 Three 155 Five 169 Nine 17INSERT INTO tp VALUES (7,"Seven"); 18SELECT * FROM tp WHERE a BETWEEN 0 AND 10; 19a b 201 One 213 Three 225 Five 237 Seven 249 Nine 25ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10; 26connection default; 27reap; 28SELECT * FROM t_10; 29a b 301 One 313 Three 325 Five 337 Seven 349 Nine 35SELECT * FROM tp WHERE a BETWEEN 0 AND 10; 36a b 372 Two 384 Four 396 Six 408 Eight 41Warning 1287 The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead. 42Warnings: 43connection test_2; 44SELECT * FROM t_10; 45a b 461 One 473 Three 485 Five 497 Seven 509 Nine 51SELECT * FROM tp WHERE a BETWEEN 0 AND 10; 52a b 532 Two 544 Four 556 Six 568 Eight 57disconnect test_2; 58connection default; 59SELECT * FROM t_10; 60a b 611 One 623 Three 635 Five 647 Seven 659 Nine 66SELECT * FROM tp WHERE a BETWEEN 0 AND 10; 67a b 682 Two 694 Four 706 Six 718 Eight 72DROP TABLE IF EXISTS t_10; 73DROP TABLE IF EXISTS t_100; 74DROP TABLE IF EXISTS t_1000; 75DROP TABLE IF EXISTS tp; 76DROP TABLE IF EXISTS tsp; 77DROP TABLE IF EXISTS tsp_00; 78DROP TABLE IF EXISTS tsp_01; 79DROP TABLE IF EXISTS tsp_02; 80DROP TABLE IF EXISTS tsp_03; 81DROP TABLE IF EXISTS tsp_04; 82DROP TABLE IF EXISTS t_empty; 83DROP TABLE IF EXISTS t_null; 84DROP USER test_2@localhost; 85