Bug Report: Vitess managed foreign key cascades incorrect value

[GuptaManan100]

Overview of the Issue

Consider the following schema -

create table fk_t15
(
    id bigint,
    col varchar(10),
    primary key (id),
    index(col)
) Engine = InnoDB;

create table fk_t16
(
    id bigint,
    col varchar(10),
    primary key (id),
    index(col),
    foreign key (col) references fk_t15(col) on delete cascade on update cascade
) Engine = InnoDB;

Configure the keyspace such that Vitess is managing the foreign keys.
Insert the following data into the two tables -

insert into fk_t15 (id, col) values (1, '-5')
insert into fk_t16 (id, col) values (1, '-5')

Now if you run the query - update fk_t15 set col = col * (col - (col)),
you'll see that the foreign key constraints are broken.

In the end, the data in the tables looks like -

select * from fk_t15;
+----+------+
| id | col  |
+----+------+
|  1 | -0   |
+----+------+

select * from fk_t16;
+----+------+
| id | col  |
+----+------+
|  1 |  0   |
+----+------+

Reproduction Steps

Given in the description

Binary Version

main

Operating System and Environment details

all

Log Fragments

No response