| Bug #9275 | This SQL crashed MySQL 4.1.10a-nt | ||
|---|---|---|---|
| Submitted: | 18 Mar 2005 11:53 | Modified: | 18 Mar 2005 12:33 |
| Reporter: | Ådne Hetlelid | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 4.1.10a | OS: | Windows (Windows XP Professional SP2) |
| Assigned to: | CPU Architecture: | Any | |
[18 Mar 2005 12:33]
MySQL Verification Team
The server's crash is related to the bug: http://bugs.mysql.com/bug.php?id=8660 as verified in the call stack. Thank you for the bug report. >mysqld-debug.exe!_NMSG_WRITE(int rterrnum=10) Line 221 C mysqld-debug.exe!abort() Line 44 + 0x7 C mysqld-debug.exe!_assert(void * expr=0x007a3bac, void * filename=0x007a3b8c, unsigned int lineno=1739) Line 267 C mysqld-debug.exe!Item_field::make_field(Send_field * tmp_field=0x03e1efe0) Line 1739 + 0x1d C++ mysqld-debug.exe!Protocol::send_fields(List<Item> * list=0x02f13618, unsigned int flag=1) Line 539 C++ mysqld-debug.exe!select_send::send_fields(List<Item> & list={...}, unsigned int flag=1) Line 791 C++ mysqld-debug.exe!do_select(JOIN * join=0x02f14848, List<Item> * fields=0x02f13618, st_table * table=0x00000000, Procedure * procedure=0x00000000) Line 5639 C++ mysqld-debug.exe!JOIN::exec() Line 1482 + 0x36 C++ mysqld-debug.exe!mysql_select(THD * thd=0x02f13460, Item * * * rref_pointer_array=0x02f13698, st_table_list * tables=0x02f18ce0, unsigned int wild_num=0, List<Item> & fields={...}, Item * conds=0x00000000, unsigned int og_num=0, st_order * order=0x00000000, st_order * group=0x00000000, Item * having=0x00000000, st_order * proc_param=0x00000000, unsigned long select_options=2156153344, select_result * result=0x02f19fe0, st_select_lex_unit * unit=0x02f134ac, st_select_lex * select_lex=0x02f135ac) Line 1604 C++ mysqld-debug.exe!handle_select(THD * thd=0x02f13460, st_lex * lex=0x02f134a0, select_result * result=0x02f19fe0) Line 193 + 0x87 C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x02f13460) Line 2082 + 0x11 C++ mysqld-debug.exe!mysql_parse(THD * thd=0x02f13460, char * inBuf=0x02f188a0, unsigned int length=81) Line 4184 + 0x9 C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02f13460, char * packet=0x00e5ebd9, unsigned int packet_length=82) Line 1505 + 0x1d C++ mysqld-debug.exe!do_command(THD * thd=0x02f13460) Line 1318 + 0x31 C++ mysqld-debug.exe!handle_one_connection(void * arg=0x02f13460) Line 1050 + 0x9 C++ mysqld-debug.exe!pthread_start(void * param=0x00d7a6d0) Line 63 + 0x7 C mysqld-debug.exe!_threadstart(void * ptd=0x00e6f7d0) Line 173 + 0xd C kernel32.dll!7c80b50b() kernel32.dll!7c8399f3()
Description: I got a sql-query "How to repeat" that crashes the MySQL server in these releases 4.1.10a 4.1.10 -Aadne How to repeat: select sub.lastdate from ( SELECT LAST_DAY('2005-02-01') as lastdate ) as sub Suggested fix: Don't know.