Bug Report: Update on a table that doesn't actually update anything sometimes fails in Vitess on RESTRICT constraint.

[GuptaManan100]

Overview of the Issue

This bug was found by the fuzzer that is added in #13980.

=== RUN   TestFkFuzzTest/Unsharded_-_Single_Thread_-_Balanced_Inserts_and_Updates
    mysql.go:228: Vitess and MySQL are not erroring the same way.
        Vitess error: Cannot delete or update a parent row: a foreign key constraint fails (errno 1451) (sqlstate 23000) during query: update fk_t10 set col = 3 where id = 6
        MySQL error: <nil>
E0914 12:55:04.166512   90626 fk_fuzz_test.go:326] Failing query - update fk_t10 set col = 3 where id = 6

We see the update fails on Vitess, but MySQL doesn't complain.
The schema of the tables are as follows -

/*
 *                fk_t10
 *                   │
 * On Delete Cascade │
 * On Update Cascade │
 *                   │
 *                   ▼
 *                fk_t11──────────────────┐
 *                   │                    │
 *                   │                    │ On Delete Restrict
 * On Delete Cascade │                    │ On Update Restrict
 * On Update Cascade │                    │
 *                   │                    │
 *                   ▼                    ▼
 *                fk_t12               fk_t13
 */

Reproduction Steps

Create the tables with the given schema
Then, try running an update query as listed above

Binary Version

main

Operating System and Environment details

main

Log Fragments

No response