| 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 |
[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.
Description: It appears group_concat() crashes the server when an expression is used in the group_concat(expr) function with "order by" and a table join is being used. Removing the "order by" or the expression calculation from the second group_concat() eliminates the problem. Build from BitKeeper Source Distribution on or around 4/14/2004. How to repeat: drop table if exists a,b; create table a (class char(10), human_years integer); create table b (class char(10), name char(10), age integer, id_no integer AUTO_INCREMENT PRIMARY KEY); insert into a (class, human_years) values('dog', 7),('cat', 12); insert into b (class, name, age) values('dog','fido', 9),('dog','spot', 3),('cat','fluffy', 8); /* this crashes the server */ select a.class ,group_concat(b.name order by b.id_no) as names ,group_concat(a.human_years*b.age order by b.id_no) as effective_age from a, b where a.class=b.class group by a.class; /* this does not */ select a.class ,group_concat(b.name order by b.id_no) as names ,group_concat(a.human_years*b.age) as effective_age from a, b where a.class=b.class group by a.class; /* this does not */ select a.class ,group_concat(b.name order by b.id_no) as names ,group_concat(b.age order by b.id_no) as effective_age from a, b where a.class=b.class group by a.class; /* expected results with "order by" */ +--------+-----------+---------------+ | class | names | effective_age | +--------+-----------+---------------+ | cat | fluffy | 96 | | dog | fido,spot | 63,21 | +--------+-----------+---------------+