Details
Description
Note: might be closely related to, or even a duplicate of, MDEV-17299.
CREATE TABLE t1 (a INT, b DATE); |
INSERT INTO t1 VALUES (2, '2012-07-20'),(3, '2031-07-20'); |
SELECT GROUP_CONCAT('foo') AS f FROM t1 GROUP BY BINARY ( SUBSTR( b FROM a ) ); |
|
# Cleanup
|
DROP TABLE t1; |
10.1 243f829c ASAN |
==11266==ERROR: AddressSanitizer: memcpy-param-overlap: memory ranges [0x61500002e7d1,0x61500002e7da) and [0x61500002e7d2, 0x61500002e7db) overlap
|
#0 0x7fcca66c891f (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x2e91f)
|
#1 0x559a4f6427a9 in my_strnxfrm_8bit_bin /data/src/10.1/strings/ctype-bin.c:422
|
#2 0x559a4e7c120a in make_sortkey /data/src/10.1/sql/filesort.cc:1055
|
#3 0x559a4e7c5b4f in find_all_keys /data/src/10.1/sql/filesort.cc:840
|
#4 0x559a4e7c5b4f in filesort(THD*, TABLE*, st_sort_field*, unsigned int, SQL_SELECT*, unsigned long long, bool, unsigned long long*, unsigned long long*, Filesort_tracker*) /data/src/10.1/sql/filesort.cc:301
|
#5 0x559a4e3a9d35 in create_sort_index /data/src/10.1/sql/sql_select.cc:21677
|
#6 0x559a4e3d06f8 in JOIN::exec_inner() /data/src/10.1/sql/sql_select.cc:3245
|
#7 0x559a4e3d1e54 in JOIN::exec() /data/src/10.1/sql/sql_select.cc:2562
|
#8 0x559a4e3c66a7 in mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /data/src/10.1/sql/sql_select.cc:3499
|
#9 0x559a4e3c6e95 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.1/sql/sql_select.cc:388
|
#10 0x559a4e296077 in execute_sqlcom_select /data/src/10.1/sql/sql_parse.cc:5950
|
#11 0x559a4e2b0287 in mysql_execute_command(THD*) /data/src/10.1/sql/sql_parse.cc:2995
|
#12 0x559a4e2c8498 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/src/10.1/sql/sql_parse.cc:7468
|
#13 0x559a4e2cf27c in dispatch_command(enum_server_command, THD*, char*, unsigned int) /data/src/10.1/sql/sql_parse.cc:1496
|
#14 0x559a4e2d5a08 in do_command(THD*) /data/src/10.1/sql/sql_parse.cc:1124
|
#15 0x559a4e57dedd in do_handle_one_connection(THD*) /data/src/10.1/sql/sql_connect.cc:1330
|
#16 0x559a4e57e3ee in handle_one_connection /data/src/10.1/sql/sql_connect.cc:1242
|
#17 0x559a4ee4dd26 in pfs_spawn_thread /data/src/10.1/storage/perfschema/pfs.cc:1861
|
#18 0x7fcca6484493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)
|
#19 0x7fcca483d93e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xe893e)
|
|
0x61500002e7d1 is located 209 bytes inside of 452-byte region [0x61500002e700,0x61500002e8c4)
|
allocated by thread T6 here:
|
#0 0x7fcca66ee73f in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x5473f)
|
#1 0x559a4f61a484 in sf_malloc /data/src/10.1/mysys/safemalloc.c:115
|
#2 0x559a4f712eda (/data/bld/10.1-asan/bin/mysqld+0x1d9feda)
|
|
Thread T6 created by T0 here:
|
#0 0x7fcca66bdbba in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x23bba)
|
#1 0x559a4ee5957d in spawn_thread_v1 /data/src/10.1/storage/perfschema/pfs.cc:1911
|
|
0x61500002e7d2 is located 210 bytes inside of 452-byte region [0x61500002e700,0x61500002e8c4)
|
allocated by thread T6 here:
|
#0 0x7fcca66ee73f in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x5473f)
|
#1 0x559a4f61a484 in sf_malloc /data/src/10.1/mysys/safemalloc.c:115
|
#2 0x559a4f712eda (/data/bld/10.1-asan/bin/mysqld+0x1d9feda)
|
|
SUMMARY: AddressSanitizer: memcpy-param-overlap ??:0 ??
|
==11266==ABORTING
|
Reproducible with at least MyISAM and InnoDB.
No obvious problems on non-ASAN builds.
Attachments
Issue Links
- relates to
-
MDEV-28686 Assertion `0' in Type_handler_string_result::make_sort_key or unexpected result
-
- Closed
-
-
MDEV-35621 UBSAN: runtime error: applying zero offset to null pointer in my_strnxfrm_utf8mb3_general_ci, my_uca_scanner_init_any and my_uca_scanner_next_utf8mb3 and in _utf8mb4 functions, and null pointer passed as argument 2, which is declared to never be null
-
- Confirmed
-
-
MDEV-17299 Assertion `maybe_null' failed in make_sortkey
-
- Closed
-
adding just to make it searchable:
10.5 4197014ba0ba8cb895f3b49b
#0 0x7fb5eb74d105 (/usr/lib/x86_64-linux-gnu/libasan.so.5+0x3f105)
#1 0x55a5943e4c17 in my_strnxfrm_8bit_bin /10.5/strings/ctype-bin.c:403
#2 0x55a592df2730 in charset_info_st::strnxfrm(unsigned char*, unsigned long, unsigned char const*, unsigned long) const /10.5/include/m_ctype.h:796
#3 0x55a592e1530f in Type_handler_string_result::make_sort_key_part(unsigned char*, Item*, SORT_FIELD_ATTR const*, Sort_param*) const /10.5/sql/filesort.cc:1159
#4 0x55a592e2244b in make_sortkey /10.5/sql/filesort.cc:3005
#5 0x55a592e16c08 in make_sortkey /10.5/sql/filesort.cc:1340
#6 0x55a592e13c72 in find_all_keys /10.5/sql/filesort.cc:954
#7 0x55a592e0f677 in filesort(THD*, TABLE*, Filesort*, Filesort_tracker*, JOIN*, unsigned long long) /10.5/sql/filesort.cc:356
#8 0x55a5927cab01 in create_sort_index(THD*, JOIN*, st_join_table*, Filesort*) /10.5/sql/sql_select.cc:23858
#9 0x55a5927b95a4 in st_join_table::sort_table() /10.5/sql/sql_select.cc:21587
#10 0x55a5927b8aad in join_init_read_record(st_join_table*) /10.5/sql/sql_select.cc:21526
#11 0x55a5927b2323 in sub_select(JOIN*, st_join_table*, bool) /10.5/sql/sql_select.cc:20600
#12 0x55a5927b056c in do_select /10.5/sql/sql_select.cc:20137
#13 0x55a59273e765 in JOIN::exec_inner() /10.5/sql/sql_select.cc:4463
#14 0x55a59273bdb7 in JOIN::exec() /10.5/sql/sql_select.cc:4244
#15 0x55a59273fccc in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /10.5/sql/sql_select.cc:4668
#16 0x55a59271200f in handle_select(THD*, LEX*, select_result*, unsigned long) /10.5/sql/sql_select.cc:417
#17 0x55a5929135e4 in Sql_cmd_create_table_like::execute(THD*) /10.5/sql/sql_table.cc:11771
#18 0x55a592681bd4 in mysql_execute_command(THD*) /10.5/sql/sql_parse.cc:5908
#19 0x55a59268f3aa in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.5/sql/sql_parse.cc:7953
#20 0x55a592665198 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.5/sql/sql_parse.cc:1839
#21 0x55a592661bcd in do_command(THD*) /10.5/sql/sql_parse.cc:1358
#22 0x55a592a7fa98 in do_handle_one_connection(CONNECT*, bool) /10.5/sql/sql_connect.cc:1422
#23 0x55a592a7f333 in handle_one_connection /10.5/sql/sql_connect.cc:1319
#24 0x55a59371d779 in pfs_spawn_thread /10.5/storage/perfschema/pfs.cc:2201
#25 0x7fb5eb6f4fa2 in start_thread /build/glibc-vjB4T1/glibc-2.28/nptl/pthread_create.c:486
#26 0x7fb5ead254ce in clone (/lib/x86_64-linux-gnu/libc.so.6+0xf94ce)