Bug #75729 'active' as field name causes issue when attempting to insert
Submitted: 2 Feb 2015 18:27 Modified: 2 Mar 2015 20:32
Reporter: Zachary Buckholz Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.2 OS:Mac OS X (OS X 10.8.x Mountain Lion)
Assigned to: CPU Architecture:Any
Tags: active, field, reserved word, WBBugReporter

[2 Feb 2015 18:27] Zachary Buckholz
Description:
----[For better reports, please attach the log file after submitting. You can find it in /Users/ubuckza/Library/Application Support/MySQL/Workbench/log/wb.log]

I imported an existing mysql dump into a new database, then used mysql workbench to modify some data. My query needed to update a field named 'active', but workbench kept telling me 

Error Code: 1054. Unknown column 'active' in 'field list'

There was also a 'RED X' in the SQL editor next to that field, also auto-complete worked for all other fields when typing them out, however the word active never had an auto-complete suggestion pop up.

How to repeat:
Create a table, add a field called active, attempt to insert into said table in workbench.
[2 Feb 2015 20:32] Miguel Solorzano
Thank you for the bug report. I couldn't repeat with WorkBeanch 6.2.4 on Yosemite Version 10.10.2 against the MySQL server 5.6.22. Please provide your WorkBench version, create table and insert data statements. Thanks.
[3 Mar 2015 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".