Bug #7687 INSERT DELAYED test case delayed.test fails on Windows

• Submitted: 5 Jan 2005 14:13
• Modified: 5 Jan 2005 15:02
• Reporter: Kent Boortz
• Status: Not a Bug
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 4.1.9pre
• OS: Windows (Windows)
• CPU Architecture: Any

[5 Jan 2005 14:13] Kent Boortz

Description:
The test case "delayed.test" fails on Windows XP (other Windows versions not tested). The first sequence of inserts and select succeeds, but the second one fails. Increasing
the --sleep 2 to --sleep 10, doesn't help. The test sequence that fails is

  create table t1 (a int not null auto_increment primary key, b char(10));
  insert delayed into t1 values (1,"b");
  insert delayed into t1 values (null,"c");
  insert delayed into t1 values (3,"d"),(null,"e");
  (last line should fail with an error)
  insert delayed into t1 values (3,"this will give an","error");
  (a delay)
  select * from t1;
  (the table is empty)

How to repeat:
Install the latest snapshot of what will become mysql-4.1.9 on Windows XP,
terminate other mysqld processes that might interfere, and do

  % cd mysql-test
  % mysql_test_run_new.exe delayed

When terminated, evaluate the result inspecting the files

  mysql-test-run.log
  r/delayed.result
  r/delayed.reject

[5 Jan 2005 15:02] Kent Boortz

The failure was not in the INSERT DELAYED, instead it was the test program that
didn't function correctly, the --sleep 2 was a zero second delay.