From: Michael Widenius
Date: March 19 1999 5:20pm
Subject: ODBC Error 13
List-Archive: http://lists.mysql.com/myodbc/71
Message-Id: <14066.34479.831823.516029@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "Calistra" == Calistra Research Labs <dave@stripped> writes:

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!

Hi!

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:

http://www.tcx.se/Manual_chapter/manual_Questions.html#Asking_questions

PLEASE read the above before reposting your question, this will save us all
a lot of time!

Yours,
Monty