ASAN error in Field_blob::get_key_image upon UPDATE with subquery

--source include/have_innodb.inc

CREATE TABLE t1 (a INT, b CHAR(8)) ENGINE=InnoDB;

CREATE TABLE t2 (c CHAR(8), d BLOB) ENGINE=InnoDB;

UPDATE t1 SET a = 1 WHERE b = ( SELECT c FROM t2 WHERE d = 'foo' );

# Cleanup

DROP TABLE t1, t2;

==18916==ERROR: AddressSanitizer: unknown-crash on address 0x6210000c1d8e at pc 0x5619488525af bp 0x7fc1284bc990 sp 0x7fc1284bc988

WRITE of size 3069 at 0x6210000c1d8e thread T27

    #0 0x5619488525ae in Field_blob::get_key_image(unsigned char*, unsigned int, Field::imagetype) /data/src/10.4/sql/field.cc:8450

    #1 0x561948c1e6e6 in Field::make_key_image(st_mem_root*, KEY_PART const*) /data/src/10.4/sql/opt_range.cc:8192

    #2 0x561948c1fed7 in Field::stored_field_make_mm_leaf(RANGE_OPT_PARAM*, KEY_PART*, scalar_comparison_op, Item*) /data/src/10.4/sql/opt_range.cc:8392

    #3 0x561948c1f4e8 in Field_str::get_mm_leaf(RANGE_OPT_PARAM*, KEY_PART*, Item_bool_func const*, scalar_comparison_op, Item*) /data/src/10.4/sql/opt_range.cc:8306

    #4 0x561948c1e144 in Item_bool_func::get_mm_leaf(RANGE_OPT_PARAM*, Field*, KEY_PART*, Item_func::Functype, Item*) /data/src/10.4/sql/opt_range.cc:8161

    #5 0x561948c1c7e2 in Item_bool_func::get_mm_parts(RANGE_OPT_PARAM*, Field*, Item_func::Functype, Item*) /data/src/10.4/sql/opt_range.cc:7995

    #6 0x561948c1c03e in Item_equal::get_mm_tree(RANGE_OPT_PARAM*, Item**) /data/src/10.4/sql/opt_range.cc:7950

    #7 0x561948bfee47 in calculate_cond_selectivity_for_table(THD*, TABLE*, Item**) /data/src/10.4/sql/opt_range.cc:3188

    #8 0x5619482225e7 in make_join_statistics /data/src/10.4/sql/sql_select.cc:5055

    #9 0x561948204e4e in JOIN::optimize_inner() /data/src/10.4/sql/sql_select.cc:1932

    #10 0x561948200385 in JOIN::optimize() /data/src/10.4/sql/sql_select.cc:1451

    #11 0x561948105ac1 in st_select_lex::optimize_unflattened_subqueries(bool) /data/src/10.4/sql/sql_lex.cc:4140

    #12 0x5619483d0e75 in mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*) /data/src/10.4/sql/sql_update.cc:433

    #13 0x561948169b73 in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:4585

    #14 0x5619481802b2 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8116

    #15 0x56194815a77f in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1852

    #16 0x561948157807 in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1397

    #17 0x5619484cdd06 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1402

    #18 0x5619484cd712 in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1308

    #19 0x561949034383 in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1862

    #20 0x7fc133e60493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)

    #21 0x7fc13224693e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xe893e)

0x6210000c1d8e is located 142 bytes inside of 4172-byte region [0x6210000c1d00,0x6210000c2d4c)

