tracker issue : CF-3818767

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

Serialization of query does not respect case

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

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

Created: 09/04/2014

Components: Language

Versions: 11.0

Failure Type: Cosmetic Issue

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

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Mac 10 All

Vote Count: 3

Listed in the version 11.0.05.293506 Issues Fixed doc 
CF11 added a new way to serialize queries (array of structs) - but in doing so it capitalizess column names. It should respect the case you used in SQL. If I did:

select beer, respectMADARNCase from goo

when serialized I'd expect to see beer and respectMADARNCase. The CF query object has access to the original case in SQL so this shouldn't be a problem.

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

Watson Bug ID:	3818767

Keywords:
FixTested


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

Attachments:

Comments:

Agreed. We live in a case-sensitive world. It's one thing for CF to *ignore* case, but it should still *preserve* it. -- Adam
Vote by External U.
11077 | September 04, 2014 04:35:54 PM GMT
Definitely +1 "Hokey religions and ancient weapons are no match for a good blaster at your side, kid." - Han Solo, Star Wars
Vote by External U.
11078 | September 04, 2014 04:59:44 PM GMT
We add a flag in application and based on that the columnName case wil be eithered preserved/uppercase for all three query formats.
Comment by Awdhesh K.
11068 | November 17, 2014 02:17:55 AM GMT
Added new setting in application.cfc to preserve the case of Query columns name. The setting is "this.SERIALIZATION.PRESERVECASEFORQUERYCOLUMN" which can be set to true/false.
Comment by Awdhesh K.
11069 | November 18, 2014 07:01:08 AM GMT
+1 ......................
Vote by External U.
11079 | November 24, 2014 02:28:53 AM GMT
Hi Awdhesh, Thanks for adding that. Just curious: What will be the default value? Thanks!, -Aaron
Comment by External U.
11070 | November 24, 2014 02:29:34 AM GMT
@ItIsDesign The default value would be "false"
Comment by Immanuel N.
11071 | December 23, 2014 02:22:41 AM GMT
Is this released? It is marked as fixed, but I don't see it in my latest CF11.
Comment by External U.
11072 | December 23, 2014 07:22:35 AM GMT
Also, when it is released, do not forget to update the docs.
Comment by External U.
11073 | December 23, 2014 07:23:39 AM GMT
No, it is not released yet. It would be included in a future update.
Comment by Rupesh K.
11074 | December 23, 2014 07:35:51 AM GMT
The fix for this bug is available in the pre-release build of ColdFusion 11 Update 5
Comment by CFwatson U.
11075 | February 20, 2015 09:26:39 AM GMT
You did not update the docs. I will.
Comment by External U.
11076 | April 14, 2015 12:59:01 PM GMT