| Bug #2968 | The use of the word "group" as a field name, seems to cause insert errors. | ||
|---|---|---|---|
| Submitted: | 26 Feb 2004 3:18 | Modified: | 26 Feb 2004 8:59 |
| Reporter: | Craig Haupt | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQLCC | Severity: | S3 (Non-critical) |
| Version: | 4.0.17 | OS: | Windows (Windows XP) |
| Assigned to: | Dean Ellis | CPU Architecture: | Any |
[26 Feb 2004 8:59]
Dean Ellis
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Additional info: GROUP is a reserved word, see: http://www.mysql.com/doc/en/Reserved_words.html You need to escape it with `` (backticks) or use a different name.
Description: Using mysql-4.0.17-win.zip. Using mysqlcc-0.9.4-win32.zip. Created a Table: expense oid - bigint(20) Primary key name - varchar(100) description - varchar(100 group - bigint(20) state - bigint(20) Ran the following in the MySQL CC query window: insert into expense (oid, name, description, group, state) values ("24", "asdsad", "asdasd", "20", "11"); Got the fault: [Root] 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 'group, state) values ("24", "asdsad", "asdasd", "20", "11")' at Ran the following in the MySQL CC query window: insert into expense (oid, name, description, state) values ("56", "asdsad", "asdasd", "11") This worked fine, sorry if this is expected behavior but its pretty poor if your syntax checker is not able to differentiate. How to repeat: Using mysql-4.0.17-win.zip. Using mysqlcc-0.9.4-win32.zip. Create a Table: expense oid - bigint(20) Primary key name - varchar(100) description - varchar(100 group - bigint(20) state - bigint(20) Run the following in the MySQL CC query window: insert into expense (oid, name, description, group, state) values ("24", "asdsad", "asdasd", "20", "11");