tracker issue : CF-4126645

select a category, or use search below
(searches all categories and all time range)
Title:

[ANeff] Bug for: CF11 vs CF12 wrt cachedWithin=0

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)

Created: 03/09/2016

Components: Caching

Versions: 2016

Failure Type:

Found In Build/Fixed In Build: Alpha_v12 /

Priority/Frequency: Major / Some users will encounter

Locale/System: English / Win All

Vote Count: 1

Pre-CF12, cachedwithin=0 returns a non-cached query (expected). In CF12, cachedwithin=0 returns a cached query (bug).

Repro:

<cfscript>
  q1 = queryNew("myCol");
  q2 = queryExecute("SELECT myCol FROM q1", [], {dbtype="query", cachedwithin=0});
  q3 = queryExecute("SELECT myCol FROM q1", [], {dbtype="query", cachedwithin=0});
  writeDump(q3.getResult().cached);//pre-CF12 returns false; CF12 returns true
</cfscript>

Same result for QoQ and non-QoQ.

Same result for internal cache and Ehcache.

Data corruption can occur if the unexpectedly-cached response is treated as a non-cached response.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4126645

External Customer Info:
External Company:  
External Customer Name: Aaron Neff
External Customer Email: adobelabs@itisdesign.com
External Test Config:

Attachments:

Comments:

Adding BUG AUDIT TRAIL ********action: updated fieldName: Status newValue: Fixed oldValue: ToTest oprid: mukumar recordName: RQ_DEFECT timpestamp: 2015-09-24 04:35:34.0 action: updated fieldName: Reason newValue: Blank oldValue: Fixed oprid: mukumar recordName: RQ_DEFECT timpestamp: 2015-09-24 04:35:34.0 action: updated fieldName: State newValue: Closed oldValue: Open oprid: mukumar recordName: RQ_DEFECT timpestamp: 2015-09-24 04:35:34.0 action: updated fieldName: Owner newValue: Blank oldValue: mukumar oprid: mukumar recordName: RQ_DEFECT timpestamp: 2015-09-24 04:35:34.0 action: updated fieldName: Closed By newValue: mukumar oldValue: Blank oprid: mukumar recordName: RQ_DEFECT timpestamp: 2015-09-24 04:35:34.0 action: updated fieldName: Date Closed newValue: 2015-09-23 21:35:34.0 oldValue: Blank oprid: mukumar recordName: RQ_DEFECT timpestamp: 2015-09-24 04:35:34.0 action: updated fieldName: QE Assigned newValue: mukumar oldValue: aksriniv oprid: aksriniv recordName: RQ_DEFECT timpestamp: 2015-09-23 06:52:20.0 action: updated fieldName: Owner newValue: mukumar oldValue: aksriniv oprid: aksriniv recordName: RQ_DEFECT timpestamp: 2015-09-23 06:52:20.0 action: updated fieldName: Date Fixed newValue: 2015-09-21 03:49:14.0 oldValue: Blank oprid: sanniset recordName: RQ_DEFECT timpestamp: 2015-09-21 10:49:14.0 action: updated fieldName: Fixed By newValue: sanniset oldValue: Blank oprid: sanniset recordName: RQ_DEFECT timpestamp: 2015-09-21 10:49:14.0 action: updated fieldName: Owner newValue: aksriniv oldValue: sanniset oprid: sanniset recordName: RQ_DEFECT timpestamp: 2015-09-21 10:49:14.0 action: updated fieldName: Reason newValue: Fixed oldValue: BugVerified oprid: sanniset recordName: RQ_DEFECT timpestamp: 2015-09-21 10:49:14.0 action: updated fieldName: Status newValue: ToTest oldValue: ToFix oprid: sanniset recordName: RQ_DEFECT timpestamp: 2015-09-21 10:49:14.0 action: updated fieldName: Changelist newValue: 295595 oldValue: Blank oprid: sanniset recordName: RQ_DEFECT timpestamp: 2015-09-21 10:49:14.0 action: updated fieldName: Owner newValue: sanniset oldValue: aksriniv oprid: aksriniv recordName: RQ_DEFECT timpestamp: 2015-09-15 09:31:22.0 action: updated fieldName: Status newValue: ToFix oldValue: Unverified oprid: aksriniv recordName: RQ_DEFECT timpestamp: 2015-09-15 09:31:22.0 action: updated fieldName: Found in Phase newValue: Alpha oldValue: Blank oprid: aksriniv recordName: RQ_DEFECT timpestamp: 2015-09-15 09:31:22.0 action: updated fieldName: Reason newValue: BugVerified oldValue: Blank oprid: aksriniv recordName: RQ_DEFECT timpestamp: 2015-09-15 09:31:22.0 action: updated fieldName: Fix By Product Milestone newValue: Beta oldValue: Blank oprid: aksriniv recordName: RQ_DEFECT timpestamp: 2015-09-15 09:31:22.0 action: updated fieldName: Fix By Milestone newValue: Beta oldValue: Blank oprid: aksriniv recordName: RQ_DEFECT timpestamp: 2015-09-15 09:31:22.0 action: updated fieldName: Priority newValue: 3 oldValue: 0 oprid: vmannebo recordName: RQ_DEFECT timpestamp: 2015-09-08 06:22:30.0 action: added fieldName: Vote Type newValue: BETA oldValue: Blank oprid: prerelease recordName: AD_DEFECT_VOTE timpestamp: 2015-08-26 07:54:57.0
Comment by CFwatson U.
3623 | March 09, 2016 04:24:24 AM GMT
Again, defeats the whole point of having immutable data structures.
Vote by External U.
3625 | March 09, 2016 04:24:26 AM GMT
Added By: PreRelease User User Name:Aaron Neff Note Added: YVW! Date Added :2015-12-09 04:04:18.0 Added By:vmannebo Note Added: Thanks Aaron for confirming the fix works. Date Added :2015-12-09 03:44:54.0 Added By: PreRelease User User Name:Aaron Neff Note Added: Just noting I've already verified this is fixed. Thanks! Date Added :2015-12-09 02:40:28.0 Added By: PreRelease User User Name:Aaron Neff Note Added: Adobe, can this please be fixed in the next Alpha? Thanks! Date Added :2015-09-15 07:52:45.0 Added By: PreRelease User User Name:Aaron Neff Note Added: Entered Bug. Date Added :2015-08-26 05:39:22.0
Comment by CFwatson U.
3624 | March 09, 2016 04:24:27 AM GMT