Menu

#2652 (ok 2.11.7) new field cannot be autoincrement and PK

2.11.5
fixed
Interface (555)
1
2013-06-11
2008-03-06
Laconero
No

In a table with various fields, if you can insert a new one, type int, you cannot select auto_increment and primary key button at the same time
You get an error:
SQL query:
ALTER TABLE `Jefes` ADD `numID` INT( 5 ) NOT NULL AUTO_INCREMENT FIRST
MySQL said: Documentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

This happen with phpmyadmin 2.11.3, 2.11.4 and 2.11.5, but not with 2.11.2
I am using firefox 2.0.0.12, mysql 5.0.45, an MacOSX 10.4.11

Discussion

  • Marc Delisle

    Marc Delisle - 2008-03-06

    Logged In: YES
    user_id=210714
    Originator: NO

    Confirmed.

     
  • Marc Delisle

    Marc Delisle - 2008-03-06
    • milestone: --> 2.11.5
     
  • Marc Delisle

    Marc Delisle - 2008-04-23
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2008-04-24

    Logged In: YES
    user_id=210714
    Originator: NO

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2008-04-24
    • priority: 5 --> 1
    • summary: you cannot select autoincrement and primary key in new field --> (ok 2.11.7) new field cannot be autoincrement and PK
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2008-06-23
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed