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

    XMLWordPrintable

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

          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.