Server crash in in JOIN_CACHE_HASHED::put_record or Assertion `0' failed in Field_blob_compressed::new_key_field or Assertion `length > 0' failed in create_ref_for_key or SIGSEGV in store_key::copy, with join_cache_level>2

--source include/have_innodb.inc

set join_cache_level=3;

CREATE TABLE t1 (col_blob text)engine=innodb;

CREATE TABLE t2 (col_blob text COMPRESSED)engine=innodb;

SELECT * FROM t1 JOIN t2 USING ( col_blob );

mysqld: /git/10.3/sql/field.h:3831: virtual Field* Field_blob_compressed::new_key_field(MEM_ROOT*, TABLE*, uchar*, uint32, uchar*, uint): Assertion `0' failed.

180724 12:21:59 [ERROR] mysqld got signal 6 ;

Server version: 10.3.9-MariaDB-debug-log

stack_bottom = 0x7f573900bc70 thread_stack 0x49000

/usr/lib/x86_64-linux-gnu/libasan.so.2(+0x4a077)[0x7f5753ab8077]

mysys/stacktrace.c:269(my_print_stacktrace)[0x5617a87a81dc]

sql/signal_handler.cc:168(handle_fatal_signal)[0x5617a74c5331]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f5752350390]

linux/raise.c:54(__GI_raise)[0x7f5751709428]

stdlib/abort.c:91(__GI_abort)[0x7f575170b02a]

assert/assert.c:92(__assert_fail_base)[0x7f5751701bd7]

/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f5751701c82]

/git/10.3/sql/mysqld(+0x16a88d5)[0x5617a74a68d5]

sql/sql_select.h:1839(store_key::store_key(THD*, Field*, unsigned char*, unsigned char*, unsigned int))[0x5617a6f60663]

sql/sql_select.h:1896(store_key_field::store_key_field(THD*, Field*, unsigned char*, unsigned char*, unsigned int, Field*, char const*))[0x5617a6f60bdd]

sql/sql_select.cc:9972(get_store_key(THD*, keyuse_t*, unsigned long long, st_key_part_info*, unsigned char*, unsigned int))[0x5617a6ee1099]

sql/sql_select.cc:9890(create_ref_for_key(JOIN*, st_join_table*, keyuse_t*, bool, unsigned long long))[0x5617a6ee016b]

sql/sql_select.cc:9565(JOIN::get_best_combination())[0x5617a6edd455]

sql/sql_select.cc:1928(JOIN::optimize_stage2())[0x5617a6ea460a]

sql/sql_select.cc:1907(JOIN::optimize_inner())[0x5617a6ea43ae]

sql/sql_select.cc:1448(JOIN::optimize())[0x5617a6ea02ae]

sql/sql_select.cc:4206(mysql_select(THD*, 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*))[0x5617a6eb9f3d]

sql/sql_select.cc:382(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5617a6e95973]

sql/sql_parse.cc:6542(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5617a6e1b4c4]

sql/sql_parse.cc:3765(mysql_execute_command(THD*))[0x5617a6e09cd7]

sql/sql_parse.cc:8073(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5617a6e23dd2]

sql/sql_parse.cc:1849(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5617a6dfeab9]

sql/sql_parse.cc:1392(do_command(THD*))[0x5617a6dfbc51]

sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x5617a714b0b6]

sql/sql_connect.cc:1309(handle_one_connection)[0x5617a714aa93]

perfschema/pfs.cc:1864(pfs_spawn_thread)[0x5617a86892e3]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f57523466ba]

x86_64/clone.S:111(clone)[0x7f57517db41d]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x62b000000288): SELECT * FROM t1 JOIN t2 USING ( col_blob )

Connection ID (thread ID): 9

Status: NOT_KILLED