 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_00; --sorted_result SELECT * FROM t_00; --sorted_result SELECT * FROM tp WHERE a BETWEEN 0 AND 00; # Back to former values. ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_00; --sorted_result SELECT * FROM t_00; --sorted_result SELECT * FROM tp WHERE a BETWEEN 0 AND 00; ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00; --sorted_result SELECT * FROM tsp_00; --sorted_result SELECT * FROM tsp WHERE a BETWEEN 0 AND 00; # Back to former values. ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00; --sorted_result SELECT * FROM tsp_00; --sorted_result SELECT * FROM tsp WHERE a BETWEEN 0 AND 00; --echo disconnect test0; disconnect test0;  --echo connection default; connection default; 