tracker issue : CF-4043047

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

query of query WHERE filter no longer disregards filler spaces in fixed with data fields

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Steve Vail / Steve Vail (Steve Vail)

Created: 08/25/2015

Components: Database

Versions: 11.0

Failure Type: Data Corruption

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

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Windows 7

Vote Count: 0

Listed in the version Issues Fixed doc
Problem Description:  WHERE Name = 'Vail'  (from char(20) field is 'Vail                ')

Steps to Reproduce:

Actual Result: returns no match

Expected Result: an equal match

Any Workarounds: redefined  char fields as nonvarchar and rewrote every value without any spaces after

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

Watson Bug ID:	4043047

External Customer Info:
External Company:  
External Customer Name: Steve
External Customer Email:  
External Test Config: My Hardware and Environment details:ms server 2008 r2



fixed WIDTH data fields
Comment by External U.
6118 | August 25, 2015 10:52:24 AM GMT
There is a jvm flag to revert to older behaviour of honoring the spaces. -Dcoldfusion.trim.dbresult=true
Comment by Himavanth R.
6119 | September 28, 2015 11:52:49 PM GMT
This issue is fixed and the fix will be available as part of an update of ColdFusion.
Comment by Nimit S.
6120 | September 29, 2015 01:22:30 AM GMT
Verified this is fixed in CF11 Update 7 (build 11,0,07,296330) by using the JVM arg -Dcoldfusion.trim.dbresult=true Adobe, can that JVM arg please be documented? It seems the fix for some tickets is to add a JVM arg, but all these JVM args should be centrally documented or at least listed on the CF Admin Java/JVM page. (I've made that suggestion in the past too - in the PR forums I think) Thanks!, -Aaron
Comment by External U.
6121 | December 03, 2015 06:24:41 AM GMT
Thanks Aaron for pointing this out. We will get it documented.
Comment by Nimit S.
6122 | December 03, 2015 06:43:13 AM GMT
Hi Nimit, You're welcome and thanks very much! -Aaron
Comment by External U.
6123 | January 05, 2016 04:02:01 AM GMT