| Bug #9216 | crash server | ||
|---|---|---|---|
| Submitted: | 16 Mar 2005 9:41 | Modified: | 17 Mar 2005 7:43 |
| Reporter: | Valentin Komissarov | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 4.1.10/4.1.11 BK source | OS: | Windows (win32) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[16 Mar 2005 9:56]
Valentin Komissarov
select cast(STR_TO_DATE('2005.01.01', '%Y.%m.%d') as DateTime)
union
select cast(STR_TO_DATE('2005.01.01', '%Y.%m.%d') as DateTime);
[16 Mar 2005 11:52]
MySQL Verification Team
Thank you for the bug report. Below call stack:
> 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=0x03e1ef30) Line 1739 + 0x1d C++
mysqld-debug.exe!Protocol::send_fields(List<Item> * list=0x02f1356c, 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=0x02f14b58, List<Item> * fields=0x02f1356c, 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=0x02f18c6c, st_table_list * tables=0x02f134dc, 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=2424588800, select_result * result=0x02f18de0, st_select_lex_unit * unit=0x02f134ac, st_select_lex * select_lex=0x02f18b80) Line 1604 C++
mysqld-debug.exe!st_select_lex_unit::exec() Line 549 + 0x7c C++
mysqld-debug.exe!mysql_union(THD * thd=0x02f13460, st_lex * lex=0x02f134a0, select_result * result=0x02f18de0, st_select_lex_unit * unit=0x02f134ac) Line 33 + 0x8 C++
mysqld-debug.exe!handle_select(THD * thd=0x02f13460, st_lex * lex=0x02f134a0, select_result * result=0x02f18de0) Line 180 + 0x18 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=0x00e5eb59, 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=0x00e6f448) Line 63 + 0x7 C
mysqld-debug.exe!_threadstart(void * ptd=0x00e6f740) Line 173 + 0xd C
kernel32.dll!7c80b50b()
kernel32.dll!7c8399f3()
[16 Mar 2005 18:13]
Martin Friebe
looks like bug 8660
[17 Mar 2005 7:43]
Dmitry Lenev
Hi, Valentin! Indeed it is duplicate of bug #8660. Martin, many thanks for pointing to this!!!
Description: Server crash. This bug repeats and at a choice of the data with function cast from tables. How to repeat: select cast('2005.01.01' as DateTime) union select cast('2005.01.02' as DateTime);