Ticket #119 (new defect)

Opened 2 years ago

Last modified 3 months ago

getByFields and deleteByFields generates same cached query hash

Reported by: jgworks Owned by: dhughes
Type: defect Priority: highest
Milestone: 1.0 Release Component: Reactor - Object Oriented Queries
Version: Severity: blocker
Keywords: cached query spam Cc:

Description

When calling .getByFields prior to calling .deleteByFields causes a cached query to be generated for a SELECT statement. When .deleteByFields is called the where statement is the same, so the SELECT cached query is loaded from disk and the select statement is run again.

I.E.:

<cfset result = groupMain.getByFields(GRM_APP_MAIN_ID=1)>
<cfset groupMain.deleteByFields(GRM_APP_MAIN_ID=4)/>

will generate the file oracle_F06C3AF7596B79237787B7C97429B5DB.cfm

when the delete function is called the same hash is generated, so that file is then loaded again.

FIX:
Include the query type in either the hash or filename to make the query more unique.

Attachments

querypatch.diff (1.0 kB) - added by jgworks 2 years ago.

Change History

Changed 2 years ago by jgworks

Changed 3 months ago by mark.drew@…

  • milestone set to 1.0 Release

Changed 3 months ago by TomChiverton

  • keywords spam added
Note: See TracTickets for help on using tickets.