Hi, I reviewed and tested the v8 patch for skipping unnecessary CHECK constraint verification during UPDATE. I reproduced the existing behavior before applying the patch and tested the behavior again after applying it. My observations after applying the patch: -CHECK constraints on unaffected columns are skipped during UPDATE. -CHECK constraints related to updated columns continue to be verified. -CHECK constraint violations are still detected correctly. -Generated column cases behaved as expected. -The BEFORE UPDATE trigger case behaved correctly. -MERGE with UPDATE and INSERT actions also behaved as expected. I reviewed the regression tests added in 001_constraint_validation.pl for the UPDATE, MERGE, and trigger cases. git diff --check completed without any issues.
Overall, I did not observe any issues during my testing and the patch behaved as expected. Regards, solai
