This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 155739 - Unable to edit data in a table that contains reserved word as column name
Summary: Unable to edit data in a table that contains reserved word as column name
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-12-18 09:17 UTC by guido_ffm
Modified: 2009-10-27 16:04 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description guido_ffm 2008-12-18 09:17:24 UTC 
Unable to edit data in a table that contains a column named "key". For MySQL the column names should be escaped with
back quotes "`" to work around this issue.
Comment 1 Jiri Rechtacek 2009-02-10 15:27:03 UTC 
Reassigned to new owner.
Comment 2 Jiri Rechtacek 2009-10-27 16:04:43 UTC 
It's intentional in MySQL that the reserved words have to be escaped. Anyway, if a table contains such columns it's
possible to edit data there in NB6.8