Bug #9413 MySQL crashes when using derived table with NOW() field
Submitted: 26 Mar 2005 17:04 Modified: 30 Mar 2005 20:21
Reporter: jocelyn fournier (Silver Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.10a OS:Linux (Linux)
Assigned to: Assigned Account CPU Architecture:Any

[26 Mar 2005 17:04] jocelyn fournier 
Description:
Hi,

MySQL crashs when using a derived table containing a NOW() field.

Regards,
  Jocelyn

How to repeat:
SELECT * FROM (SELECT NOW()) as a;

Stack trace : 

0x80c9ead handle_segfault + 653
0x835a40a __pthread_sighandler + 122
0x837beff strlen + 15
0x80c1a56 Protocol::send_fields(List<Item>*, unsigned int) + 678
0x80b8228 select_send::send_fields(List<Item>&, unsigned int) + 40
0x810d9ea do_select(JOIN*, List<Item>*, st_table*, Procedure*) + 890
0x811afeb JOIN::exec() + 5339
0x811bd30 _Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_jP8st_orderSB_S2_SB_mP13select_resultP18st_select_lex_unitP13st_sel + 176
0x811c3a0 handle_select(THD*, st_lex*, select_result*) + 256
0x80e6699 mysql_execute_command(THD*) + 20041
0x80ea5bf mysql_parse(THD*, char*, unsigned int) + 319
0x80eb178 dispatch_command(enum_server_command, THD*, char*, unsigned int) + 2872
0x80ec323 handle_one_connection + 1571
0x8355f0e pthread_start_thread + 206
0x838362a __clone + 106
[26 Mar 2005 17:39] Jorge del Conde 
Verified w/4.1.11 from bk
[30 Mar 2005 20:21] Oleksandr Byelkin 
Thank you for bugreport!
But this bugreport repeat exactly Bug #8824.
bugfix for Bug #8824 (and this one) is already pushed into our source repository.