As the bug was already fixed, just testcase added here

don't evaluate subqueries during statement prepare, even if they
are not correlated.
With post-review fixes.

(Bug which caused its failure before was fixed in the beginning of March
 by the ChangeSet that introduced improved SP-locking).

into rurik.mysql.com:/home/igor/mysql-5.0

into rurik.mysql.com:/home/igor/dev/mysql-5.0-0

into frost.snake.net:/Volumes/frost2/MySQL/bk/mysql-5.0

into frost.snake.net:/Volumes/frost2/MySQL/bk/mysql-5.0

into rurik.mysql.com:/home/igor/dev/mysql-5.0-0

  Added missing ';'.

into mysql.com:/home/cps/mysql/trees/mysql-5.0

into rurik.mysql.com:/home/igor/mysql-4.1

into rurik.mysql.com:/home/igor/dev/mysql-5.0-0

  Fixed bug #9899: erronious NOT_NULL flag for some attributes
  in the EXPLAIN table.

into rurik.mysql.com:/home/igor/mysql-5.0

into rurik.mysql.com:/home/igor/mysql-5.0

into mysql.com:/home/cps/mysql/trees/mysql-5.0

into mysql.com:/space/my/mysql-5.0

into mysql.com:/home/my/mysql-4.1

into mysql.com:/opt/local/work/mysql-5.0-7306-final

into mysql.com:/home/cps/mysql/trees/mysql-5.0

Fix instead wrong call to ha_key_cmp
This is related to bug #10741 Inserting double value into utf8 column crashes server

into rurik.mysql.com:/home/igor/dev/mysql-5.0-0

  Removed an extra space char.

into mysql.com:/opt/local/work/mysql-5.0-7306-final

into mysql.com:/home/dlenev/src/mysql-5.0-bg10015

We should not allow explicit or implicit transaction commits inside
of stored functions or triggers (so in autocommit mode we should not
do commits after execution of sub-statement).
Also since we don't support nested statement transactions in 5.0,
we shouldn't commit or rollback stmt transactions while we are inside
stored functions or triggers. This should be fixed in later (>=5.1)
releases.

into hundin.mysql.fi:/home/heikki/mysql-5.0

into a193-229-222-105.elisa-laajakaista.fi:/home/my/bk/mysql-5.0

into a193-229-222-105.elisa-laajakaista.fi:/home/my/bk/mysql-5.0

into mysql.com:/space/my/mysql-5.0

  better fix for bug#10190

into rurik.mysql.com:/home/igor/dev/mysql-4.1-0

 error for LIMIT placeholder".
The patch adds grammar support for LIMIT ?, ? and changes the
type of ST_SELECT_LEX::select_limit,offset_limit from ha_rows to Item*,
so that it can point to Item_param.