Bug #3752 | mysqld-nt crashes with group_concat() | ||
---|---|---|---|
Submitted: | 13 May 2004 23:52 | Modified: | 15 May 2004 10:31 |
Reporter: | Edmund Mierzwa | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 4.1.2 | OS: | Any (all) |
Assigned to: | Oleksandr Byelkin | CPU Architecture: | Any |
[13 May 2004 23:52]
Edmund Mierzwa
[14 May 2004 0:52]
Dean Ellis
Verified against 4.1.2 (occurs in Linux also). Thank you for the report! CREATE TABLE t1 ( a int ); CREATE TABLE t2 ( a int ); INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1), (2); SELECT GROUP_CONCAT(t1.a*t2.a ORDER BY t1.a) FROM t1, t2 GROUP BY t1.a; DROP TABLE t1, t2;
[14 May 2004 0:56]
MySQL Verification Team
Thank you for the bug report I was able to repeat with server built with BK tree 2004-05-12: /ctype-utf8.c --1971-- static int my_strcasecmp_utf8(CHARSET_INFO *cs, const char *s, const char *t) { uint s_len=strlen(s); uint t_len=strlen(t); ^^^^^^^^^^^^^^^^^^^^^^^^^^ CALL STACK: mysqld.exe!strlen() Line 78 Asm > mysqld.exe!my_strcasecmp_utf8(charset_info_st * cs=0x007c8f18, const char * s=0x00000000, const char * t=0x00e5fc8c) Line 1973 + 0x9 C mysqld.exe!find_item_in_list(Item * find=0x02f0b358, List<Item> & items={...}, unsigned int * counter=0x03e0f044, find_item_error_report_type report_error=IGNORE_ERRORS) Line 2099 + 0x21 C++ mysqld.exe!find_order_in_list(THD * thd=0x00e5b7f8, Item * * ref_pointer_array=0x00e55220, st_table_list * tables=0x00e55280, st_order * order=0x00e54fb0, List<Item> & fields={...}, List<Item> & all_fields={...}) Line 7984 + 0x13 C++ mysqld.exe!setup_group(THD * thd=0x00e5b7f8, Item * * ref_pointer_array=0x00e55220, st_table_list * tables=0x00e55280, List<Item> & fields={...}, List<Item> & all_fields={...}, st_order * order=0x00e54fb0, int * hidden_group_fields=0x03e0f0ec) Line 8075 + 0x1d C++ mysqld.exe!Item_func_group_concat::setup(THD * thd=0x00e5b7f8) Line 2006 + 0x32 C++ mysqld.exe!JOIN::make_sum_func_list(List<Item> & field_list={...}, List<Item> & send_fields={...}, int before_group_by=0) Line 8603 + 0x18 C++ mysqld.exe!JOIN::optimize() Line 955 + 0x1d C++ mysqld.exe!mysql_select(THD * thd=0x00e5b7f8, Item * * * rref_pointer_array=0x00e5ba00, st_table_list * tables=0x00e55280, unsigned int wild_num=0, List<Item> & fields={...}, Item * conds=0x00e55478, unsigned int og_num=1, st_order * order=0x00000000, st_order * group=0x00e555a8, Item * having=0x00000000, st_order * proc_param=0x00000000, unsigned long select_options=42224128, select_result * result=0x00e555e0, st_select_lex_unit * unit=0x00e5b81c, st_select_lex * select_lex=0x00e5b914) Line 1621 + 0x8 C++ mysqld.exe!handle_select(THD * thd=0x00e5b7f8, st_lex * lex=0x00e5b810, select_result * result=0x00e555e0) Line 192 + 0x87 C++ mysqld.exe!mysql_execute_command(THD * thd=0x00e5b7f8) Line 1969 + 0x11 C++ mysqld.exe!mysql_parse(THD * thd=0x00e5b7f8, char * inBuf=0x00e548b8, unsigned int length=181) Line 3887 + 0x9 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x00e5b7f8, char * packet=0x00e50851, unsigned int packet_length=182) Line 1457 + 0x1d C++ mysqld.exe!do_command(THD * thd=0x00e5b7f8) Line 1272 + 0x31 C++ mysqld.exe!handle_one_connection(void * arg=0x00e5b7f8) Line 1016 + 0x9 C++ mysqld.exe!pthread_start(void * param=0x00e5d6f8) Line 63 + 0x7 C mysqld.exe!_threadstart(void * ptd=0x00e4fe78) Line 173 + 0xd C kernel32.dll!77e6d33b()
[14 May 2004 17:56]
Oleksandr Byelkin
ChangeSet 1.1855 04/05/14 18:55:24 bell@sanja.is.com.ua +3 -0 check of item name presence in find_item_in_list (Bug #3752)
[15 May 2004 10:31]
Oleksandr Byelkin
Thank you for bugreport. Bug is fixed and patch for this bug is sent to our internal repository. It will be present in next server release.