tracker issue : CF-4147446

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

Duplicate() Function error

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): mark landmann / mark landmann (mark landmann)

Created: 05/02/2016

Components: Core Runtime

Versions: 2016

Failure Type: Data Loss

Found In Build/Fixed In Build: CF2016_Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Windows 10 64 bit

Vote Count: 0

Duplicate ID:	CF-4122530

Problem Description:
Using a duplicate on Query return results in an empty query being returned.

Steps to Reproduce:

Create a CFC with a method, such as:

	<cffunction name="Pick" access="public" output="true" returntype="Query" DisplayName="Pick AccountType">
		<cfargument Name="SortBy" 	         	 Type="String"  	Required="No" 	Hint="SortBy" 				Default="SortPosition">
		<cfset var qPick = "" />
		<cfquery name="qPick" datasource="#variables.dsn#" cachedwithin="#CacheTime#">
			SELECT		AccountTypeCode, AccountType
			FROM		tblAccountType
			WHERE 		1 = 1
			ORDER BY 	tblAccountType.SortPosition
		<cfreturn Duplicate(qPick)>

Then call it:
<cfinvoke component="#APPLICATION.DIR#CFC2\AccountTypeDAO" 	 method="pick"  returnVariable="AccountTypeQ">
<cfdump var="#AccountTypeQ#">

Actual Result:
Query result is empty

Expected Result:
A list of account AccountTypeCode, AccountType - about 5 records in my case

Any Workarounds:

Remove the duplicate in the method:

<cfreturn qPick>

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

Watson Bug ID:	4147446

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



This is a duplicate of bug #CF-4122530. This issue is fixed and the fix will be available in the upcoming update of ColdFusion 2016.
Comment by Nimit S.
2970 | May 04, 2016 05:03:55 AM GMT