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

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.1, 5.5.30, 5.1.67, 5.2.14, 5.3.12
    • 5.5.31, 5.1.73, 5.2.15, 5.3.13
    • 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.

      Attachments

        Activity

          pushed in 5.1

          serg Sergei Golubchik added a comment - pushed in 5.1

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.