UPDATE counters doesn't work for queries with semi-join

MariaDB [test]> select * from cs1;

+------+

| i    |

+------+

|   45 |

|   45 |

|   45 |

+------+

3 rows in set (1.771 sec)

MariaDB [test]> insert into cs1 values (42);

Query OK, 1 row affected (0.078 sec)

MariaDB [test]> update cs1 set i = 43 where i in (select i from cs1 where i = 42);

Query OK, 0 rows affected (1.242 sec)

Rows matched: 0  Changed: 0  Warnings: 0

MariaDB [test]> select * from cs1;

+------+

| i    |

+------+

|   45 |

|   45 |

|   45 |

|   43 |

+------+

4 rows in set (1.432 sec)