Hi, Holyfoot! On Dec 09, holyfoot@askmonty.org wrote:
At file:///home/hf/wmar/mdev-5138/
------------------------------------------------------------ revno: 3995 revision-id: holyfoot@askmonty.org-20131209020845-9o3l30ao90vzf600 parent: holyfoot@askmonty.org-20131208143921-3veatgg9wngyzb47 committer: Alexey Botchkov <holyfoot@askmonty.org> branch nick: mdev-5138 timestamp: Mon 2013-12-09 06:08:45 +0400 message: MDEV-5138 Numerous test failures in "mtr --ps --embedded". If a prepared statement calls an stored procedure, the thd->server_status out of the SP goes up to the PS and then to the client. So that the client gets the SERVER_STATUS_CURSOR_EXISTS status if the SP uses a cursor. Which makes the embedded server fail.
Why does embedded fail while a normal client-server protocol is ok with that?
Fixed by saving/restoring the upper-level server_status in sp_head::execute().
Regards, Sergei