MySQL Bugs: #8787: Test 'view' fails: PS protocol, correlated subquery

Bug #8787	Test 'view' fails: PS protocol, correlated subquery
Submitted:	24 Feb 2005 17:51	Modified:	7 Apr 2005 18:42
Reporter:	Joerg Bruehe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.3-pre	OS:	HP/UX (HP-UX, 32 bit)
Assigned to:	Oleksandr Byelkin	CPU Architecture:	Any

Description:
Build based on changeset
  1.1840.1.1 05/02/24 12:17:59 ramil@mysql.com +1 -0
  A fix (mysql_priv.h should be included first)

Test 'view' passes in default mode, but crashes the server if run '--ps-protocol'. Message:

view                           [ fail ]

Errors are (from /var/tmp/mysqldev/hpux11/test/mysql-debug-5.0.3-alpha-hp-hpux11.11-hppa2.0w/mysql-test/var/log/mysqltest-time) :
/var/tmp/mysqldev/hpux11/test/mysql-debug-5.0.3-alpha-hp-hpux11.11-hppa2.0w/bin/mysqltest: At line 1716: unable to execute statement 'select s2 from v1 vq1 where 2 = (select count(*) aa from v1 vq2 having vq1.s2 = aa)': Lost connection to MySQL server during query (mysql_stmt_errno=2013 returned=1)
(the last lines may be the most important ones)

Ending Tests
Shutting-down MySQL daemon

master not cooperating with mysqladmin, will try manual kill
kill: 28339: The specified process does not exist.
master refused to die. Sending SIGKILL
kill: 28339: The specified process does not exist.
Master shutdown finished
Slave shutdown finished
view_query_cache               [ pass ]

How to repeat:
Build and run the test suite.

I have the same exact problem on production.mysql.com, and have had this problem since Feb 25th, while testing my Federated patch. The directory is on production in ~/patg/mysql-5.0 (logged in as mysqldev).

Does not occur with latest 5.0.4 build anymore.