Bug #36693 stored procedure, derived table crash

• Submitted: 13 May 2008 15:43
• Modified: 6 May 2010 7:32
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Can't repeat
• Category: MySQL Server: DML
• Severity: S1 (Critical)
• Version: 5.0.66a,5.1.24
• OS: Any
• CPU Architecture: Any

[13 May 2008 15: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 2009 8:37] MySQL Verification Team

probably a duplicate of bug #41802

[23 Mar 2009 15: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?

[19 Feb 2010 12:31] Susanne Ebrecht

This seems to be related to bug #48157 which was fixed in 5.1.43.

Please test with 5.1.43 or higher.

[6 May 2010 7:32] MySQL Verification Team

have not seen this recently. probably fixed already.