tracker issue : CF-3369252

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

CF9 Query of Queries on CF10 Query object only returns the first row

| View in Tracker

Status/Resolution/Reason: Closed/Won't Fix/Workaround

Reporter/Name(from Bugbase): Chris Le Moeligou / Chris Le Moeligou (ChrisLeM)

Created: 11/21/2012

Components: Database

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final /

Priority/Frequency: Minor / Few users will encounter

Locale/System: English / Win All

Vote Count: 0

Problem Description: When a cfquery object is serialised on Coldfusion 10 and deserialised on Coldfusion 9, a query of queries operation on the deserialised object only returns a single row, specifically the first row of data. The query object seems to function correctly otherwise (cfdump correctly shows all data, recordcount variable returns correct count etc).

Steps to Reproduce: Create query object on CF10. Serialise to Base64 using toBase64 and objectsave. Copy serialised object to a CF9 server. Deserialise object using objectload and tobinary. Perform SELECT * query of queries on deserialised object. (Script is attached to run on CF10 then CF9 to reproduce.)

Actual Result: The first row of data is returned

Expected Result: All the rows from the original query should be returned

Any Workarounds: None known

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

Watson Bug ID:	3369252

External Customer Info:
External Company:  
External Customer Name: ChrisLeM
External Customer Email:  
External Test Config: Tested on CF10 Standard (10,0,4,283281) Win2008r2, and CF9 Standard (9,0,1,274733) Win2008r2 and CF9 developer instance (9,0,1,274733) Windows7 

JVM 1.6_24 (CF9) and 1.6_34 (CF9/CF10)

Attachments:

  1. November 21, 2012 00:00:00: 1_CF9QoQonCF10Query.cfm

Comments:

I realise that this is an edge case but currently we are consuming CF10 query objects in CF9 via a webservice and would appreciate and insight/workarounds.
Comment by External U.
17158 | November 21, 2012 05:18:02 AM GMT
JSON?
Comment by External U.
17159 | August 29, 2013 12:30:34 PM GMT
Verified in Coldfusion 10 Update 11 (Comment added from ex-user id:nawani)
Comment by Adobe D.
17160 | September 23, 2013 06:11:54 AM GMT
This is using ObjectSave function which may not work across versions. Looks like an edge case. If it works within the same versions, it should be ok. For working across versions, please use json serialization.
Comment by Himavanth R.
17161 | January 15, 2014 05:26:38 AM GMT