Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.1, 5.5.30, 5.1.67, 5.2.14, 5.3.12
-
None
-
None
Description
CREATE TABLE t1 (i INT) ENGINE=MyISAM; |
INSERT INTO t1 VALUES (NULL),(8); |
SELECT GROUP_CONCAT( i ), MAKE_SET( i, 'a', 'b' ) field FROM t1 GROUP BY field; |
mysqld: filesort.cc:828: void make_sortkey(SORTPARAM*, uchar*, uchar*): Assertion `0' failed.
|
[ERROR] mysqld got signal 6 ;
|
#7 0x00007fddb30c5192 in __GI___assert_fail (assertion=0xd3e8ed "0", file=0xd3e7df "filesort.cc", line=828, function=0xd3ec20 "void make_sortkey(SORTPARAM*, uchar*, uchar*)") at assert.c:103
|
#8 0x00000000007c238e in make_sortkey (param=0x7fddb1f38260, to=0x7fdd98033a00 "\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245h4z\025\217\217\217\217\217\217\217\217h4z\025u", ref_pos=0x7fddb1f381e0 "") at filesort.cc:828
|
#9 0x00000000007c1b03 in find_all_keys (param=0x7fddb1f38260, select=0x7fdd9801e138, sort_keys=0x7fdd98033998, buffpek_pointers=0x7fddb1f38560, tempfile=0x7fddb1f383d0, indexfile=0x0) at filesort.cc:646
|
#10 0x00000000007c0627 in filesort (thd=0x1f99c98, table=0x7fdd9802d358, sortorder=0x7fdd9801e610, s_length=1, select=0x7fdd9801e138, max_rows=18446744073709551615, sort_positions=false, examined_rows=0x7fddb1f38778) at filesort.cc:259
|
#11 0x000000000071e2ee in create_sort_index (thd=0x1f99c98, join=0x7fdd98030cc0, order=0x7fdd9801d580, filesort_limit=18446744073709551615, select_limit=18446744073709551615, is_order_by=true) at sql_select.cc:14419
|
#12 0x00000000006ff4ad in JOIN::exec (this=0x7fdd98030cc0) at sql_select.cc:2310
|
#13 0x00000000006fffe7 in mysql_select (thd=0x1f99c98, rref_pointer_array=0x1f9c030, tables=0x7fdd9801d140, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x0, group=0x7fdd9801d580, having=0x0, proc_param=0x0, select_options=2147764736, result=0x7fdd9801d650, unit=0x1f9ba30, select_lex=0x1f9be58) at sql_select.cc:2576
|
#14 0x00000000006f7e69 in handle_select (thd=0x1f99c98, lex=0x1f9b990, result=0x7fdd9801d650, setup_tables_done_option=0) at sql_select.cc:280
|
#15 0x0000000000695116 in execute_sqlcom_select (thd=0x1f99c98, all_tables=0x7fdd9801d140) at sql_parse.cc:5247
|
#16 0x000000000068bf90 in mysql_execute_command (thd=0x1f99c98) at sql_parse.cc:2386
|
#17 0x00000000006978f9 in mysql_parse (thd=0x1f99c98, rawbuf=0x7fdd9801c690 "SELECT GROUP_CONCAT( i ), MAKE_SET( i, 'a', 'b' ) field FROM t1 GROUP BY field", length=78, found_semicolon=0x7fddb1f39900) at sql_parse.cc:6222
|
#18 0x0000000000689729 in dispatch_command (command=COM_QUERY, thd=0x1f99c98, packet=0x2006969 "SELECT GROUP_CONCAT( i ), MAKE_SET( i, 'a', 'b' ) field FROM t1 GROUP BY field", packet_length=78) at sql_parse.cc:1294
|
#19 0x0000000000688624 in do_command (thd=0x1f99c98) at sql_parse.cc:906
|
#20 0x00000000006855bb in handle_one_connection (arg=0x1f99c98) at sql_connect.cc:1238
|
#21 0x00007fddb345ce9a in start_thread (arg=0x7fddb1f3a700) at pthread_create.c:308
|
#22 0x00007fddb3189cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
revision-id: holyfoot@askmonty.org-20130310190805-3jncxhq14nr7vw66
|
revno: 3188
|
branch-nick: 5.1
|
The problem is also reproducible on all furhter versions of MariaDB, and on MySQL 5.5, but not on MySQL 5.6. I assume it was fixed with http://bugs.mysql.com/bug.php?id=60034 (see the comment, only fixed in 5.6.5). Please consider if we want to fix it in earlier version(s) as well.