Users who require the MySQL Connector/J should avoid 8.0.23 as it breaks date values returned in queries. Stick with 8.0.22 for now.
We encountered a problem while setting up a new ColdFusion 2021 server, and felt it warranted an alert to other users who want to use MySQL through the community version of the MySQL Connector/J.
The currently available connector version 8.0.23 implements a change that breaks date values returned in queries in ColdFusion. Instead of returning the typical date or datetime string one expects, the connector now returns a LocalDateTime Java object. This is incompatible with any of the standard ColdFusion date-related functions, and causes errors.
To resolve the issue, we had to replace Connector/J 8.0.23 with Connector/J 8.0.22 instead, and everything is fine.
To download the connector: https://dev.mysql.com/downloads/connector/j/
To read about the issue: