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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.