Hi!

<cut> Kulakov> Commands Alter Table, Rename Table and probably kulakov> some other fail if the table they change is opened by previous
commands. For kulakov> example, if the following two commands are executed: kulakov> How-To-Repeat:

kulakov> 1. You have a table like this: kulakov> Create Table Words( kulakov> id int primary key, kulakov> Word varchar(40) not null, kulakov> Index(Word) kulakov> )

kulakov> 2. And some data in it (actually it should have more data)

kulakov> Insert Into Words Values (1, 'a'), (2, 'b'), (3, 'c')

kulakov> 3. Then you work with the table:

kulakov> Select * From Words

kulakov> 4. And then you try to change it:

kulakov> Rename Table Words To Words1

kulakov> The last query will produce an error. In order to succeed, one has to
first kulakov> perform Flush Tables that closes all open tables (by the way, the form
Flush kulakov> Tables TableName1, TableName2 doesn't work under Windows either).

kulakov> Conclusion: MySQL for Windows should close table files whenever it
needs to kulakov> change them as a whole or get their parameters

We actually have code in MySQL that closes all things on windows before doing any of the above operations. It seams however that we have some bug in this code: We will try to fix this ASAP.

Regards, Monty