[Phpmyadmin-devel] bug #4540: table create issue
marc at infomarc.info
Mon Sep 22 14:30:51 CEST 2014
Smita a écrit :
> On Mon, Sep 22, 2014 at 5:37 PM, Marc Delisle <marc at infomarc.info> wrote:
>> Smita a écrit :
>>> This is in reference of bug in current master. While I was debugging
>>> code to fix the issue, I found that we are trying to force the column to
>>> primary key if auto_increment has been checked.
>>> there is this comment in Table.class.php:
>>> // Force an auto_increment field to be part of the primary key
>>> // even if user did not tick the PK box;
>>> anyone have an idea why are we doing so ?
>> Hi Smita,
>> This is a misinterpretation of the doc. In  we see that the column
>> must be indexed, not necessarily part of the primary key.
>> I have the impression that traditionally, people use the auto_increment
>> mostly on the primary key but it's not mandatory.
>> yeah, So I think we should not force the auto_increment to be primary key,
> right? This will also fix the bug.
Indeed, we should not.
>>>  https://sourceforge.net/p/phpmyadmin/bugs/4540/
>>  http://dev.mysql.com/doc/refman/5.5/en/create-table.html
>> Marc Delisle (phpMyAdmin)
Marc Delisle (phpMyAdmin)
More information about the Developers