Details
Description
MDEV-21102 not fully fixed, as it seems.
Reproducible, needs cleaning
CREATE TABLE t2 LIKE mysql.help_category; |
INSERT INTO t2 SELECT * FROM mysql.help_category LIMIT 40; |
|
CREATE TABLE table8_aria_int_autoinc (pk integer auto_increment, |
col_varchar_10_utf8_key varchar(10) CHARACTER SET utf8, |
primary key (pk DESC), |
key (col_varchar_10_utf8_key DESC)); |
|
EXPLAIN FORMAT=JSON DELETE FROM table8_aria_int_autoinc WHERE NOT EXISTS (SELECT tbl1.COMMENT AS fld1 FROM information_schema.ENGINES AS tbl1 RIGHT JOIN t2 AS tbl2 ON (tbl1.TRANSACTIONS >= tbl2.help_category_id AND tbl2.parent_category_id <= 'm')); |