Bug #8824 Subquery with now() breaks cluster

Description:
I have a cluster of three MySQL machines running 4.1.10.  Two of the machines are running both ndbd and mysqld, and the third runs ndb_mgmd.  There are a few databases which contain clustered tables, but they aren't used in this bug.  Running a query that uses now() in a subquery causes the API node to crash.

Not sure if this is common to all SuSE9.2 installs running 4.1.10, or if it requires a cluster to exist as well.  

How to repeat:
dbadmin@node1:/usr/local/mysql> mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.10-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from (select now() as foo) as bar;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> select * from (select now() as foo) as bar;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: *** NONE ***

ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>

Further testing shows that the alias on now() is not required.  Adjusting synopsis.

tested quickly in 5.0 src tree without cluster, same problem

concluded it is not cluster specific, changing category to server

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/internals/23308

Thank you for bugreport. bugfix is pushed into source tree marked as 4.1.11.

Noted in 4.1.11 changelog.