Wrong result upon GROUP BY on a table with indexed virtual column after INSERT IGNORE

CREATE TABLE t (a INT PRIMARY KEY, va TINYINT AS (a), KEY(va));

INSERT IGNORE INTO t (a) VALUES (100),(150),(200);

SELECT a, COUNT(*) FROM t GROUP BY a;

SELECT * FROM t;

DROP TABLE t;

SELECT a, COUNT(*) FROM t GROUP BY a;

a	COUNT(*)

100	1

150	2

SELECT * FROM t;

a	va

100	100

150	127

200	127

commit 8cdee25952763a0401e4c2a4d61e92c13499bdc6

Author: Yuchen Pei

Date:   Wed Jun 4 11:43:30 2025 +1000

    MDEV-36132 Substitute vcol expressions with indexed vcol fields in ORDER BY and GROUP BY