An UPDATE that moves a row to another partition and meets a duplicate key gives ERROR 1022 instead of ERROR 1062 on MyISAM and Aria

--source include/have_partition.inc

CREATE TABLE t1 (id INT PRIMARY KEY, a INT) ENGINE=MyISAM PARTITION BY HASH (id) PARTITIONS 4;

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

--error 0,ER_DUP_ENTRY,ER_DUP_KEY

UPDATE t1 SET id = 2 WHERE id = 1;

if ($mysql_errno != 1062)

{

  --die An UPDATE on MyISAM that moves a row to another partition and meets a duplicate key gives error $mysql_errno, not 1062 ER_DUP_ENTRY

}

CREATE TABLE t2 (id INT PRIMARY KEY, a INT) ENGINE=Aria PARTITION BY HASH (id) PARTITIONS 4;

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

--error 0,ER_DUP_ENTRY,ER_DUP_KEY

UPDATE t2 SET id = 2 WHERE id = 1;

if ($mysql_errno != 1062)

{

  --die An UPDATE on Aria that moves a row to another partition and meets a duplicate key gives error $mysql_errno, not 1062 ER_DUP_ENTRY

}

CREATE TABLE t3 (a INT, b INT, c INT, PRIMARY KEY (a, b), UNIQUE KEY uc (a, c)) ENGINE=MyISAM PARTITION BY HASH (a) PARTITIONS 4;

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

--error 0,ER_DUP_ENTRY,ER_DUP_KEY

INSERT INTO t3 VALUES (1, 1, 9) ON DUPLICATE KEY UPDATE a = 2;

GET DIAGNOSTICS CONDITION 1 @m = MESSAGE_TEXT;

--let $ok= query_get_value(SELECT @m LIKE '%for key ''uc''%' AS ok, ok, 1)

if (!$ok)

{

  --die An INSERT ... ON DUPLICATE KEY UPDATE on MyISAM that moves a row to another partition and meets a duplicate on key uc does not name key uc

}

DROP TABLE t1, t2, t3;

mysqltest: At line 8: An UPDATE on MyISAM that moves a row to another partition and meets a duplicate key gives error 1022, not 1062 ER_DUP_ENTRY

+--------+---------------------------------------+------------------------------------+

| MySQL  | UPDATE t1                             | INSERT ... ON DUPLICATE KEY UPDATE |

+--------+---------------------------------------+------------------------------------+

| 5.5.62 | Duplicate entry '2' for key 'PRIMARY' | Duplicate entry '2-1' for key 'uc' |

| 5.6.51 | Duplicate entry '2' for key 'PRIMARY' | Duplicate entry '2-1' for key 'uc' |

| 5.7.44 | Duplicate entry '2' for key 'PRIMARY' | Duplicate entry '2-1' for key 'uc' |

+--------+---------------------------------------+------------------------------------+

MySQL 8.0.36 and 9.1.0 do not partition a MyISAM table.