Moved the test cases for parallel execution from stat_tables.test

into a separate file stat_tables_par.test because the test cases
could not be run with embedded server.

1 files changed, 0 insertions, 112 deletions

diff --git a/mysql-test/t/stat_tables.test b/mysql-test/t/stat_tables.test
index 40c4c17c569..640f9febc75 100644
--- a/mysql-test/t/stat_tables.test
+++ b/mysql-test/t/stat_tables.test
@@ -1,5 +1,4 @@
 --source include/have_stat_tables.inc
---source include/have_debug_sync.inc
 
 set @save_use_stat_tables=@@use_stat_tables;
 
@@ -145,117 +144,6 @@ eval $QQ1;
 
 set optimizer_switch=@save_optimizer_switch;
 
-#
-# Test for parallel memory allocation for statistical data
-# 
-#    assumes that start the code of memory allocation for stats data has this line:
-#
-#       DEBUG_SYNC(thd, "statistics_mem_alloc_start1");
-#       DEBUG_SYNC(thd, "statistics_mem_alloc-start2");
-#
-
-let $Q6=
-select sum(l_extendedprice*l_discount) as revenue
-from lineitem
-where l_shipdate >= date '1994-01-01' 
-      and l_shipdate < date '1994-01-01' + interval '1' year
-      and l_discount between 0.06 - 0.01 and 0.06 + 0.01
-      and l_quantity < 24;
-
-flush table lineitem;
-set use_stat_tables='never';
-eval $Q6;
-
-connect (con1, localhost, root,,);
-connect (con2, localhost, root,,);
-
-connection con1;
-set debug_sync='statistics_mem_alloc_start1  WAIT_FOR second_thread_started_too';
-set debug_sync='statistics_mem_alloc_start2  SIGNAL first_thread_working';
-use dbt3_s001;
-set use_stat_tables='preferably';
---send_eval $Q6                                            
-
-connection con2;
-set debug_sync='statistics_mem_alloc_start1  SIGNAL second_thread_started_too';
-set debug_sync='statistics_mem_alloc_start2  WAIT_FOR first_thread_working';
-use dbt3_s001;
-set use_stat_tables='preferably';
---send_eval $Q6
-
-connection con1;
---reap
-
-connection con2;
---reap
-
-connection default;
-set use_stat_tables='preferably';
-disconnect con1;
-disconnect con2;
-set debug_sync='RESET';
-
-#
-# Test for parallel statistics collection
-# 
-#    assumes that start of stats collection code has this line:
-#
-#       DEBUG_SYNC(thd, "statistics_collection_start1");
-#       DEBUG_SYNC(thd, "statistics_collection_start2");
-#
-
-select * from mysql.index_stat where table_name='lineitem' order by index_name;
-delete from mysql.index_stat 
-  where table_name='lineitem' and
-        index_name in ('i_l_shipdate', 'i_l_receiptdate');
-select * from mysql.index_stat where table_name='lineitem' order by index_name;
---disable_result_log
---disable_warnings
-analyze table lineitem persistent for columns() indexes (i_l_shipdate);
---enable_warnings
---enable_result_log
-select * from mysql.index_stat where table_name='lineitem' order by index_name;
-delete from mysql.index_stat 
-  where table_name='lineitem' and index_name= 'i_l_shipdate';
-select * from mysql.index_stat where table_name='lineitem' order by index_name;
-
-connect (con1, localhost, root,,);
-connect (con2, localhost, root,,);
-
-connection con1;
-set debug_sync='statistics_collection_start1  WAIT_FOR second_thread_started_too';
-set debug_sync='statistics_collection_start2  SIGNAL first_thread_working';
-use dbt3_s001;
-set use_stat_tables='preferably';
---send analyze table lineitem persistent for columns() indexes (i_l_shipdate)
-
-connection con2;
-set debug_sync='statistics_collection_start1  SIGNAL second_thread_started_too';
-set debug_sync='statistics_collection_start2  WAIT_FOR first_thread_working';
-use dbt3_s001;
-set use_stat_tables='preferably';
---send analyze table lineitem persistent for columns() indexes (i_l_receiptdate)
-
-connection con1;
---disable_result_log
---disable_warnings
---reap
---enable_warnings
---enable_result_log
-
-connection con2;
---disable_result_log
---disable_warnings
---reap
---enable_warnings
---enable_result_log
-
-connection default;
-disconnect con1;
-disconnect con2;
-set debug_sync='RESET';
-
-select * from mysql.index_stat where table_name='lineitem' order by index_name;
 
 DROP DATABASE dbt3_s001;