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!!!
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.039 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.
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);