Status/Resolution/Reason: Closed/Won't Fix/Workaround
Reporter/Name(from Bugbase): John Whish / John Whish (John Whish)
Created: 09/05/2016
Components: Database
Versions: 2016
Failure Type: Data Corruption
Found In Build/Fixed In Build: CF2016_Final /
Priority/Frequency: Minor / Unknown
Locale/System: ALL / Mac 10.9 64 bit
Vote Count: 5
Problem Description:
There appears to be unscoped vars in parseSQL of query.cfc (which is shipped with ColdFusion in the com.adobe.coldfusion package) which could have unintended side effects.
1) In the switch statement `switch(sqlType)` it sets a variable `s`. This is only scoped for the first case of `posSql` it should be scoped for all cases.
2) The `continueloop` variable is unscoped.
Use queryExecute.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4186779
External Customer Info:
External Company:
External Customer Name: John Whish
External Customer Email:
External Test Config: My Hardware and Environment details:
Attachments:
Comments: