Bug #47974 'TYPE=storage_engine' is deprecated and will be removed in MySQL 6.0
Submitted: 11 Oct 11:50
Reporter: Sveta Smirnova
Status: Verified
Category:Server: Errors Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Target Version:5.1+
Triage: Triaged: D4 (Minor)

[11 Oct 11: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 14: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!)