tracker issue : CF-3795774

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

Query Of Query generating different responses between CF10 and CF11

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Alan Bullpitt / Alan Bullpitt (Alan Bullpitt)

Created: 07/28/2014

Components: Database

Versions: 11.0

Failure Type: Data Loss

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Windows 7 SP1 64-bit

Vote Count: 1

Duplicate ID:	CF-3783011

Problem Description: When using multiple QOQ on the same page over the same original query I am getting different results to that of Coldfusion 10. 

Steps to Reproduce: I create 2 queries. tempQuery and tempQuery2. I do a cfdump of tempQuery. I then create a new QoQ linking tempQuery and tempQuery2. Then run a select * QoQ on tempQuery and dump the output. The results are now different to the original dump.

Compare the results on both a CF10 instance and CF11 instance.

Test file supplied.

Actual Result: In Coldfusion 11 the new result set is actually less than the original. In Coldfusion 10 the results are the same.

Expected Result: Both results of the dumps should be the same. 

Any Workarounds: Create new query variables using duplicate for each query used.

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

Watson Bug ID:	3795774

External Customer Info:
External Company:  
External Customer Name: Abullpitt
External Customer Email:  
External Test Config: My Hardware and Environment details:



Server Details

Server Product	ColdFusion

Version	11,0,0,289822

Edition	Enterprise (Trial)  

Operating System	Windows 7  

OS Version	6.1  

Adobe Driver Version	5.1.1 (Build 0001)  





JVM Details

Java Version	1.7.0_51  

Java Vendor	Oracle Corporation  

Java Vendor URL	http://java.oracle.com/  

Java Home	C:\ColdFusion11\jre  

Java File Encoding	Cp1252  

Java Default Locale	en_US  

File Separator	\  

Path Separator	;  

Line Separator	Chr(13)  

User Name	WS-T3500-02$  

User Home	C:\  

User Dir	C:\ColdFusion11\cfusion\bin  

Java VM Specification Version	1.7  

Java VM Specification Vendor	Oracle Corporation  

Java VM Specification Name	Java Virtual Machine Specification  

Java VM Version	24.51-b03  

Java VM Vendor	Oracle Corporation  

Java VM Name	Java HotSpot(TM) 64-Bit Server VM  

Java Specification Version	1.7  

Java Specification Vendor	Oracle Corporation  

Java Specification Name	Java Platform API Specification  

Java Class Version	51.0

Attachments:

  1. July 29, 2014 00:00:00: 1_qoq_test.cfm

Comments:

I can replicate this. This strikes me as potentially a rather significant bug? -- Adam
Vote by External U.
11511 | July 29, 2014 02:35:57 AM GMT