Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4289

Assertion `0' fails in make_sortkey with GROUP_CONCAT, MAKE_SET, GROUP BY

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: 10.0.1, 5.5.30, 5.1.67, 5.2.14, 5.3.12
        • Fix Version/s: 5.5.31, 5.3.13, 5.2.15, 5.1.73
        • Component/s: None
        • Labels:
          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.

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #60034 - valgrind errors then assertion in make_sortkey when grouping by make_set

                  Activity

                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment -

                  pushed in 5.1

                  Show
                  serg Sergei Golubchik added a comment - pushed in 5.1

                    People

                    • Assignee:
                      serg Sergei Golubchik
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 20 minutes
                        20m