CREATE TABLE t1 (a CHAR(8), b TEXT, UNIQUE(b)) WITH SYSTEM VERSIONING;

INSERT INTO t1 VALUES  ('foo','bar'),('bar','foo');

CREATE TABLE t2 (c INT);

INSERT INTO t2 VALUES (1),(2);

UPDATE t1, t2 SET t1.a = 'qux';

# Cleanup

DROP TABLE t1, t2;

mysqld: /data/src/10.5/sql/handler.cc:6946: int handler::ha_write_row(const uchar*): Assertion `inited == NONE || lookup_handler != this' failed.

200407  1:27:04 [ERROR] mysqld got signal 6 ;

#6  0x00007f24e7095e67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5570127ffc78 "inited == NONE || lookup_handler != this", file=file@entry=0x5570127fd5be "/data/src/10.5/sql/handler.cc", line=line@entry=6946, function=function@entry=0x557012802220 <handler::ha_write_row(unsigned char const*)::__PRETTY_FUNCTION__> "int handler::ha_write_row(const uchar*)") at assert.c:92

#7  0x00007f24e7095f12 in __GI___assert_fail (assertion=0x5570127ffc78 "inited == NONE || lookup_handler != this", file=0x5570127fd5be "/data/src/10.5/sql/handler.cc", line=6946, function=0x557012802220 <handler::ha_write_row(unsigned char const*)::__PRETTY_FUNCTION__> "int handler::ha_write_row(const uchar*)") at assert.c:101

#8  0x0000557011be4ab8 in handler::ha_write_row (this=0x7f24d00f9c00, buf=0x7f24d01abeb8 "\370foo     \003") at /data/src/10.5/sql/handler.cc:6946

#9  0x000055701182fa86 in vers_insert_history_row (table=0x7f24d00f8d88) at /data/src/10.5/sql/sql_insert.cc:1719

#10 0x00005570119a57dd in multi_update::send_data (this=0x7f24d0014ab8, not_used_values=...) at /data/src/10.5/sql/sql_update.cc:2559

#11 0x000055701191a2e5 in select_result_sink::send_data_with_check (this=0x7f24d0014ab8, items=..., u=0x7f24d0004b20, sent=0) at /data/src/10.5/sql/sql_class.h:5236

#12 0x0000557011901266 in end_send (join=0x7f24d0015128, join_tab=0x7f24d00183d8, end_of_records=false) at /data/src/10.5/sql/sql_select.cc:21795

#13 0x00005570118fe8fa in evaluate_join_record (join=0x7f24d0015128, join_tab=0x7f24d0018030, error=0) at /data/src/10.5/sql/sql_select.cc:20826

#14 0x00005570118fe1bb in sub_select (join=0x7f24d0015128, join_tab=0x7f24d0018030, end_of_records=false) at /data/src/10.5/sql/sql_select.cc:20603

#15 0x00005570118fe8fa in evaluate_join_record (join=0x7f24d0015128, join_tab=0x7f24d0017c88, error=0) at /data/src/10.5/sql/sql_select.cc:20826

#16 0x00005570118fe1bb in sub_select (join=0x7f24d0015128, join_tab=0x7f24d0017c88, end_of_records=false) at /data/src/10.5/sql/sql_select.cc:20603

#17 0x00005570118fd61a in do_select (join=0x7f24d0015128, procedure=0x0) at /data/src/10.5/sql/sql_select.cc:20137

#18 0x00005570118d1447 in JOIN::exec_inner (this=0x7f24d0015128) at /data/src/10.5/sql/sql_select.cc:4463

#19 0x00005570118d0573 in JOIN::exec (this=0x7f24d0015128) at /data/src/10.5/sql/sql_select.cc:4244

#20 0x00005570118d1ca4 in mysql_select (thd=0x7f24d0000b18, tables=0x7f24d0013a18, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2200096997504, result=0x7f24d0014ab8, unit=0x7f24d0004b20, select_lex=0x7f24d0005320) at /data/src/10.5/sql/sql_select.cc:4668

#21 0x00005570119a3441 in mysql_multi_update (thd=0x7f24d0000b18, table_list=0x7f24d0013a18, fields=0x7f24d0005470, values=0x7f24d00059e8, conds=0x0, options=0, handle_duplicates=DUP_ERROR, ignore=false, unit=0x7f24d0004b20, select_lex=0x7f24d0005320, result=0x7f24e1c33050) at /data/src/10.5/sql/sql_update.cc:1925

#22 0x000055701187f45f in mysql_execute_command (thd=0x7f24d0000b18) at /data/src/10.5/sql/sql_parse.cc:4439

#23 0x000055701188ba8c in mysql_parse (thd=0x7f24d0000b18, rawbuf=0x7f24d0013930 "UPDATE t1, t2 SET t1.a = 'qux'", length=30, parser_state=0x7f24e1c33520, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7953

#24 0x00005570118772dd in dispatch_command (command=COM_QUERY, thd=0x7f24d0000b18, packet=0x7f24d0008699 "UPDATE t1, t2 SET t1.a = 'qux'", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1840

#25 0x0000557011875a13 in do_command (thd=0x7f24d0000b18) at /data/src/10.5/sql/sql_parse.cc:1359

#26 0x0000557011a19913 in do_handle_one_connection (connect=0x557015122348, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1422

#27 0x0000557011a19642 in handle_one_connection (arg=0x557015122348) at /data/src/10.5/sql/sql_connect.cc:1319

#28 0x0000557011f4e8ea in pfs_spawn_thread (arg=0x5570150cbfd8) at /data/src/10.5/storage/perfschema/pfs.cc:2201

#29 0x00007f24e901e4a4 in start_thread (arg=0x7f24e1c34700) at pthread_create.c:456

#30 0x00007f24e7152d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

commit 0515577d128318e1b62511846d88d0c56226168d

Author: Sergei Golubchik

Date:   Thu Mar 5 19:19:57 2020 +0100

    cleanup: prepare "update_handler" for WITHOUT OVERLAPS

    * rename to a generic name

    * move remaning initializations from query exec to prepare time

    * simplify/unify key handling in open_table_from_share and delayed

    * remove dead code

    * move tests where they belong