Bug #7233 SHOW CREATE TABLE uses non-preferred syntax

Description:
The manual states that (http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html)

   TYPE type_name can be used as a synonym for USING type_name to specify an index type.

However, SHOW CREATE TABLE uses TYPE type_name

How to repeat:
mysql> drop table if exists t;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE t (i int, index using btree (i)) engine=memory;
Query OK, 0 rows affected (0.06 sec)

mysql> show create table t\G
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE `t` (
  `i` int(11) default NULL,
  KEY `i` TYPE BTREE (`i`)
) ENGINE=HEAP DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

Suggested fix:
Replace "TYPE" with "USING"

The following part got lost in the cut'n'paste from the manual:

   However, USING is the preferred form.

(which is the key sentence for this)

This was pushed to the 5.0 tree. It was decided that changing the output of SHOW CREATE TABLE 
this late in the 4.1 cycle is too likely to cause problems for tools vendors.

Noted in 5.0.3 changelog.