Bug #36033 Test funcs_1.processlist_val_ps fails on Windows

• Submitted: 13 Apr 2008 17:12
• Modified: 1 May 2008 19:13
• Reporter: Patrick Crews
• Status: Closed
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Windows
• Assigned to: Patrick Crews
• CPU Architecture: Any
• Tags: funcs_1, Tests, windows

[13 Apr 2008 17:12] Patrick Crews

Description:
Test funcs_1.processlist_val.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_val.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.

[1 May 2008 6:17] Bugs System

Pushed into 5.1.25-rc

[1 May 2008 6:19] Bugs System

Pushed into 6.0.6-alpha

[1 May 2008 19:13] Paul DuBois

Test suite changes. No changelog entry needed.