Bug #16767 DD: ALTER LG that does not exist returns wrong error code
Submitted: 25 Jan 2006 3:23 Modified: 8 Feb 2006 23:48
Reporter: Nikolay Grishakin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.1 OS:Linux (Linux)
Assigned to: Jonas Oreland CPU Architecture:Any

[25 Jan 2006 3:23] Nikolay Grishakin
Description:
Alter LOGFILE GROUP that does not exist returns wrong error 1511 ER_ALTER_TABLESPACE_FAILED. Should be something ike ER_ALTER_LOGFILE GROUP_FAILED and new error code as well.

The following statment will return 1511:

  ALTER LOGFILE GROUP wnc1
  ADD UNDOFILE './tmp/undofile.dat'
  ENGINE=NDB;

How to repeat:
see above
[26 Jan 2006 1:52] Nikolay Grishakin
error message that returned: "1511: Failed to alter: CREATE UNDOFILE"
[6 Feb 2006 12:22] Jonas Oreland
I changed error code from ER_{CREATE/ALTER/DROP}_TABLESPACE_FAILED
to ER{CREATE/ALTER/DROP}_FILEGROUP_FAILED
[7 Feb 2006 5:53] Jonas Oreland
pushed into 5.1.7
[8 Feb 2006 23:48] Nikolay Grishakin
Tested with latest mysql-5.1-new. Now it returns error 1511 "ER_ALTER_FILEGROUP_FAILED"