MySQL Bugs: #47974: 'TYPE=storage_engine' is deprecated and will be removed in MySQL 6.0

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

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

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!)

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

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

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.

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.

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".

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)

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)

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)

Pushed into mysql-next-mr (revid:alik@sun.com-20100302072432-k8xvfkgcggkwgi94) (version source revid:alik@sun.com-20100224135227-rcqs9pe9b2in80pf) (pib:16)

Cosmetic change. No changelog entry needed.

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)

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)

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)