Partitioning by COLUMNS or KEY on a virtual column changes the query result after an ALTER TABLE changes its expression

--source include/have_partition.inc

CREATE TABLE t1 (a INT, v INT AS (a+1) VIRTUAL) PARTITION BY LIST COLUMNS (v) (PARTITION p0 VALUES IN (2,3,4), PARTITION p1 DEFAULT);

INSERT INTO t1 (a) VALUES (3);

# With v = a+2 the row gets v = 5, which belongs in p1

ALTER TABLE t1 MODIFY v INT AS (a+2) VIRTUAL;

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

if ($c != 1)

{

  --die The row with v=5 is not found by v=5 after the expression of the LIST COLUMNS column v was changed

}

DROP TABLE t1;

mysqltest: At line 10: The row with v=5 is not found by v=5 after the expression of the LIST COLUMNS column v was changed

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

| MySQL  | LIST COLUMNS (v) | KEY (v) | RANGE COLUMNS (v) |

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

| 5.7.44 | 1 of 1           | 8 of 8  | 1 of 1            |

| 8.0.36 | 1 of 1           | 8 of 8  | 1 of 1            |

| 9.1.0  | 1 of 1           | 8 of 8  | 1 of 1            |

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