MySQL Bugs: #36846: Changing a MyISAM table to RAID type = "striped" fails with 'RAID

Bug #36846	Changing a MyISAM table to RAID type = "striped" fails with 'RAID_TYPE' is depre
Submitted:	21 May 2008 10:33	Modified:	21 May 2008 21:35
Reporter:	Janek Bogucki
Status:	Not a Bug
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	Any
Assigned to:		Target Version:

Description:
When using "Edit" on a MyISAM table to change the RAID type from none to striped this
error is shown when executing the SQL:

Error executing SQL commands to update table.
MySQL Error Nr. 1287
'RAID_TYPE' is deprecated; Use 'PARTITION' type instead.

This is the SQL:
ALTER TABLE `cert`.`raid` RAID_TYPE = STRIPED
  RAID_CHUNKS = 12
  RAID_CHUNKSIZE = 64;

Server version: 5.0.51a-3ubuntu5.1-log

How to repeat:
Use the mysql-query-browser to create a MyISAM table and then change the RAID type to
striped.

Thank you for taking the time to write to us, but this is not a bug. Please double-check
the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

According to http://dev.mysql.com/doc/refman/5.0/en/create-table.html:

# RAID_TYPE

RAID support has been removed as of MySQL 5.0. For information on RAID, see
http://dev.mysql.com/doc/refman/4.1/en/create-table.html.

You can use MySQL Query Browser with version 4.1 there this syntax is valid.

There is related bug #26756.