1
CREATE DATABASE test_2;
6
--source suite/parts/inc/part_exch_tabs.inc
9
--source suite/parts/inc/part_exch_tabs.inc
15
# 10) Exchanges with different databases.
16
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE test_2.t_10;
18
SELECT * FROM test_2.t_10;
20
SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
21
# Back to former values.
22
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE test_2.t_10;
24
SELECT * FROM test_2.t_10;
26
SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
27
ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE test_2.tsp_00;
29
SELECT * FROM test_2.tsp_00;
31
SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
32
# Back to former values.
33
ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE test_2.tsp_00;
35
SELECT * FROM test_2.tsp_00;
37
SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
39
--source suite/parts/inc/part_exch_drop_tabs.inc
41
--source suite/parts/inc/part_exch_drop_tabs.inc