Bug #20317 Test fails in "embedded" because only one thread is running
Submitted: 7 Jun 2006 13:13 Modified: 2 Aug 2006 17:54
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1.11-beta OS:Any (all)
Assigned to: Alexey Botchkov CPU Architecture:Any

[7 Jun 2006 13:13] Joerg Bruehe 
Description:
Build of 5.1.11-beta.

The following diff shows up in all "embedded" runs:

-------------------------------------------------------
*** r/ps_1general.result
--- r/ps_1general.reject
***************
*** 299,305
  prepare stmt4 from ' show status like ''Threads_running'' ';
  execute stmt4;
  Variable_name Value
! Threads_running       2
  prepare stmt4 from ' show variables like ''sql_mode'' ';
  execute stmt4;
  Variable_name Value
--- 299,305
  prepare stmt4 from ' show status like ''Threads_running'' ';
  execute stmt4;
  Variable_name Value
! Threads_running       1
  prepare stmt4 from ' show variables like ''sql_mode'' ';
  execute stmt4;
  Variable_name Value
***************

How to repeat:
Run the test suite on an embedded build.

Suggested fix:
Split the test into general parts and those which work only with a multi-threaded server.
[26 Jul 2006 21:22] Jim Winstead 
Patch looks good to me.
[2 Aug 2006 17:54] Paul DuBois 
No changelog entry needed.