Bug #41816 another multi-table crash with derived tables

• Submitted: 1 Jan 2009 4:35
• Modified: 3 Oct 2010 8:59
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Can't repeat
• Category: MySQL Server: Optimizer
• Severity: S1 (Critical)
• Version: 5.1.30
• OS: Windows
• CPU Architecture: Any

[1 Jan 2009 4:35] Shane Bester

Description:
140053FCB mysqld.exe!Item_field::used_tables()[item.cc:2124]
14016803C mysqld.exe!setup_fields()[sql_base.cc:7400]
1401D9339 mysqld.exe!JOIN::prepare()[sql_select.cc:492]
14020F103 mysqld.exe!st_select_lex_unit::prepare()[sql_union.cc:264]
1401803F8 mysqld.exe!mysql_derived_prepare()[sql_derived.cc:151]
140180050 mysqld.exe!mysql_handle_derived()[sql_derived.cc:56]
1402123AA mysqld.exe!mysql_multi_update_prepare()[sql_update.cc:971]
14019EC40 mysqld.exe!mysql_execute_command()[sql_parse.cc:2980]
14013A548 mysqld.exe!sp_instr_stmt::exec_core()[sp_head.cc:2900]
14013DCC5 mysqld.exe!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:2728]
14013DEC6 mysqld.exe!sp_instr_stmt::execute()[sp_head.cc:2844]
14013F8E5 mysqld.exe!sp_head::execute()[sp_head.cc:1250]
140140CAF mysqld.exe!sp_head::execute_procedure()[sp_head.cc:1977]
1401A0D57 mysqld.exe!mysql_execute_command()[sql_parse.cc:4235]
1401A2F06 mysqld.exe!mysql_parse()[sql_parse.cc:5791]
1401A3C1A mysqld.exe!dispatch_command()[sql_parse.cc:1202]
1401A4CD7 mysqld.exe!do_command()[sql_parse.cc:857]
140246327 mysqld.exe!handle_one_connection()[sql_connect.cc:1115]
1402B82C5 mysqld.exe!pthread_start()[my_winthread.c:85]
1403CAC37 mysqld.exe!_callthreadstart()[thread.c:295]
1403CAD05 mysqld.exe!_threadstart()[thread.c:275]
077D6B69A kernel32.dll!BaseThreadStart()

How to repeat:
.

[1 Jan 2009 14:44] MySQL Verification Team

here are valgrind errors I caught!

Attachment: bug41816_valgrind_errors.txt (text/plain), 63.87 KiB.

[3 Oct 2010 9:00] MySQL Verification Team

never seen this again with modern versions of mysqld..