| Bug #10598 | Table creation with 'isam' does not set engine as MyISAM by default | ||
|---|---|---|---|
| Submitted: | 12 May 2005 14:18 | Modified: | 13 May 2005 0:50 |
| Reporter: | Disha | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.5 | OS: | Windows (Windows Server 2003) |
| Assigned to: | CPU Architecture: | Any | |
[12 May 2005 14:28]
Disha
We expect the storage engine to be set to MyISAM regard less of the value of @@storage_engine system variable when we specify ISAM as engine while table creation as ISAM is an obsolete storage engine, now replaced by MyISAM.
[13 May 2005 0:50]
MySQL Verification Team
http://dev.mysql.com/doc/mysql/en/storage-engines.html The original storage engine was ISAM, which managed non-transactional tables. This engine has been replaced by MyISAM and should no longer be used. It is deprecated in MySQL 4.1, and is removed in MySQL 5.0. ................. When a storage engine is missed is used the default one, in your case InnoDB.
Description: Table creation with engine name as 'isam' does not set engine as MyISAM by default as it is specified in 'isam' engine definition. Expected: Step 5 below should display ENGINE=MyISAM instead of InnoDB, though we set @@storage_engine as 'InnoDB' the definition of 'ISAM' engine in 'show engines' say that ISAM is 'Obsolete storage engine, now replaced by MyISAM'. +-------+--------------------------------------------------------------------+ | Table | Create Table | +-------+--------------------------------------------------------------------+ | t1 | CREATE TABLE `t1` (`f1` char(1) default NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +-------+--------------------------------------------------------------------+ It displays: +-------+--------------------------------------------------------------------+ | Table | Create Table | +-------+--------------------------------------------------------------------+ | t1 | CREATE TABLE `t1` (`f1` char(1) default NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +-------+--------------------------------------------------------------------+ How to repeat: 1)show engines // 2)set @@storage_engine=innodb // 3)drop table if exists t1 // 4)create table t1 (a int) engine=isam// 5)show create table t1 //