Bug #18982 im_options_unset test fails
Submitted: 10 Apr 2006 19:21 Modified: 12 Apr 2006 10:13
Reporter: Brian Pontz Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.9-pre OS:SunOS 5.9 i86pc i386
Assigned to: Assigned Account CPU Architecture:Any

[10 Apr 2006 19:21] Brian Pontz
Description:
im_options_unset               [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/im_options_unset.result
--- r/im_options_unset.reject
***************
*** 2,15
  server_id           =2
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     1
  UNSET mysqld1.server_id;
  server_id           =2
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     1
  UNSET mysqld2.server_id;
  FLUSH INSTANCES;
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     1
---  server_id           =2
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     11
  UNSET mysqld1.server_id;
  server_id           =2
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     11
  UNSET mysqld2.server_id;
  FLUSH INSTANCES;
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     11
 2,15

How to repeat:
run test mentioned above
[12 Apr 2006 10:13] Alexander Barkov
Duplicate to http://bugs.mysql.com/bug.php?id=18027