Assertion `field->type_handler() == this' failed in FixedBinTypeBundle<NATIVE_LEN, MAX_CHAR_LEN>::Type_handler_fbt::stored_field_cmp_to_item

-- source include/have_innodb.inc

CREATE TABLE t1 ( pk uuid, c text) engine=myisam;

INSERT INTO t1 VALUES ('00000000-0000-0000-0000-000000000000',1);

CREATE TABLE t2 ( d text, KEY (d)) engine=innodb ;

INSERT INTO t2 VALUES (2);

UPDATE t2 JOIN t1 ON ( t1.pk > t2.d) SET t1.c = 1;

DROP TABLE t1, t2;

#3  <signal handler called>

#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#5  0x00007faac0c01859 in __GI_abort () at abort.c:79

#6  0x00007faac0c01729 in __assert_fail_base (fmt=0x7faac0d97588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x557da84a926d "field->type_handler() == this", file=0x557da84a9290 "/preview-10.7-MDEV-4958-uuid/src/sql/sql_type_fixedbin.h", line=308, function=<optimized out>) at assert.c:92

#7  0x00007faac0c12f36 in __GI___assert_fail (assertion=0x557da84a926d "field->type_handler() == this", file=0x557da84a9290 "/preview-10.7-MDEV-4958-uuid/src/sql/sql_type_fixedbin.h", line=308, function=0x557da84a92e0 "int FixedBinTypeBundle<NATIVE_LEN, MAX_CHAR_LEN>::Type_handler_fbt::stored_field_cmp_to_item(THD*, Field*, Item*) const [with long unsigned int NATIVE_LEN = 16; long unsigned int MAX_CHAR_LEN = 36]") at assert.c:101

#8  0x0000557da7e42600 in FixedBinTypeBundle<16ul, 36ul>::Type_handler_fbt::stored_field_cmp_to_item (this=0x557da93a3e40 <FixedBinTypeBundle<16ul, 36ul>::type_handler_fbt()::th>, thd=0x7faa54000db8, field=0x7faa5494ab80, item=0x7faa54014fc8) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_type_fixedbin.h:308

#9  0x0000557da750d64d in stored_field_cmp_to_item (thd=0x7faa54000db8, field=0x7faa5494ab80, item=0x7faa54014fc8) at /preview-10.7-MDEV-4958-uuid/src/sql/item.cc:9896

#10 0x0000557da6fd74be in SEL_ARG_LT::SEL_ARG_LT (this=0x7faa54958180, thd=0x7faa54000db8, key=0x7faa549595f0 "", field=0x7faa5494ab80, value=0x7faa54014fc8) at /preview-10.7-MDEV-4958-uuid/src/sql/opt_range.cc:1973

#11 0x0000557da6fbce39 in Field::stored_field_make_mm_leaf (this=0x7faa5494ab80, param=0x7faab80b8df0, key_part=0x7faa549574d0, op=SCALAR_CMP_LT, value=0x7faa54014fc8) at /preview-10.7-MDEV-4958-uuid/src/sql/opt_range.cc:9016

#12 0x0000557da6fbc89a in Field_str::get_mm_leaf (this=0x7faa5494ab80, prm=0x7faab80b8df0, key_part=0x7faa549574d0, cond=0x7faa54015208, op=SCALAR_CMP_LT, value=0x7faa54014fc8) at /preview-10.7-MDEV-4958-uuid/src/sql/opt_range.cc:8923

#13 0x0000557da6fbbed9 in Item_bool_func::get_mm_leaf (this=0x7faa54015208, param=0x7faab80b8df0, field=0x7faa5494ab80, key_part=0x7faa549574d0, functype=Item_func::LT_FUNC, value=0x7faa54014fc8) at /preview-10.7-MDEV-4958-uuid/src/sql/opt_range.cc:8778

#14 0x0000557da6fbb31b in Item_bool_func::get_mm_parts (this=0x7faa54015208, param=0x7faab80b8df0, field=0x7faa5494ab80, type=Item_func::LT_FUNC, value=0x7faa54014fc8) at /preview-10.7-MDEV-4958-uuid/src/sql/opt_range.cc:8613

#15 0x0000557da6fd2bfe in Item_bool_func2_with_rev::get_func_mm_tree (this=0x7faa54015208, param=0x7faab80b8df0, field=0x7faa5494ab80, value=0x7faa54014fc8) at /preview-10.7-MDEV-4958-uuid/src/sql/item_cmpfunc.h:499

#16 0x0000557da6fba0c8 in Item_bool_func::get_full_func_mm_tree (this=0x7faa54015208, param=0x7faab80b8df0, field_item=0x7faa540150f0, value=0x7faa54014fc8) at /preview-10.7-MDEV-4958-uuid/src/sql/opt_range.cc:8266

#17 0x0000557da6fd2928 in Item_bool_func::get_full_func_mm_tree_for_args (this=0x7faa54015208, param=0x7faab80b8df0, item=0x7faa540150f0, value=0x7faa54014fc8) at /preview-10.7-MDEV-4958-uuid/src/sql/item_cmpfunc.h:208

#18 0x0000557da6fd2ddd in Item_bool_func2_with_rev::get_mm_tree (this=0x7faa54015208, param=0x7faab80b8df0, cond_ptr=0x7faa54017788) at /preview-10.7-MDEV-4958-uuid/src/sql/item_cmpfunc.h:528

#19 0x0000557da6fac09b in SQL_SELECT::test_quick_select (this=0x7faa54017780, thd=0x7faa54000db8, keys_to_use=..., prev_tables=0, limit=18446744073709551615, force_quick_range=false, ordered_output=false, remove_false_parts_of_where=true, only_single_index_range_scan=false) at /preview-10.7-MDEV-4958-uuid/src/sql/opt_range.cc:2881

#20 0x0000557da7190471 in get_quick_record_count (thd=0x7faa54000db8, select=0x7faa54017780, table=0x7faa549521f8, keys=0x7faa5495c7c0, limit=18446744073709551615) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_select.cc:5035

#21 0x0000557da7192dc1 in make_join_statistics (join=0x7faa54015f00, tables_list=..., keyuse_array=0x7faa54016220) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_select.cc:5761

#22 0x0000557da7186e75 in JOIN::optimize_inner (this=0x7faa54015f00) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_select.cc:2453

#23 0x0000557da71847bb in JOIN::optimize (this=0x7faa54015f00) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_select.cc:1809

#24 0x0000557da7190150 in mysql_select (thd=0x7faa54000db8, tables=0x7faa54014118, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2200096997504, result=0x7faa54015de0, unit=0x7faa54005120, select_lex=0x7faa54005918) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_select.cc:4977

#25 0x0000557da7271e55 in mysql_multi_update (thd=0x7faa54000db8, table_list=0x7faa54014118, fields=0x7faa54005bb8, values=0x7faa54005fe0, conds=0x0, options=0, handle_duplicates=DUP_ERROR, ignore=false, unit=0x7faa54005120, select_lex=0x7faa54005918, result=0x7faab80ba000) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_update.cc:1962

#26 0x0000557da712333c in mysql_execute_command (thd=0x7faa54000db8, is_called_from_prepared_stmt=false) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_parse.cc:4489

#27 0x0000557da712f2a3 in mysql_parse (thd=0x7faa54000db8, rawbuf=0x7faa54014010 "UPDATE t2 JOIN t1 ON ( t1.pk > t2.d) SET t1.c = 1", length=49, parser_state=0x7faab80ba480) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_parse.cc:8036

#28 0x0000557da711b677 in dispatch_command (command=COM_QUERY, thd=0x7faa54000db8, packet=0x7faa5400b979 "UPDATE t2 JOIN t1 ON ( t1.pk > t2.d) SET t1.c = 1", packet_length=49, blocking=true) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_parse.cc:1896

#29 0x0000557da711a013 in do_command (thd=0x7faa54000db8, blocking=true) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_parse.cc:1404

#30 0x0000557da72eb429 in do_handle_one_connection (connect=0x557daacca728, put_in_cache=true) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_connect.cc:1418

#31 0x0000557da72eb0b9 in handle_one_connection (arg=0x557daacca728) at /preview-10.7-MDEV-4958-uuid/src/sql/sql_connect.cc:1312

#32 0x0000557da780ca5f in pfs_spawn_thread (arg=0x557daacca808) at /preview-10.7-MDEV-4958-uuid/src/storage/perfschema/pfs.cc:2201

#33 0x00007faac112b609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#34 0x00007faac0cfe293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95