tracker issue : CF-4205435

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

setColumnNames method not working on query introduced by hotfix 5

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/Fixed

Reporter/Name(from Bugbase): Giancarlo G. / ()

Created: 10/15/2019

Components: Database, CFQuery

Versions: 2018

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: Update 5 build 315699 / CF2018U6

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Win 2016

Vote Count: 3

Problem Description:
When trying to use setColumnNames to rename a query's columns the following error is thrown.

Either there are no methods with the specified method name and argument types or the setColumnNames method is overloaded with argument types that ColdFusion cannot decipher reliably. ColdFusion found 0 methods that match the provided arguments. If this is a Java object and you verified that the method exists, use the javacast function to reduce ambiguity.

Steps to Reproduce:
Write a simple query and try to rename columns like below
{code:java}
<cfscript>
qry = queryExecute("SELECT userID, email FROM users");
qry.setColumnNames(["id","emailAddress"]);
</cfscript>
{code}


Actual Result:
Error

Expected Result:
Query Object with columns renamed

Any Workarounds:
Revert hotfix 5

Attachments:

Comments:

Why is this ticket set to fixed? The "fixed in build" field is still empty. This problem was introduced in HF5
Comment by Dik K.
31608 | October 16, 2019 09:42:45 AM GMT
Hello, This issue is fixed. However, it is still not tested. Please let me know if you want an early access private patch for this issue. -Nimit
Comment by Nimit S.
31618 | October 16, 2019 12:15:24 PM GMT
Hello Nimit, I have reverted hotfix 5 on all my servers and I have another bug to submit today that appears to be a parsing issue. You can send me the private patch but I think for now I will leave all staging and production servers @ hotfix 4.
Comment by Giancarlo G.
31619 | October 16, 2019 03:32:07 PM GMT
we have seen this issue since upgrading to CF2018 hotfix 5. Our development server which is on cf2018 hoxfix4 does not have this issue. Please let me know if there is a workaround or early release patch we can try.
Comment by Brian M.
31681 | October 24, 2019 04:13:53 PM GMT
This issue is fixed. The fix for this issue will be available as part of the upcoming update of ColdFusion 2018.
Comment by Nimit S.
31717 | November 06, 2019 04:54:47 PM GMT