Ticket #119 (new defect)
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
Change History
Note: See
TracTickets for help on using
tickets.

