Status/Resolution/Reason: Closed/Withdrawn/Duplicate
Reporter/Name(from Bugbase): Legorol San / Legorol San (Legorol San)
Created: 04/10/2016
Versions: 11.0
Failure Type:
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Major / All users will encounter
Locale/System: English / Win All
Vote Count: 0
Duplicate ID: CF-4117243
Problem Description:
The datatypes specified in QueryNew are not enforced. If data is added to the query that can't be converted to the specified datatype, then it's just added as a string, instead of throwing an exception. This is in contrast with QueryAddColumn, which strictly enforces the datatype specified.
Affects CF 11 Update 7.
Also affects CF 10 Update 18, although in CF 10, QueryAddColumn completely ignores datatypes (see bug #4137969).
Steps to Reproduce:
Consider this code:
<!--- Create a query using QueryNew --->
<cfset firstQuery = QueryNew("id","integer",[["1"],["hello"],["3"]])>
<cfdump var=#firstQuery#>
<cfdump var=#SerializeJSON(firstQuery)#>
<!--- Create a query using QueryAddColumn --->
<cfset secondQuery = QueryNew("")>
<cfset QueryAddColumn(secondQuery,"int","integer",["1","hello","3"])>
<cfdump var=#secondQuery#>
<cfdump var=#SerializeJSON(secondQuery)#>
Actual Result:
id
1 1
2 hello
3 3
{"COLUMNS":["ID"],"DATA":[[1],["hello"],[3]]}
followed by ColdFusion exception on line 8:
Invalid data hello for CFSQLTYPE CF_SQL_INTEGER.
Expected Result:
Using QueryNew should also throw an exception when data of the wrong type is added.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4137970
External Customer Info:
External Company:
External Customer Name: Legorol San
External Customer Email:
External Test Config: My Hardware and Environment details: Windows 10 Pro 64-bitAttachments:
Comments: