EVOLUTION-MANAGER

Edit File: partition_exch_qa_11.test

# Author: Horst Hunger # Created: 2010-07-13 --source include/have_partition.inc let $engine_table= MYISAM; let $engine_part= MYISAM; let $engine_subpart= MYISAM; use test; --disable_result_log --disable_query_log --source suite/parts/inc/part_exch_tabs.inc --enable_result_log --enable_query_log # 13) Exchange with dynamic variables. SET @part= 'p0'; SET @part_tab= 'tp'; SET @table= 't_10'; SET @s= CONCAT('ALTER TABLE ',@part_tab,' EXCHANGE PARTITION ',@part,' WITH TABLE ',@table); PREPARE test_stmt1 FROM @s; EXECUTE test_stmt1; --sorted_result SELECT * FROM t_10; --sorted_result SELECT * FROM tp; DEALLOCATE PREPARE test_stmt1; SET @part_tab= 'tp'; SET @s= CONCAT('ALTER TABLE ',@part_tab,' EXCHANGE PARTITION ? WITH TABLE ?'); --error ER_PARSE_ERROR PREPARE test_stmt2 FROM @s; --source suite/parts/inc/part_exch_drop_tabs.inc