tracker issue : CF-3950189

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

Query of Query Issue in ColdFusion 11

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Joe Chittick / Joe Chittick (Joe Chittick)

Created: 03/09/2015

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 / Win 2012 Server x64

Vote Count: 1

Duplicate ID:	CF-3519030

Problem Description: When submitting a query of query in Coldfusion 11, if the data has trailing spaces on the end, the query will not return any data. In our previous environment, Coldfusion 9, the query would return the events regardless if the data had extra trailing spaces.

Steps to Reproduce:

Actual Result: When the query is ran in CF11, no results are produced.

Expected Result: When the query is ran in CF9, the correct results are returned.

Any Workarounds:

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

Watson Bug ID:	3950189

External Customer Info:
External Company:  
External Customer Name: Joe
External Customer Email:  
External Test Config: My Hardware and Environment details: HP Proliant DL360 GEN9 running Server 2012 and the latest version of CF11.

Attachments:

  1. March 10, 2015 00:00:00: 1_CF11Bug.zip

Comments:

Please let me know if you need any more info. I am not the developer, just a network guy submitting on his behalf.
Comment by External U.
8128 | March 09, 2015 01:09:02 PM GMT
Here is the code: <cfset list=queryNew("code,description","varchar,varchar")> <cfset queryAddRow(list)> <cfset querySetCell(list,"code","TYT ")> <cfset querySetCell(list,"description","Toyota")> <cfset queryAddRow(list)> <cfset querySetCell(list,"code","HND ")> <cfset querySetCell(list,"description","Honda")> <cfset queryAddRow(list)> <cfset querySetCell(list,"code","HMMR ")> <cfset querySetCell(list,"description","Hummer")> <cfset queryAddRow(list)> <cfset querySetCell(list,"code","CHVLT")> <cfset querySetCell(list,"description","Chevrolet")> Data inside the "list" table. <table border="1" cellspacing="0" cellpadding="4"> <tr> <td>Code</td> <td>Code Length</td> <td>Description</td> </tr> <cfoutput query="list"> <tr> <td>#list.code#</td> <td>#Len(list.code)#</td> <td>#list.description#</td> </tr> </cfoutput> </table> <br /><br /> Select * from list where code='TYT' or code='HND' <br /><br />In ColdFusion 6, the above query will give you Toyota and Honda, but in ColdFusion 11, it will not give you any results. <br /><br /> Query Result: <cfquery name="tyt" dbtype="query"> Select * from list where code='TYT' or code='HND' </cfquery> <cfdump var="#tyt#">
Comment by External U.
8129 | March 16, 2015 03:30:01 PM GMT
Joe, Does your database data have spaces? I am working a case where QoQ is working in CF9 and not in CF11 but we are not injecting spaces, however, it seems like QoQ is adding \ padding spaces. So = 'test' will return 0 rows (returns rows in CF9) like 'test%' will return rows. Although a len on the column would return 4 in the above example on the db query. Thanks.
Comment by External U.
8130 | April 09, 2015 08:26:48 AM GMT
Experiencing the exact same issue. We have the same source that has been in a production eCommerce site using CF9, CF10, but after upgrading our test environment to CF11, we are unable to get query results as the issue has stated.
Vote by External U.
8131 | January 27, 2016 02:10:17 PM GMT