MySQL Bugs: #36032: Test funcs_1.processlist_priv

Bug #36032	Test funcs_1.processlist_priv_ps fails on Windows
Submitted:	13 Apr 2008 17:04	Modified:	1 May 2008 19:12
Reporter:	Patrick Crews	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Server	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Windows
Assigned to:	Patrick Crews	CPU Architecture:	Any
Tags:	funcs_1, Tests, windows

Description:
Test funcs_1.processlist_priv.ps is failing on Windows (pushbuild, especially)

It appears that queries invoking SHOW PROCESSLIST do not take into account the host:client_port format -- expected results are only localhost, without a port number.

Example diff output from test failure:
SHOW processlist;
22031:  Id	User	Host	db	Command	Time	State	Info
22032: -ID	root	localhost	information_schema	Query	TIME	NULL	SHOW processlist
22033: -ID	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
22034: +ID	root	localhost:9466	information_schema	Query	TIME	NULL	SHOW processlist
22035: +ID	ddicttestuser1	localhost:9467	information_schema	Sleep	TIME		NULL

How to repeat:
Run the test on a Windows system:

From the mysql-test directory, execute the following command:

./mysql-test-run.pl --suite=funcs_1 --ps-protocol processlist_priv.ps

You should see the test failing for similar mismatches localhost:<port> vs localhost in the expected results

Suggested fix:
Alter the test with a --replace_column call to account for the variability of the HOST value.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/45722

ChangeSet@1.2584, 2008-04-17 20:17:00-04:00, pcrews@pcrews-mac-local.local +9 -0
  Bug#36032
  Bug#36033
  Bug#36034
  Bug#36036
  Bug#36037
  Bug#36038
  Bug#36039
  Bug#36040
  
  Fixes the tests that are failing for these bugs.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/45723

ChangeSet@1.2579, 2008-04-17 19:02:54-04:00, pcrews@pcrews-mac-local.local +8 -0
  Bug#36032 - funcs_1.processlist_priv_ps fails on Windows
  Bug#36033 - funcs_1.processlist_val_ps fails on Windows
  Bug#36034 - parts.part_supported_sql_func_<eng> fails on Windows
  Bug#36036 - parts_partition_alter1_<eng> fails on Windows
  Bug#36037 - parts.partition_alter2_<eng> fails on Windows
  Bug#36038 - parts.partition_basic_<eng> fails on Windows
  Bug#36039 - parts.partition_engine_<eng> fails on Windows
  Bug#36040 - parts.partition_syntax_<eng> fails on Windows.
  
  Various changes to fix these bugs.  Tested on Windows and MacOS (*Nix) to ensure we didn't break anything on one to fix the other.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/46065

ChangeSet@1.2567, 2008-04-26 19:52:43-04:00, pcrews@pcrews-mac-local.local +10 -0
  Bug#36032 - Test funcs_1.processlist_priv_ps fails on Windows
  Bug#36033 - Test funcs_1.processlist_val_ps fails on Windows
  Bug#36034 - Test parts.part_supported_sql_func_<eng> fails on Windows
  Bug#36036 - Test parts.partition_alter1_<eng> fails on Windows
  Bug#36037 - Test parts.partition_alter2_<eng> fails on Windows
  Bug#36038 - Test parts.partition_basic_<engine> failing on Windows
  Bug#36039 - Test parts.partition_engine_<eng> fails on Windows
  Bug#36040 - Test parts.partition_syntax_<eng> fails on Windows
  
  Changeset to fix multiple 5.1.24-rc build bugs on Windows platforms.
  
  Many of these bugs had the same root causes.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/46077

ChangeSet@1.2631, 2008-04-27 14:13:00-04:00, pcrews@pcrews-mac-local.local +4 -0
  Bug#36032 - Test funcs_1.processlist_priv_ps fails on Windows
  Bug#36033 - Test funcs_1.processlist_val_ps fails on Windows
  
  Changes to .result files to account for differences between 6.0 and 5.1

Pushed into 5.1.25-rc

Pushed into 6.0.6-alpha

Test suite changes. No changelog entry needed.