Rows affected returns wrong number after self-join update

Steps to reproduce:

drop table if exists a;
create table a (a char(20)) engine=columnstore;
insert into a values ('x');
select * from a;
update a join a y on a.a = y.a set a.a='99';

Expected result:
after update there should be a message:
Query OK, 1 row affected

Actual result:
Query OK, 0 row affected

Reproduces on develop-23.02,
while on stable-23.10 it works as expected
Catched by test297 in regression