>>>>> "Calistra" == Calistra Research Labs <dave@stripped>
Calistra> I am executing
Calistra> ALTER TABLE Cases
Calistra> CHANGE COLUMN newcol CaseID int(11) NULL
Calistra> to rename a column.
Calistra> MySQL renames the file Cases.frm to B-1.frm and returns the
Calistra> following error
Calistra> SQLExecDirect returned SQL_ERROR
Calistra> State S1000 Native Code 7
Calistra> [TCX][MyODBC]Error on rename of './Reginald/cases.ISD' to
Calistra> './Reginald/B-1.ISD' (Errcode: 13)
Calistra> Whereafter the table Cases no longer exists!
You have your original data left in the B-1 file; You can get it back
by doing a rename in dos.
According to my knowledge, the above can only happen with the MySQL
Win32 shareware version if the table was in use by another thread during
the ALTER TABLE. It should be fixed in the registered MySQL version.
Please ALWAYS include information about your MySQL version and
operating system when submitting a bug report!
You can find information how to do a correct bug report at:
PLEASE read the above before reposting your question, this will save us all
a lot of time!