tracker issue : CF-4201446

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

CFQUERY BUG

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/NotABug

Reporter/Name(from Bugbase): Chad Adamson / Chad Adamson ()

Created: 03/06/2018

Components: Language, Functions

Versions: 2016

Failure Type: Others

Found In Build/Fixed In Build: 2016.0.05.303689 /

Priority/Frequency: Normal /

Locale/System: / Win 2012 Server x64

Vote Count: 0

Problem Description:
Any queries that have a column named "enabled" in them return 0 results.
Steps to Reproduce:
SELECT * FROM events WHERE  enabled = 1
Actual Result:
0 records
Expected Result:
All records where column enabled = 1
Any Workarounds:
SELECT * FROM events WHERE events.enabled = 1

Attachments:

Comments:

I found the problem. I was testing ColdFusion 2016 Standard on the same MySQL 5.7 database as the production server running ColdFusion 9 Enterprise. After making a copy of the production database and using the copied database for testing, the SQL statements are now executing correctly.
Comment by Chad A.
74 | March 09, 2018 02:48:50 AM GMT