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

Assertion `0' failed in Type_handler_string_result::make_sort_key(uchar*, Item*, const SORT_FIELD_ATTR*, Sort_param*)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2
    • Fix Version/s: 10.2.6
    • Component/s: JSON
    • Labels:

      Description

      10.2 1ca8637ae3506

      mysqld: /data/src/10.2/sql/filesort.cc:1018: virtual void Type_handler_string_result::make_sort_key(uchar*, Item*, const SORT_FIELD_ATTR*, Sort_param*) const: Assertion `0' failed.
      170326  1:31:30 [ERROR] mysqld got signal 6 ;
      

      #7  0x00007f60eb47b312 in __GI___assert_fail (assertion=0x7f60ee87ae03 "0", file=0x7f60ee87aac8 "/data/src/10.2/sql/filesort.cc", line=1018, function=0x7f60ee87b6c0 <Type_handler_string_result::make_sort_key(unsigned char*, Item*, SORT_FIELD_ATTR const*, Sort_param*) const::__PRETTY_FUNCTION__> "virtual void Type_handler_string_result::make_sort_key(uchar*, Item*, const SORT_FIELD_ATTR*, Sort_param*) const") at assert.c:101
      #8  0x00007f60edfbdf6f in Type_handler_string_result::make_sort_key (this=0x7f60ef2bbce8 <type_handler_varchar>, to=0x7f60d25aa500 '\245' <repeats 200 times>..., item=0x7f60d2464280, sort_field=0x7f60d24673f8, param=0x7f60eeed9560) at /data/src/10.2/sql/filesort.cc:1018
      #9  0x00007f60edc960eb in Item::make_sort_key (this=0x7f60d2464280, to=0x7f60d25aa500 '\245' <repeats 200 times>..., item=0x7f60d2464280, sort_field=0x7f60d24673f8, param=0x7f60eeed9560) at /data/src/10.2/sql/item.h:880
      #10 0x00007f60edfbe65d in make_sortkey (param=0x7f60eeed9560, to=0x7f60d25aa500 '\245' <repeats 200 times>..., ref_pos=0x7f60d241c298 "") at /data/src/10.2/sql/filesort.cc:1186
      #11 0x00007f60edfbd8c4 in find_all_keys (thd=0x7f60d2416070, param=0x7f60eeed9560, select=0x7f60d24669d0, fs_info=0x7f60d269e200, buffpek_pointers=0x7f60eeed9770, tempfile=0x7f60eeed95f0, pq=0x0, found_rows=0x7f60d269e3f0) at /data/src/10.2/sql/filesort.cc:866
      #12 0x00007f60edfbbb62 in filesort (thd=0x7f60d2416070, table=0x7f60d24d7870, filesort=0x7f60d2466bb0, tracker=0x7f60d2467388, join=0x7f60d2465028, first_table_bit=1) at /data/src/10.2/sql/filesort.cc:284
      #13 0x00007f60eddce83a in create_sort_index (thd=0x7f60d2416070, join=0x7f60d2465028, tab=0x7f60d2466070, fsort=0x7f60d2466bb0) at /data/src/10.2/sql/sql_select.cc:21540
      #14 0x00007f60eddc92c7 in st_join_table::sort_table (this=0x7f60d2466070) at /data/src/10.2/sql/sql_select.cc:19375
      #15 0x00007f60eddc8fb6 in join_init_read_record (tab=0x7f60d2466070) at /data/src/10.2/sql/sql_select.cc:19322
      #16 0x00007f60eddc6fa9 in sub_select (join=0x7f60d2465028, join_tab=0x7f60d2466070, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18414
      #17 0x00007f60eddc65a3 in do_select (join=0x7f60d2465028, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:17961
      #18 0x00007f60edda15b7 in JOIN::exec_inner (this=0x7f60d2465028) at /data/src/10.2/sql/sql_select.cc:3463
      #19 0x00007f60edda0abc in JOIN::exec (this=0x7f60d2465028) at /data/src/10.2/sql/sql_select.cc:3266
      #20 0x00007f60edda1c2f in mysql_select (thd=0x7f60d2416070, tables=0x7f60d2464840, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7f60d2464ef8, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f60d2465008, unit=0x7f60d2419b50, select_lex=0x7f60d241a280) at /data/src/10.2/sql/sql_select.cc:3658
      #21 0x00007f60edd96710 in handle_select (thd=0x7f60d2416070, lex=0x7f60d2419a88, result=0x7f60d2465008, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373
      #22 0x00007f60edd62b59 in execute_sqlcom_select (thd=0x7f60d2416070, all_tables=0x7f60d2464840) at /data/src/10.2/sql/sql_parse.cc:6415
      #23 0x00007f60edd58b86 in mysql_execute_command (thd=0x7f60d2416070) at /data/src/10.2/sql/sql_parse.cc:3448
      #24 0x00007f60edd6652c in mysql_parse (thd=0x7f60d2416070, rawbuf=0x7f60d2464088 "SELECT JSON_KEYS(f) FROM t1 ORDER BY 1", length=38, parser_state=0x7f60eeedadd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7858
      #25 0x00007f60edd545f2 in dispatch_command (command=COM_QUERY, thd=0x7f60d2416070, packet=0x7f60d2458071 "", packet_length=38, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1812
      #26 0x00007f60edd52f62 in do_command (thd=0x7f60d2416070) at /data/src/10.2/sql/sql_parse.cc:1362
      #27 0x00007f60ede9bf3f in do_handle_one_connection (connect=0x7f60eac656b0) at /data/src/10.2/sql/sql_connect.cc:1358
      #28 0x00007f60ede9bccc in handle_one_connection (arg=0x7f60eac656b0) at /data/src/10.2/sql/sql_connect.cc:1264
      #29 0x00007f60ee2b4658 in pfs_spawn_thread (arg=0x7f60e23ce870) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #30 0x00007f60ed37d064 in start_thread (arg=0x7f60eeedc300) at pthread_create.c:309
      #31 0x00007f60eb53562d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      --source include/have_innodb.inc
       
      SET sql_mode='';
      CREATE TABLE t1 (f INT NOT NULL) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (0);
      SELECT JSON_KEYS(f) FROM t1 ORDER BY 1;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: