Uploaded image for project: 'FarCry Core Framework'
  1. FC-3193

Lucee 5.3.x and Connector/J 8.0.x compatibility for MySQL DB Gateway getColumns

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects versions: FarCry 7.4
    • Fix versions: 7.4.0
    • Components: None
    • Labels:
      None
    • Sprint:

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              justincarter Justin Carter
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: