Bug #47974 'TYPE=storage_engine' is deprecated and will be removed in MySQL 6.0
Submitted: 11 Oct 2009 9:50 Modified: 18 Jun 2010 1:41
Reporter: Sveta Smirnova Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Magne Mæhre CPU Architecture:Any
Triage: Triaged: D4 (Minor)

[11 Oct 2009 9:50] Sveta Smirnova
Description:
create table ... type= returns warning "The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 6.0. Please use 'ENGINE=storage_engine' instead" while this syntax was actually removed in version 5.4.4 (see http://dev.mysql.com/doc/refman/5.4/en/news-5-4-4.html)

How to repeat:
mysql> create table bug17501(f1 int) type=myisam;
Query OK, 0 rows affected, 1 warning (0.16 sec)

mysql> show warnings;
+---------+------+-----------------------------------------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                                                     |
+---------+------+-----------------------------------------------------------------------------------------------------------------------------+
| Warning | 1287 | The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 6.0. Please use 'ENGINE=storage_engine' instead |
+---------+------+-----------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Suggested fix:
Fix warning
[11 Oct 2009 12:12] Peter Laursen
maybe it should even be 'removed in 5.2' and not '.. in 6.0'. Or even better '..will be removed in releases after 5.1'.

The 5.2 tree was never officially abandoned and is still available on FTP mirror sites like here: ftp://mirrors.dotsrc.org/mysql/Downloads/MySQL-5.2/

(but it would be very nice if MySQL would officially abandon 5.2 and remove the downloads.  From time to time our users and customers get confused about it!)
[8 Feb 2010 21:11] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/99643
[9 Feb 2010 10:31] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/99674
[21 Feb 2010 21:31] Alexey Kopytov
The patch for this bug changes the deprecation macro argument so that it now claims the 'TYPE=' syntax will be removed in 5.4.4. However, it is still not removed in mysql-trunk-merge which has "5.5.2-m2" as the version string.

As a result, there is now a debug assertion failure in a test case that deliberately uses the deprecated syntax.

Currently http://dev.mysql.com/doc/refman/5.4/en/news-5-4-4.html does not contain anything about the removal of the old syntax. 

If it's been decided to postpone the removal once again to some later version, then the patch for this bug should be corrected.

If we do want to stop supporting the old syntax in 5.4.4, then we should remove support from the code, fix (or remove) the test case for bug #21801 in sp-error.test and update the changelog.
[23 Feb 2010 10:24] Magne Mæhre
A decision has now been made to remove this option in the "Celosia" release.  Since the version no. is not yet available, it should be reverted "6.0" in the code.
[23 Feb 2010 11:18] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/101172

3352 Magne Mahre	2010-02-23
      Revert of a change introduced by Bug#47974
      
      "TYPE=storage_engine" is deprecated, and will be removed
      in the Celosia release of MySQL.  Since the option is
      present in the Betony release and the version number of
      Celosia is still not decided, we need to bump the
      deprecation version number back up to "6.0".
[1 Mar 2010 8:46] Bugs System
Pushed into 5.1.45 (revid:joro@sun.com-20100301083827-xnimmrjg6bh33o1o) (version source revid:magne.mahre@sun.com-20100223111720-nubmj7o9lb89js8t) (merge vers: 5.1.45) (pib:16)
[2 Mar 2010 14:32] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100302142746-u1gxdf5yk2bjrq3e) (version source revid:alik@sun.com-20100225090938-2j5ybqoau570mytu) (merge vers: 6.0.14-alpha) (pib:16)
[2 Mar 2010 14:38] Bugs System
Pushed into 5.5.3-m2 (revid:alik@sun.com-20100302072233-t3uqgjzdukt1pyhe) (version source revid:alexey.kopytov@sun.com-20100223132645-fj9ybhpzs9fl1voe) (merge vers: 5.5.2-m2) (pib:16)
[2 Mar 2010 14:43] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100302072432-k8xvfkgcggkwgi94) (version source revid:alik@sun.com-20100224135227-rcqs9pe9b2in80pf) (pib:16)
[8 Mar 2010 1:38] Paul Dubois
Cosmetic change. No changelog entry needed.
[17 Jun 2010 12:19] Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 13:06] Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:martin.skold@mysql.com-20100609140708-52rvuyq4q500sxkq) (merge vers: 5.1.45-ndb-6.2.19) (pib:16)
[17 Jun 2010 13:47] Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)