Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
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
- relates to
-
MDEV-16174 Assertion `0' failed in Type_handler_string_result::make_sort_key(uchar*, Item*, const SORT_FIELD_ATTR*, Sort_param*)
- Closed