CREATE TABLE t1 (f VARCHAR(4096), s DATE, e DATE, PERIOD FOR app(s,e), UNIQUE(f)) ENGINE=MyISAM;

INSERT INTO t1 VALUES ('foo', '2023-08-30', '2025-07-09'),('bar', '2021-01-01', '2021-12-31');

DELETE FROM t1 FOR PORTION OF app FROM '2023-08-29' TO '2025-07-01';

# Cleanup

DROP TABLE t1;

mysqld: /data/src/bb-10.5-monty/sql/handler.cc:6706: int handler::ha_write_row(const uchar*): Assertion `inited == NONE || update_handler != this' failed.

200201 17:59:07 [ERROR] mysqld got signal 6 ;

#7  0x00007f26b79d7f12 in __GI___assert_fail (assertion=0x562045277aa0 "inited == NONE || update_handler != this", file=0x5620452755d8 "/data/src/bb-10.5-monty/sql/handler.cc", line=6706, function=0x562045279fa0 <handler::ha_write_row(unsigned char const*)::__PRETTY_FUNCTION__> "int handler::ha_write_row(const uchar*)") at assert.c:101

#8  0x00005620446b8e27 in handler::ha_write_row (this=0x7f26a01308b8, buf=0x7f26a013a0e8 "\374\003") at /data/src/bb-10.5-monty/sql/handler.cc:6706

#9  0x00005620444aa7c6 in TABLE::period_make_insert (this=0x7f26a012f5e0, src=0x7f26a0013da0, dst=0x7f26a0130570) at /data/src/bb-10.5-monty/sql/table.cc:8567

#10 0x00005620444aa9f3 in TABLE::insert_portion_of_time (this=0x7f26a012f5e0, thd=0x7f26a0000b00, period_conds=..., rows_inserted=0x7f26b2382570) at /data/src/bb-10.5-monty/sql/table.cc:8597

#11 0x000056204487c591 in mysql_delete (thd=0x7f26a0000b00, table_list=0x7f26a0013600, conds=0x7f26a0014a90, order_list=0x7f26a00054e0, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.5-monty/sql/sql_delete.cc:794

#12 0x0000562044361c9b in mysql_execute_command (thd=0x7f26a0000b00) at /data/src/bb-10.5-monty/sql/sql_parse.cc:4739

#13 0x000056204436d599 in mysql_parse (thd=0x7f26a0000b00, rawbuf=0x7f26a00134c8 "DELETE FROM t1 FOR PORTION OF app FROM '2023-08-29' TO '2025-07-01'", length=67, parser_state=0x7f26b2383570, is_com_multi=false, is_next_command=false) at /data/src/bb-10.5-monty/sql/sql_parse.cc:7990

#14 0x00005620443585a9 in dispatch_command (command=COM_QUERY, thd=0x7f26a0000b00, packet=0x7f26a0008461 "DELETE FROM t1 FOR PORTION OF app FROM '2023-08-29' TO '2025-07-01'", packet_length=67, is_com_multi=false, is_next_command=false) at /data/src/bb-10.5-monty/sql/sql_parse.cc:1846

#15 0x0000562044356d03 in do_command (thd=0x7f26a0000b00) at /data/src/bb-10.5-monty/sql/sql_parse.cc:1364

#16 0x00005620444f8b85 in do_handle_one_connection (connect=0x562047de2740, put_in_cache=true) at /data/src/bb-10.5-monty/sql/sql_connect.cc:1422

#17 0x00005620444f88b4 in handle_one_connection (arg=0x562047de2740) at /data/src/bb-10.5-monty/sql/sql_connect.cc:1319

#18 0x0000562044a5514b in pfs_spawn_thread (arg=0x562047de2380) at /data/src/bb-10.5-monty/storage/perfschema/pfs.cc:1869

#19 0x00007f26b99604a4 in start_thread (arg=0x7f26b2384700) at pthread_create.c:456

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

commit 574eb36c14d4ca2022c7803bd5c94076937df16a

Author: Monty

Date:   Mon Jan 13 18:30:13 2020 +0200

    Improve update handler (long unique keys on blobs)

    MDEV-21606 Improve update handler (long unique keys on blobs)

    MDEV-21470 MyISAM and Aria start_bulk_insert doesn't work with long unique