tracker issue : CF-3779331

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

Query of Query and SQL statements ending in semicolon

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Jojo Serquina / Jojo Serquina (Jojo Serquina)

Created: 06/20/2014

Components: Database

Versions: 11.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Windows 8.1/64bit

Vote Count: 1

Listed in the version 11.0.03.292480 Issues Fixed doc
Problem Description: 

Steps to Reproduce:
<cfset myQuery = QueryNew('ID,Name,Address','Integer,VarChar,Varchar') />
<cfset QueryAddRow(myQuery,1) />
<cfset QuerySetCell(myQuery,'ID',1,1) />
<cfset QuerySetCell(myQuery,'Name','John Doe',1) />
<cfset QuerySetCell(myQuery,'Address','Street Named Doe',1) />

<cfquery name="qNew" dbtype="query">
	SELECT * FROM myQuery WHERE ID = 1;
</cfquery>

<cfdump var="#qNew#">

Actual Result:
ID	 818
type	 Database
message	 Error Executing Database Query.
detail	 <br><b>Query Of Queries runtime error.</b><br> The select column reference [1;] is not a column in any of the tables of the FROM table list.



Expected Result:
The query is executed and records are returned


Any Workarounds:
Unknown (remove the semicolon)?

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

Watson Bug ID:	3779331

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

Local

Windows 8.1

Attachments:

Comments:

Used to work in pre-11
Comment by External U.
11834 | June 20, 2014 02:13:56 PM GMT
Yeah, it's a regression and accordingly should be fixed. -- Adam
Vote by External U.
11840 | June 23, 2014 07:18:21 AM GMT
Just for kicks - I installed CF11 in a newly configured VM, no other configuration other an a base OS and IIS - I am able to reproduce the issue.
Comment by External U.
11835 | June 23, 2014 08:50:06 AM GMT
This issue is fixed and this fix will be available in the upcoming update of ColdFusion 11.
Comment by Nimit S.
11836 | August 21, 2014 08:34:25 AM GMT
is it possible to get this patch now? I need to move a server
Comment by External U.
11837 | August 22, 2014 04:46:14 PM GMT
If you need the patch right now, please get in touch with the support and they would be able to give it to you.
Comment by Rupesh K.
11838 | August 25, 2014 06:12:40 AM GMT
I've verified this is fixed in CF11 Update 3. Thanks!, -Aaron
Comment by External U.
11839 | November 05, 2014 06:13:55 AM GMT