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)	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S1 (Critical)
Version:	5.0.66a,5.1.24	OS:	Any
Assigned to:		CPU Architecture:	Any

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.

probably a duplicate of bug #41802

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?

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

Please test with 5.1.43 or higher.

have not seen this recently. probably fixed already.

Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.