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

[21 May 2008 8:33] Janek Bogucki
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.
[21 May 2008 19:35] Sveta Smirnova
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.