We're updating the issue view to help you get more done. 

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.

Environment

None

Status

Assignee

Unassigned

Reporter

Justin Carter

Labels

None

Fix versions

Affects versions

FarCry 7.4

Priority

Major