Bug #36693 stored procedure, derived table crash
Submitted: 13 May 2008 17:43 Modified: 29 Mar 19:13
Reporter: Shane Bester
Status: Analyzing
Category:Server: DML Severity:S1 (Critical)
Version:5.0.66a,5.1.24 OS:Any
Assigned to: Shane Bester Target Version:

[13 May 2008 17:43] Shane Bester 
Description:
testing some stored procedures on 5.1.24, I got this crash:

mysqld.exe!Item_ref::fix_fields
mysqld.exe!Item_func::fix_fields
mysqld.exe!JOIN::prepare
mysqld.exe!st_select_lex_unit::prepare
mysqld.exe!mysql_derived_prepare
mysqld.exe!mysql_handle_derived
mysqld.exe!open_and_lock_tables_derived
mysqld.exe!execute_sqlcom_select
mysqld.exe!mysql_execute_command
mysqld.exe!sp_instr_stmt::exec_core
mysqld.exe!sp_lex_keeper::reset_lex_and_exec_core
mysqld.exe!sp_instr_stmt::execute
mysqld.exe!sp_head::execute
mysqld.exe!sp_head::execute_procedure
mysqld.exe!mysql_execute_command
mysqld.exe!mysql_parse
mysqld.exe!dispatch_command
mysqld.exe!do_command
mysqld.exe!handle_one_connection
mysqld.exe!pthread_start
mysqld.exe!_threadstart
kernel32.dll!FlsSetValue

How to repeat:
don't know yet.
[2 Jan 9:37] Shane Bester 
probably a duplicate of bug #41802
[23 Mar 16:59] Susanne Ebrecht 
I have some questions:

1) did you upgrade from 5.0 to 5.1 and didn't use mysql_upgrade?
2) would you provide a reproducable procedure that you tested?