Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)
Created: 04/11/2014
Components: Caching
Versions: 11.0
Failure Type:
Found In Build/Fixed In Build: PublicBeta /
Priority/Frequency: Major / Some users will encounter
Locale/System: English / Win All
Vote Count: 0
ColdFusion 10 Update 11 broke cacheGetAllIDs() for query objects. It is still broken in CF11.
For query objects, CF10's (before Update 11) cacheGetAllIDs() returns an array of IDs. In CF10 Update 11+, and CF11, it returns an array of coldfusion.sql.QueryDetails objects.
Steps to Reproduce:
Place these files in site root, and compare result in CF10 (before Update 11) and CF11:
ehcache.xml
-----------
<?xml version="1.0" encoding="UTF-8"?>
<ehcache xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="ehcache.xsd">
<diskStore path="java.io.tmpdir"/>
<cacheManagerEventListenerFactory class="" properties=""/>
<defaultCache maxElementsInMemory="10000" eternal="false" timeToIdleSeconds="86400" timeToLiveSeconds="86400" overflowToDisk="false" diskSpoolBufferSizeMB="30" maxElementsOnDisk="10000000" diskPersistent="false" diskExpiryThreadIntervalSeconds="3600" memoryStoreEvictionPolicy="LRU" clearOnFlush="true" statistics="true" />
</ehcache>
Application.cfc
-----------
component {
THIS.name = "CF10vsCF11wrtCacheGetAllIDs";
THIS.cache.configfile = expandPath("./ehcache.xml");
}
index.cfm
-----------
<cfscript>
cacheRemoveAll("query");
q = queryNew("");
</cfscript>
<cfquery name="q" dbtype="query" cachedwithin="#createTimeSpan(0,0,1,0)#">
SELECT * FROM q
</cfquery>
<cfset writeDump(cacheGetAllIDs("query")) />
Expected result in CF10 and CF11: An array containing an ID.
Actual result in CF10 (before Update 11): An array containing an ID.
Actual result in CF10 (Update 11+) and CF11: An array containing a coldfusion.sql.QueryDetails object.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3741588
External Customer Info:
External Company:
External Customer Name: itisdesign
External Customer Email:
Attachments:
Comments: