| Bug #7540 | cannot create a table containing fied INT1 | ||
|---|---|---|---|
| Submitted: | 27 Dec 2004 8:30 | Modified: | 27 Dec 2004 13:39 |
| Reporter: | Nicolas Lozano | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 4.1.8 | OS: | Windows (Windos XP SP2) |
| Assigned to: | CPU Architecture: | Any | |
[27 Dec 2004 13:39]
Alexander Keremidarski
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: INT1 .. INT4 are mapped to INTEGER types for compatibility with other products
[12 Jun 2005 19:58]
Henning Andersen
Hello, I was having a similar problem as Nicolas describes. I'm however wondering why int1 and so forth aren't made reserved words then? Because it isn't very userfriendly in the manual to look elsewhere. And int1 (and int2 and ...) are merely mapped to another type so in fact they are reserved words? It's just a suggestion for improving documentation. Best regards, Henning
Description: When I have tried to create a table or index using fields named INTx where x is a number : mysql return a error I have the same error using MyODVC-3.51.10 or MySql-Connector-java-3.0.16 or the client Mysql ver 14.7 create table PMTEMP ( SESS int not null, INT1 int , INT2 int , STR1 varchar(254) , STR2 varchar(254) ) ; returns ERROR 1064 (42000) How to repeat: create table PMTEMP ( SESS int not null, INT1 int , INT2 int , STR1 varchar(254) , STR2 varchar(254) ) ;