Lucee 5.3.x and Connector/J 8.0.x compatibility for MySQL DB Gateway getColumns
Description
Lucee 5.3 ships with MySQL Connector/J 8.0.x and INFORMATION_SCHEMA queries now need to include the table_schema of the current database, otherwise they will return columns from tables across all databases visible to the credentials used in the connection.
The MySQL DB Gateway must query INFORMATION_SCHEMA.COLUMNS because the built-in cfdbinfo query results do not return date time precision correctly.
Major
Lucee 5.3 ships with MySQL Connector/J 8.0.x and INFORMATION_SCHEMA queries now need to include the table_schema of the current database, otherwise they will return columns from tables across all databases visible to the credentials used in the connection.
The MySQL DB Gateway must query INFORMATION_SCHEMA.COLUMNS because the built-in cfdbinfo query results do not return date time precision correctly.