Bug #21342 | mysqldump from 4.1 version downgrade to 4.0, lost 'auto_increment' keyword | ||
---|---|---|---|
Submitted: | 29 Jul 2006 15:01 | Modified: | 29 Jul 2006 18:07 |
Reporter: | Kam Hon Eng | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 4.1.18 | OS: | Windows (Windows XP) |
Assigned to: | CPU Architecture: | Any | |
Tags: | auto_increment, compatible, mysqldump |
[29 Jul 2006 15:01]
Kam Hon Eng
[29 Jul 2006 17:15]
MySQL Verification Team
Version 4.1.20 still not fixed. Will test source server: c:\mysql\bin>mysqladmin -uroot create dbx c:\mysql\bin>mysql -uroot dbx < achdetail.sql c:\mysql\bin>mysqldump --create-options --compatible=mysql40 dbx -- MySQL dump 10.9 -- -- Host: localhost Database: dbx -- ------------------------------------------------------ -- Server version 4.1.20-community-nt /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `achdetail` -- DROP TABLE IF EXISTS `achdetail`; CREATE TABLE `achdetail` ( `acd_no` mediumint(10) NOT NULL, `acd_key` varchar(25) NOT NULL default '', `acd_icode1` varchar(10) NOT NULL default '', `acd_icode2` int(5) NOT NULL default '1', `acd_month` int(2) NOT NULL default '0', `acd_year` int(4) NOT NULL default '0', `acd_dcode1` varchar(10) NOT NULL default '', `acd_dcode2` int(5) NOT NULL default '1', `acd_rank` int(2) NOT NULL default '1', `acd_share` decimal(14,2) NOT NULL default '0.00', `acd_sharevalue` decimal(14,2) NOT NULL default '0.00', `acd_bonus` decimal(14,2) NOT NULL default '0.00', PRIMARY KEY (`acd_no`) ) TYPE=InnoDB;
[29 Jul 2006 18:07]
MySQL Verification Team
Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=14515 and already fixed on release: c:\mysql\bin>mysqladmin -uroot create dbx c:\mysql\bin>mysql -uroot dbx < c:\tmp\achdetail.sql c:\mysql\bin>mysqldump --create-options --compatible=mysql40 dbx -- MySQL dump 10.9 -- -- Host: localhost Database: dbx -- ------------------------------------------------------ -- Server version 4.1.21-community-nt /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `achdetail` -- DROP TABLE IF EXISTS `achdetail`; CREATE TABLE `achdetail` ( `acd_no` mediumint(10) NOT NULL auto_increment, `acd_key` varchar(25) NOT NULL default '', `acd_icode1` varchar(10) NOT NULL default '', `acd_icode2` int(5) NOT NULL default '1', `acd_month` int(2) NOT NULL default '0', `acd_year` int(4) NOT NULL default '0', `acd_dcode1` varchar(10) NOT NULL default '', `acd_dcode2` int(5) NOT NULL default '1', `acd_rank` int(2) NOT NULL default '1', `acd_share` decimal(14,2) NOT NULL default '0.00', `acd_sharevalue` decimal(14,2) NOT NULL default '0.00', `acd_bonus` decimal(14,2) NOT NULL default '0.00', PRIMARY KEY (`acd_no`) ) TYPE=InnoDB;