Error Code: 1525. Incorrect DATE value: '2022/05/32'

[zhu guan]

I have had a Website working for 7 years and have had no problems
until at the weekend I replace my MySQL version with a newer one.

MySQL version (old): MySQL 5.1
MySQL version (new): MySQL 8.0.28

I run following code in MySQL 5.1, it return my expected result.

SELECT * FROM tbl_compare_test where tbl_compare_test.col_date >= '2022/05/32'

However after i migrated to MySQL 8.0.28, i hit following error:

********** Error **********
Error Code: 1525. Incorrect DATE value: '2022/05/32'
********** Error **********

The Website application is large and rewrite is a terrible job.
And i don't know how to quickly and accurately find out the SQL with the problem.

Is there any easy way to maintain compatibility?