------------ MySQL 4.1.1 ----------------

0x8086bd3 handle_segfault + 423
0x82d03c8 pthread_sighandler + 184
0x80e96bd sortlength__FP13st_sort_fieldUiPb + 73
0x80e7cbc filesort__FP3THDP8st_tableP13st_sort_fieldUiP10SQL_SELECTUlPUl + 124
0x80bfe8a create_sort_index__FP3THDP4JOINP8st_orderUlUl + 338
0x80b44cb exec__4JOIN + 4111
0x80b4a3c mysql_select__FP3THDPPP4ItemP13st_table_listUiRt4List1Z4ItemP4ItemUiP8st_orderT7T5T7UlP13select_resultP18st_select_lex_unitP13s + 832
0x811a76b mysql_derived__FP3THDP6st_lexP18st_select_lex_unitP13st_table_list + 699
0x8093bf9 mysql_execute_command__FP3THD + 309
0x80988d9 mysql_parse__FP3THDPcUi + 177
0x8092cdf dispatch_command__F19enum_server_commandP3THDPcUi + 1635
0x8092671 do_command__FP3THD + 161
0x8091df9 handle_one_connection + 549
0x82cdb7c pthread_start_thread + 220
0x830355a thread_start + 4

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x862df38 = SELECT MIN(price) min, MAX(price) max, AVG(price) avg
FROM (SELECT SUBSTRING( MAX(concat(date_,";",price)), 12) price
FROM itemprices
WHERE itemid=128 AND  grpid='rozn'
GROUP BY itemid, grpid, vendor) lastprices
thd->thread_id=1
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.

Number of processes running now: 0
040116 03:41:40  mysqld restarted
040116  3:41:40  InnoDB: Started; log sequence number 0 43644
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.1-alpha-standard'  socket: '/tmp/mysql.sock'  port: 3306
040116  3:53:11  /usr/local/mysql/bin/mysqld: Normal shutdown

040116  3:53:12  InnoDB: Starting shutdown...
040116  3:53:14  InnoDB: Shutdown completed; log sequence number 0 43644
040116  3:53:14  /usr/local/mysql/bin/mysqld: Shutdown Complete


------------ MySQL 5.0.0 ----------------

0x80880d3 handle_segfault + 423
0x82df1d8 pthread_sighandler + 184
0x80b42f2 fill_record__FPP5FieldRt4List1Z4Itemb + 70
0x8121eec send_data__12select_unionRt4List1Z4Item + 60
0x80c44cf end_send_group__FP4JOINP13st_join_tableb + 355
0x80c3268 sub_select__FP4JOINP13st_join_tableb + 52
0x80c303b do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 451
0x80ba019 exec__4JOIN + 4237
0x80ba542 mysql_select__FP3THDPPP4ItemP13st_table_listUiRt4List1Z4ItemP4ItemUiP8st_orderT7T5T7UlP13select_resultP18st_select_lex_unitP13s + 838
0x812353b mysql_derived__FP3THDP6st_lexP18st_select_lex_unitP13st_table_list + 699
0x809597e mysql_execute_command__FP3THD + 378
0x809afc9 mysql_parse__FP3THDPcUi + 185
0x8094a1f dispatch_command__F19enum_server_commandP3THDPcUi + 1659
0x809439a do_command__FP3THD + 218
0x8093aea handle_one_connection + 602
0x82dc98c pthread_start_thread + 220
0x83124ca thread_start + 4

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8649d38 = SELECT MIN(price) min, MAX(price) max, AVG(price) avg
FROM (SELECT SUBSTRING( MAX(concat(date_,";",price)), 12) price
FROM itemprices
WHERE itemid=128 AND  grpid='rozn'
GROUP BY itemid, grpid, vendor) lastprices
thd->thread_id=2
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.

Number of processes running now: 0
040116 04:06:05  mysqld restarted
040116  4:06:05  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
040116  4:06:05  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 224490.
InnoDB: Doing recovery: scanned up to log sequence number 0 224490
040116  4:06:05  InnoDB: Flushing modified pages from the buffer pool...
040116  4:06:05  InnoDB: Started; log sequence number 0 224490
/usr/local/mysql/bin/mysqld: ready for connections.