allocated by thread T27 here:

    #0 0x7fc1340ca73f in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x5473f)

    #1 0x5619499df1d6 in sf_malloc /data/src/10.4/mysys/safemalloc.c:118

    #2 0x5619499afb53 in my_malloc /data/src/10.4/mysys/my_malloc.c:101

    #3 0x56194998f65f in alloc_root /data/src/10.4/mysys/my_alloc.c:250

    #4 0x561948c1e554 in Field::make_key_image(st_mem_root*, KEY_PART const*) /data/src/10.4/sql/opt_range.cc:8188

    #5 0x561948c1fed7 in Field::stored_field_make_mm_leaf(RANGE_OPT_PARAM*, KEY_PART*, scalar_comparison_op, Item*) /data/src/10.4/sql/opt_range.cc:8392

    #6 0x561948c1f4e8 in Field_str::get_mm_leaf(RANGE_OPT_PARAM*, KEY_PART*, Item_bool_func const*, scalar_comparison_op, Item*) /data/src/10.4/sql/opt_range.cc:8306

    #7 0x561948c1e144 in Item_bool_func::get_mm_leaf(RANGE_OPT_PARAM*, Field*, KEY_PART*, Item_func::Functype, Item*) /data/src/10.4/sql/opt_range.cc:8161

    #8 0x561948c1c7e2 in Item_bool_func::get_mm_parts(RANGE_OPT_PARAM*, Field*, Item_func::Functype, Item*) /data/src/10.4/sql/opt_range.cc:7995

    #9 0x561948c1c03e in Item_equal::get_mm_tree(RANGE_OPT_PARAM*, Item**) /data/src/10.4/sql/opt_range.cc:7950

    #10 0x561948bfee47 in calculate_cond_selectivity_for_table(THD*, TABLE*, Item**) /data/src/10.4/sql/opt_range.cc:3188

    #11 0x5619482225e7 in make_join_statistics /data/src/10.4/sql/sql_select.cc:5055

    #12 0x561948204e4e in JOIN::optimize_inner() /data/src/10.4/sql/sql_select.cc:1932

    #13 0x561948200385 in JOIN::optimize() /data/src/10.4/sql/sql_select.cc:1451

    #14 0x561948105ac1 in st_select_lex::optimize_unflattened_subqueries(bool) /data/src/10.4/sql/sql_lex.cc:4140

    #15 0x5619483d0e75 in mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*) /data/src/10.4/sql/sql_update.cc:433

    #16 0x561948169b73 in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:4585

    #17 0x5619481802b2 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8116

    #18 0x56194815a77f in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1852

    #19 0x561948157807 in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1397

    #20 0x5619484cdd06 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1402

    #21 0x5619484cd712 in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1308

    #22 0x561949034383 in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1862

    #23 0x7fc133e60493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)

Thread T27 created by T0 here:

    #0 0x7fc134099bba in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x23bba)

    #1 0x56194903494b in spawn_thread_v1 /data/src/10.4/storage/perfschema/pfs.cc:1912

    #2 0x561947eb1d86 in inline_mysql_thread_create /data/src/10.4/include/mysql/psi/mysql_thread.h:1268

    #3 0x561947ec7fa4 in create_thread_to_handle_connection(CONNECT*) /data/src/10.4/sql/mysqld.cc:6438

    #4 0x561947ec86a9 in create_new_thread(CONNECT*) /data/src/10.4/sql/mysqld.cc:6508

    #5 0x561947ec8a39 in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /data/src/10.4/sql/mysqld.cc:6625

    #6 0x561947ec9685 in handle_connections_sockets() /data/src/10.4/sql/mysqld.cc:6790

    #7 0x561947ec7461 in mysqld_main(int, char**) /data/src/10.4/sql/mysqld.cc:6060

    #8 0x561947eafc0f in main /data/src/10.4/sql/main.cc:25

    #9 0x7fc13217e2b0 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x202b0)

SUMMARY: AddressSanitizer: unknown-crash /data/src/10.4/sql/field.cc:8450 Field_blob::get_key_image(unsigned char*, unsigned int, Field::imagetype)

Shadow bytes around the buggy address:

  0x0c4280010360: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c4280010370: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c4280010380: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c4280010390: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c42800103a0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

=>0x0c42800103b0: 00[00]00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0c42800103c0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0c42800103d0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0c42800103e0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0c42800103f0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0c4280010400: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

Shadow byte legend (one shadow byte represents 8 application bytes):

  Addressable:           00

  Partially addressable: 01 02 03 04 05 06 07 

  Heap left redzone:       fa

  Heap right redzone:      fb

  Freed heap region:       fd

  Stack left redzone:      f1

  Stack mid redzone:       f2

  Stack right redzone:     f3

  Stack partial redzone:   f4

  Stack after return:      f5

  Stack use after scope:   f8

  Global redzone:          f9

  Global init order:       f6

  Poisoned by user:        f7

  Contiguous container OOB:fc

  ASan internal:           fe

==18916==ABORTING