Meyer, Patrick writes:
> Running 3.23.33 on Windows 2000 Server.
>
> I have noticed that executing an ALTER TABLE works... but the next query on
> the alter table crashes MySQL and corrupts the table.
>
> If I FLUSH TABLES after an ALTER TABLE, it seems to reduce the occurance,
> but should this be required?
>
> [EMAIL PROTECTED]
> National Aeronautics and Space Administration
>
> -------------- S c i e n c e @ N A S A ----------------------
> http://science.nasa.gov/ INFORM - the fast paced expansion of knowledge
> http://kids.msfc.nasa.gov/ INSPIRE - the future belongs to our children
> http://liftoff.msfc.nasa.gov/ INVOLVE - today's dreams, tomorrow's reality.
>
>
Hi!
Can you please try to make a repeatable test case.
It should consist of CREATE TABLE statement for the table, plus
INSERT's to insert few rows, then ALTER TABLE and query that crashes
MySQL.
When you prepare it, please upload the file to our FTP server on
support.mysql.com , directory /pub/mysql/Incoming and let us know a
file name .
Many thanks in advance.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
