Skip to:

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

Query CachedWithin not working for MySQL

Description

Running the code below

<cfquery name="db" cachedWithin="#createTimespan(0, 6, 0, 0)#"> SELECT * from user </cfquery> <cfdump var="#db#"/>

Always produce the attached, the record is not cached (I ran the code more than once).

Environment

macOS Mojave
Lucee 5.3.3.28-SNAPSHOT
MySQL 8.0.12
MySQL Extension v 8.0.15

Attachments

1
  • 07 May 2019, 10:07 pm

Activity

Show:

Pothys - MitrahSoft 22 May 2019 at 13:41

I've checked that. If we dump the query it returns the cached with 'yes' & cache type is time span.

Pothys - MitrahSoft 22 May 2019 at 10:57

, Its working for your affect version or any other lucee version. How did you check that? Could you please report it here then only we can able to finalize the status of this ticket.

Arowolo Abiodun 11 May 2019 at 23:11

Kindly Close/Cancel this issue CachedWithin seems to be working now, can’t really point to what happened.

Pothys - MitrahSoft 8 May 2019 at 08:25

Cannot Reproduce

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

Affects versions

Created 7 May 2019 at 22:08
Updated 23 May 2019 at 06:42
Resolved 23 May 2019 at 06:42

Flag notifications