tracker issue : CFB-4193624

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

Seemingly every time that I try to write a SQL CASE statement, CF Builder locks up and is unresponsive.

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): Eric Belair / Eric Belair (Eric Belair)

Created: 09/27/2016

Components: Performance

Versions: 2016,3.0

Failure Type: Crash

Found In Build/Fixed In Build: 3.0 Final , ColdFusion Builder 2016 update 3 /

Priority/Frequency: Major / Unknown

Locale/System: English / Windows 10

Vote Count: 0

Problem Description:
I am writing a SQL query with sub-queries and CASE statements. When I am in the middle of writing a CASE statement, ColdFusion locks up, is unresponsive, and I am forced to start and restart the application.

Steps to Reproduce:

Actual Result:

Expected Result:

Any Workarounds:

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

Watson Bug ID:	4193624

Reason:	BugVerified

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

Manufacturer: HP Inc.

Model: HP ProDesk 400 G2.5 SFF

Processor: Intel(R) Core(TM) i5-4590S CPU @ 3.00GHz

Installed Memory: 12.0GB

System type: 64-bit Operating System, x64-based processor

Operating System: Windows 10 pro



Eric, Here is a Code snippet which I tried to reproduce the case <cfquery name="myQuery" datasource="cfartgallery"> <!--- SELECT * FROM Orders where ORDERID in(Select orderid from Orders where tax > 800) ---> SELECT CUSTOMERFIRSTNAME, CUSTOMERLASTNAME, TAX CASE Tax WHEN Tax = 0 THEN '100' WHEN Tax < 500 THEN '250' WHEN Tax >= 500 and Tax < 1000 THEN '750' WHEN Tax >= 1000 and Tax < 5000 THEN '2000' ELSE '8000' END FROM ORDERS where ORDERID in(Select City from Orders where city like = 'D%') </cfquery> <cfdump var="#myquery#"/> Can you please provide other repro case if above is not matching , then we will fix your repro case as well . Thanks Subir
Comment by Subir J.
26117 | October 04, 2016 05:38:29 AM GMT
Eric, I was trying to replicate the issue you mentioned but I was unable to reproduce. Can you please provide SQL code in which ColdFusion Builder stops responding. Any help would be highly appreciated. Thanks and Regards Nikhil Dubey
Comment by Nikhil D.
26118 | March 27, 2017 08:35:22 AM GMT