tracker issue : CF-3836820

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

queryExecute in a thread is broken

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Raymond Camden / Raymond Camden (Raymond Camden)

Created: 10/09/2014

Components: Language

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final / CF11 Update5

Priority/Frequency: Major / Most users will encounter

Locale/System: English / Mac All

Vote Count: 4

Listed in the version 11.0.05.293506 Issues Fixed doc
If you run queryExecute in a thread, the result is undefined:

<cfscript>
	
	data = querynew("id", "varchar", [{id:"a"}, {id:"b"}]);
	
	cfthread(name="d1") {
		thread.result = queryExecute("select * from data", {}, {dbtype:"query"});
	}
	cfthread(name="d2") {
		var result = queryExecute("select sleep(2), title from tblblogentries limit 0,1", {}, {datasource:"myblog"});
		thread.foo = 1;
		thread.result = result;
	}
	cfthread(action="join",name="d1,d2");
	writedump(cfthread);
</cfscript>

<cfdump var="#variables#" showudfs="false" >

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

Watson Bug ID:	3836820

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

Attachments:

Comments:

+1.................................
Vote by External U.
10736 | October 09, 2014 10:50:58 AM GMT
+1 - im sure my vote will really matter too.
Vote by External U.
10737 | October 09, 2014 01:24:50 PM GMT
This shouldn't even need voting on, but I'm afraid it'll fall to the bottom of a spreadsheet if I don't vote.
Vote by External U.
10738 | October 10, 2014 04:12:48 AM GMT
+1 ......................
Vote by External U.
10739 | November 24, 2014 05:53:09 AM GMT
The fix for this bug is available in the pre-release build of ColdFusion 11 Update 5
Comment by CFwatson U.
10734 | February 20, 2015 09:26:45 AM GMT
Verified this is fixed in CF11 Update 5 (build 11,0,05,293506). Thanks!, -Aaron
Comment by External U.
10735 | May 17, 2015 05:23:56 PM GMT