Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

mysql error with query with time column com/mysql/cj/protocol/InternalTime

Description

Ubuntu 22.04 LTS
Java (JDK) 20.0.2
Apache 2.4.52
Tomcat 9.0.41
Lucee 6.2.0.321 (now downgraded to 6.1.0.243 after error)
MySQL 8.0.41

In my database, the structure and data which is about 20 years old through various versions… I have a table with a field called “timeToRun” and the data type is “time”, not null, default mask is 00:00:00.

This has never been a problem. Recently upgraded this instance to Lucee 6.2.0.321 and now I have an error:

SELECT myTable.fieldA, myTable.fieldB, myTable.timeToRun
FROM myTable

Lucee throws an error:

Downgraded to Lucee 6.1.0.243 and it works fine again. Is this a known problem?

Environment

None

Activity

Show:

Zac Spitzer 25 March 2025 at 09:01

Details

Assignee

Reporter

Priority

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Created 25 March 2025 at 08:59
Updated 25 March 2025 at 09:01