[Phpmyadmin-devel] bug in MYSQL40 compatibility mode

[Sebastian Mendel]

Marc Delisle schrieb:
> Hi,
> 
> I wonder if we should stop to offer the MYSQL40 mode in export, or at 
> the very least display a big warning about it. In this mode, MySQL 
> creates a dump that removes the auto_increment clause for the primary key!
> 
> Marc
> 
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 358345 to server version: 5.0.21-standard
> 
> mysql> show create table bug1607282;
> 
> CREATE TABLE `bug1607282` (
>    `id` int(11) NOT NULL auto_increment,
>    `description` varchar(100) NOT NULL,
>    PRIMARY KEY  (`id`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1
> 
> mysql> set sql_mode=MYSQL40;
> 
> mysql> show create table bug1607282;
> 
> CREATE TABLE `bug1607282` (
>    `id` int(11) NOT NULL,
>    `description` varchar(100) NOT NULL,
>    PRIMARY KEY  (`id`)
> ) TYPE=MyISAM


is there any bug report about this at mysql?


-- 
Sebastian Mendel

www.sebastianmendel.de