tracker issue : CFB-3809129

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

SQL Comments cause Builder to Freeze/Crash

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/Fixed

Reporter/Name(from Bugbase): Carl Von Stetten / Carl Von Stetten (Carl Von Stetten)

Created: 08/20/2014

Components: General - IDE, Performance

Versions: 2016,3.0,2018

Failure Type: Crash

Found In Build/Fixed In Build: 3.0 Final / Latest

Priority/Frequency: Critical / Some users will encounter

Locale/System: English / Windows 7 64-bit

Vote Count: 4

Problem Description: Within <cfquery> tags, if inline SQL comments ("-- my comment" placed at end of a line of SQL code) are used, and you later reopen the file to make edits to the query, CF Builder will freeze/crash.

Steps to Reproduce: Use a "-- something" type comment inline within a SQL statement, within a <cfquery> tag.

Actual Result: Builder will freeze (become unresponsive), then eventually have to be killed manually/crashes.

Expected Result: Builder should work normally and not freeze.

Any Workarounds:  Don't embed "-- something" style comments in SQL statements.  Put the comment in a <!--- ---> ColdFusion comment above the <cfquery> tag.

Note - I haven't checked to see if "/* */" style comments cause problems.

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

Watson Bug ID:	3809129

Reason:	BugVerified

External Customer Info:
External Company:  
External Customer Name: Carl Von Stetten
External Customer Email:  
External Test Config: Windows 7 64-bit, ColdFusion Builder 3.0 (latest updates applied).

Attachments:

Comments:

I have a huge query that I have a lot of coldfusion comments throughout, but I cannot edit the file because the editor freezes. I do not want to have to put comments outside of the query as it describes what is happening throughout. I use a different editor to modify that file.
Vote by extuser
26861 | August 21, 2014 02:25:07 AM GMT
Happens to me too on CFB 3......
Vote by extuser
26862 | July 07, 2015 07:22:44 AM GMT
Happens in CFB on line 1460 of the same file, in the same CFQUERY tag, a big SQL query which contains multiple CFML comment tags too.
Vote by extuser
26863 | August 27, 2015 04:48:06 AM GMT