Partitioning changes the query result after ADD PARTITION or REORGANIZE PARTITION on a LIST table with a DEFAULT partition

--source include/have_partition.inc

CREATE TABLE t1 (a INT) PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1), PARTITION pd DEFAULT);

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

# The row 2 is in pd. After this, it belongs in p2

ALTER TABLE t1 ADD PARTITION (PARTITION p2 VALUES IN (2));

--let $c= query_get_value(SELECT COUNT(*) AS c FROM t1 WHERE a=2, c, 1)

if ($c != 1)

{

  --die The row 2 is not found by a=2 after ADD PARTITION took the value 2 out of the DEFAULT partition

}

CREATE TABLE t2 (a INT) PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1), PARTITION pd DEFAULT);

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

ALTER TABLE t2 REORGANIZE PARTITION p0 INTO (PARTITION p0 VALUES IN (1), PARTITION p2 VALUES IN (2));

--let $c= query_get_value(SELECT COUNT(*) AS c FROM t2 WHERE a=2, c, 1)

if ($c != 1)

{

  --die The row 2 is not found by a=2 after REORGANIZE PARTITION took the value 2 out of the DEFAULT partition

}

DROP TABLE t1, t2;

mysqltest: At line 10: The row 2 is not found by a=2 after ADD PARTITION took the value 2 out of the DEFAULT partition