tracker issue : CF-4153580

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

Coldfusion 11 update 8 breaks left and right sql sever functions

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Anthony Morse / Anthony Morse (Anthony Morse)

Created: 05/16/2016

Components: Database

Versions: 11.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Win 2012 Server x64

Vote Count: 2

Listed in the version 2016.0.02.299200 Issues Fixed doc
Verification notes: verified_ignore on February 13, 2020 using build 2016.0.02.299200
Problem Description: After applying coldfusion 11 update 8 any sql using the functions left or right returns an error

Steps to Reproduce: Run any sql using left or right functions example = select left(field, 5) as test from testtable order by left(field, 5) 

Actual Result: returns a sql error message

Expected Result: sql query should run

Any Workarounds: uninstall coldfusion 11 update 8

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

Watson Bug ID:	4153580

External Customer Info:
External Company:  
External Customer Name: Anthony Morse
External Customer Email:  
External Test Config: cold fusion 11 update 7  / sql server 2012, windows 2012 server



Anthony, I have tried to repro this issue, but I am unable to do so. It works fine at my end. Please provide the details mentioned below: 1. Database version 2. Database driver being used. 3. Settings summary
Comment by Nimit S.
2780 | May 17, 2016 11:06:00 PM GMT
I have the same problem. I've pinned it down to the order by causing the error. The select left(field, 5) works as it should.
Comment by External U.
2781 | May 19, 2016 11:08:17 AM GMT
I can confirm this behavior. The query works in SQL Server Management Studio, but not in a ColdFusion script. CF11 update 8, SQL Server 2012, Windows Server 2012.
Comment by External U.
2782 | May 19, 2016 12:50:26 PM GMT
Database version info is: Microsoft SQL Server Standard (64-bit) - Microsoft Windows NT 6.2 (9200) - 11.0.6020.0 I am using the Microsoft SQL Server driver on the datasource The setting son the data source are all standard
Comment by External U.
2783 | May 30, 2016 05:42:58 PM GMT
Thanks Anthony We are able to repro this issue now. I will work on it.
Comment by Nimit S.
2784 | June 01, 2016 06:01:07 AM GMT
This issue is fixed now and the fix will be available as part of ColdFusion 11 Update 9 and ColdFusion 2016 Update 2.
Comment by Nimit S.
2785 | June 07, 2016 05:14:30 AM GMT
And when will the updates be release?
Comment by External U.
2786 | June 08, 2016 08:02:39 AM GMT
More concerning is how this broke in the first place. Is ColdFusion trying to parse the SQL?
Comment by External U.
2787 | June 10, 2016 09:42:08 AM GMT
fixed in on June 14, 2016
Comment by External U.
2788 | June 14, 2016 11:44:40 AM GMT