Assertion `!(table->key_info[active_index].flags & 262144U)' failed in handler::ha_index_init

CREATE TABLE t0 (c5 int) ;

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

CREATE TABLE t1 (pk int) ;

INSERT INTO t1 VALUES (1),(2),(3);

CREATE TABLE t2 (a varchar(9029)) ;

INSERT INTO t2 VALUES ('b'),(NULL),('x'),('h'),('f'),('j'),('p'),(NULL),('x'),(NULL),('x'),('e'),('x'),('f'),('g'),('e'),(NULL),(NULL),('l'),('n'),('y'),('b'),('o'),('g'),('d'),('i'),('u'),('u'),('l'),('z'),(NULL),('a'),('a'),('v');

CREATE TABLE t3 ( pk timestamp(6) NOT NULL, c4 time(3), c1 longtext, PRIMARY KEY (pk), KEY c1 (c1(250)) )  ;

INSERT INTO t3 VALUES('0000-00-00 00:00:00.000000','00:00:00.000','0000-00-00 00:00:00.000');

UPDATE IGNORE t1,t0,t2

SET t1.pk = 1

WHERE t0.c5 <> ALL (SELECT sq1_t1.c5 FROM (t0 AS sq1_t1 JOIN t3 ON t3.pk = sq1_t1.c5) WHERE sq1_t1.c5 != t0.c5 OR t3.c4 <= t2.a);

mariadbd: /11.6/src/sql/handler.cc:3777: int handler::ha_index_init(uint, bool): Assertion `!(table->key_info[active_index].flags & 262144U)' failed.

241112 14:27:10 [ERROR] mysqld got signal 6 ;

Server version: 11.6.2-MariaDB-debug-log source revision: d8dad8c3b54cd09fefce7bc3b9749f427eed9709

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

sql/handler.cc:3780(handler::ha_index_init(unsigned int, bool))[0x556bf98f4e94]

sql/sql_select.cc:24768(join_read_key2(THD*, st_join_table*, TABLE*, st_table_ref*))[0x556bf90d84d7]

sql/sql_expression_cache.cc:224(Expression_cache_tmptable::check_value(Item**))[0x556bf956b0c1]

sql/item.cc:9124(Item_cache_wrapper::check_cache())[0x556bf9980a34]

sql/item.cc:9319(Item_cache_wrapper::val_bool())[0x556bf998341d]

sql/item_cmpfunc.cc:203(Item_func_not::val_bool())[0x556bf99af306]

sql/sql_select.cc:24216(evaluate_join_record(JOIN*, st_join_table*, int))[0x556bf90d4778]

sql/sql_select.cc:24152(sub_select(JOIN*, st_join_table*, bool))[0x556bf90d3ffc]

sql/sql_select.cc:24348(evaluate_join_record(JOIN*, st_join_table*, int))[0x556bf90d51d2]

sql/sql_select.cc:24115(sub_select(JOIN*, st_join_table*, bool))[0x556bf90d39cf]

sql/sql_select.cc:24348(evaluate_join_record(JOIN*, st_join_table*, int))[0x556bf90d51d2]

sql/sql_select.cc:24152(sub_select(JOIN*, st_join_table*, bool))[0x556bf90d3ffc]

sql/sql_select.cc:23626(do_select(JOIN*, Procedure*))[0x556bf90d1189]

sql/sql_select.cc:5045(JOIN::exec_inner())[0x556bf904ac61]

sql/sql_select.cc:4828(JOIN::exec())[0x556bf9047fb8]

sql/sql_select.cc:34378(Sql_cmd_dml::execute_inner(THD*))[0x556bf911d756]

sql/sql_update.cc:3118(Sql_cmd_update::execute_inner(THD*))[0x556bf92f0a98]

sql/sql_select.cc:34315(Sql_cmd_dml::execute(THD*))[0x556bf911d23e]

sql/sql_parse.cc:4414(mysql_execute_command(THD*, bool))[0x556bf8f29677]

sql/sql_parse.cc:7898(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556bf8f4205e]

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

sql/sql_parse.cc:1416(do_command(THD*, bool))[0x556bf8f15421]

sql/sql_connect.cc:1438(do_handle_one_connection(CONNECT*, bool))[0x556bf941e90a]

sql/sql_connect.cc:1352(handle_one_connection)[0x556bf941e45d]

perfschema/pfs.cc:2200(pfs_spawn_thread)[0x556bfa0fab6c]

nptl/pthread_create.c:478(start_thread)[0x7f743be36609]

Query (0x6290001092a8): UPDATE IGNORE t1,t0,t2

SET t1.pk = 1

WHERE t0.c5 <> ALL (SELECT sq1_t1.c5 FROM (t0 AS sq1_t1 JOIN t3 ON t3.pk = sq1_t1.c5) WHERE sq1_t1.c5 != t0.c5 OR t3.c4 <= t2.a)