Bug #30845 | InnoDB: misleading error message for key creation | ||
---|---|---|---|
Submitted: | 5 Sep 2007 22:28 | Modified: | 1 Oct 2007 10:26 |
Reporter: | Paul DuBois | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Errors | Severity: | S3 (Non-critical) |
Version: | 4.1 and up | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[5 Sep 2007 22:28]
Paul DuBois
[5 Sep 2007 22:35]
MySQL Verification Team
Thank you for the bug report. Verified as described.
[6 Sep 2007 11:20]
Heikki Tuuri
The error message texts are not inside InnoDB. Reclassifying this as a MySQL Server bug. The error message could be clearer.
[10 Sep 2007 19:16]
Ricardo Cuevas
This is not a solution, on MyISAM, if you declare the auto_increment after another column, on the key. MyISAM, make separate numbers of auto_increment. Changue the text not fix the problem. Sorry by my poor english.
[10 Sep 2007 19:25]
Paul DuBois
Clarification: The original report is specific to InnoDB and applies only to InnoDB.
[5 Dec 2010 17:36]
Valeriy Kravchuk
This is still not fixed: macbook-pro:5.1 openxs$ bin/mysql -uroot test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.1.54-debug Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> drop table if exists t; Query OK, 0 rows affected (0.02 sec) mysql> create table t ( -> i int unsigned not null auto_increment, -> j int not null, -> index (j, i) -> ) engine=innodb; ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key mysql> drop table if exists t; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> create table t ( -> i int unsigned not null auto_increment, -> j int not null, -> index (i, j) -> ) engine=innodb; Query OK, 0 rows affected (0.07 sec)