| Bug #60453 | ORDER BY column names in EDIT statement | ||
|---|---|---|---|
| Submitted: | 13 Mar 2011 18:54 | Modified: | 9 Jan 2015 16:24 |
| Reporter: | Philip Baker | Email Updates: | |
| Status: | Unsupported | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
| Version: | 5.2.33 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Edit, order by | ||
[13 Mar 2011 19:59]
Valeriy Kravchuk
Thank you for the bug report. Verified on Mac OS X.
Description: The following EDIT command works as expected: EDIT aciptbl [WHERE ...] ORDER BY volNdx Now, if the field(s) in the ORDER BY clause need to have backticks (`) around them, the SQL Editor doesn't recognize the fields and generates an error message. For example, EDIT aciptbl [WHERE ...] ORDER BY `byte count` generates the following error: Error Code: 1054 Unknown column 'byte count LIMIT 0, 1000' in 'order clause' How to repeat: This behavior happens in both Windows and MAC OS X versions of the Workbench. Suggested fix: Allow column names requiring backticks ('`') in the ORDER BY clause of an EDIT statement.