tracker issue : CF-3356884

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

SQL Queries with commas in the column name cannot be introspected

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): will coleda / will coleda (will coleda)

Created: 10/31/2012

Components: Database

Versions: 9.0.1

Failure Type: Crash

Found In Build/Fixed In Build: 9.0.1 / 288313

Priority/Frequency: Critical / Some users will encounter

Locale/System: English / Linux All

Vote Count: 0

Problem Description: A query that contains commas in a column name (e.g. something with a function with multiple arguments and no column alias) cannot be introspected with <cfdump>

Steps to Reproduce:

Against an Oracle database, try:

<cfquery name="eek">

select decode(1,1,1) from dual


<cfdump var="#eek#">

Actual Result:

Throws a java exception:

[Table (rows 1 columns DECODE(1,1,1)): [DECODE(1,1,1): coldfusion.sql.QueryColumn@28826c2c] ] is not indexable by DECODE(1

Expected Result:

CFDUMP output showing a resultset of a single cell with a value of 1.

Any Workarounds:

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

Watson Bug ID:	3356884


External Customer Info:
External Company:  
External Customer Name: CokeGod
External Customer Email:  
External Test Config: Happens on 9.0.1 on my OSX development box using the standalone developer edition as well as on our redhat linux/jboss installation (also 9.0.1)



Can you please provide more elaborated test case for this issue?
Comment by Nimit S.
17321 | October 27, 2013 05:12:08 AM GMT
I'm not sure what more elaboration is required - I've provided code that should work but instead generates an exception. Can you be more specific about the details you need?
Comment by External U.
17322 | October 27, 2013 03:11:08 PM GMT
This fix will be available in the next major release.
Comment by Nimit S.
17323 | February 09, 2014 07:15:31 AM GMT