| Bug #252 | mysql client comment processing seems to be bad. | ||
|---|---|---|---|
| Submitted: | 8 Apr 2003 12:55 | Modified: | 26 Apr 2003 5:53 |
| Reporter: | Peter Zaitsev (Basic Quality Contributor) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 4.0.12 | OS: | Any (all) |
| Assigned to: | Jani Tolonen | CPU Architecture: | Any |
[26 Apr 2003 5:53]
Michael Widenius
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at http://www.mysql.com/downloads/ Couldn't repeat with 4.0 development tree. (Maybe old mysql client was used ?)
Description: It looks like mysql client does not handle comment chars escaped with `` properly. Note both # and -- comments are broken. How to repeat: mysql> create table a (`po#` int); -> ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 mysql> create table a (`po-- ` int);