Bug #18988 sp test case fails
Submitted: 10 Apr 2006 20:21 Modified: 2 Aug 2006 9:41
Reporter: Brian Pontz Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:5.0.21, 5.1.9-pre OS:powermacg5
Assigned to: CPU Architecture:Any

[10 Apr 2006 20:21] Brian Pontz
Description:
sp                             [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line NNN: query 'select bug2674()' failed: 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)
Result from queries before failure can be found in r/sp.log

Killing Possible Leftover Processes

powermacg5-5.1-community.log   debug

How to repeat:
run test as specified on powermac
[26 Apr 2006 12:43] Per-Erik Martin
This happens in 5.0 as well.
[26 Apr 2006 13:57] Per-Erik Martin
The crash is in the test function bug2674:
create function bug2674() returns int
  return @@sort_buffer_size;

It's not specific for sort_buffer_size, returning some other system variable, e.g.sql_max_join_size, causes the same crash.

The crash is in THD::rollback_item_tree_changes() - on return, the C call stack has been trashed.
[2 Jun 2006 14:50] Konstantin Osipov
Brian, I believe this has been fixed already (by the fix for Bug#18037).
Could you please verify it again?
[2 Aug 2006 9:41] Konstantin Osipov
This doesn't happen anymore.