--disable_abort_on_error let $sess2_last_number1= 0; let $sess2_run1= 1; while ($sess2_run1) { connection con2; --disable_query_log SET @sess2_test_found = 0; --disable_warnings eval SELECT test_number, 1 INTO @sess2_test_number, @sess2_test_found FROM t99_actions WHERE test_number >= $sess2_last_number1 ORDER BY test_number ASC LIMIT 1; --enable_warnings --enable_query_log let $sess2_run1= `SELECT @sess2_test_found`; if ($sess2_run1) { let $sess2_last_number1= `SELECT @sess2_test_number + 1`; ##### Now both sessions know the tests to be executed #### --enable_query_log --echo #--------------------------------------------------------------------------# # session 1 executes it's part --echo connection con1; connection con1; # Example: $sess1_command contains "PREPARE s1 FROM 'SELECT 1'" eval $sess1_command; EXECUTE s1; # # session 2 executes it's part --echo connection con2; connection con2; --source include/ml0501.inc # # session 1 executes it's parsed statement again --echo connection con1; connection con1; EXECUTE s1; # # session 2 executes it's part again --echo connection con2; connection con2; --source include/ml0501.inc # # session 1 executes it's parsed statement again --echo connection con1; connection con1; EXECUTE s1; } # End of block to be executed, if there was a valid test for session 2 } # End of session 2 test loop --enable_abort_on_error