[Phpmyadmin-devel] bug in MYSQL40 compatibility mode

[Marc Delisle]

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