wait_show_pattern.inc 1.11 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
# include/wait_show_pattern.inc
#
# SUMMARY
#
#   Waits until output produced by SHOW statement which particular type is
#   specified as parameter matches certain pattern or maximum time reached.
#
# NOTES
#
#   Only the first row produced by the parameter statement is checked.
#
# USAGE
#
#   let $show_type= <Tail of SHOW statement>;
#   let $show_pattern= 'Pattern to be used for LIKE matching';
#   --source wait_show_pattern.inc
#
# EXAMPLES
# 
#   alter_table-big.test, wait_slave_status.inc
#
# SEE ALSO
#
#   wait_slave_status.inc, wait_condition.inc (>=5.1)
#
###############################################################################

--disable_query_log

# We accept to wait maximum 30 seconds (0.2 sec/loop).
let $wait_counter= 150;
while ($wait_counter)
{
  let $result= `SHOW $show_type`;
35
  let $success= `SELECT "$result" LIKE $show_pattern`;
36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
  if ($success)
  {
    let $wait_counter= 0;
  }
  if (!$success)
  {
    real_sleep 0.2;
    dec $wait_counter;
  }
}
if (!$success)
{
  echo Timeout in wait_show_pattern.inc \$show_type= $show_type \$show_pattern= $show_pattern (\$result= '$result');
}

--enable_query_log